Skip to content

A Power BI project on Adventure Works dataset. The project includes Power BI interactive dashboard visuals along with measures and calculated columns. Also with help of AI tools, anomaly and trends are observed in the dataset.

License

Notifications You must be signed in to change notification settings

AkashKV-1998/Power-BI-Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

17 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Adventure Works Project: Power-BI

A dynamic Power BI project that transcends traditional data analysis and visualization. Embark on a journey through the Adventure Works dataset where data comes alive, weaving a compelling narrative through meticulously crafted visualizations and cutting-edge AI tools.

Project Highlights:

  1. Dynamic Visualizations: 📊

Immerse yourself in a visually stunning dashboard that transforms raw data into actionable insights. Watch data tell a story, painting a vivid picture of trends, patterns, and outliers.

  1. AI Magic: ✨

Experience the future with built-in AI tools. Witness the power of forecasting as the system predicts future trends, and let anomaly detection unveil hidden gems within the dataset. The algorithm is the compass, guiding through the uncharted territories of the data.

  1. Intelligent Relationships: ↔

The heart of Adventure Insights lies in the interconnected web of datasets. Relationships are forged, creating a symphony of data points that harmonize seamlessly. Each connection deepens the understanding and unlocks layers of information.

  1. Calculated Wizardry: 🧙‍♂️

Behold the magic of calculated columns and measures! These behind-the-scenes conjurations extract valuable nuggets of wisdom, turning raw numbers into actionable metrics. Every calculation is a stroke of brilliance, illuminating the path to informed decision-making.

Power BI Structure:


i) The relationship created between the data can be found in the Model View Tab:

ii) The 'Executive Dashboard' explaining an overview of the data is on page 1:

iii) The 'Map' page gives details of 'Total Orders' in each country:

iv) The 'Product Detail' contains analysis and experiments conducted for the products in the data:

v) The 'Customer Detail' contains analysis and experiments conducted for the customers in the data:

vi) The page 'Discussion' contains a section that can be used to interact with AI to extract information from the data:


Reference:

  1. Microsoft Power BI Desktop for Business Intelligence, Udemy Course -- Main reference
  2. Prepare, Clean, Transform, and Load Data using Power BI, Coursera Project

About

A Power BI project on Adventure Works dataset. The project includes Power BI interactive dashboard visuals along with measures and calculated columns. Also with help of AI tools, anomaly and trends are observed in the dataset.

Topics

Resources

License

Stars

Watchers

Forks