Caricamento...
MOC20778

Analyzing Data with Power BI

Prezzo

€ 1,050.00
(Iva esclusa)

Scheda tecnica

Scarica

Giorni

3 gg

L'obiettivo principale di questo corso è fornire ai partecipanti una buona conoscenza dell'analisi dei dati con Power BI.

Il corso include la creazione di visualizzazioni, Power BI Service  e Power BI Mobile App.

Obiettivi

Al termine del corso gli studenti saranno in grado di:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.
  • Describe the Power BI mobile app.
Il corso è rivolto a creatori di Report con SQL Server report interessati a metodi alternativi di presentazione dei dati.
  • eccellente conoscenza dei database relazionali e di reporting
  • conoscenza di base della topologia degli schemi di data warehouse (tra cui star e snowflake).
  • competenze di programmazione di base (ad esempio, looping e branching).
  • una certa familiarità le con i concetti di entrate, redditività e contabilità finanziaria.
  • familiarità con le applicazioni Microsoft Office - in particolare Excel.

Module 1: Introduction to Self-Service BI Solutions

Introduces business intelligence (BI) and how to self-serve with BI.

Lessons 

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI

Lab : Exploring an Enterprise BI solution

  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard
  • After completing this module, students will be able to:
  • Describe the trends in BI
  • Describe the process of data analysis in Power BI.
  • Use the key visualizations in Power BI.
  • Describe the rationale for self-service BI.
  • Describe considerations for self-service BI.
  • Understand how you can use Microsoft products to implement a BI solution.

Module 2: Introducing Power BI 

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Lessons 

  • Power BI
  • The Power BI service

Lab : Creating a Power BI dashboard

  • Connecting to Power BI data
  • Create a Power BI dashboard
  • After completing this module, students will be able to:
  • Develop reports using the Power BI Desktop app.
  • Use report items to create dashboards on the Power BI portal.
  • Understand the components of the Power BI service including licensing and tenant management.

Module 3: Power BI 

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Lessons 

  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service

Lab : Importing data into Power BI

  • Importing Excel files into Power BI
  • Viewing reports from Excel files

After completing this module, students will be able to:

  • Describe the data model and know how to optimize data within the model.
  • Connect to Excel files and import data
  • Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector
  • Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups.

Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, buil-in tools. 

This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.

Lessons 

  • Power BI desktop queries
  • Shaping data
  • Combining data

Lab : Shaping and combining data

  • Shape power BI data
  • Combine Power BI data

After completing this module, students will be able to:

  • Perform a range of query editing skills in Power BI
  • Shape data, using formatting and transformations.
  • Combine data together from tables in your dataset.

Module 5: Modelling data

This module describes how to shape and enhance data.

Lessons 

  • Relationships
  • DAX queries
  • Calculations and measures

Lab : Modelling Data

  • Create relationships
  • Calculations

After completing this module, students will be able to:

  • Describe relationships between data tables.
  • Understand the DAX syntax, and use DAX functions to enhance your dataset.
  • Create calculated columns, calculated tables and measures. 

Module 6: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Lessons 

  • Creating Power BI reports
  • Managing a Power BI solution

Lab : Creating a Power BI report

  • Connecting to Power BI data
  • Building Power BI reports
  • Creating a Power BI dashboard

After completing this module, students will be able to:

  • Use Power Bi desktop to create interactive data visualizations.
  • Manage a power BI solution.

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons 

  • Cloud data
  • Connecting to analysis services

Lab : Direct Connectivity

  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service
  • After completing this module, students will be able to:
  • Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop
  • Use Power BI with SQL Server Analysis Services data, including Analysis services modles running in multidimentional mode.

Module 8: Developer API

This module describes the developer API within Power BI.

Lessons 

  • The developer API
  • Custom visuals

Lab : Using the developer API

  • Using custom visuals
  • After completing this module, students will be able to:
  • Describe the developer API.
  • Use the developer API to create custom visuals.

Module 9: Power BI mobile app

This module describes the Power BI mobile app.

Lessons 

  • The Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

After completing this module, students will be able to:

  • Describe the Power BI mobile app.
  • Download and use the Power BI mobile app.
  • Describe Power BI embedded and when you would want to use it.

Il corso è propedeutico per i seguenti esami:

  • 70-778 - Analyzing and Visualizing Data with Microsoft Power BI (beta)
Sede Data P
Torino 20/02/2019
Bologna 20/02/2019
Roma 06/03/2019
Milano 22/05/2019
Bologna 10/06/2019
Roma 08/07/2019
Milano 18/09/2019
Roma 18/09/2019
Bologna 30/09/2019
Milano 13/11/2019
Torino 20/11/2019
Roma 11/12/2019

Potrebbe interessarti