BI Reporting for Business Operations Data

About the project

Operations Data in my last company Collaborate with business stakeholders to gather functional requirements and translate them into scalable BI reporting solutions. • Designed and implemented robust data integration workflows by consolidating data from Excel, SharePoint, Salesforce, and SQL Server into a centralized reporting model. • Performed comprehensive data profiling, cleansing, transformation, and modeling using Power Query (M) to deliver high-quality, analysis-ready datasets. • Designed and developed dynamic dashboards using custom visuals, hierarchical drill-down structures, geo-maps, and drill-through features to enhance analytical depth and improve strategic business decisions. • Proficient in advanced DAX (YTD, QTD, MTD, YoY, MoM), performance optimization using DAX Studio, incremental refresh, aggregations, and RLS implementation. • Experienced in Power BI Service, Gateway configuration, scheduled refresh, workspace management, and multi-source data integration (SQL Server, Excel, SharePoint, Salesforce, CSV). • Delivered domain dashboards across HR, Finance, and Profitability analysis, enabling leadership visibility into key metrics. • Streamlined recurring reporting processes through Excel VBA automation, minimizing • Built customized Excel/VBA tracking solutions to standardize reporting, improve version control, and increase operational efficiency.

Skills required