Business Intelligence Analyst tasks:

1. Automation Reports (Dashboard)

2. Ad-hoc Analysis
3. Data Storytelling

Mastering Data Analytics is the author of this document.

Please keep confidential this document! MECE in LOGIC TREES + TAXONOMY

Descriptive Fundamental

• CENTRAL - Mean, Mode, Median

• Normal Distribution
• Standard Normal Distribution
• Random, Discrete, Continuous
Statistics Terminology • Picturing the distribution
• Other distribution
• SHAPE - Skewness vs Kurtosis
• DISPERSION - Range
• DISPERSION - SD, Variance
• Effect Size: Cohen's D, Correlation, R2

• Selection Bias
• Survivorship Bias
Avoid Misrepresenting Data • Overall vs Groups_Simpson's Paradox
• Statistics vs Distribution
• Problem with single metric
BI vs BA • Relative vs Absolute change
Technology in BI BI Terminology
Data, Analysis, Analytics
Understanding Data
Microsoft Fabric TABLE: Frequency
BI Intelligence Fundamentals Static
Self-service BI & Analytics
Analytics structure and Coordination Model
Module 3: Descriptive CHART: Composition (counts (mode), %)

BI Success (Organization) Analytics in Business TABLE: Frequency

BI Success (Individual) Changing over time
BI in Corporates
The Evolution of Business Intelligence Intelligence (Time-Based Variance)
Categorical variables
How can data analytics help organizations? CHART: Composition (counts (mode), %)
BI process
Decision making with BI TIP 1: Treat Time as Category
Decision Bias
Module 1: Business
TIP 2: Parent-Child Relationship : Graph Chart
Overview Concept Intelligence Fundamentals &
Analytical Thinking
Data Analytics Problem Solving
Center: Mean, Median, Mode
Most Detail Level (All) TABLE: Summary measures, Descriptive
Logic Tree Fundamentals
Analysis (Center, Spread, Shape) Spread: Min, Max, Quartie, St.d ...

Techniques to build Logic Trees

Qualitative (LOGIC TREE) Shape: Skewness, Kurtosis
PREPARE THE DATA - M Static
The 4 things you need to "get” to understand Analytical Thinking
CHART: Box plots, Histogram
Logic Trees MODEL THE DATA Data model , Violin

Algebraic structures VIZUALIZE THE DATA Center: Mean, Median, Mode

DA-100 Numerical Variables
TABLE: Summary measures, Descriptive
Process Structures ANALYZE THE DATA - DAX Part 3-5 Analysis (Center, Spread, Shape) Spread: Min, Max, Quartie, St.d ...

Conceptual Frameworks DEPLOY & MANTAIN DELIVERABLES

Shape: Skewness, Kurtosis
5 core structures overview
Univariate Descriptive Changing over time
Segmentations (Time-Based Variance) CHART: Box plots, Histogram
, Violin
Opposite Words
Date Hierachy
Combine Structures Time series charts for patterns
MoM, YoY, YTD...

Most Detail Level (Slicer)

Power Query Overview

Get Data Distribution by Transaction

Tip:
PQ - Basic Transform Data Distribution by Date + Using chart for Change level detail (
Change detail level of original data
Datekey/ ProductKey…)
Profiling Data Example: Contoso - Product (Unit Price) + For Salekey, using Table Summary Measures
Distribution by ID/Key/Name
Bad Shape + Dirty Data Data Preparation Example: Supper market: Customer ID
Data Issues
Missing Data + Outliers

Combine Data From Folder

TABLE: of joint counts (cross-tabs or pivot Static
Blending Data

BUSINES
tables) - Aggregation

Note Changing over time (Time: Slicers/ Small

Checklist of joint counts Multiples)

Data Model Overview INTELLIGENCE Categorical vs categorical CHART

Oder of Magnitude cuts: Top/ Bottom

Fact & Dimension

PROGRAM (Chi-Square Test...)

PART 1 -2 DA100 Schema Module 2: End-to-End

Data Modelling
Business Intelligence TABLE: Summary measures by category
Cardinality
Workflow Aggregation Analysis, CHARTs: Bar/ Line (Ex:
Cross Filter Direction Revenue by City Bar chart OR Sum by CITY Static
Overtime
Hierarchies Note Changing over time (Time: Slicers/ Small
Categorical vs numerical Pareto Multiples/ Axis)
Introduce PBI Ecosystem (PBI Service) CHART
2 VARIABLES
Oder of Magnitude cuts
Fact & Dimension
Side-by-side boxplots
Prep Data (On Pro & Premium)
(T-Test, ANOVA...)
Data Modeling
End-to-End in Power BI Cloud
Report and Dashboard TABLE: Summary measures (if any)

Refresh Scorecard & Metrics Aggregation Analysis (Ex: Bar chart of Sum Static
Revenue by Unit Sold Group)
Sharing, Collaboration, (PBI Mobile) Changing over time (Time: Slicers/ Small
1 Numerical is discrete + few distinct values Note
Oder of Magnitude cuts Multiples/ Axis)
Numerical vs numerical
Deployment Pipelines CHART
Pareto

Correlations Matrix Scatterplots

Introduction to Visualization Relationship

Introduction to Data Visualization 1. Fundamentals of (Pearson Test)
Data Visualization Trends Data Visualization
Data Visualization Evolution
Good Data Visualization
Why visualize? Sankey

Bubble
From Data to Story process >2 VARIABLES
Understanding the context Scatter plot matrix
Data Dictionary
Part 3_DA100 Dashboard Introduction (Test: ANOVA)
Types of Dashboard 2. Data Storytelling

Part 3-5 Part 4_DA100

Dashboard - DAR What is an insight? Module 5: Data
Analytics path to value
Insight - BUS Data Storytelling Vizualization & Storytelling BIG DATA
19
Part 5_DA100 Storytelling - ARC Storylining
Design data story
Exploratory vs Explanatory Analysis IFSELF Correlogram Analytics - XLSTAT

Gestalts Rules Module 4: Diagnostics Data Table

Quantitative
Visual Cues
analytics Sentiment Analytics Azure Machine Learning
How chart lies
Color 3. Essential Visualization Principles
Typography/ Text Cohort Analytics
Other tips
Before vs After (Dashboard vs Story)
Auto-clustering of Power BI
Chart (Fundamentals of chart and table design/
Types of data, Chart types)
Segmentation Segmentation in key drivers

Basic: in Visual Analytics

Geospatial Advance: Alteryx

Data Table
(2 ways)

Ad-hoc BI
Scenario Manager
What-If Scenario
Goal Seek

Visual Analytics 11

FROM DATA TO STORY PROCESS