About

Magan Sachdeva is a Microsoft Certified Data Analyst/Business Intelligence Consultant with over 5 years of experience in the services industry. He possesses strong skills in Microsoft Business Intelligence, Data Engineering, Data Warehousing, and Data Visualization (Power BI). Magan is a professional with a Bachelor’s Degree in Computer/Information Technology and has a demonstrated history of working in the field of data analytics. Currently, Magan is working as an Advisor at Dell, where he is responsible for providing data analysis and business intelligence consulting services to clients. In his previous role as a Business Intelligence Consultant at Fractal, he designed and developed Power BI models for self-service BI, built composite data models for specific reporting needs, and utilized deployment pipelines to implement SDLC. He also built daily, weekly, and monthly complex reports to track KPIs and explored datasets to identify potential areas of analysis to drive business impact. In his previous role as a Business Intelligence Developer at Absolutdata Analytics, Magan designed and developed Power BI models for self-service BI and developed complex DAX measures. He also implemented dynamic row-level security in Power BI and integrated custom visuals based on business requirements using Power BI desktop. Additionally, he automated Excel dashboard refresh through Python and automated Power BI dataset refresh using Microsoft Flows. Magan has a strong technical background in Azure, SQL, Python, and Data Engineering. He is a Microsoft Certified Data Analyst and Microsoft Certified Trainer. He has experience working with Azure SQL Database, SSAS, Advance Excel, Azure Data Factory, SSIS, and Python. He is skilled in creating parameters for Power BI reports datasets and using Power BI data flows in Power BI service. He has also installed and configured Power BI Gateway (Personal, Enterprise) and scheduled data refresh for all the reports. Overall, Magan Sachdeva is a skilled and experienced data analyst with a passion for utilizing data to drive business impact. He has a proven track record of delivering high-quality data analysis and business intelligence consulting services to clients.