PL-300T00 – POWER BI DATA ANALYST

Durata

3 Giorni

Ruolo

Analyst, Cloud Architect, Database Administrator, Engineer, Project Manager

Tecnologie

Power BI

Vendor

Microsoft

Edizioni del corso

1,175.00

Dettagli

OBIETTIVI

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI

CONTENUTI:

Module 1: Get Started with Microsoft Data Analytics

  • Data Analytics and Microsoft
  • Getting Started with Power BI

 

Lab : Getting Started in Power BI Desktop

  • Getting Started

 

Module 2: Prepare Data in Power BI

  • Get data from various data sources

 

Lab : Preparing Data in Power BI Desktop

  • Prepare Data

 

Module 3: Clean, Transform, and Load Data in Power BI

  • Data shaping
  • Enhance the data structure
  • Data Profiling

 

Lab : Transforming and Loading Data in Power BI Desktop

  • Loading Data

 

Module 4: Design a Data Model in Power BI

  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies

 

Lab : Data Modeling in Power BI Desktop

  • Create Model Relationships
  • Configure Tables
  • Review the model interface
  • Create Quick Measures

 

Lab : Advanced Data Modeling in Power BI Desktop

  • Configure many-to-many relationships
  • Enforce row-level security

 

Module 5: Create Model Calculations using DAX in Power BI

  • Introduction to DAX
  • DAX context
  • Advanced DAX

 

Lab : Advanced DAX in Power BI Desktop

  • Use the CALCULATE() function to manipulate filter context
  • Use Time Intelligence functions

 

Lab : Introduction to DAX in Power BI Desktop

  • Create calculated tables
  • Create calculated columns
  • Create measures

 

Module 6: Optimize Model Performance in Power BI

  • Optimze the model for performance
  • Optimize DirectQuery Models
  • Create and manage Aggregations

 

Module 7: Create Reports in Power BI

  • Design a report
  • Enhance the report

 

Lab : Designing a report in Power BI Desktop

  • Create a live connection in Power BI Desktop
  • Design a report
  • Configure visual fields and format properties

 

Lab : Enhancing reports with interaction and formatting in Power BI Desktop

  • Create and configure Sync Slicers
  • Create a drillthrough page
  • Apply conditional formatting
  • Create and use Bookmarks

 

Module 8: Create Dashboards in Power BI

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard

 

Lab : Creating a Dashboard in Power BI Service

  • Create a Dashboard
  • Pin visuals to a Dashboard
  • Configure a Dashboard tile alert
  • Use Q&A to create a dashboard tile

 

Module 9: Enhance reports for usability and storytelling in Power BI

  • Paginated report overview
  • Create Paginated reports

 

Lab : Creating a Paginated report in Power BI Desktop

  • Use Power BI Report Builder
  • Design a multi-page report layout
  • Define a data source
  • Define a dataset
  • Create a report parameter
  • Export a report to PDF

 

Module 10: Perform Advanced Analytics in Power BI

  • Advanced Analytics
  • Data Insights through AI visuals

 

Lab : Data Analysis in Power BI Desktop

  • Create animated scatter charts
  • Use the visual to forecast values
  • Work with Decomposition Tree visual
  • Work with the Key Influencers visual

 

Module 11: Manage Datasets in Power BI

  • Parameters
  • Datasets
  • Security in Power BI

 

Module 12: Create and Manage Workspaces in Power BI

  • Creating Workspaces
  • Sharing and Managing Assets

 

Lab : Publishing and Sharing Power BI Content

  • Map security principals to dataset roles
  • Share a dashboard
  • Publish an App

EDU.Labs by Computer Gross
Via del Pino 1 - 50053 Empoli (FI) - Italia - P. I. 04801490485 - C.F. 02500250168
info@educationlabs.it | 0571 9977