Centralino: 0571 997787

Numero attivo in orario lavorativo

Microsoft Education Center (MOC)



3 Giorni


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


Power BI



Al momento non sono disponibili edizioni del corso




  • 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


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 997787