Athletic Performance Tracking Dashboard in Excel
Completely built in Excel itself. Data will be dynamically fed into the datasheet provided. A query table will convert the raw data into numbers. A series of calculations and conversions will be carried out using the Power Query formulas. The output table will have all the relevant data in the required formats. A pivot table is then made using this data table and visualized in the dashboard page . All the elements in the dashboard page are totally dynamic and fully customized. A name slicer and a timeline slicer provided to drill through the reports. Ultimate aim was to create a dashboard that is simple, dynamic and user friendly , without VBA. Total time taken : 6 hours Tools used : Excel 365 Price: $50
About Me
I specialize in creating customized solutions for data processing, reporting and visualising using Power BI, Excel, Google Sheets and Looker Studio (Google Data Studio). Well adept in Python, DAX, M, SQL and VBA, I can also help you with process flow automation using Power Automate and Logic App. I am a Microsoft Certified Fabric Analytics Engineer (DP600) in addition to the PL300 Data Analyst Associate certification. Coming to my background, I have a degree in Mechanical Engineering and worked as a marine engineer for 10 years. Afterwards, I have been working as a freelance consultant since 2019. Have helped organizations establish end to end analytics solution using Fabric, Power BI and Azure ( ADLS2, ADF , Azure SQL, Databricks, Azure Synapse and Dataflows)
