Generated PowerBI dashboards with advanced page/global filters, parameters and calculated fields that allowed tracking projected KPI for product performance, and customer interactions.
Creating a re-usable Data Models for reusability and to implement the single version of truth.
Experience in migrating the Excel reports into Power BI Solution.
Experience in data cleansing using Power Query (M-Code) and transforming the data to fit for the reporting structure.
Experience in writing or enhancing the M-code by creating functions for reusability.
Creating different reports like Summary Reports, detailed reports like Drill-through, Drill-down and dynamic Page navigation reports.
Creating complex DAX Measures, Calculated Columns and Calculated Tables.
Creating reports with bookmarks, page navigation and dynamically hiding visuals for better user visual experience.
Education
Collaborated closely with internal stakeholders to gather information related to production problems, projects, or user queries.
Responded to specific BI requests from business development personnel, creating reports with requested information in easily understandable formats.
Perform end to end analysis of Data using various tools and technologies.
Profiled the legacy database tables using T-SQL queries to provide data cleansing issue reports to the client.
Developed data reconciliation SQL queries to validate the overall data migration.
Extracted data from Oracle, SQL Server, Flat Files, Excel, and XML using SSIS and cleanse the data.
Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Effectively used data blending, filters, actions, and hierarchies feature in Power BI.
Analysed the data using Statistical features in Power BI to develop trend analysis.
Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data.
Programming tasks- Advance Dynamic SQL, Stored Procedures, Indexed Views, Functions and CTEs using T-SQL.
Responsible for creating Company core business KPIs and Executive Dashboards for board members by just not showing the numbers but making a Data Story about it.
Creating Technical Documentation and providing Power BI training to users for creating their own dashboards in Power BI Service.
Experience in using external tools like DAX Studio, Tabular Editor, ALM Tool kit and Bravo.
