Chat with us, powered by LiveChat

Power BI (In English)

First day:

Entry-level training – basics of building and visualizing Power BI reports, data sequencing, filtering and grouping.

In addition an overview of different layouts and bookmarks. Basics of collaboration in Power BI service.

  • Introduction to Power BI

Practice: My First “Sales Report”.

  • Visuals, fields and format
  • Geographic visualization of locations
  • Visuals interactions
  • Obtaining custom visuals
  • Report’s, page’s and visual’s filters

Practice: Fulfilling Sales Goals

  • Refresh data
  • Adding data from a file, relationships, key table
  • Time dimension, hierarchies
  • Bookmarks, slicers
  • Mobile view

Practice: Working with Power BI service

  • Publish report into Power BI service
  • Reports in the service, dashboards, apps
  • Create and use a workspaces
  • Organizing collaborative work, different roles
  • Mobile App

As a result of the initial training trainee will acquire the ability to create basic reports and displays for themselves and colleagues in the Power BI environment.

Second day:

Get data from different data sources, basic skills to remove unnecessary information, improve information, optimization tips and tricks.

Understand the types of query tables, the structure of queries, the importance of data types. Creating a data model. Get the primary skills to add missing measures, data (DAX).

  • Introduction to Power Query
  • Import data, connectivity modes

Practice: Data Design and Modeling

  • Best practices
  • Data management
  • Data types
  • Clean, add, aggregate, merge e.c.t.
  • Load data
  • Data model, relationships
  • Date table

Practice: Introduction to DAX Formulas

  • Calculated columns, measures
  • Table of measures
  • Quick measures
  • Calculated tables

Practice: Calendar, Data Update, row level security

  • DAX – calendar
  • Refresh
  • Row level security
  • In Power BI Desktop
  • In service
  • Adding additional info, visual header tooltip
  • Buttons
  • Field, table properties

As a result of second day training trainee is able to understand importants of data quality, is able to improve and clean data, create data model, add basic calculations and measures to. Have control over reports not opposite.

Õppekavarühm: 0611 Arvutikasutus.

Tähelepanu! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.

Attention! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.

Внимание! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.