Sahil Parab

Fresher

[email protected] +91 9619688429

Resume

Hello, I am

Sahil Parab.

1

Excel
Project

4

PowerBI
Projects

1

SQL
Project

About Me

Welcome to My Portfolio!

I'm Sahil Parab, a Data Analyst with a background in Computer Science and a passion for transforming raw data into meaningful insights. I’m Microsoft Certified: Power BI Data Analyst Associate (PL-300) and skilled in Excel, Power BI, SQL, and Python.

Though early in my career, I’ve completed real-world projects—from analyzing telecom KPIs and EV sales trends to marketing insights for consumer brands. These experiences reflect my ability to handle data end-to-end and communicate findings through clear visuals.

I’m curious, detail-oriented, and enjoy solving problems with data. This portfolio highlights my work, learning journey, and certifications as I look to contribute to data-focused teams.

Thanks for visiting—let’s connect if you believe in the impact of data!

Key Skills

SQL

Excel

Power BI

Tableau

My Projects

Sales Analytics Report for AtliQ Hardwares

Business Insights 360 Dashboard for AtliQ Hardware

Provide Insights to the revenue team in Hospitality Domain

Domain/Function: Hospitality

Management Insights in the Consumer Goods Domain

Domain/Function: Consumer Goods | Executive Management

CodeX Insight Analysis

Domain/Function: F & B

AtliQ Motors Insight Analysis

Domain/Function: Automotive

Awards & Certificate

Microsoft Certified: Power BI Data Analyst Associate

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/sahil-parab-a398082a3/

Call Me

+91 9619688429

GitHub

https://github.com/sahilparab1408

Excel Project

Sales Analytics Report for AtliQ Hardwares

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years.

Market performance vs Target report across years: Pivot Table summarize and analyze data effectively , Conditional formmatting provides clear insights

Project Details

In this project, I made a sales report in Excel using pivot tables. It helps businesses figure out good discounts for customers, talk with them better, and find places to grow in new countries. The reports I made give clear advice for businesses to make their sales better, make customers happier, and make more money.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

In short, this project helps businesses have the right tools and ideas to watch, check, and make their sales better. By looking at sales numbers, businesses can find new chances to grow, make more money, and keep up with other companies in the changing market.

PowerBI Project

Business Insights 360 Dashboard for AtliQ Hardware

AtliQ Hardwares, a consumer electronics company, is experiencing rapid expansion but lacks the competitive edge of data-driven insights due to reliance on Excel reports. My objective is to deploy an advanced analytics solution via Power BI, empowering the company to gain actionable insights and make

View Project
Engagement

View Project
on GitHUB

The Dashboard Home Page contains buttons for all the views. Users can go to a specific view by clicking on the corresponding icon.

The project involves organizing data into over 10 interconnected tables for analysis, known as data modeling.

Project Details

This project aims to create a single report for sales, marketing, finance, and executive teams.

It focuses on:
1. Building a strong data model
2. Making the report easy to use
3. Providing detailed insights that users can explore further.

Throughout the project, I learned:
1. Cleaning of the Data
2. How to handle data in Power Query
3. Creating formulas in DAX
4. Working with many data tables
5. Choosing the right charts and layout
6. Designing user-friendly dashboards
7. Adding navigation shortcuts
8. Use of Bookmarks
9. Sharing the report online
10. Listening to feedback and making improvements
11. Including key metrics from different business areas like sales and finance.

Live Interactive Dashboard

PowerBI Project

Provide Insights to the revenue team in Hospitality Domain

Domain/Function: Hospitality

AtliQ Grands, a leading hotel chain in India, is losing market share and revenue in the luxury hotel sector due to competition and poor management. To fix this, the managing director wants to use business and data intelligence. Without an in-house analytics team, they hired a third-party service to

View Project
on GitHUB

User-Centric Landing Page as Part of Dashboard Design

The project involves organizing data into interconnected tables for analysis.

Project Details

In this project, the goal is to create a report for the managing director & revenue team to help regain market share and revenue by making better strategic decisions and countering competition.

The focus is made on the following

