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

Download Excel File: https://ift.tt/2tvSYbd
Download pdf Notes: https://ift.tt/2lwxPdq

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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.