Data Analytics Process, Cloud Solutions, and Power BI Solutions

Wishlist Share

About Course

 

 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
Show More

What Will You Learn?

  • Install and configure Power BI.
  • Evaluate the various data solutions offered by cloud providers such as Azure.
  • Gain an understanding of the different structures, modeling approaches, and data warehouse designs used to store, manage and access Big Data.
  • Apply tools and techniques to clean data in preparation for analysis.
  • Build reporting and analytics solutions based on on-premise as well as cloud data.
  • Integrate data analytics solutions with a data warehouse.
  • Mitigate data security risks and ensure data privacy

Course Content

Data Analytics Process, Cloud Solutions, and Power BI Solutions
Data analysis refers to the process of obtaining, cleaning, and analyzing data, often times in a visual manner, to derive insights for better decision making. More and more data is being stored in databases in the cloud so it is important to have a strategy for understanding, managing and accessing such data. One popular tool for accessing and visualizing data is Power Bi.

Student Ratings & Reviews

No Review Yet
No Review Yet