Project Management Dashboard in Excel using VBA
Winner and runner up of the Dashboard creation contest. Totally designed on Excel using VBA and DAX formulas. A non VBA version was also created retaining almost all features of the main dashboard. Total time taken : 2 days for 2 dashboards See the dashboard in action here Main Dashboard : https://1drv.ms/x/s!AsQ4UDnUPP0EhRiNQSUfl2d8ZQ-L Dark Theme : https://1drv.ms/x/s!AsQ4UDnUPP0EhRcBYL3JG2CGDASA
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)
