Click here to Skip to main content
15,304,276 members
Articles / Hosted Services / Azure
Posted 8 Jul 2021


2 bookmarked

Dazzling Dashboards and Business Intelligence with Azure Synapse Analytics Part 1: Overview

Rate me:
Please Sign up or sign in to vote.
5.00/5 (1 vote)
8 Jul 2021CPOL3 min read
In this article, we explore how Azure Synapse Analytics combines all the tools business intelligence specialists and data scientists need to analyze data and create visualizations.
In the first article in this series, we learn how Azure Synapse Analytics brings together all the tools that data scientists and business intelligence (BI) specialists need to get the most out of their data, and discussed the specific tools we need.

This article is a sponsored article. Articles such as these are intended to provide you with information on products and services that we consider useful and of value to developers

We data scientists and business intelligence (BI) specialists need the right tools to succeed. However, it’s a complex effort to pull data from multiple systems and then use a wide range of separate tools to understand and report business data.

Microsoft’s Azure Synapse Analytics gathers all the tools we need into one location. This all-in-one data hub helps us save time and focus on what we love to do: delve deep into our data to extract valuable insights.

Azure Synapse Analytics helps us easily pull and connect data from multiple sources — and types of sources. Azure Synapse Analytics streamlines this process into repeatable, scheduled pipelines. It allows us to explore the data using queries directly in the dashboard, experiment inside notebooks, then publish and share our visualizations and findings with others so they can get as excited about the data as we are.

In this series of articles, we’ll use the Contoso BI Demo Dataset for Retail Industry to demonstrate how Azure Synapse Analytics turns data into clear and helpful visualizations. We won’t go through every feature Azure Synapse Analytics offers, but we’ll reveal some of what these tools can do. We may inspire you to explore more business intelligence tools for your own data needs.

Image 1

Here’s a brief overview of the steps we’ll take:

  1. Import the dataset into Azure.
  2. Create a workspace and ingest the data.
  3. Run SQL queries and build a notebook to view and transform the data.
  4. Create and publish visualizations.

Although this dataset is fictional, it represents realistic data. Our goal in this series is to answer some fundamental business questions using this data, such as:

  • What are our total revenue and gross profit?
  • Which stores are performing best?
  • Which products are selling the most and least?
  • How much revenue is each channel (store, online, catalog, or reseller) generating?
  • Which promotions were the most effective?

Preparing for our Project

Before we get started, we must ensure we have all the tools we need for this project. All of these tools are either free or include a free trial. To follow along, make sure you have the following:

Now that we have everything we need, we can begin our project.

Next Steps

To learn more about Azure Synapse Analytics, register to view the Hands-on Training Series for Azure Synapse Analytics and continue to the second article of this series to learn how to import and analyze business intelligence data.

This article is part of the series 'Dazzling Dashboards and Business Intelligence with Azure Synapse Analytics View All


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Raphael Mun
United States United States
Raphael Mun is a tech entrepreneur and educator who has been developing software professionally for over 20 years. He currently runs Lemmino, Inc and teaches and entertains through his Instafluff livestreams on Twitch building open source projects with his community.

Comments and Discussions

-- There are no messages in this forum --