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

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

Requirements

  • Experience with elementary data analysis (e.g., Excel).
  • A general understanding of cloud concepts (e.g., AWS).

Audience

  • Database engineers
  • Developers
 35 Hours

Number of participants



Price per participant

Testimonials (2)

Related Courses

Fn Project

7 Hours

Parallel Programming with OpenMP

14 Hours

Kubeless for Developers

14 Hours

OpenFaas for Developers

14 Hours

Knative for Developers

14 Hours

Serverless Framework for Developers

14 Hours

Serverless on Kubernetes Fundamentals

21 Hours

Building Microservices with Microsoft Azure Service Fabric (ASF)

21 Hours

Amazon DynamoDB for Developers

14 Hours

Advanced Amazon Web Services (AWS) CloudFormation

7 Hours

AWS CloudFormation

7 Hours

AWS IoT Core

14 Hours

Amazon Web Services (AWS) IoT Greengrass

21 Hours

Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「4 Hours Remote」

4 Hours

Industrial Training IoT (Internet of Things) with Raspberry PI and AWS IoT Core 「8 Hours Remote」

8 Hours

Related Categories

1