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
 

Testimonials

Related Courses

Building Cloud Services with NoCloud

  28 hours

OpenNebula Cloud Computing

  21 hours

Boomi Integration Fundamentals

  14 hours

Boomi Developer Advanced

  28 hours

Virtualization with Citrix Hypervisor for Administrators

  21 hours

Virtualization Management using Red Hat CloudForms

  21 hours

VMware vSphere: Install, Configure, Manage [V8]

  35 hours

VMware PKS

  7 hours

VMware Tanzu Fundamentals

  14 hours

VMware vSphere: Install, Configure, Manage [V7]

  35 hours

Tinkerbell: Provisioning Bare Metal Servers

  7 hours

GlusterFS for System Administrators

  21 hours

Red Hat Ceph Storage Fundamentals

  21 hours

Ceph Storage Fundamentals

  21 hours

Parallel Programming with OpenMP

  14 hours