Azure Synapse has many features to help analyze data, and in this episode of Data Exposed, Ginger Grant will review how to query data stored in a Data Lake not only in Azure Synapse but also visualize the data in Power BI.

The demonstrations show how to run SQL queries against the Data Lake without using any Synapse Compute or data manipulation. Ginger will also walk-through the steps for how you can connect to Power BI from within Azure Synapse and visualize the data. To help get started Power BI and Azure Synapse, the video will walk through the steps to create Power BI Data Source files to speed connectivity.

Index:

  • 0:00 Introduction
  • 1:15 What is Azure Synapse
  • 2:27 What you can do with Azure Synapse
  • 3:40 Azure Synapse Studio
  • 5:10 Including PowerBI Demo
  • 9:40 When to use Azure Synapse

Leila Gharani explains why PowerQuery is such a powerful tool.

Excel Power Query has been a part of Excel since Excel 2016! It’s in the Data tab under Get and Transform. Unfortunately many people haven’t explored what it has to offer! They continue doing things the old “manual” way, Or the “complex” way with difficult formulas.

Curbal shows you how to write if-statements like a pro.

Contents:

  • 00:40 if stamentent in Excel wont work
  • 01:50 Use power query user interface to write if statement
  • 03:00 Nested if-statements
  • 03:38 AND/OR conditions in if statements
  • 04:48 NOT condtition in if statements
  • 05:20 Manage errors in if statements
  • 06:13 Advanced if statements
  • 08:19 Order of evaluation if statements