Projects
A collection of business intelligence dashboards and analytics projects built using Power BI, Tableau, SQL, and Python demonstrating data cleaning, modeling, visualization, and insight generation.
Reliance Business Performance Dashboard
Tools Used: Power BI, DAX, Power Query, Data Modeling
- Developed multi-page dashboard comparing Retail (FMCG) and Fuel division performance.
- Structured synthetic dataset with seasonality; performed Power Query transformations.
- Built star-schema model with Date Table and relationships.
- Created DAX measures: Total Sales, Profit, Margin %, MoM Growth, YoY Trends.
- Insights: seasonal demand patterns, top regions, margin inconsistencies, revenue gaps.
Business Impact: Helps stakeholders identify revenue trends, high-performing regions, and operational insights that support data-driven decision making.
Cleaning Services Performance Dashboard
Tools Used: Power BI
- Built operational dashboard tracking revenue and service productivity.
- Visualized revenue by suburb, service type, and monthly performance.
- Used slicers for service type, suburb, and payment status.
Business Impact: Allows service managers to identify high-performing areas and optimize workforce allocation.
Global Trends Explorer
Tools Used: Power BI
- Analyzed global economic indicators including GDP and unemployment.
- Built map visuals and time series analysis.
- Enabled country and region-based filtering.
Business Impact: Provides insights into global economic trends and regional development patterns for research and policy analysis.
Road Safety Insights Dashboard
Tools Used: Power BI, Python
- Analyzed accident data by road condition, vehicle type, and severity.
- Visualized casualty distribution by age and gender.
- Identified accident patterns using interactive visuals.
Business Impact: Supports road safety authorities in identifying high-risk conditions and planning preventive measures.
Workforce Lens: Employee Insights Dashboard
Tools Used: Power BI
- Analyzed employee salary distribution and compensation components.
- Visualized workforce demographics across departments.
- Identified salary trends based on experience levels.
Business Impact: Helps HR teams analyze compensation patterns and workforce structure to support better HR decision making.
Financial Overview Dashboard
Tools Used: Power BI, DAX, Excel
- Designed financial dashboard tracking revenue, expenses, and profit margin.
- Built KPI cards and trend analysis visuals.
- Analyzed revenue vs expenses and operating cost patterns.
Business Impact: Helps finance teams monitor financial performance and identify cost inefficiencies to improve profitability.
Customer Analytics Dashboard
Tools Used: Power BI
- Analyzed customer acquisition and repeat customer trends.
- Identified high-value customers using segmentation.
- Tracked revenue contribution by customer segments.
Business Impact: Helps businesses improve customer retention and optimize marketing strategies.
Inventory Management Dashboard
Tools Used: Power BI
- Tracked inventory value and stock levels across products.
- Identified low stock alerts and dead stock.
- Analyzed supplier performance and stock turnover.
Business Impact: Helps operations teams maintain optimal stock levels and prevent inventory shortages.
Sales Performance Dashboard
Tools Used: Power BI
- Tracked revenue trends and product performance.
- Analyzed regional sales and customer contribution.
- Identified top performing products and markets.
Business Impact: Enables sales teams to identify growth opportunities and optimize sales strategies.