Explore and Analyze Data

Transform and Analyze Data with Microsoft Fabric

Luis Silva

Solution Architect - Data & AI

Data Analysis

Descriptive Analytics

Illustration of a sample bar chart showing sales over time

Diagnostic Analytics

Illustration of a sample bar chart showing sales over time with a list of cities that allow user to drill down into detail

Predictive Analytics

Illustration of a sample bar chart showing sales over time, with an added trend line

Prescriptive Analytics

Illustration of a tree chart that suggests which locations might have a higher return on sales

Descriptive Analytics

Show what happened in the past.

Example: Historic sales data

Illustration of a sample bar chart showing sales over time

Diagnostic Analytics

Explain why something happened.

Example: Drill down sales by location

Illustration of a sample bar chart showing sales over time with a list of cities that allow user to drill down into detail

Predictive Analytics

Predict what might happen in the future.

Example: Trend line

Illustration of a sample bar chart showing sales over time, with an added trend line

Prescriptive Analytics

Suggest actions to achieve an objective.

Example: Identify where to focus marketing efforts to increase sales

Illustration of a tree chart that suggests which locations might have a higher return on sales

Data Profiling

Power Query (Dataflow) data view
- Column quality

Screenshot of the column quality view in a dataflow query

Data Profiling

Power Query (Dataflow) data view
- Column quality
- Column value distribution

Screenshot of the column value distribution view in a dataflow query

Data Profiling

Power Query (Dataflow) data view
- Column quality
- Column value distribution
- Column profile

Screenshot of the column profile view in a dataflow query

SQL query tools

Inside Fabric:
- SQL Query Editor
- Visual Query Editor

SQL query tools

Inside Fabric:
- SQL Query Editor
- Visual Query Editor

Outside Fabric:
- SQL Server Management Studio
- Azure Data Studio
- Power BI Desktop
- OLE DB / ODBC SQL clients

SQL query editor

Text editor for writing SQL queries.

Screenshot of the SQL query editor showing a sample SELECT query

Visual query editor

Easy visual interface for writing queries.
Similar to Dataflow Power Query interface.

Screenshot of the visual query editor showing a table

Connecting using other SQL tools

Lakehouse: SQL analytics endpoint

Screenshot of the Lakehouse settings screen showing the location of the SQL analytics endpoint

Connecting using other SQL tools

Warehouse: SQL connection string

Screenshot of the Warehouse settings screen showing the location of the SQL connection string

Connecting from SQL Server Management Studio (SSMS)

Screenshot of SQL Server Management Studio connecting to a Fabric warehouse

Connecting from Azure Data Studio

Screenshot of Azure Data Studio connecting to a Fabric warehouse

XMLA endpoint

Open standard
Client tools:
- SQL Server Management Studio
- Power BI Desktop
- Excel PivotTables
- DAX Studio
- Other third-party XMLA clients
Connectivity to Semantic Models

XMLA endpoint

powerbi://api.powerbi.com/v1.0/[tenant]/[workspace]

Let's practice!

Transform and Analyze Data with Microsoft Fabric