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

Overview

This course aims to teach the fundamental terms and concepts of Data Analysis and Business Intelligence using Microsoft Power Tools. The learning outcomes include understanding data types, data modeling, database structures, and data transformation techniques. The course covers skills such as creating proper data sets, utilizing Excel Table features, establishing relationships, and implementing ETL processes. The teaching method involves a comprehensive video lecture by an experienced instructor. The intended audience for this course is individuals interested in enhancing their data analysis and business intelligence skills using Microsoft Power Tools.

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.