Portfolio - Divya Panseriya

Excel Project

Advanced Business Analytics Dashboard Project

Created a suite of advanced Excel dashboards that deliver comprehensive analyses of profit metrics, store performance, and revenue trends. This project supports strategic business decision-making by presenting essential data through visually compelling and user-friendly interfaces.

View Project
Engagement

Advanced Business Analytics Dashboard Project

Project Task Details Description

Dashboard Snapshot

Project Details

This project aims to harness advanced Excel functionalities to create dashboards that provide comprehensive business insights for strategic decision-making.
Profit View Dashboard: Focuses on financial metrics, customer demographics, and product insights, with a keen eye on trends affecting profit.
Timeframe Dashboard: Analyzes revenue patterns over different periods, emphasizing quarterly and weekday vs. weekend performance.
Store Dashboard: Provides detailed revenue breakdowns by store, highlighting performance against targets.
Technical Details and Tools Used:

Data Integration/Clean-up: Utilized Power Query.
Data Modeling: Employed Power Pivot.
Calculations: Created complex DAX measures.
Interactive Elements: Added slicers, option buttons.
Visualization: Used Zebra BI tables, and dynamic charts.
Automation: Developed macros, VBA code, and
linked dashboards.
User Controls: Enhanced with radio buttons.

Project video

PowerBI Project

Business Insights 360 Dashboard

This project offers a 360° view across finance, sales, marketing, and supply chain, fostering a deep understanding of the business landscape. AltiQ Hardwares' adoption of Power BI signifies a strategic shift towards data analytics, revolutionizing its approach.

View Project
Engagement

User-centric dashboard landing page for an intuitive experience.

In-depth data modeling across 10+ interconnected tables for comprehensive insights.

Project Details

This project aims to create a unified Power BI report for diverse stakeholders at AtliQ Hardwares, enhancing decision-making in sales, marketing, finance, and supply chain. The dynamic dashboard, enriched with visuals and strategic insights, is pivotal for actionable insights, ensuring unparalleled efficiency and growth across the organization. By seamlessly integrating data-driven principles, this initiative propels AtliQ Hardwares into a future of informed and strategic excellence.

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:
1. Advanced Power Query Operations
2. Simple & Complex DAX Formulas
3. Navigating 10+ Table Data Modeling
4. Visual Selection and Formatting Expertise
5. Dashboard Designing Mastery
6. Bookmark Integration Tactics
7. Efficient Power BI Service Deployment
8. Stakeholder Feedback Implementation Agility
9. Incorporating Domain-Specific Metrics

Live Interactive Dashboard

PowerBI Project

Sales Performance Analysis Dashboard

This project explores the intricacies of Awesome Chocolates' sales landscape, uncovering essential insights into regional sales, product trends, and the effectiveness of the sales team.

View Project
Engagement

Explore the pulse of sales across regions, product categories, and teams, with a dynamic visualization of sales trends over time.

Data Modeling

Project Details

This Power BI report delivers key insights into 𝐀𝐰𝐞𝐬𝐨𝐦𝐞 𝐂𝐡𝐨𝐜𝐨𝐥𝐚𝐭𝐞𝐬' 𝐬𝐚𝐥𝐞𝐬 𝐛𝐲 𝐫𝐞𝐠𝐢𝐨𝐧, 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐭𝐫𝐞𝐧𝐝 performance.

MySQL integration for seamless data import, Power Query ETL for data integrity, Star Schema and DAX for insightful data modeling and calculations, enriched with strategic report design and visualization techniques for maximum clarity and impact.

𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐅𝐞𝐚𝐭𝐮𝐫𝐞𝐬 𝐟𝐨𝐫 𝐏𝐫𝐞𝐜𝐢𝐬𝐢𝐨𝐧:
📊 Error Bars: For precise sales tracking.
🌍 Geospatial Analysis: Offers detailed regional sales insights.
🏆 Performance Metrics: Highlights salesforce effectiveness.
🔄 Data Series Overlap: Focuses attention on crucial metrics.
🃏 New Card Visuals: For intuitive report presentations.
🔍 Zoom Charts: Enables deep data exploration.

