Dataset 009 – Pull it together

 

Having captured the data and imported it into Power BI Dataflows now it is time to pull everything together and build that Data Model! Power BI works seamlessly with the dataflows that are created within it, this gives an extremely functional way to manage huge data sources and at over around 40GB (uncompressed) the NYC Taxi dataset really delivers.

In addition to this, we go through how you configure a shapefile sourced from the internet – part of the NYC Taxi data feed.

Links

New York Data Source – https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page
Shape File preparation – https://mapshaper.org/ – Remember you need to make sure the projection is correct for Power BI -proj wgs84
Download the Fixed NYC Shape File

00:00 – Introduction
01:10 – Apology
02:00 – EXPLAIN – Demo 2 Revisited
05:39 – TECHNICAL – Demo 2 – Dataflows revisited
11:56 – EXPLAIN – Week 2 Plans
13:53 – EXPLAIN – Demo 3 – New York City Shape File
15:33 – TECHNICAL – Demo 3 – New York City Shape File
18:37 – TECHNICAL – Demo 3 – Shape file validation in Power BI Desktop
21:22 – EXPLAIN – Demo 4 – Combine Dataflows into a single model
22:26 – TECHNICAL – Demo 4 – Combine Dataflows
24:30 – Conclusions

Leave a Reply