1. Data Modeling
2. User-Friendly Report Design
3. Detailed, Interactive Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Deploying in Power BI service
7. Feedback Implementation

This project helps businesses make smarter choices by providing them with useful tools and strategies.By looking at their sales numbers, businesses can find new ways to grow, make more money, and stay competitive with other companies

Live Interactive Dashboard

SQL Project

Management Insights in the Consumer Goods Domain

Domain/Function: Consumer Goods | Executive Management

AtliQ Hardwares, a leading computer hardware producer, The management has noticed that they do not receive enough information to make quick and smart data-informed decisions. My objective is to deploy an advanced analytics solution using SQL, empowering the company to gain actionable insights.

View Project
Engagement

View Project
on GitHUB

SQL queries solving different ad-hoc requests for actionable insights

Individual tables in a data model view

Project Details

In this project, I developed a comprehensive report using SQL and Power BI. The goal was to create a report for management to make quick and smart data-informed decisions through actionable insights.

This dashboard enables businesses to:
- Identify months with the highest and lowest sales
- Analyze unique product increases
- Find the highest and lowest manufacturing costs
- Find gross sales for each month
- Integrate SQL queries into Power BI
- Design user-friendly reports
- Provide detailed, interactive insights
- The insights generated from this project help management optimize their sales strategies.

Key Learnings:
- Using SQL queries in Power BI
- Data processing
- Data analysis
- Generating key insights
- Report generation

Overall, this project helps management make smarter choices by providing them with useful tools and strategies. By analyzing their sales numbers, businesses can find new ways to grow, increase revenue, and stay competitive.

PowerBI Project

CodeX Insight Analysis

Domain/Function: F & B

CodeX Energy Drink, a growing brand in the energy beverage industry, faces challenges in targeting the right demographics and understanding consumer preferences. To address this, the marketing team seeks actionable data-driven insights to refine strategies and enhance brand positioning.

View Project
Engagement

View Project
on GitHUB

The Dashboard Home Page contains buttons for all the views. Users can go to a specific view by clicking on the corresponding icon.

Consumer Preference dashboard showcasing age and gender preferences

Project Details

This project aims to help the marketing team understand consumer behavior, identify effective marketing channels, and create strategies for better outreach and brand growth.

The focus is made on the following:
1. Building a strong data model.
2. User-friendly report design.
3. Delivering actionable insights.

I learned the following things in this project:
1. Power Query (Data Cleaning & Transformation).
2. Writing DAX formulas for advanced analysis.
3. Data modeling for structured insights.
4. Selecting effective visuals and layouts.
5. Principles of interactive dashboard design.
6. Publishing dashboards in Power BI Service.
7. Refining designs based on feedback.

This project supports marketing teams in understanding customer preferences, refining marketing strategies, and improving brand positioning against competitors.

Live Interactive Dashboard

PowerBI Project

AtliQ Motors Insight Analysis

Domain/Function: Automotive

AtliQ Motors, a prominent EV manufacturer, is navigating challenges in a rapidly growing electric vehicle market. With a need to enhance market strategies and counter competition, the company relies on actionable insights derived from a detailed sales analysis of electric vehicle

View Project
Engagement

View Project
on GitHUB

Makers Inight Dashboard

State Inight Dashboard

Project Details

This project aims to empower the leadership team at AtliQ Motors with insights into electric vehicle sales trends, helping them make informed decisions to improve market strategy and revenue growth.

The focus is made on the following:

Developing a robust data model to analyze EV sales.
Designing an intuitive and user-friendly dashboard.
Delivering actionable insights, including key growth metrics like CAGR.
Throughout the Project, I Learned:
Power Query (Data Cleaning & Transformation).
Writing advanced DAX formulas, including CAGR calculations.
Building a structured and efficient data model.
Choosing impactful visuals and layouts.
Implementing principles of interactive dashboard design.
Publishing dashboards using the Power BI Service.
Enhancing dashboard design based on feedback and end-user needs.
This project provides a comprehensive view of EV sales, helping AtliQ Motors identify growth opportunities, optimize strategies, and strengthen its market presence.