数据分析·Business Intelligence

Part 1 Business Intelligence Overview

课程介绍

What is Business Intelligence

Big Data Ecosystem

Business intelligence work flow overview

Major Business Intelligence Platform comparison

Essential Business Intelligence Skills

Part 2 Basic Kimball Dimensional Modelling Introduction

课程介绍

What is data modelling

Conceptual, logical and physical schemas

Entity relationship

Star Schema

Dimension, Fact & Summary Table

Cast Study: Star schema Sample

Part 3 Introduction to Microsoft Power BI

课程介绍

History of Power BI

Creating Datasets from Data Models and Data Files

Using Quick Insights to Explore a Dataset

View Reports

Exploring a Dashboard

Part 4 Introduction to DAX

课程介绍

What is DAX

Data types supported

DAX calculation

Calculated column

Calculated measures

DAX Functions

Aggregation

Filter

Time Intelligence

Date & Time

Logical

Math

Parent & Child

Statistical

Text

Part 5 Basic DAX Function Use Cases (Case Study)

课程介绍

Cumulative Count

Using variables in DAX expressions

Obtain previous fact

Compare different timeframe

Certain period count

Moving average

Compare selected attributes

Part 6 Report Generation (Case Study)

课程介绍

Create views

Display further details

Part 7 Advanced DAX Function Use Cases (Case Study)

课程介绍

Time Intelligence

Top selection by certain entity

Rolling time comparison

Total count in certain period

Table relationships and DAX

DAX tables and filtering

Part 8 Comprehensive Case study

课程介绍

Create comprehensive sales report/dashboard

Create the dashboard of analysing the customer segmentation

Data visualization bonus: visualize the European debt crisis

Publish and share Power BI report

Part 9 Revision and Q&A

课程介绍

Revision from part 1 to 8

Career Path consultation

CV writing consultation