Mercy Maigut
Data Analyst @Advanced Drainage Systems, Inc.
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst @Advanced Drainage Systems, Inc.
OH, US
In charge of maintaining reports by monitoring auto refresh failures in Power BI Service and data problems in source data systems.• Built complex measures and calculated columns using DAX queries, accomplished different data transformations with Power Query in Power BI desktop.• Automated monthly and weekly deployment status monitoring by making a self-serving Power BI report that replaced weekly manual reports. The new report allowed the engineering team to check the status of deployment in real time, immediately identifying failures and errors and fixing the issues in a timely manner.• Created and optimized complex data models within Microsoft Fabric/Power BI, enabling the development of insightful Power BI reports and dashboards. Utilized Fabric’s data transformation capabilities to enhance performance and support data-driven decision-making across various departments.• Accomplished in creating spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data to uncover insights into the costumer usage standards.• Created operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data using Power BI together with Azure Analysis Services.• Utilized Power BI to implement a semantic model to clarify the analysis of business data and relationships by loading relevant data from Azure Synapse data warehouse
EDUCATION
Technical Univeristy of Kenya
Bachelor of Commerce - BCom
Park University
Master's degree
ABOUT MERCY MAIGUT
Holding a Master\'s degree in Information Systems and Business Analytics from Park…
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.