Lataa pdf-muodossa

Analytics with Power BI

This Power BI workshop is an intensive two-day course that is designed for Advanced Power Users and Information workers who want to learn utilize the tools available in the Power BI stack, including the Power BI Cloud Portal. You will learn the basics of creating visualizations using the new Power BI desktop experience as well as using Excel 2013/2016 to create stunning visualizations of your data by tools as Power View, Power Map. 

Lasaros Mavropoulos, Kursutvecklare och kursledare
Lasaros Mavropoulos,
Course writer and teacher

You’ll also learn how to build models using Power Pivot as well as perform mashups using Power Query to shape additional information that can be found in external data sources.

You’ll also use new Power BI cloud platform as a way of sharing your reports, and utilize extra features such as building interactive dashboards, create Content packs, use Q&A,manage Data refresh for your queries and sources.

Target audience

This class is targeted for Power Users or End Users that are looking to design their own Power BI solutions.


Deep database knowledge is not required. Ideally participants would have a basic understanding of database terminology (tables, columns, rows, views, procedures, etc..)

Training material

Digital Material

Informator Training Cloud

Our training portal supports your development throughout the training. The portal saves you time and is designed to give you a more effective learning experience - leading to better results and greater knowledge enforcement after the course. Read more >

Day 1

Introducing The Excel Power Tools

1. Power Query

• Introduction to Power Query
• Importing Data from On-prem and External Data Sources
• Using Power Query to Sort, Group, Filter and Transform Data
• Using Power Query Formulas

2. Excel Data Model (Former PowerPivot)

• Importing Data into Power Pivot
• Creating the Data Models and Table Relationships
• Creating Calculated Columns and Measures, Hierarchies and KPIs from DAX
• Optimizing Power Pivot Models for better visualizations
• Incorporating DAX Time Intelligence functions

3. Power View

• Creating Basic Power View Visualizations
• Creating Interactive and Animated Visualizations
• Map your data to spatial locations (Map visualizations)

4. Power Map

• Mapping Geography Data using Power Map
• Linking Geographical Fields to Power Map properties
• Mapping Time Data
• Creating a Power Map Tours

Analysis Services Tabular Models

• Making Self-Service BI Scalable by upgrading Power Pivot Models to SQL Server Tabular Models
• Deploying to SharePoint and PowerPivot Gallery

Analysis Services Multidimensional Models

• Connect to Analysis Services Multidimensional Sources
• Visualize data from Cubes and Dimensions

Day 2
Introducing Power BI Desktop (One tool instead of three…)

• Get data, Create & edit queries
• Learn how to perform mashups
• Learn how to model data
• Create reports from your queries
• Import Visualizations
• Deploy to the Power BI Cloud Service

Power BI on the cloud Service

• Introducing the Power BI Cloud Service
• Learn how to create Content packs
• Learn how to distribute Content packs across your organization
• Installing the Power BI Gateways
• Administering data sources, queries and data refresh
• Building and sharing dashboards
• Using the Q&A feature

Ota yhteyttä



010 4321 001 Ota yhteyttä

Kesto: 2 päivää
Veroton hinta (+ alv 24 %): 2 146 €

Tästä asiakaskohtainen toteutus?

Toteutamme koulutuksia myös asiakaskohtaisina. Jätä yhteystietosi, ja tehdään juuri teille sopiva toteutus.

Voit maksaa:

Paikka ja päiväys

i Lue lisää

Osallistu koulutukseen kotoa tai työpaikaltasi

9.5 – 10.5
Swedish Svenska
28.5 – 29.5
Swedish Svenska
17.6 – 18.6
Swedish Svenska
9.5 – 10.5
Finnish Finnish
28.5 – 29.5
Finnish Finnish
17.6 – 18.6
Finnish Finnish