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