Shaik Sardar

Around 1+ years of Professional Experience in IT industry in Data Warehousing related Projects using Power BI Desktop & Power BI Service Software’s. Experience in connecting with multiple data sources like SQL Server and Excel from Power BI to build complex Datasets. Extensively worked on performing the ETL Activities in Power Query. Good Experience in filtering Unwanted Data in Power Query. Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc. Extensive Experience in doing Data Modeling in Power Pivot Model. I worked extensively on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions. Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information. Extensively worked in Power View for Presenting the Data in Graphical Format using Different Visualizations in Power BI. Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report. Good Experience in Creating Hierarchies and Drilldown Reports. Good Experience in sorting the Data in Visualizations, Grouping and Binning the Data in Power BI. Extensive Experience in Creating APP Workspaces and adding the Members to APP Workspace to Manage the Content in Power BI Service. Experience in publishing the Reports to Power BI Service and setting up the necessary connections. Extensive Experience in Creating Dashboards using Multiple Reports. Worked on On-Premises Data Gateway to Refresh and Schedule Refresh the Data in the Dataset. Implemented ROW LEVEL SECURITY (RLS) as part of security in Power BI. Experience in sharing the Reports and Dashboards with End Users. Hands on Experience on writing SQL Queries as part of testing the Data. Excellent Communication, Presentation, Interpersonal, Strong Troubleshooting and Organization Skills.

Microsoft Power BI Analyst