Portfolio - Pradeep M

PowerBI Project

Business Insights 360

I created a Power BI dashboard called Business Insights 360 for AtliQ Hardwares, a company that sells computer hardwares. The dashboard helps them to understand their financial, sales, marketing, supply chain, and executive performance. It also shows them how accurate their predictions are and where

View Project
Engagement

View Project
on GitHUB

This is the finance view, which shows the important details of finance such as revenue, profit, cost, budget, variance, and ROI.

This is the executive view, which shows the key indicators of the company’s performance and how it compares to its competitors.

Project Details

Project Overview: I created a dashboard for AtliQ Hardware, a company that sells computer hardwares in India, to help them understand their business performance and make data-driven decisions.
Data Sources: I used data from Excel/CSV files and a MySQL database, and integrated them into Power BI using Power Query and DAX.
Data Analysis and Visualization: I developed a data model and created various charts and visuals to show the financial, sales, marketing, supply chain, and executive performance of the company.
Dashboard Interactivity: I also added features such as filters, slicers, drill-downs, and tooltips to make the dashboard interactive and user-friendly.
Performance Improvement: I optimized the dashboard’s performance using DAX Studio and best practices, resulting in a faster and more efficient report.
Business Impact: The dashboard helps AtliQ Hardware to identify their strengths and weaknesses, opportunities and threats, and areas for improvement.

Project video

Live Interactive Dashboard

PowerBI Project

Revive IQ Insights: Hospitality Analysis

Revive Insights 360 for Marriott Bonvoy: a PowerBI project revealing weekly hotel performance metrics, occupancy trends, room distribution, and KPI cards tailored for executive-level decision-makers.

View Project
Engagement

View Project
on GitHUB

Revive IQ Insights: Hospitality Analysis

Offers weekly hotel performance metrics, correlating guest stays with ratings and showcasing revenue/RevPAR trends across properties.

Curated for executives, it showcases hotel performance metrics, weekly occupancy trends, room class distribution and realization percentage changes.

Project Details

Leveraged Power BI to craft a data-driven tool boosting Marriott Bonvoy's hospitality game. Revive Insights 360 equips them with:

🔎 Booking Bonanza: Identifies top booking platforms.
🚫 Cancellation Conquering: Reveals cancellation patterns.
🤫 Guest Guru: Discovers guest preferences.

Features include:
📊 Dashboard of Destiny: Key metrics at a glance.
🏨 Hotel Hero Headquarters: Drill-down into hotel performance.
🔄 Room Roulette Revolution: Optimize room allocation.

Benefits:
🤓 Smarter Decisions: Data-driven decisions.
💰 Revenue Renaissance: Boost bookings & revenue.
🌟 Guest Satisfaction Soars: Understand guests better.

This project helps Marriott shine brighter in the hospitality industry!

Project video

Live Interactive Dashboard

Excel Project

Sales and Finance Analytics

AtliQ Sales and Finance Analytics Reports showcases my exploration into customer and market performance, financial health, and strategic decision-making. Leveraged ETL methodologies, Power Query, Power Pivot, and DAX to craft impactful reports.

View Project
Engagement

View Project
on GitHUB

The report discovers key insights and growth trends. A comprehensive analysis of various customers shaping the success of business.

This report uncovers key insights shaping our global business journey.

Project Details

Sales Report Insights:

📈 Explored customer sales figures and growth percentages over the years in the Customer Performance Report.
🌐 Conducted a detailed comparison between market performance and sales targets in the Market Performance and Sales Targets Comparison.

Finance Report Insights:

💹 Evaluated financial performance over different time frames in Profit and Loss (P&L) Reports by Fiscal Year and Months.
📊 Explored market-wise insights for benchmarking in Profit and Loss (P&L) Reports by Markets.

Technical Skills Gained:

🔍 Applied ETL methodology for efficient data processing.
🔄 Generated date tables and derived fiscal months and quarters with Power Query.
💡 Established data model relationships and incorporated supplementary data using Power Pivot.

Soft Skills Gained:

📊 Developed user-centric reports with empathy in mind.
🎯 Fine-tuned report generation processes for efficiency.
📅 Devised a systematic plan for building comprehensive reports.

SQL Project

Festive Campaign Analysis

Analyzed data from Diwali and Sankranti promotions using SQL and PowerBI. I uncovered which promotions worked best, increased sales significantly, and identified top-performing products.

View Project
Engagement

View Project
on GitHUB

To identify the top-performing products across all campaigns based on incremental revenue generated.

This dashboard was built with the intention of simplifying our findings for stakeholders to easily understand.

Project Details

Challenge: Analyzed massive festive promotions for Atliq Mart (50+ supermarkets) to deliver immediate insights for data-driven decisions.

Solution:
Consolidate data: Created a "sales summary" view for efficient analysis.
Uncover trends: Explored customer behavior & product performance.
Measure impact: Assessed sales, revenue, & engagement for each promotion.
Visualize success: Built interactive Power BI dashboards for clear communication.

Impact:
Sales soared: 107.64% increase during Diwali & 113.58% during Sankranti.
Strategic insights: Identified top-performing products & categories.
Data-driven decisions: Uncovered hidden patterns to inform future marketing.

Hello, I am

Pradeep M

2

1

1

About

Key

My

Business Insights 360

Revive IQ Insights: Hospitality Analysis

Sales and Finance Analytics

Festive Campaign Analysis

Awards

Contact Me

Email

Github

Linkedin

Pradeep M