Enables Awesome Chocolate Company to refine production and marketing strategies, boosting profitability. Insights spotlight standout products and top performers for informed strategic planning.

Project video

Live Interactive Dashboard

SQL Project

Consumer Goods Ad-hoc Insights

This project analyzes consumer goods sales data for comprehensive insights. Focusing on ten critical aspects, it aims to provide informed decision support for sustained success. AtliQ Hardware prioritizes data-driven decision-making for enhanced performance.

View Project
Engagement

View Project
on GitHUB

Consumer goods 10 Ad-hoc request

Project Details

AtliQ Hardware sought comprehensive sales data insights to drive informed decisions amidst ten ad-hoc requests. Leveraging SQL for intricate queries, dynamic visualizations via Power BI, Excel for data validation, and impactful presentations with PowerPoint, I empowered AtliQ to maintain its competitive edge.

Key Findings & Recommendations:
- Market performance analysis and selling ratios are pivotal for growth strategies.
- Diversification of product range boosts sales and attracts a broader customer base.
- Low product variation signals the need for diversification to mitigate risks.
- Package deals facilitate cross-selling opportunities and enhance customer value.
- Dependency on top segments (Notebooks, Accessories, Peripherals) warrants diversification for market resilience.
- Misaligned discounts highlight strategy inefficiencies, necessitating optimization efforts.

Project video

PowerBI Project

Revenue Insights Hospitality Domain

Crafted a dynamic Power BI dashboard for the Revenue Management team at AtliQ Grands, delivering actionable insights to optimize revenue strategies and drive sustainable growth in the competitive hospitality market.

View Project
Engagement

The page is about using data analytics to revive AtliQ Grands' market position.

Data model structured in star schema with measures for analysis.

Project Details

Crafting a dynamic Power BI dashboard for AtliQ Grands' Revenue Management team involved identifying key metrics, cleaning and modeling data, and designing a user-friendly layout. The dashboard provides valuable insights into revenue trends, booking patterns, and performance metrics, empowering stakeholders to make informed decisions.

Key performance indicators (KPIs) such as Revenue, Occupancy% , ADR, DSRN, Realisation %, and RevPAR were meticulously calculated to gauge performance accurately.

In conclusion, this project exemplifies the integration of data intelligence to optimize revenue strategies and drive success in the hospitality industry, ultimately enhancing AtliQ Grands' market position and profitability.

Project video

Live Interactive Dashboard

PowerBI Project

Wavecon Telecom Analysis

The project focuses on analyzing the impact of 5G introduction at WAVECON TELECOM on revenue, market performance, and customer adoption, highlighting transformative shifts in the telecom industry.

View Project
Engagement

Tasked with analyzing 5G impact for comprehensive insights.

Overview for comprehensive project insights

Project Details

The analysis undertaken in this project rigorously evaluates WAVECON TELECOM's KPIs following the introduction of 5G, aiming to reveal the extensive impact of this new technology. It involves a detailed examination of revenue streams, KPIs after the 5G launch, and the effectiveness of various service plans, delving into the broader consequences of 5G implementation on the company's functioning.

With the telecom landscape being reshaped by 5G, Wavecon Telecom is experiencing a decline in revenues, a decrease in active user numbers, and a rise in subscription cancellations. Understanding the root causes of these trends and crafting appropriate strategic responses is essential.

This investigation into the transformative influence of 5G on the company's revenue, post-launch KPIs, and service plan performance sheds light on Wavecon Telecom's strategic approach in the face of technological progress.

Hello, I am

Divya Panseriya

1

4

1

About

Key

My

Advanced Business Analytics Dashboard Project

Business Insights 360 Dashboard

Sales Performance Analysis Dashboard

Consumer Goods Ad-hoc Insights

Revenue Insights Hospitality Domain

Wavecon Telecom Analysis

Awards

Contact Me

Email

Github

Linkedin

Call

Divya Panseriya

Download Resume