Power BI & Synapse Part 1 — The Art of (im)possible

In the 1st part of the blog series related to integration between Power BI and Synapse Analytics, learn about the enormous flexibility that the Serverless SQL pool within Synapse brings to the table

Image for post
Image for post
https://unsplash.com/photos/7JX0-bfiuxQ

Azure Synapse Analytics — New kid on the block, or…?

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post

Swiss knife for your data

Image for post
Image for post

Azure Synapse Studio — your ticket for all events

Image for post
Image for post

Synapse Workspace — Understanding core components

Image for post
Image for post

Serverless SQL pool — full power without a single piece of hardware!

Image for post
Image for post
SELECT * FROM sys.objects

Abrakadabra — read parquet file using T-SQL

Image for post
Image for post
Image for post
Image for post
Image for post
Image for post
WITH taxi_rides AS
(
SELECT
CAST([tpepPickupDateTime] AS DATE) AS [current_day],
COUNT(*) as rides_per_day
FROM
OPENROWSET(
BULK 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/puYear=*/puMonth=*/*.parquet',
FORMAT='PARQUET'
) AS [nyc]
WHERE nyc.filepath(1) = '2016'
GROUP BY CAST([tpepPickupDateTime] AS DATE)
),
public_holidays AS
(
SELECT
holidayname as holiday,
date
FROM
OPENROWSET(
BULK 'https://azureopendatastorage.blob.core.windows.net/holidaydatacontainer/Processed/*.parquet',
FORMAT='PARQUET'
) AS [holidays]
WHERE countryorregion = 'United States' AND YEAR(date) = 2016
)
SELECT
*
FROM taxi_rides t
LEFT OUTER JOIN public_holidays p on t.current_day = p.date
ORDER BY current_day ASC

Conclusion

Data Mozart — Don’t let data make noise, create music from it | data-mozart.com | https://www.linkedin.com/in/nikola-ilic-data-mozart/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store