Design and manage analytics solutions using Power BI (PL-300)

Virtual Learning:1,350€ + IVA

Duração:

3 dias

Próxima Data:

Consulte-nos

Local:

Online

Descrição

This course covers the various methods and best practices that align with the business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show you how to access and process data from a variety of data sources, including relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for content sharing and distribution.

*PVP por participante. A realização do curso nas datas apresentadas está sujeita a um quórum mínimo de inscrições.

Destinatários

This course is designed for data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. It is also suitable for individuals who develop reports that visualize data from both cloud-based and on-premises data platform technologies.

Área: Microsoft
Certificação Associada: PL-300

Inscrição

Programa:

Module 1: Start using Microsoft data analytics

Companies need data analytics more than ever. In this learning path, you will learn about the life and career path of a data analyst, their skills, tasks, and the processes they go through to tell a story with data that enables confident business decisions. You will learn how the Power BI suite of tools and services is used by a data analyst to tell a compelling story through reports and dashboards, and the need for true BI in the company.

Lessons:

Discover data analysis
Get started building with Power BI

Module 2: Prepare data for analysis with Power BI

You'll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You'll also learn to profile, clean, and load data into Power BI before you model your data.

Lessons:

Get data in Power BI
Clean, transform, and load data in Power BI

Module 3: Model data with Power BI

Learn what a Power BI semantic model is, which data loading approach to use, and how to build out your semantic model to get the insights you need.

Lessons:

Describe Power BI Desktop models
Choosing a Power BI model architecture
Designing a semantic model in Power BI
Writing DAX formulas for Power BI Desktop models
Add measures to Power BI Desktop models
Add calculated tables and columns to Power BI Desktop models
Using DAX time analysis functions in Power BI Desktop models
Optimize a model for better performance in Power BI
Enforcing Power BI model security

Module 4: Create effective reports in Power BI

Turn data into interactive, actionable insights with Power BI Desktop visuals and reports.

Lessons:

Scope report structure requirements
Structuring Power BI reports
Configure Power BI report filters
Improve Power BI report designs for user experience

Module 5: Manage and protect Power BI

Ensure content is accessible and effectively distributed in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organization.

Lessons:

Managing workspaces in the Power BI service
Manage semantic models in Power BI
Choosing a content distribution method
Create dashboards in Power BI
Protecting data access in Power BI

Pré-requisitos:

Successful Data Analysts start this role with experience of working with data in the cloud.

Specifically:

Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.

You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Data Fundamentals before taking this course.

Inscrição