Project Details

Business Insights 360 is a unified Power BI dashboard designed for executives and department heads across Finance, Sales, Marketing, Executive and Supply Chain. Built using robust data modeling, optimized DAX, and interactive features like bookmarks and drill downs, the dashboard simplifies complex datasets into intuitive, actionable insights.

I learned the following things in this project :
1) Power Query – basic to advanced
2) DAX – simple to complex formulas
3) Data modeling – 10+ tables
4) Visual selection & formatting
5) Dashboard design principles
6) Bookmarks & drilldowns
7) Power BI Service deployment
8) Stakeholder feedback integration
9) Cross-domain business metrics

Impact:
+30% Reporting Efficiency | +10% Revenue Growth | –20% Cost Reduction

Live Interactive Dashboard

Project Details

In this project, I built a Power BI dashboard using historical hotel booking data to support AtliQ Grands' revenue team in making data-driven decisions. The objective was to translate stakeholder mockups and a metric list into a visual analytics solution focused on revenue recovery.

Key focuses included:
-KPIs like RevPAR, ADR, Occupancy %, and Realisation %
-Dashboard design from stakeholder mockups
-Tooltip pages for detailed trend insights
-Data modeling using 5+ relational tables
-Weekday vs weekend revenue comparison

I gained hands-on experience in:
-Power BI data modeling & DAX calculations
-Power Query for data transformation
-KPI creation and business-driven visuals
-Insight generation beyond given metrics
-Enhancing user experience with interactive design

The final dashboard helped identify key revenue trends and guided strategic decisions.

Live Interactive Dashboard

Project Details

This project entails a detailed data analysis of a pizza delivery business, leveraging structured query language (SQL). The primary objective is to extract actionable insights into customer behavior, sales patterns, and product performance by analyzing transactional sales data organized across multiple interrelated tables.

Objectives and Key Analyses Conducted:
- Order Volume and Revenue Analysis
- Product Performance Insights
- Category and Size Distribution Analysis
- Temporal Trends Examination
- Revenue Performance Evaluation

Tools and Techniques Utilized:
SQL: The analysis was fully conducted using SQL, applying advanced functionalities such as:- Joining data from multiple tables
- Aggregation techniques (e.g., SUM, COUNT, AVG)
- Window functions (e.g., RANK, CUMULATIVE SUM)
- Sub queries and nested selects

- Data Modeling: Essential for comprehending the relationships among tables like orders, order_details, pizzas, and pizza_types.

Project Details

Project Overview:

AtliQ Media, a private media company, aimed to create a special broadcast for the 2024 Lok Sabha elections. Rather than engaging in typical debates, they wanted to present unbiased insights and explore themes like voter turnout. As a data analyst, I was tasked with this mission, leveraging guidance from my manager and addressing key questions.

My Approach:

1. Incorporated additional data from official government sites to enhance the analysis.
2. Cleaned and organized data using SQL.
3. Developed interactive visualizations and crafted a compelling presentation.

The project demonstrated my ability to handle large datasets, conduct thorough analysis, and deliver clear, impactful insights.

Project Details

In this impactful project, I've leveraged Excel pivot tables to create dynamic sales reports that empower businesses to optimize customer discounts, streamline negotiations, and identify lucrative market opportunities. These reports aren't just data summaries; they're strategic assets delivering actionable insights to elevate sales strategies, bolster customer satisfaction, and drive revenue growth.

My journey through this project honed my expertise across pivotal areas:
1. Mastering pivot tables for comprehensive data analysis.
2. Harnessing the power of Power Query for seamless data integration.
3. Commanding the fundamentals of DAX for advanced data modeling.
4. Elevating data presentation through strategic conditional formatting.
5. Extracting invaluable insights from sales metrics to fuel strategic decisions.

This project is more than just number-crunching—it's about arming businesses with the tools and knowledge to supercharge their sales initiatives.