Microsoft Power BI
Power BI is a unified, scalable platform for self-service and enterprise business intelligence (BI). Connect to and visualize any data, and seamlessly infuse the visuals into the apps you use every day.
Microsoft Power BI contains of 3 different programs:
Get started building with Power BI
Microsoft have created a very good getting startede guide Get started building with Power BI
Northwind
All the data from the Northwind database are copied into one Excel file.
Excel file
Tables
- Customers
- Orders
- Order_Details
- Products
- Categories
- Suppliers
- Employees
ER-Diagram
Supermarket - Demo
The data for this demo project are from kaggle.com
Context
The dataset is one of the historical sales of supermarket company which has recorded in 3 different branches for 3 months data.
Predictive data analytics methods are easy to apply with this dataset.
The dataset has:
- 16 columns
- 1.000 rows
Information
There are several question we could get the answers from the dataset:
- How many total purchases were made per branch, and which branch had the highest total purchasing?
- Show the data about comparison of customer type per branch!
- Show the data about comparison of gender among customers, and which gender has a higher representation?
- Show the data about comparison of payment methods used by customer!
- What are the top 3 best-selling items, and how do the product lines rank based on the highest quantity sold?
- Sorted the product line based on the highest of total purchasing
- What is the total purchasing of each product line in every month?
And proberly more!
Files
I have converted the datafile a little, you can get my version in CSV or Excel:
DAX
DAX stands for Data Analysis Expressions, i.e. such expressions or formulas that are used for data analysis and calculations.
DAX formulas are very useful in Power BI, as they help data analysts to use the data sets they have to the fullest potential. DAX is used in Power BI, Excel, Power Pivot and also in Analysis Services.
DAX is a data functional language which has several prebuilt functions, operators and methods which allow us to do calculations on data as well as transformations on it.