Course Code: bisol
Duration: 35 hours
Course Outline:

 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 5

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