Power BI Bundle 55164 and 20778 - Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

Course 97015

Power BI Bundle 55164 and 20778 - Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

Easy-to-use dashboards, interactive reports, and compelling visualizations that bring your data to life.

This 5 day course is the following 2 classes combined:

55164 Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

20778 Analyzing Data with Power BI 2017

Save over $800 and when you buy both courses together.

This Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI course is designed to teach the participant how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI into graphs, charts, KPIs, reports, and other visualizations for use in their business. This course is lab example intensive.

Who Should Attend

The course is targeted towards business analysts, business intelligence developers, and reporting professionals.

After completing this course, students will be able to:

Navigate the Power View interface.

Utilize Power View reports.

Work with tables.

Understand aggregations.

Utilize matrix.

Configure drill through.

Use cards as a visualization.

Apply filters.

Create charts.

Utilize tiles.

Add slicers to reports.

Utilize themes.

Navigate the PowerPivot interface.

Load data.

Examine and configure relationships.

Configure calculated columns are calculated fields.

Create PivotTables.

Understand and utilize DAX.

Use KPIs.

Work with hierarchies.

Manage perspectives.

Navigate the Power Query interface.

Load data.

Filter data.

Merge datasets.

Manage modifications.

Perform data cleaning.

Navigate the Power Map interface.

Use Bing maps.

Examine map data.

Configure tours, scenes, and layers.

Add time to a presentation.

Navigate the Power BI interface.

Utilize data sources.

Understand querying with natural language.

Module 1: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons

Introduction

Course Materials

Facilities

Prerequisites

Module 2: Power View.

In this module, we will explore Power View and its capabilities, then briefly walk-through the types of reports available and how to format them..

Lessons

Exploring the Power View Interface

Visualizing Power View Reports

Working with Tables

Understanding Aggregations

Utilizing Matrix

Configuring Drill Through

Using Cards

Applying Filters

Creating Charts

Examining Tiles

Adding Slicers to Reports

Theming Reports

Lab : Power View

Module 3: Power Pivot

In this module, we will explore PowerPivot and its capabilities, then briefly walk-through the options available and how to configure them.

Lessons

Exploring the PowerPivot Interface

Loading Data

Examining Relationships

Configuring Calculated Columns and Calculated Fields

Creating PivotTables

Understanding DAX

Utilizing DAX Functions

Using KPIs

Working with Hierarchies

Managing Perspectives

Lab : PowerPivot

Module 4: Power Query

In this module, we will delve into the benefits and features provided using Power Query. We will examine the options available within the ribbon, as well as explore and demonstrate importing, filtering, and merging data using Power Query.

Lessons

Exploring The Power Query Interface

Loading Data

Managing Modifications

Examining Data Cleaning

Lab : Power Query

Module 5: Power Map

In this module we will explore Power Map and its capabilities.

Lessons

Exploring The Power Map Interface

Using Bing Maps

Examining Map Data

Reviewing Map Types and Presentation

Lab : Power Map

Module 6: Introduction to Power BI

In this module, we will explore the Power BI interface and walk-through the options available.

Lessons

Introducing Power BI

Explaining Excel and Power BI

Examining Data Sources

Querying with Natural Language

Lab : Introduction to Power BI

Prerequisites

Before attending this course, students must have:

Navigate the Power BI interface.

Utilize data sources.

Understand querying with natural language.

Course 20778 Wed-Fri 3 days

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Who Should Attend

The 20778 Analyzing Data with Power BI 2017course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Course Outline

Module 1: Introduction to Self-Service BI Solutions

Introduces business intelligence (BI) and how to self-serve with BI.

Lessons

Introduction to business intelligence

Introduction to data analysis

Introduction to data visualization

Overview of self-service BI

Considerations for self-service BI

Microsoft tools for self-service BI

Lab: Exploring an Enterprise BI solution

Viewing reports

Creating a Power BI report

Creating a Power BI dashboard

After completing this module, students will be able to:

Describe the trends in BI

Describe the process of data analysis in Power BI.

Use the key visualizations in Power BI.

Describe the rationale for self-service BI.

Describe considerations for self-service BI.

Understand how you can use Microsoft products to implement a BI solution.

Module 2: Introducing Power BI

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Lessons

Power BI

The Power BI service

Lab: Creating a Power BI dashboard

Connecting to Power BI data

Create a Power BI dashboard

After completing this module, students will be able to:

Develop reports using the Power BI Desktop app.

Use report items to create dashboards on the Power BI portal.

Understand the components of the Power BI service including licensing and tenant management.

Module 3: Power BI

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Lessons

Using Excel as a data source for Power BI

The Power BI data model

Using databases as a data source for Power BI

The Power BI service

Lab: Importing data into Power BI

Importing Excel files into Power BI

Viewing reports from Excel files

After completing this module, students will be able to:

Describe the data model and know how to optimize data within the model.

