Completed
) Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Data Analysis Business Intelligence Terms - Microsoft Power Tools for Data Analysis Class
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Data Analysis, Business Intelligence
- 3 ) Query
- 4 ) Goal of Data Analysis and Business Intelligence:
- 5 ) Raw Data
- 6 ) Proper Data Set, Field Names / Column Names / Header Names
- 7 ) Data Type
- 8 ) Naming things Smartly & Consistently
- 9 ) Excel Table feature
- 10 ) Grain or Granularity
- 11 ) Keys: Primary Key & Foreign Key
- 12 ) Fact Table / Transaction Table and Dimension Table / Lookup Table / Entity Tables
- 13 ) Data Models
- 14 ) Flat Table in Excel
- 15 ) Relationships
- 16 ) Star Schema Data Model
- 17 ) Snow Flake Data Model
- 18 ) Relational Database = Normalized Database
- 19 ) Columnar Database
- 20 ) Clean Raw Data, Transform Data Sets, Import Data
- 21 ) ETL, Data Warehousing, SQL
- 22 ) Concluding Picture and Summary