This project demonstrates how a network graph can be built to visualize relational data in SQL Server using Microsoft Power BI. Sample sales data from the Microsoft AdventureWorks sample database is used.
The goal of this project is to answer some of the most commonly asked questions by executives on the sales data, such as:
- What products are sold?
- Where are products sold to?
- How many products are sold or how much are products sold for?
- Are there any correlation between product and customer geographical locations?
- For a brand new product, where should it be marketed and sold to?
For a detailed discussion on the visualization, please see my recent article, Data Science — Building a Network Graph in Power BI using SQL Server (link: https://medium.com/@ss.shawnshi/data-science-building-a-network-graph-in-power-bi-using-sql-server-a1b4c9b7610a)
Prerequisites
- Microsoft Account. You can register for free.
- Power BI Desktop. You can download it for free from this Microsoft link.
- SQL Server. You can download it for free from this Microsoft link.
- Microsoft sample database "AdventureWorksLT2016"
You should be able to clone the repo and open the AdventureWorks.pbix workbook.
