Shubham Rokade

About Shubham Rokade

A growth-oriented professional, with 2 plus years of Power BI experience in developing various reports and data visualization. Hands on experience on Power BI Desktop, Power Query and Power BI Service, DAX, Azure, Power Apps, Power Automate. Experience in creating Charts like Pie Charts/Donut/Word/charts/cards/gauges/slicers etc. andworking with custom visualizations using Power BI Good knowledge on Data warehousing concepts like Star schema, Snowflake schema andidentifying the dimension and fact tables. Good at analyzing, gathering, managing and documenting business requirements. Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column,Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc. Experience in connecting with multiple data sources like SQL Server, json, csv and Excel fromPower BI to build complex Datasets. Skilled in Advanced Excel, SQL and Power BI (Power BI Desktop and Power BI Service). Extensively worked on performing the ETL Activities in Power Query. 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. Extensive Experience in doing Data Modeling in Power Pivot Model. I worked extensively on Enhancing the Data Model by Creating New Columns, New Measureand New Tables using DAX Expressions. Hands on Experience with Visual level, Page level, Report level and Drill Through filters forfiltering the data in a Report. Published Power BI Reports in the required originations and made Power BI Dashboards availablein Web clients and mobile apps. Hands on experience on Implementing Row Level Security, Bookmarks, Parameters to restrict userdataset. Experience in publishing the Reports to Power BI Service and setting up the necessary connections. Extensive Experience in Creating Dashboards and Mobile View using Multiple Reports. Worked on On-Premises Data Gateway to Refresh and Schedule Refresh the Data in the Dataset. Experience in sharing the Reports and Dashboards with End Users. Good Experience and knowledge on cloud computing such as – Azure Experience in working with Azure services such as – Azure Storage, Azure Lake Storage, Azure SQL Database, and Azure Data Factory. Hands on experience about how to trigger flows from PowerApps, Outlook and SharePoint.

Experience

1. Associate Consultant

   KPMG

   Jun 2024 — Present · Bengaluru, IN

Education

• Savitribai Phule Pune University

  Bachelor of Engineering - BE

  2015 — 2020