Dedicated Power BI Developer with experience in creating interactive Power BI Reports. Worked with multiple teams to build user-centered Power BI Dashboards that showed various business scenarios. Confident in querying in SQL and DAX languages. Always look to build effective and efficient reports to maximize performance.
Creates dashboard in Power BI with different data sources such as Excel, CSV, MySQL, Snowflake, Databricks, OneDrive, Amazon S3, Azure Blob, Azure ADLSGEN 2, Azure Synapse, Python, Web URLs, etc.
Skills &Tools -
Microsoft Power BI
DAX
Data Visualization
Data Modelling
Data Warehousing
MySQL
MS Excel
MS PowerPoint
Snowflake
Azure Blob/ Amazon S3
Air byte
Amazon Athena
Tableau
Sigma Computing
Worked on the below Projects -
1. Retail Store Sales Data Analysis
Build an interactive dashboard in Power BI for Sales Data showing most effective and improved stores, items in terms of revenue, profit and sales.
Used various visuals charts in dashboard like tree map chart, funnel chart, maps, KPIs.
Created measures in DAX for various calculations.
2. Affiliate Networks Data Analysis
Build Dashboard for Affiliate Networks data in Power BI showing merchant wise active products of different Networks.
Importing data by querying using SQL from MySQL Database.
Created Measures in DAX and ETL using Power Query.
Published report to Power BI Service with Scheduled Refresh of Power BI Datasets
3. Website Traffic Analysis Report
Build a Power BI dashboard to analyze the website traffic data showing each webpage traffic in terms of sessions, impressions, clicks.
Connected Power BI with Google Analytics connector to import data and then transformed it in Power Query.
Created Measures in DAX.
4. Web Page Action Taken Report
Build a Power BI Report for a Web Page showed which user is making changes in which section of Web Page.
Imported Data from MySQL DB and then transformed it in Power Query having data format of JSON.
Used charts in Dashboard like Multirow cards KPIs, Slicers.
5. Retail Store Sales Data Analysis
Build an interactive dashboard in Power BI for Sales Data showing most effective and improved stores, items in terms of revenue, profit and sales.
Used various visuals charts in dashboard like tree map chart, funnel chart, maps, KPIs.
Created measures in DAX for various calculations.
6. Affiliate Networks Data Analysis
Build Dashboard for Affiliate Networks data in Power BI showing merchant wise active products of different Networks.
Importing data by querying using SQL from MySQL Database.
Created Measures in DAX and ETL using Power Query.
Published report to Power BI Service with Scheduled Refresh of Power BI Datasets
7. Website Traffic Analysis Report
Build a Power BI dashboard to analyze the website traffic data showing each webpage traffic in terms of sessions, impressions, clicks.
Connected Power BI with Google Analytics connector to import data and then transformed it in Power Query.
Created Measures in DAX.
8. Web Page Action Report