Powered by
Codebasics DA Bootcamp

Sibha Patait

Data Aspirant

+91 9307502261 [email protected]

Hello, I am

Sibha Patait.

1

Excel Project

2

PowerBI Projects

2

SQL Projects

1

Python Project

About Me

Hello everyone,

I’m an aspiring Data Analyst with a BBA in Finance and a passion for working with data to uncover insights that drive smarter decisions. My interest in analytics led me to build strong skills in Advanced Excel, Power BI, SQL, and Python.

Through hands-on projects, I’ve learned how to clean, analyze, and visualize data to solve real-world business problems. I enjoy turning raw data into clear, actionable insights and am excited to contribute to a team that values data-driven thinking.

Feel free to check out my work and connect. Thank you for reading. 😊

#DataAnalytics #AspiringDataAnalyst #PowerBI #SQL #Python #Excel #DataDriven

Key Skills

stakeholder management

presentation skills

business acumen

advanced excel

sql

power bi

python

My Projects

My Experience

Awards & Certificate

Excel: Mother of Business Intelligence

Tableau Mini

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Microsoft Fabric Mini: For Data Analysts

SQL (Basics)

SQL (Intermediate)

SQL (Intermediate)

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.

[email protected]

https://www.linkedin.com/in/sibha-patait-147b632b7/

+ 91 9307502261

https://github.com/Sibha-Analytics

Excel Project

Sales and Finance Report

Domain/Function: Sales - Finance

Generated actionable insights via robust sales and financial analytics within the FMCG sector. Enabled businesses with data-driven strategies, showcasing proficiency in ETL, Power Query, Power Pivot, DAX, and user-centric report design for optimal decision-making, growth, and expansion.

View Project
Engagement

View Project
on GitHUB

Sales and Finance Report

Customer performance report : provides net sales performance of each customer across years

Sales and Finance Report

Market performance vs Target report across years: enables stakeholders to assess the country's performance and compare it to set targets

Project Details

Steps in Making this Report-

1. ETL (Extract Transform Load) Process
Loaded and processed CSV files in Power Query, ensuring data integrity, uniqueness, and correcting errors before integrating into Power Pivot.

2. Data Modeling
Implemented a star schema, created dim_date table with a fiscal year perspective, ensuring seamless integration with other tables.

3. Pivot Table and Power Pivot Integration
Integrated the data model with a Pivot Table for quick analysis, utilizing Power Pivot for efficient data transformation and connectivity.

4. DAX (Data Analysis Expressions) Formulas
Developed 10+ new measures and columns using DAX, including Net Sales, Gross Margin, GM%, COGS, and applied a fiscal year perspective for deeper insights.

5. Conditional Formatting
Applied Conditional Formatting to enhance data presentation, highlighting key information, identifying trends, and improving overall data readability for effective analysis.

PowerBI Project

Business Insights 360

Domain/Function: Sales - Marketing - Finance

AtliQ Hardware, a global manufacturer, tasked us with extracting insights from their 1.8 million-entry dataset. Crafted reports and dashboards, enabling data driven decision making across diverse business domains such as Finance, Sales, Marketing, Supply Chain and Executive.

View Project
Engagement

View Project
on GitHUB

Business Insights 360

User- empathetic landing page As a part of dashboard design

Business Insights 360

Data Modelling Involving 10+ Tables

Project Details

1. Connect & Import Data:
Ingested over 1.8 million records from diverse sources like Excel, CSV, and MySQL into Power BI, ensuring a unified data platform for in-depth analysis.

2. Extract, Transform & Load Data (ETL):
Applied Power Query for seamless extraction, transformation, and loading, optimizing data flow. Leveraged DAX Studio to reduce load time and storage by 25%.

3. Data Model and DAX:
Engineered a robust data model with 15+ tables using a Snowflake Schema, fostering efficient relationships. Utilized DAX for insightful calculated columns and measures.

4. Create Reports:
Crafted tailored reports, including P&L for Finance, Sales Performance Matrix, NP% and GM% for Marketing, Forecast Accuracy for Supply Chain, and Market Share Trend for Executives.

5. Dashboard Creation:
Engineered a versatile Power BI dashboard, catering to AtliQ Hardware's departmental needs, facilitating a holistic view of critical insights.

Live Interactive Dashboard

SQL Project

Ad-Hoc-Insights

Domain/Function: Consumer Goods

AtliQ Hardwares, a leading computer hardware producer, faced challenges in making data-driven decisions. To solve this, they needed a comprehensive report to analyze business queries. This involved utilizing SQL for data analysis and Power BI for creating clear, actionable insights.

View Project
Engagement

View Project
on GitHUB

Ad-Hoc-Insights

The image shows an SQL query that retrieves a list of markets where the customer "Atliq Exclusive" operates in the APAC region.

Ad-Hoc-Insights

