Completed
) Load Entire CSV File and look at Model Size.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Power Query - Reduce Data Model Size, Transformations to Columnar Database Size
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Download HUGE CSV File.
- 3 ) Talk about How Columnar Database works and how we can reduce size.
- 4 ) Rules for Efficient Data Modeling
- 5 ) Get Data From Government Web Site: https://data.seattle.gov/Public-Safety/Call-Data/33kz-ixgy
- 6 ) Import CSV Text File
- 7 ) Load Entire CSV File and look at Model Size.
- 8 ) Filter Rows and look at Model Size.
- 9 ) Remove Columns and look at Model Size.
- 10 ) Reduce Cardinality of Columns with 1) Add Column for Time
- 11 ) Reduce Cardinality of Columns with 2) Transform Columns and get Date Only
- 12 ) Edit Time Column to Create only Hour and reduce size further.
- 13 ) Edit Query can lead to trouble in subsequent steps. See how to fix the problem.
- 14 ) Add Date Table
- 15 ) Create Relationship
- 16 ) Create Measure to Count Rows for Call Type. Use COUNTROWS DAX Function.
- 17 ) Create Dashboard
- 18 ) Create Pivot Table
- 19 ) Filter to show Top 20, 911 Call Types
- 20 ) Show Values As in Data Model PivotTable
- 21 ) Sort Measure Biggest to Smallest
- 22 ) Add Slicers
- 23 ) Scrape Data form Web Site
- 24 ) Summary
