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
Timeline
Data Analyst
SP Web Connect
05.2023 - Current
Bachelor's in Engineering -
Mumbai University
04.2001 -
Similar Profiles
Lucyna MuchaLucyna Mucha
Junior Strategic Buyer at Kaufland Polska Markety Sp. Z O.O. Sp. J.Junior Strategic Buyer at Kaufland Polska Markety Sp. Z O.O. Sp. J.
Paweł PłachtaPaweł Płachta
Technical Engineer at Atos Global Delivery Center Polska Sp. Z O.o. Sp. KTechnical Engineer at Atos Global Delivery Center Polska Sp. Z O.o. Sp. K
Janusz StaranowiczJanusz Staranowicz
General Manager, Board Member at Novigo sp. z o.o. sp. k.General Manager, Board Member at Novigo sp. z o.o. sp. k.
Shreyas KedarShreyas Kedar
IT Development Team Lead at Transimpact Pvt LtdIT Development Team Lead at Transimpact Pvt Ltd
Shray YadavShray Yadav
Senior Associate at EXL Services (India) Private LimitedSenior Associate at EXL Services (India) Private Limited