T1936BI

Ladda ner som PDF

Power BI Intermediate

This Power BI (level 2) workshop is an intensive two-day course that is designed for pro-Information workers who want to learn utilize the most of the tools available in the Power BI stack, including the Power BI Cloud Portal. We’ll learn the importance of building good models, we’ll learns to use DAX as well as 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 Deploying/sharing your reports 
and dashboards, and utilize extra features such as building interactive dashboards, use Q&A and manage Data refresh and alerts for your queries and sources. At the end of this course we’ll introduce you to some hot topics such as Dataflows, Composite Models, Aggregation Tables, Common Data Service for apps.

Audience

This training is targeted for Data professionals that are looking to design their own Power BI solutions. In other words, this course will take the Self- Service-Business-Intelligence (SSBI) concept to its edge.

Prior knowledge

Basic understanding of DAX and you have created reports in Power BI Desktop.
Basic understanding of data warehouse schemas and Cubes...
Basic knowledge about databases and ETL flows

Modules

• Introducing the Power BI Platform
• Getting Started with Power BI Desktop
• Designing Reports and navigation in Power BI Desktop
• Mastering Query Features
• Advanced Data Modeling Topics
• Designing and Deploying Dashboards
• Integrating Power BI with Excel 2016 and Excel Online
• Understanding Data Refresh, Gateways and DirectQuery Mode
• Publishing Content using App Workspaces

Outline-Power BI Intermediate

Day 1

Introducing the Power BI Platform
• Understanding the Power BI Platform
• Creating a Trial Office 365 Tenant for Testing
• Creating Datasets, Reports and Dashboards
• Report & Dashboard settings in Power BI.com
• Staying in Sync with Monthly Updates

Getting Started with Power BI Desktop
• Introducing the Power BI Desktop Settings
• Creating Queries in Power BI Desktop
• Modeling Data in Power BI Desktop
• Designing Reports and navigation in Power BI Desktop
• Publishing Power BI Desktop Projects

Mastering Query Features
• Working with the Query Editor Window
• Managing Queries, Datasources and Credentials
• Deciding What To Measure
• Merge Operations
• Designing Queries to Generate a Star Schema

Advanced Data Modeling Topics
• Designing a Data model
• Understanding Relationships
• Understanding Bi Directional Filtering
• Creating Calculated... Läs mer

Modules

• Introducing the Power BI Platform
• Getting Started with Power BI Desktop
• Designing Reports and navigation in Power BI Desktop
• Mastering Query Features
• Advanced Data Modeling Topics
• Designing and Deploying Dashboards
• Integrating Power BI with Excel 2016 and Excel Online
• Understanding Data Refresh, Gateways and DirectQuery Mode
• Publishing Content using App Workspaces

Outline-Power BI Intermediate

Day 1

Introducing the Power BI Platform
• Understanding the Power BI Platform
• Creating a Trial Office 365 Tenant for Testing
• Creating Datasets, Reports and Dashboards
• Report & Dashboard settings in Power BI.com
• Staying in Sync with Monthly Updates

Getting Started with Power BI Desktop
• Introducing the Power BI Desktop Settings
• Creating Queries in Power BI Desktop
• Modeling Data in Power BI Desktop
• Designing Reports and navigation in Power BI Desktop
• Publishing Power BI Desktop Projects

Mastering Query Features
• Working with the Query Editor Window
• Managing Queries, Datasources and Credentials
• Deciding What To Measure
• Merge Operations
• Designing Queries to Generate a Star Schema

Advanced Data Modeling Topics
• Designing a Data model
• Understanding Relationships
• Understanding Bi Directional Filtering
• Creating Calculated Columns
• Creating Measures
• Configuring Geographic Fields to a Data Model
• Creating Dimensional Hierarchies
• Data Modeling Best Practises

Day 2

Designing and Deploying Dashboards
• Designing Dashboards for Power BI
• Executing Queries with Natural Language Q&A.
• Sharing and collaboration with Dashboards and Office 365 Users
• Manage Permissions and security
• Configuring Subscriptions & Alerts
• Configure for Mobile Devices
• Configuring Dashboard & Tile Settings
• Best Practises when creating Dashboards

Integrating Power BI with Excel 2016 and Excel Online
• Understanding Excel Integration with Power BI
• Connecting to Files
• Importing and Connecting to Excel Workbooks
• Using the Power BI Publishing for Excel Add-in
• Connecting from Excel to a Power BI Dataset
• Creating an Excel survey using Forms and Power BI

Publishing Content using App Workspaces
• Understanding Workspaces
• Content Distribution in Power BI
• App Workspaces
• Publishing Apps
• Introducing Power BI Premium

Kursfakta

Kurs-ID: T1936BI
Längd: 2 dagar
Pris exkl moms: 18 900 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 17.00

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
11 mar-12 mar
Boka nu!
2 jun-3 jun
Boka nu!
Göteborg
11 mar-12 mar
R
Boka nu!
2 jun-3 jun
R
Boka nu!
Cloud Access
i Läs mer

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

11 mar-12 mar
Boka nu!
2 jun-3 jun
Boka nu!

Tipsa