Hridik Agarwal

Freelance Data Analyst

Upwork

Aug 2024 - Present • 2 yrs

Built interactive dashboards in Power BI, Tableau, and Excel to track KPIs, performance trends, and business insights for 35+ clients. -Designed custom Excel and Google Sheets templates with advanced formulas, automated calculations, and user-friendly layouts. -Helped bookkeepers streamline financial reporting by developing templates to track income, expenses, and budget performance. -Assisted HR professionals by creating headcount and attrition trackers for workforce management. -Supported real estate clients with project management and property trackers, providing better visibility into performance and timelines. -Developed project management dashboards and trackers for freelancers and small business owners to monitor progress and deadlines. -Automated manual reporting processes using Power Query and formulas, saving one client approximately 2 days per report and eliminating hours of manual calculations for others, enabling greater focus on data analysis and results. -Created an Amazon KDP dashboard using Power Query, allowing clients to simply add data to a designated folder for automated processing and insights. -Developed an interactive Tableau dashboard combined with Tableau Prep Builder for a client, enabling seamless data preparation, cleaning, and dynamic visualizations for real-time insights and easier decisionmaking. -Delivered clear, well-structured reports and visuals, ensuring data accuracy and easy interpretation.