Mrunali Kashid

Certified Data Analyst with hands-on experience in data analysis, data modeling, and data visualization. Proficient in using tools such as SQL, Python, Excel, Tableau, and Power BI to clean, analyze, and present data-driven insights. Strong understanding of data manipulation, exploratory data analysis (EDA), and building interactive dashboards to support decision-making. Skilled in identifying trends, patterns, and opportunities to drive business strategies, and operational improvements. Equipped with a solid foundation in data analytics methodologies and best practices, and ready to contribute to a dynamic team by transforming complex data into actionable insights. Eager to leverage my certification and passion for data to solve real-world problems and support data-driven decisions.

• Certification In POWER BI from B10x.
• Certification In TABLEAU from B10x.
• Certification In Basic and advance MS Excel from B10x.
• Certification In MYSQL from B10x.
• Certification In PYTHON from B10x.

1. Pizza Sales portfolio project using Power BI and MSSQL

We used MSSQL Server, imported data, created a database in SQL Server, and worked on SQL queries in the server based on the problem-solving statement and data requirements. We ran a query and captured results; on the basis of the results, we made a document and recorded all details After we move ahead and use Power BI, I have made two dashboards for that. First, connect the MSSQL server to Power BI Then I did the data cleaning process by using Power Query, and after that, I processed the data using DAX functionality for clean data in a custom column In the final data visualization, build two dashboards: one for the pizza delivery report, and the second for the best and worst seller dashboard.

  Software used for project: 

 1. MS office/ Excel: Version 2021

 2. MS SQL SERVER:19.0

 3. SQL MANAGEMENT STUDIO -19.0.20209.0

4. POWER BI ; JUNE2023 VERSION.

2.Blinkit Sales and Operations Power BI Dashboard

      Developed a Power BI dashboard to track sales, inventory, and operations for Blinkit, optimizing supply chain management and improving decision-making for inventory restocking and sales forecasting.

 Tools Used: Power BI, DAX, SQL, Excel, Power Query, Data Modeling.

Impact: The dashboard provided valuable insights into sales trends and inventory gaps, helping Blinkit reduce stockouts by 20%, optimize delivery times, and improve inventory turnover.