Data Analysis Business Intelligence Terms - Microsoft Power Tools for Data Analysis Class

Learn essential data analysis and business intelligence concepts in this 31-minute video tutorial from the Microsoft Power Tools for Data Analysis Class. Explore key terms including data analysis, business intelligence, queries, raw data, proper data sets, data types, naming conventions, Excel tables, granularity, primary and foreign keys, fact and dimension tables, data models, relationships, star schema, snowflake models, relational and columnar databases, data cleaning, and ETL processes. Gain a comprehensive understanding of these fundamental concepts to enhance your data analysis skills and improve business decision-making.

Syllabus

) Introduction.
) Data Analysis, Business Intelligence.
) Query.
) Goal of Data Analysis and Business Intelligence:.
) Raw Data.
) Proper Data Set, Field Names / Column Names / Header Names.
) Data Type.
) Naming things Smartly & Consistently.
) Excel Table feature.
) Grain or Granularity.
) Keys: Primary Key & Foreign Key.
) Fact Table / Transaction Table and Dimension Table / Lookup Table / Entity Tables.
) Data Models.
) Flat Table in Excel.
) Relationships.
) Star Schema Data Model.
) Snow Flake Data Model.
) Relational Database = Normalized Database.
) Columnar Database.
) Clean Raw Data, Transform Data Sets, Import Data.
) ETL, Data Warehousing, SQL.
) Concluding Picture and Summary.