Data Science — Building a Network Graph using Microsoft Power BI for SQL Relational Data

Data Science — Building a Network Graph using Microsoft Power BI for SQL Relational Data

This article will discuss how to build a network graph for SQL relational data stored in SQL Server. It may be of interest to folks (e.g. software engineers, data engineers, database administrators) who want to take on some data science projects.

Network Theory is a state-of-art theory that is used to represent the complex relationships between entities. Some interesting applications are pandemic diffusion analysis (e.g., COVID19), social network analysis (e.g., Facebook network), world trade analysis, etc.. Network Graph is built upon the Network Theory and can provide a dynamic, sometimes mind-blowing, graphs for storytelling.

This article will discuss how to build a network graph for SQL relational data stored in SQL Server. It may be of interest to folks (e.g. software engineers, data engineers, database administrators) who want to take on some data science projects.

Here is a final network graph for sales data for bike-related products. Note that I am not using all the data for simplicity and cleaner view for demo purpose.

power-bi visualization network-graph data-science network-theory

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Building a Network Graph in Power BI using the Custom Visual

A quick start guide on building a network graph in Power BI using the Custom Visual. Network Navigator is a custom visual in Power BI that is created by Microsoft.

Tableau vs Power BI: Comparing the Data Visualization Tools

In analytics, Tableau is the leading visualisation tool. Its rich analytical features and attention to data details are the reason behind its popularity. Power BI, on the other hand, is preferred by professionals who are more comfortable with...

Explore your JIRA Data with Power BI

JIRA Software provides bug tracking, issue tracking, and project management capabilities for teams and organizations. The JIRA content pack for Power BI helps you quickly import JIRA data so you can get an instant dashboard to analyze workloads...

Managing your Data with Microsoft’s Power BI

In a world where the sheer amount of data is often overwhelming, the ability to interrogate and organise data to make meaningful business decisions is more important than ever. Microsoft have created Power BI to enable every day users to use the...

Power Query tips for every Power BI Developer

Use these simple yet powerful techniques to speed-up your Power BI development. If someone asks you to define the Power Query, what should you say?