Project Details

Throughout this project, I have acquired a robust skill set in data analysis and reporting, including:
>Data Cleaning and Preparation: Mastering techniques to transform raw data into refined datasets, ensuring accuracy and reliability for analysis.
>ETL Methodology: Proficiency in the Extract, Transform, Load (ETL) process, ensuring seamless handling of data from inception to fruition.
>Powerful Analysis Tools: Leveraging Power Pivot and Power Query to extract deeper insights and identify meaningful patterns within the data.
>Creating Useful Columns: Utilizing DAX to craft tailored columns in Excel, enriching analysis with bespoke metrics and dimensions.
>Understanding Data: Developing a keen eye for summarizing data and identifying pivotal trends, enabling informed decision-making.
>Interactive Reports: Designing dynamic dashboards that provide real-time insights, fostering agile and data-driven strategies.

Project Details

🛠 Tools Utilized:
SQL | Excel | Power BI Desktop | DAX Studio

🚀 Dashboard Highlights:
🏠 Home: Central hub for seamless navigation.
ℹ️ Info: Essential data repository for quick insights.
💰 Finance View: Dive into P&L, Net Sales trends, and top-performing products.
📊 Sales View: Analyze customer and product performance with detailed insights.
🎯 Marketing View: Evaluate GM% and NP% across segments and operational expenses.
📦 Supply Chain View: Monitor the dynamics of demand and supply.
📈 Executive View: Panoramic insights into overall company performance.

🔗 Key Learnings:
-Connected MySQL, Excel seamlessly.
-Transformed data with Power Query.
-Crafted Date table using M language.
-Developed robust data models and data cleaning.
-Initial Data Validation against Benchmark Numbers.
-Created dynamic visuals: Slicers, Tables, Matrix, Line charts.
-Applied Conditional Formatting.
-Optimized queries with Merged/Append and Power Query.
-Navigated Row and Filter context.

Live Interactive Dashboard

Project Details

Tools Used: MYSQL, EXCEL

Database Schema:
We've designed a database schema with below tables :
dim_customer
dim_product
fact_forecast_monthly
fact_sales_monthly
fact_freight_cost
fact_gross_price
fact_manufacturing_cost
fact_post_invoice_deductions
fact_pre_invoice_deductions

Created Tables, Functions, views & Stored Procedures in MYSQL

Analysis Tasks:
Top 5 customers by Net Sales
Top 5 Markets by Net Sales
Net Sales Global Market Share %
Net Sales % Share by Region(APAC & EU)

Conclusion:
The sales analysis of Atliq Hardware provides valuable
insights into customer preferences, market performance, and global market
share. By identifying top customers, markets, and regional sales distribution,
Atliq Hardware can strategize its marketing and sales efforts more effectively,
thereby optimizing revenue generation and market expansion opportunities.

Project Details

Key Insights:
📉 Discovered hidden trends
📊 Visualized sales patterns
🎯 Enabled data-driven decision-making

Highlighted Skills:
🧹 Expertise in data cleaning & preprocessing
💻 Proficiency in SQL querying
📊 Creation of Power BI dashboards

Tools - Power Bi, SQL

Here's a summary of the operations I've performed:
1. Data Gathering
2. Data Cleaning
3. Data Transformation
4. Data Modelling
5. Utilized DAX (Data Analysis Expressions)
6. Data Visualization
7. Sharing Insights

Project Details

Project Overview:
Utilizing advanced data analysis techniques, I delved into extensive datasets spanning multiple years and geographic regions to comprehensively understand the dynamics of road accidents and their impact on casualties.

Key Performance Indicators (KPIs):
Total CY Casualties
Total CY Accidents
CY Slight Casualties
CY Serious Casualties
CY Fatal Casualties

Casualties Analysis:
Casualties by Vehicle Type
Casualties by Urban/Rural
Casualties by Light Condition
Casualties by Road Type
Casualties by Location

This Road Accident Analytics Dashboard serves as a powerful tool for data-driven decision-making, enabling stakeholders to implement evidence-based interventions that enhance road safety.

Live Interactive Dashboard