Senior Bi Consultant
Current• Developed interactive and visually appealing reports using Power BI Desktop and dashboards using Power BI Service.• Leveraged the power of inbuilt ETL Tool- Power Query and ADF to extract, transform, and load data from various sources such as SQL Server, Azure SQL Database, Excel, CSV File etc. into Power BI.• Used DAX functions and worked on data modeling in Power Pivot to ensure accurate and efficient data representation.• Developed and implemented new measures, calculated columns tailored to Project requirements.• Extensive knowledge of various reporting objects like Filters, Slicers, Parameters, Bookmarks, Hierarchies in Power BI.• Collaborated with cross-functional teams and stakeholders to gather requirements and understand the business objectives.• Used Power View to create data visualizations including Table, Map and various Charts such as Column, Bar, Line Donut, Pie, Line, Ribbon, Tree Map charts, Decomposition Tree to present key insights effectively.• Optimized performance and enhanced user experience by implementing best practices for report and dashboard design.• Worked with Power BI Service to create Project workspace for team collaboration, implement security, add and assign different roles to members and configured Gateway to schedule refresh.• Working with DDL, DML, Sub-queries, CTE, Joins, Union, Like Operator & Functions to get required data in Power BI.• Shared Reports and Dashboards using Apps and delivered actionable insights to stakeholders and business users, enabling data-driven decision-making and identifying opportunities for process improvement.• Provided training and support to end-users on Power BI usage, best practices, and self-service capabilities.
