Project Details

Crafted a detailed report using Power BI for Shield Insurance LTD to analyze sales and customer demographics, offering insights to enhance business decisions.

Process:-
Data Management: Leveraged Power Query and MS Excel for data cleaning and organization.
Visualization: Designed interactive dashboards with Power BI, incorporating Canva for aesthetics.
Analysis: Examined age group trends, sales channels, and revenue growth.

Achievements:-
Identified key customer segments for targeted marketing.
Pinpointed effective sales channels, boosting strategic planning.
Presented month-over-month performance metrics.

Tools:-
Power BI & Power Query for data analytics.
MS Excel for dataset management.
Canva for creative design elements.

This project showcases my ability to transform data into strategic insights, underpinning decision-making and fostering company growth.

Live Interactive Dashboard

Project Details

Academic Performance Analytics Dashboard is a dynamic tool designed to transform data into actionable insights for educators.
It features two core components:
a) Class Overview Dashboard that offers an aggregated view of average scores, trend analysis, and highlights both top performers and those needing attention.
b) Individual Dashboard allows for detailed monitoring of a student's performance across subjects, pinpointing strengths and areas requiring support. With functionalities like zoom-in for detailed test analysis and topics coverage.
The dashboard is pivotal for tailored educational strategies.
Database Design: MySQL
Used Star Schema Tables for optimized data storage and swift retrieval. Ensured rapid data retrieval for dashboard updates.

Data Visualization: Power BI
Expertly designed dashboards that are visually appealing and informative. Interactive features, including the 'Zoom In' tool, add depth to the analysis.

Live Interactive Dashboard

Project Details

This project, part of a monthly challenge by Codebasics, addresses the fictional company AtliQ Grands, which operates several five-star hotels across India and faces a decline in market share due to ineffective management decisions. The key objective is to leverage business and data intelligence to pinpoint gaps in strategy and improve decision-making. The tasks include creating specific metrics, developing a dashboard based on a provided mock-up, and generating relevant insights beyond the provided metrics and dashboard designs.
The data model is structured in a star schema, centralizing fact tables surrounded by dimension tables. Significant data cleaning was done using Power Query, especially in calculating revenue based on booking status & used DAX formulas for manipulating dates and getting required KPI's.
The project's report offers insights into AtliQ Grands' finances and performance, emphasizing crucial metrics like revenue and cancellations, to enhance revenue strategies.

Live Interactive Dashboard

Project Details

The Business Insights 360 project, a part of the Codebasics Data Analytics Bootcamp, focuses on using Power BI to enhance AtliQ Hardware's business strategy. AtliQ, a global hardware manufacturer, is struggling in Latin America. The project aims to move from intuition-based to data-driven decisions. The Power BI dashboard includes Finance, Sales, Marketing, Supply Chain, and Executive views to provide a comprehensive business analysis. The project involves real-life business scenarios, stakeholder feedback, and dynamic reporting. Key steps include data loading into MySQL, validation, transformation, and modeling using DAX formulas, and report optimization for user accessibility. The final outcome is a dynamic dashboard with multiple views, catering to different stakeholder needs, and a home page for easy report navigation.

Live Interactive Dashboard

Project Details

Dive into the Yummy Pizza Sales Analysis where SQL meets Power BI to transform data into actionable intelligence. This project is a blend of rigorous data validation using MySQL and creative data storytelling through Power BI dashboards. We've crunched numbers to capture total revenue, average order value, pizza counts, order tallies, and average pizzas per order. Explore the intricacies of sales trends, customer behaviors, and purchasing patterns. A savory mix of analyses reveals top/bottom-selling pizzas by revenue and quantity, offering Yummy Pizza strategic data to spice up their marketing efforts and menu decisions.

Live Interactive Dashboard