Power Bi Data Analyst

SHUBHAM JAGTAP

Pune, Maharashtra *****************@*****.*** +91-965******* LinkedIn GitHub SUMMARY

Power BI Developer Data Analyst with 3years of experience in designing, developing, and deploying interactive dashboards. Skilled in transforming raw data into actionable insights using Power BI, SQL and Python. Proven ability to optimize reporting efficiency, enhance data quality, and support strategic decision-making. Delivered insights that improved decision-making by 25%. Proficient in business intelligence, Report automation, KPI tracking, Data storytelling, and working with data warehouse. PROJECTS & ACHIEVEMENTS

Migrated 20+ dashboards from Google Looker to Power BI, improving visualization and reporting efficiency.

Conducted data quality audits for 2+ clients, identifying data gaps and implementing corrective strategies.

Automated project workflows using SQL and Power BI, reducing manual effort and boosting reporting accuracy. SKILLS

BI Tools: Power BI (DAX, Power Query, Power Automate, Dataflows, Power BI Service, Development, Power BI Gateway, RLS), Warehouse Microsoft fabric, Alteryx.

Databases: MySQL and PostgreSQL (Proficient in SQL Commands, Data types, Constraints, String Function, Date and time Function, Joins, Union, CTEs, Aggregate Function, Subqueries, Window Function, Temp Table, Stored Procedures, Triggers) Snowflake, BigQuery.

Programming: Python (Pandas, NumPy, Matplotlib, Seaborn, Automation, Data Transformation).

Office Tools: MS Word and Advanced MS Excel (IF, COUNDIF, SUMIF, VLOOKUP, Index, Match, Pivot Table & Charts)

Analytics Techniques: Data Warehouse, Data Modeling, Data Cleaning, ETL, EDA, Statistical Modeling, Dashboarding, Data Governance, Statistics & Probability, Data Visualization, Data Analytics, Data Profiling, Data Manipulation, Data Extraction, Data Pipeline, Business Requirements Gathering, Root Cause Analysis. PROFESSIONAL EXPERIENCE

Data Analyst Entytle India Pvt Ltd, Pune December 2022 - June 2025

Created advanced Power BI dashboards integrating data from SQL, Excel, and cloud data warehouse (Snowflake).

Leveraged DAX for complex business calculations and Power BI Dataflows for efficient data preparation.

Designed and delivered both standard and custom Power BI dashboards with KPI tracking and real-time metrics.

Led migration of 20+ dashboards from Looker to Power BI, enhancing business intelligence and user experience.

Developed SQL queries (joins, views) to extract meaningful data from multiple sources.

Built Alteryx workflows for automated delta load ingestions to SQL and Snowflake.

Identified and resolved data quality issues, improving data integrity by 30%.

Automated reporting processes, enabling faster delivery of critical insights to stakeholders.

Applied techniques including data extraction, mapping, cleaning, mining, preparation, ingestion, visualization, and reporting.

Managed multiple projects concurrently, prioritizing tasks to ensure timely delivery while maintaining quality. Data Science Intern VisionNLP LLP, Pune December 2021 - March 2022

Developed a Python-based web scraping solution using BeautifulSoup for extracting website content.

Parsed and cleaned extracted text data for analytics use cases. Machine Learning Intern Pantech Solutions, Remote May 2021 - June 2021

Built and evaluated regression and classification models on real-world datasets.

Gained hands-on experience in ML pipelines from data preprocessing to model evaluation. EDUCATION

Imarticus Learning, Pune January 2021 - February 2022

Post Graduate Program in Data Analytics and Machine Learning Dr Babasaheb Ambedkar Marathwada University (BAMUA) Aurangabad August 2016 - June 2019

B.sc (Computer Sciences)

CERTIFICATIONS

SQL (Intermediate) – HackerRank 2021

Python for Data Science and Machine Learning – Udemy 2021

Power BI A-Z: Hands-On Power BI Training – Udemy 2025

Contact this candidate