Power BI Portfolios

Explore our collection of innovative Power BI projects showcasing our expertise and creativity in data visualization.

Wine Analysis Report

Wine Analysis Summary

Thank you for visiting our Wine Analysis project, created for a fictional wine magazine called WineMag. This dataset includes over 120,000 wines, featuring data on price, rating points, geographic origin, and expert reviews. The ratings were provided by professional sommeliers, many of whom also wrote detailed tasting notes.

You can explore the data by continent and country. From the main page, you can right-click any continent listed in the graphs to drill through to individual countries and the wines they produce.

There are four buttons that guide you through different aspects of the analysis:

🍷 Wine Selection

Use this page to find wines based on price and quality. A custom value index was calculated by comparing a wine's price to the rating points given by sommeliers. This helps you discover great-value bottles.
➡️ Tip: Hover over the index to see how it was calculated.

💰 Price Influencers

Explore the key factors that influence wine pricing using Power BI’s Key Influencer visual.
⚠️ Note: This visual does not render when embedded on a website, but you can:

• Download the .pbix file to view it locally in Power BI Desktop, or

• View the report in full using Power BI Service.

🧑‍💼 Sommelier's Opinions

See which sommeliers contributed reviews and how they scored wines across different regions and price points.

✍️ Descriptive Words

Explore the language used by sommeliers to describe wines. This page breaks down common review terms by point rating level, offering insight into how quality influences tasting notes.

Marketing Campaign Report

Marketing Campaign Summary

Marketing Campaign Dashboard Summary

Thank you for viewing our Marketing Campaign Dashboard. This project showcases a fictitious marketing campaign for a supermarket.

The dataset includes six marketing campaigns that were created and promoted. It also contains extensive customer data, which we used to analyze how customer profiles and campaign exposure influenced sales across different product categories: baked goods, fish, fruit, meat, sweets, and wine.

Campaign Performance

This page provides a breakdown of:

• Which customers accepted the marketing campaigns

• The products they purchased

• Their preferred sales platforms

Buyer Composition

This section offers insights into customer profiles, helping us understand purchasing behavior by demographic. It also allows for comparison between customer groups and the campaigns they responded to.

Purchase Drivers

This page highlights the key factors influencing sales, broken down by marketing campaign. The data is further segmented by product category to reveal what drives customer purchases in each area.

Housing Market Report

Housing Market Summary

Housing Market Report – Austin, Texas

Thank you for viewing our Housing Market Report. All data in this report is sourced from the Austin, Texas area.

The report is designed as a single interactive page with a navigable cover page. You can access each section of the report directly from the cover page. On the main report page, use the icons in the upper left corner to quickly navigate to different sections.

Summary

This section provides a high-level overview of the dataset. It includes:

• Total listings

• Average and range of prices

• Home sizes and build years

• Common features and home types

• A location map of the properties

Location

This interactive map allows you to zoom in and out to view property locations across the Austin area. Hovering over a property will display a tooltip with detailed information about that specific listing.

Schools

The Schools section provides details about schools in the area. You can:

• Filter by school rating, school size, and student-to-teacher ratio

• Zoom in on the map to explore the school zones and nearby properties in more detail

Key Influencers

This section analyzes how different home features impact property prices. You can:

• View relationships between home attributes and pricing

• Explore detailed data on specific properties

• See a breakdown of descriptive words commonly used in property listings at various price points

Human Resources Report

Human Resources Summary

Thank you for reviewing our HR Analytics Report. This is a simulated dataset representing a company's human resources metrics. You can begin at the cover page and navigate to the Headcount, Retention, and Turnover sections.

👥 Headcount

This section provides an overview of the company’s workforce. You can break down employee data by:

• Department

• Job Level

• Location

• Gender

• Age

• Education

• Marital Status

📈 Retention

This page presents employee retention trends beginning in 2012, the company’s first year of operation. However, meaningful trend analysis is best viewed starting from 2013.

Visuals include:

• Retention over time

• Retention by job level

• Retention by department

• Key influences impacting employee retention

🔁 Turnover

This section displays employee turnover across the years, starting from 2012. You can filter by:

• Job Level

• Department

• Reason for Termination

• Termination Type

You can also click on an individual employee to view specific details related to their departure.