MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class

Download Excel File: https://people.highline.edu/mgirvin/A...
Download pdf Notes: https://people.highline.edu/mgirvin/A...

Buy excelisfun products:
https://teespring.com/stores/excelisf...

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

This video defines these terms and concepts:
1. (00:10) Introduction
2. (01:17) Data Analysis, Business Intelligence
3. (02:08) Query
4. (03:03) Goal of Data Analysis and Business Intelligence:
5. (03:30) Raw Data
6. (03:59) Proper Data Set, Field Names / Column Names / Header Names
7. (04:52) Data Type
8. (05:20) Naming things Smartly & Consistently
9. (07:41) Excel Table feature
10. (09:48) Grain or Granularity
11. (12:07) Keys: Primary Key & Foreign Key
12. (14:16) Fact Table / Transaction Table and Dimension Table / Lookup Table / Entity Tables
13. (17:04) Data Models
14. (19:43) Flat Table in Excel
15. (20:11) Relationships
16. (22:30) Star Schema Data Model
17. (23:32) Snow Flake Data Model
18. (25:12) Relational Database = Normalized Database
19. (25:46) Columnar Database
20. (27:52) Clean Raw Data, Transform Data Sets, Import Data
21. (29:00) ETL, Data Warehousing, SQL
22. (30:35) Concluding Picture and Summary

• #education
• #excelisfun
• #highline_college
• #data_analysis
• #business_intelligence
• #bi_348
• #mike_girvin
• #microsoft_power_tools_for_data_analysis_01
• #free_business_intelligence_class
• #online_business_intelligence_class
• #terms_for_class
• #granularity
• #grain
• #define_granularity
• #grain_of_fact_table
• #granularity_of_fact_table
• #columnar_database
• #star_schema_data_model
• #relationships
• #goal_of_data_analysis_and_business_intelligence
• #data_models
• #what_makes_a_good_data_model
• #msptda