This shows the highest and lowest manufacturing cost product.

Project Details

Title: Ad-Hoc Insights

Company: AtliQ Hardwares (an imaginary leading computer hardware producer in India with a global presence)

Challenge: AtliQ Hardwares aimed to enhance data-driven decision-making by expanding their analytics team. Tony Sharma, the Data Analytics Director, devised a SQL challenge to evaluate candidates' technical and soft skills.
My Task: As a hypothetical applicant, I:

Reviewed 'ad-hoc-requests.pdf' with business queries.
Crafted and executed SQL queries.
Developed a Power BI and PowerPoint presentation to showcase insights to top management.

Approach: Utilized MySQL for data retrieval and analysis. Designed a professional presentation to communicate findings and recommendations effectively.

Outcome: This project demonstrated my ability to handle complex data queries and present findings effectively, enhancing both my technical and communication skills.

Python Project

AtliQ Hotels Data Analysis

Domain/Function: Hospitality

Atliq Grands a well established entity in India's hotel industry is currently facing competition and a decline in revenue to address these, my aim is to empower atliq grands to make informed decisions and regain a competitive edge in the industry

View Project
on GitHUB

AtliQ Hotels Data Analysis

DATA CLEANING

AtliQ Hotels Data Analysis

DATA TRANSFORMATION

Project Details

Project Goal
The goal of this project is to conduct a comprehensive analysis of the hotel domain using Python. By employing data-driven insights and strategic recommendations, my aim is to empower Atliq Grands to make informed decisions and regain a competitive edge in the industry.

Project Highlights
Data Cleaning- Handling missing values and outliers.
Data Transformation - Added occupancy% columns.
Insights generation-key questions answered
calculating average occupaancy rate by room type and city.
Identifying occupancy rate on weekdays and weekends.
Analyzing revenue

Skills Learned
Python Programming: Enhancing proficiency in Python for data analysis,cleaning ,transforamtion and visualization.
Data Viusualization: Leveraged Matplotlib library for creating charts and bars.
Pandas Fundamentals: creating various dataframes,group by functions,concate and merging,hanling NA values,read csv files etc.

SQL Project

Pizza Sales Analysis

Domain/Function: Food & Beverage

Analyzed pizza sales data using SQL to uncover insights on sales trends, best-selling products, customer behavior, and operational efficiency. Helped inform data-driven strategies for improving performance and revenue.

View Project
on GitHUB

Pizza Sales Analysis

Query to find the most commonly ordered pizza size using SQL with result table.

Pizza Sales Analysis

SQL query calculates average pizzas ordered per day by grouping orders by date

Project Details

Project Overview:
This project involved a comprehensive analysis of pizza sales data using SQL to derive meaningful business insights. By examining key metrics across sales, product performance, and customer behavior, the analysis supported data-driven strategies to enhance sales and streamline operations.

🎯 Primary Objectives:
Sales Analysis: Track trends across different time periods and customer segments.
Product Performance: Identify best-sellers and underperformers.
Customer Insights: Understand preferences and ordering patterns.
Operational Efficiency: Analyze order timing and volumes for workforce and inventory optimization.

📈 Key Learnings:
SQL for real-world data analysis and business queries
Identifying sales trends and seasonal performance
Evaluating product popularity and profitability
Gaining customer behavior insights
Conducting revenue and performance reporting
Supporting strategic decisions through data

PowerBI Project

Revenue Insights in Hospitality Domain

Domain/Function: Luxury Hospitality

AtliQ Grands, a renowned name in India’s luxury hotel industry for over two decades, is currently facing a decline in market share and revenue, driven by intensifying competition and internal management inefficiencies. To address these challenges and regain its competitive edge, my objective is to i

View Project
on GitHUB

Revenue Insights in Hospitality Domain

Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage, average rates and other metrics.

Revenue Insights in Hospitality Domain

Examines booking patterns, cancellations, and guest behavior. Generates actionable insights to improve operational efficiency and drive revenue growth

Project Details

I crafted this project as a third-party data analyst to assist AtliQ Grand, a renowned hotel chain, in reclaiming lost market share and boost revenue. Facing tough competition and lacking data-driven decisions, they sought expertise to turn the tide.

This project offers three comprehensive views:

Performance Overview:
Gives a snapshot of vital performance indicators like revenue, RevPAR, and occupancy percentage. Detailed metrics such as average rates and cancellation percetage are included.

Revenue Breakdown:
Delves into revenue distribution across cities, hotel categories, and booking platforms. These insights are crucial for optimizing sales strategies.

Booking Analysis:
Examines booking patterns, cancellations, and guest behavior. This yields actionable insights to improve operational efficiency and drive revenue growth.

I learned the following things in this project

1. Data Visualization
2. Revenue Analysis
3. Presentation Skills
4.Critical thinking
5. Dax

Live Interactive Dashboard