Главная
Study mode:
on
1
) Introduction
2
) Data Analysis, Business Intelligence
3
) Query
4
) Goal of Data Analysis and Business Intelligence:
5
) Raw Data
6
) Proper Data Set, Field Names / Column Names / Header Names
7
) Data Type
8
) Naming things Smartly & Consistently
9
) Excel Table feature
10
) Grain or Granularity
11
) Keys: Primary Key & Foreign Key
12
) Fact Table / Transaction Table and Dimension Table / Lookup Table / Entity Tables
13
) Data Models
14
) Flat Table in Excel
15
) Relationships
16
) Star Schema Data Model
17
) Snow Flake Data Model
18
) Relational Database = Normalized Database
19
) Columnar Database
20
) Clean Raw Data, Transform Data Sets, Import Data
21
) ETL, Data Warehousing, SQL
22
) Concluding Picture and Summary
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Intelligence #Microsoft PowerApps #Data Science #Data Analysis #Programming #Domain-Specific Languages (DSL) #SQL #Data Warehousing #Data Processing #Data Transformation #Databases #Database Design #Data Modeling
0:00 / 0:00
1 of 22

) Introduction