T1703

Ladda ner som PDF

Power BI for Power Users

For many organizations, Self-Service BusinessLasaros Mavrapolous Intelligence (BI) is emerging as a larger segment of the business intelligence and analytics environment. The role of power users in a Self-Service BI initiative can mean many things. Power users are often the first to adopt new functionality, sometimes even before the corporate IT department is prepared to support it. Power users can be an invaluable source of domain knowledge. They can also be great advocates for BI tools and techniques, which can translate to a big impact on user adoption and satisfaction. In some organizations, power users act as the first line of support for business users in their functional area.

Instructor: Lasaros Mavropoulos

Audience

In this course, the target is Report Designers (creating Reports & dashboards) who want to move to the next step, which in this case is Data Analysists (Creation of Data Models, Integration of data, Change & transform that data, and also some management of that data…)

Prior knowledge

Candidates who attend this course typically are IT professionals who:
• Need to analyze data utilizing Power BI.
• Are technically proficient business users.
• Good knowledge of the Microsoft Windows operating system and its core functionality.
• Have basic knowledge of data warehouse schema topology (including star and snowflake schemas).
• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
• Familiarity with Microsoft Office applications – particularly Excel.

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 DAX Language

  • DAX Data Types
  • DAX Operators
  • Understanding Calculated Columns and Measures
  • Handling Errors in DAX Expressions
  • Handling Empty or Missing Values
  • Common DAX Functions
  • Logical Functions
  • Information Functions
  • Mathematical Functions
  • Text Functions
  • Date and Time Functions
  • Relational Functions

DAX Patterns

  • Many-to-Many
  • Parent-Child
  • Banding
  • DAX Time Intelligence

DAX Querying

  • Evaluate
  • Filter
  • CALCULATETABLE
  • ADDCOLUMNS
  • SUMMARIZE
  • ROLLUP
  • CROSSJOIN
  • GENERATE
  • TOP N

Day 2

Introducing the Power Query Formula Language (M)

  • M Language overview
  • Table Functions
  • List Functions
  • Date Functions

Working with the Query Editor in Power BI Desktop

  • Importing Data into Power BI Desktop
  • Learn how to perform mashups
  • Learn how to work with APIs
  • Invoking Functions & Parameters
  • Create Power BI Desktop Templates
  • Manage Data source settings
  • Introducing Advanced Transformations

Creating Data Models

  • Creating the Data Model and Table Relationships
  • Creating Standard Measures, Hierarchies and Key Performance Indicators (KPIs)
  • Optimizing the Model for better visualizations
  • Creating Calculated Columns and Measures with DAX
  • Using DAX Built-in functions

Analysis Services Tabular Models

  • Making Self-Service BI Scalable
  • Creating & Deploying a Tabular Model
  • Upgrading Power Pivot Models to SQL Server Tabular... Läs mer

Day 1

Introducing The DAX Language

  • DAX Data Types
  • DAX Operators
  • Understanding Calculated Columns and Measures
  • Handling Errors in DAX Expressions
  • Handling Empty or Missing Values
  • Common DAX Functions
  • Logical Functions
  • Information Functions
  • Mathematical Functions
  • Text Functions
  • Date and Time Functions
  • Relational Functions

DAX Patterns

  • Many-to-Many
  • Parent-Child
  • Banding
  • DAX Time Intelligence

DAX Querying

  • Evaluate
  • Filter
  • CALCULATETABLE
  • ADDCOLUMNS
  • SUMMARIZE
  • ROLLUP
  • CROSSJOIN
  • GENERATE
  • TOP N

Day 2

Introducing the Power Query Formula Language (M)

  • M Language overview
  • Table Functions
  • List Functions
  • Date Functions

Working with the Query Editor in Power BI Desktop

  • Importing Data into Power BI Desktop
  • Learn how to perform mashups
  • Learn how to work with APIs
  • Invoking Functions & Parameters
  • Create Power BI Desktop Templates
  • Manage Data source settings
  • Introducing Advanced Transformations

Creating Data Models

  • Creating the Data Model and Table Relationships
  • Creating Standard Measures, Hierarchies and Key Performance Indicators (KPIs)
  • Optimizing the Model for better visualizations
  • Creating Calculated Columns and Measures with DAX
  • Using DAX Built-in functions

Analysis Services Tabular Models

  • Making Self-Service BI Scalable
  • Creating & Deploying a Tabular Model
  • Upgrading Power Pivot Models to SQL Server Tabular Models
  • Deploying content to SharePoint

Manage Data refresh

  • Installing & Managing Gateways
  • Gateway Security
  • Creating Data Connections through Gateways
  • Connect to Analysis Services Multidimensional Models
  • Connect to Analysis Services Tabular Models

Day 3

Jump into the Power BI Service (Cloud)

  • Learn how to get data
  • Create Organizational Content Packs
  • Create reports from your queries
  • Building and sharing dashboards
  • Tuning in, and Using the Q&A feature
  • Managing Security
  • Managing Workspaces
  • Manage your Users and their Activity
  • Share Dashboards within your organization
  • Manage Alerts & Subscriptions
  • Manage Auditing & your Tennant Settings
  • Add Data Classification to your Dashboards

Day 4

Introducing the Business Application Platform

  • Streamed Datasets
  • Building Real-time Dashboards
  • Using Microsoft Flow to create Workflows
  • Create Apps with PowerApps to visualize Power BI Content
  • Create on-line questionaries and visualize the results in Power BI
  • Sentiment analysis with Microsoft Cognitive Services

Kursfakta

Kurs-ID: T1703
Längd: 4 dagar
Pris exkl moms: 31 450 kr
Inregistrering: 09.00
Kursstart: 09.30
Kursslut (ca): 16.30

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
4 sep-7 sep
Boka nu!
Göteborg
4 sep-7 sep
R
Boka nu!
Malmö
4 sep-7 sep
R
Boka nu!
Cloud Access
i Läs mer

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

4 sep-7 sep
Boka nu!

Tipsa