Connect to Excel files and import data

Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector

Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups.

Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, built-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.

Lessons

Power BI desktop queries

Shaping data

Combining data

Lab: Shaping and combining data

Shape power BI data

Combine Power BI data

After completing this module, students will be able to:

Perform a range of query editing skills in Power BI

Shape data, using formatting and transformations.

Combine data together from tables in your dataset.

Module 5: Modeling data

This module describes how to shape and enhance data.

Lessons

Relationships

DAX queries

Calculations and measures

Lab: Modeling Data

Create relationships

Calculations

After completing this module, students will be able to:

Describe relationships between data tables.

Understand the DAX syntax, and use DAX functions to enhance your dataset.

Create calculated columns, calculated tables and measures.

Module 6: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Lessons

Creating Power BI reports

Managing a Power BI solution

Lab: Creating a Power BI report

Connecting to Power BI data

Building Power BI reports

Creating a Power BI dashboard

After completing this module, students will be able to:

Use Power Bi desktop to create interactive data visualizations.

Manage a power BI solution.

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons

Cloud data

Connecting to analysis services

Lab: Direct Connectivity

Direct connectivity from Power BI desktop

Direct connectivity from the Power BI service

After completing this module, students will be able to:

Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.

97015Power BI Bundle 55164 and 20778 - Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

ERROR: Add to Cart

We could not add your item to the cart. There may be a maximum number of items you can add to cart in any one order at this time, and we recommend you proceed to checkout now. If you got this error while having no items in your cart, please try again, and if this error message continues to appear when you have zero items in your cart, please call (800) 453-5961 or use our Contact Form.

Successfully Reserved and Added to Cart

We successfully reserved your course seat(s) and added your item to cart. You were among the first reservations - however, we have detected very high demand on the system for this course. You must complete checkout within the time indicated on the timer to finish reserving your course seat(s). Please continue shopping or complete checkout now using the "Complete Checkout Now" button within the indicated time.

You have to continue shopping or to complete checkout

Why am I receiving this message and what should I do now?

If you see this message, we successfully reserved your course seat(s), however we require you to complete checkout or continue shopping within the time indicated.

When the timer runs out, your course seat(s) will be released, so you should complete checkout as soon as possible or at least continue shopping as soon as possible.

Browsing a web-page, adding another course to the cart, or otherwise being active on the website, might re-start the timer, which sometimes might extend your current reservations and therefore might give you additional time to check out.

We reserve the right to monitor activity and release seat(s) at any time. To ensure your reservation, please complete checkout within the time indicated, which is displayed in MM:SS (Minutes, Seconds) remaining. Unless otherwise specified, you should complete checkout within 30 minutes from now to ensure your seats. If the time displayed is less than 30 minutes, you need to complete checkout even sooner, by the time indicated.

This course is currently in very high demand. We were unable to reserve your seat(s). However, if you enter your e-mail address now, and use the "Review My Course Reservation" button, we can review your course reservation attempt.

Why am I receiving this message and what should I do now?

If you see this message, we detected multiple concurrent attempts to reserve this course across our course reservation system, and we were unable to reserve your seats.

Even though we were unable to reserve your seats, please enter your e-mail address now. Also, please make sure your e-mail address is valid and that you check it often.

Entering your e-mail address here does not create a commitment or otherwise obligate you to purchase this course - however we have detected very high demand on the system for this course, so we need your email address now.

If you enter your e-mail address now, there is a chance that we can successfully reserve your seat(s) for this course pending a manual review of your reservation attempt.

Even if you've been previously prompted to do this in the past or are a returning customer, you still need to perform this step now to trigger a manual review of your reservation attempt.

This course is currently in very high demand and we need your e-mail address now to reserve your seat(s) for this course:

Course Number: 97015

Course Name: Power BI Bundle 55164 and 20778 - Quick Powerful Graphics with Power View, PowerPivot, Power Query, Power Map and Power BI

Course Date/Location:

Quantity: seat(s)

Please enter your email address now and then click the green "Reserve My Seat(s)" button to reserve your seat(s) now for this course.

You have to enter your e-mail address

Why am I receiving this message and what should I do now?

If you see this message, we detected multiple concurrent attempts to reserve this course across our course reservation system. We prioritized you since you were among the first reservations - however, we need your e-mail address now to ensure reserving your course seat(s).

Make sure your e-mail address is valid and that you check it often, because reservations that have indicated a valid, real email address in this step will be prioritized.

When the timer runs out, your seat(s) will be released. Therefore, you should enter your e-mail address as soon as possible within the time limit indicated by the timer to reserve your course seat(s).

Entering your e-mail address here does not create a commitment or otherwise obligate you to purchase this course - however we have detected very high demand on the system for this course, so we need your e-mail address now to proceed with reserving your seat(s) for this course.

Even if you've been previously prompted to do this in the past or are a returning customer, you still need to perform this step now to reserve your course seat(s).