Swati Naik
Data Analyst
Pune
Summary
Data Analyst with 2 years of experience in transforming data into actionable insights using Power BI, Excel, SQL, and Python. Skilled in data cleaning, transformation, dashboard development, and reporting. Adept at identifying trends, solving business problems, and supporting data-driven decision-making.
Overview
2
2
years of professional experience
3
3
Languages
Work History
Data Analyst
SP Web Connect
05.2023 - Current
- Have a Good Experience in Power Bi.
- Developed and maintained Power BI dashboards to monitor sales performance across regions, helping leadership identify underperforming areas.
- Cleaned and transformed raw data using Power Query to prepare it for analysis.
- Created data models by establishing relationships across multiple data tables.
- Utilized DAX functions to build custom KPIs, Measures, and Calculated Columns.
- Published and scheduled reports on Power BI Service, enabling stakeholders to access live data insights.
- Integrated data from Excel and SQL Server.
- Performed data transformation in Power Query Editor.
- Built a star schema model with fact and dimension tables.
- Designed an interactive dashboard with Slicers and Drill-through features.
- Used DAX to calculate sales trends, YoY growth, and top product categories.
- Queried large datasets using PostgreSQL to generate reports and KPIs for sales and customer behavior analysis.
- Wrote complex SQL queries involving multiple joins, subqueries, Windows Function and CTEs to extract actionable insights.
- Created and maintained views, functions, and stored procedures for automated reporting.
- Improved query performance by implementing indexes and analyzing execution plans.
- Built interactive Excel dashboards using pivot tables, slicers, and charts to visualize product sales and regional performance.
- Used VLOOKUP, INDEX-MATCH, and nested IF formulas to consolidate and analyze large datasets from multiple sources.
- Automated repetitive reporting tasks using macros.
- Cleaned and transformed raw data using data validation, text functions, and conditional formatting.
- Utilized Python (Pandas, NumPy) to clean and transform raw datasets from multiple sources for reporting and visualization.
- Knowledge exploratory data analysis (EDA),Matplotlib,Seaborn.
- Work on Googlesheet.
Education
Bachelor's in Engineering -
Mumbai University
04.2001 -
Skills
Technical Skills
Data Analysis & Visualization: Power BI, Excel (Pivot Tables, VLOOKUP, Charts), Google Sheets
Programming Languages: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL
Databases: MySQL, PostgreSQL
Data Cleaning & Transformation: Power Query, Python, SQL, Advanced Excel
Business Intelligence Tools: Power BI (DAX, Power Query, Data Modeling, KPIs)
Reporting & Dashboarding: Power BI Service, Excel Dashboards
Tools & Platforms: JIRA, GitHub, AWS (Basics), Linux (Basics)
Soft Skills
Analytical Thinking
Problem Solving
Communication
Time Management
Attention to Detail
Timeline
Data Analyst
SP Web Connect
05.2023 - Current
Bachelor's in Engineering -
Mumbai University
04.2001 -