Download Excel File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/002-MSPTDA-DataAnalysisBusinessIntelliegence-Terms.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/002-MSPTDA-DataAnalysisBusinessIntelliegence-Terms.pdf
Buy excelisfun products:
https://teespring.com/stores/excelisfun-store
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