Summary
Work History
Education
Skills
Languages
Business insights 360 – [Power BI | SQL | Excel | DAX Studio] Project
P & L Report – [Excel | Pivot table | Power Query] Project
Timeline
BusinessAnalyst
Ashwini Jadhav

Ashwini Jadhav

Data Analysis
Pune ,Maharashtra

Summary

A prospective data analyst with solid expertise in Excel, Power BI, and SQL, bolstered by recent certifications in these tools. Successfully executed two real-world projects—one employing Excel and the other harnessing Power BI—demonstrating adeptness in data analysis and visualization. Eager to apply knowledge and drive insights in a dynamic data analysis role.

Work History

SEO Internship

Firstcry
Pune
12.2018 - 04.2019
  • Developed and implemented SEO strategies to increase website visibility in organic search engine results.
  • Optimized content by ensuring correct placement of target keywords within text, meta tags, and titles.
  • Monitored rankings of target keywords using various analytics tools.
  • Posting blogs on their respective sites, utilizing tools such as Google Keyword Planner, Google Trends, SEMrush, and Google Search Console.

Education

Data Analytics Certification - Technical

Code Basics
Pune
03-2024

Post Graduation Diploma - Instructional Design

Instructional Design
Symbiosis Center For Distance Learning
03-2017

B.Sc. PCM

New Kohinoor College
Aurangabad
06-2015

Skills

Data Analysis Skills

  • Advanced Excel
  • ETL (Extract, Transform, and Load)
  • Power BI
  • SQL
  • Data Cleaning and Preprocessing
  • Data Modeling
  • Data Visualization
  • Analytics

Digital Marketing Skills:-

  • Search Engine Optimization (SEO)
  • Social Media Marketing (SMM)
  • Keyword Analysis
  • Google Analytic

Languages

Marathi
First Language
English
Intermediate (B1)
B1
Hindi
Upper Intermediate (B2)
B2

Business insights 360 – [Power BI | SQL | Excel | DAX Studio] Project

  • Created four distinct dashboards, each tailored for Finance, Marketing, Sales, and Supply Chain, utilizing AtliQ Hardware's sales data.
  • Built a data model and visualizations in Power BI and optimized the reports in DAX Studio, resulting in a 5% improvement in performance.
  • Developed and implemented dynamic dashboards showcasing key performance indicators for fiscal years 2019-2022; enabled AtliQ Hardware to analyze trends and make data-driven decisions for business growth and optimization.

P & L Report – [Excel | Pivot table | Power Query] Project

  • Generated Profit and Loss (P&L) reports for AtliQ Hardware for the fiscal years 2019-2022.
  • Performed Extract, Transform, Load (ETL) processes and automated data cleaning using Power Query to connect to the data model. Additionally, obtained insights from the data by creating measures in Power Pivot and using Data Analysis Expressions (DAX).

Timeline

SEO Internship

Firstcry
12.2018 - 04.2019

Data Analytics Certification - Technical

Code Basics

Post Graduation Diploma - Instructional Design

Instructional Design

B.Sc. PCM

New Kohinoor College

Similar Profiles

  • Hanan Tabbaa

    Hanan TabbaaHanan Tabbaa

    Category Buyer at FirstcryCategory Buyer at Firstcry

    View Profile
  • HIMANSHU PRASAD

    HIMANSHU PRASADHIMANSHU PRASAD

    Regional Business Manager at Firstcry Intellitots PreschoolRegional Business Manager at Firstcry Intellitots Preschool

    View Profile
  • Mayank Kumar

    Mayank KumarMayank Kumar

    SOURCING MANGER at BRAINBEES SOLUTION PVT. LTD /FIRSTCRYSOURCING MANGER at BRAINBEES SOLUTION PVT. LTD /FIRSTCRY

    View Profile
Ashwini JadhavData Analysis