Building simple Business Intelligence Project using Azure Synapse and Power BI

Spotify Data Analysis using Synapse and Power BI

Photo by Mike Kononov on Unsplash

In this article, I created a very simple end-end-end Business Intelligence (BI) project using Azure Synapse and Power BI. But, before that, what is BI? In short, BI is a process of collecting, storing, analyzing, and converting raw data into actionable insights which help organizations make better data-driven decisions.

This project was created using Azure Synapse analytics and used Spotify dataset. Azure Synpase is a unified platform which ingest, explore, prepare, transform, manage, and serve data for immediate BI and machine learning needs.

Image by Author

Below are the steps followed in this project (please refer to above),

1. Extracted data from Spotify API through Azure Synapse notebook (powered by Apache Spark)
2. Transformed the data again using Synapse notebook
3. Loaded the data into Azure Data Lake from the Synapse notebook
4. Analysed the data using Synapse notebook
5. Connected the data into Power BI from…