   Data Analytics Process, Cloud Solutions, and Power BI Solutions培訓

Introduction

Overview of On-Premise and Cloud-Based Data Storage and Analysis Solutions

Understanding Big Data

Big Data criteria
Big Data structure
Working with Big Data
Cloud Solutions

Azure SQL Database
Azure Data Warehouse
Azure Data Factory
Azure Databricks
Power BI
Working with Databases

Data warehouse design
Dimensional modelling
Implementation and deployment
Data Models - A Comparison

SSAS Tabular Data Models
SSAS Multidimension Models
Power BI Models
Data Cleansing

Strategies and tools
Report Models

Building Power BI tabular models
Understanding DAX
PowerBI Reports

Designing Power BI reports
Power BI Architecture

Workspace generation
Licensing
Permissions
Administration

Administering Azure solutions
Administering the Power BI Service
Security

Maintaining a secure Azure architecture
Azure SQL Database/Data Warehouse, Data Factory and Data Bricks
Data Masking and Privacy Issues
Summary and Conclusion