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

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

Project Details

Problem Statement:
AtliQ Grands owns multiple five-star hotels across India. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands is losing its market share and revenue. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue.
Workflow steps:
1. Data collection and exploration, create a Date table in Power Query (M language).
2. Data load to Power BI and initial validation.
3. Data Transformation in Power Query.
4. Data Modelling and creating calculated columns.
5. Creating measures using the DAX language.
6. Build Executive View, Finance View, Revenue View, Occupancy and Booking View and Key Metrics View.
7. Designing an effective Dashboard that includes page navigation with buttons, tooltips, using KPIs, and conditional formatting of the values in visuals.
8. Deploying the solution using Power BI.

Live Interactive Dashboard

Project Details

1. Ad-hoc Query Resolution:
Analyzed and resolved 10 ad-hoc requests using fundamental SQL concepts. Applied WHERE clause, GROUP BY, ORDER BY, JOINS, CTE, WINDOW FUNCTION, etc. Ensured accuracy and efficiency in data retrieval for each query.

2. Power BI Data Visualization:
Exported query results to Power BI for robust data visualization. Employed effective visualizations such as bar charts, pie charts, maps, donuts, and line charts. Utilized conditional formatting to enhance clarity and highlight key insights.

3. Insights Presentation:
Delivered a comprehensive video presentation explaining insights derived from visualizations. Shared meaningful observations and actionable recommendations. Ensured a clear and engaging narrative to facilitate understanding.

This integrated approach, from ad-hoc query resolution to impactful data visualization and insightful presentation, demonstrates a holistic strategy in transforming raw data into actionable informed decision-making.