T1412BI

Ladda ner som PDF

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.

Audience

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

Prior knowledge

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

Courseware

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 Läs mer

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

Kurs-ID: T1412BI
Längd: 2 dagar
Pris exkl moms: 20 450 kr

Frågor om kursen?

Har du frågor om kursens innehåll, leveransdatum/ort eller behöver en företagsanpassad variant? Fyll i formuläret nedan!


Kan betalas med:
TRAINING CARD

Ort och datum

Stockholm
19 jan-20 jan
Boka nu!
2 mar-3 mar
Boka nu!
18 apr-19 apr
Boka nu!
12 jun-13 jun
Boka nu!
Göteborg
19 jan-20 jan R
Boka nu!
2 mar-3 mar R
Boka nu!
18 apr-19 apr R
Boka nu!
12 jun-13 jun R
Boka nu!
Malmö
19 jan-20 jan R
Boka nu!
2 mar-3 mar R
Boka nu!
18 apr-19 apr R
Boka nu!
12 jun-13 jun R
Boka nu!
Cloud Access
i Läs mer

Delta på kursen från ditt hem, jobb eller annan plats.

19 jan-20 jan
Boka nu!
2 mar-3 mar
Boka nu!
18 apr-19 apr
Boka nu!
12 jun-13 jun
Boka nu!

Tipsa