* COVID-19: 1 Person per Room Health & Safety Policy *


eLearning Bundle - Power BI Online Course

Power BI TrainingeLearning Bundle - Power BI

by Certstaffix® Training

Length: 5 Course(s)      Price: $710/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Power BI


This eLearning Bundle includes these 5 courses: Building Interactive Dashboards with Microsoft Power BI, Hands-On Data Visualization with Microsoft Power BI, Learning Microsoft Power BI, Microsoft Power BI Recipes and Office 365 Power BI.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Power BI Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any software needed for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Power BI Training

Office 365 Power BI - 3:08 hours

FEATURES
Video
Post-Assessment

This course will cover the Office 365 program Power BI. Power BI is a powerful business intelligence tool for analyzing your data and presenting it visually. This course will cover both the Power BI web app as well as the Power BI Desktop app. Topics covered include getting started with Power BI, connecting to data, visualizing data, publishing your visualizations in dashboards and reports, and connecting to other apps like Excel.


1. Introduction
• Introduction 00:01:52

2. Getting Started with Power BI
• What is Power BI? 00:01:28
• The Power BI Web App and Desktop App 00:02:32
• Components of Power BI 00:02:08
• Signing into the Power BI Service 00:02:46
• The Power BI Web Interface 00:02:34
• The Power BI Desktop Interface 00:04:59
• Power BI Desktop Options 00:04:24
• Saving a Report in Power BI Desktop 00:02:56

3. Connecting to Data
• Data Connection Basics 00:03:20
• Connecting to a File for Data 00:03:27
• Connecting to an Online Source for Data 00:04:16
• Modifying Data Through Edit Query 00:02:46
• Creating Relationships 00:03:09
• Configuring Columns 00:04:56
• Creating Columns 00:03:56
• Creating Measures 00:06:06
• Modifying or Deleting Columns or Measures 00:01:36
• Creating a Calculated Table 00:02:40

4. Visualizing Data
• The Visual Components of Power BI 00:04:29
• Creating a New Visual 00:01:57
• Configuring the Fields of a Visual 00:04:57
• Configuring the Formatting of a Visual 00:05:33
• Copying Formatting from One Visual to Another 00:01:44
• Creating a Pie Chart 00:05:14
• Creating a Map 00:06:49
• Creating a Text Box, Image, or Shape 00:03:27
• Creating a Table 00:03:18
• Creating a Column or Bar Chart 00:04:21
• Creating a Line Chart 00:06:41
• Using Filters and Slicers 00:03:45
• Adding Conditional Formatting 00:03:18
• Using Edit Interactions 00:04:04
• Using Analytics 00:05:11
• Using Insights 00:03:13

5. Dashboards/Publishing Data
• The Difference Between Dashboards and Reports 00:03:34
• Creating Reports 00:04:06
• Adding and Modifying Pages within Reports 00:03:47
• Creating a Drillthrough Page 00:04:15
• Publish a Report 00:03:04
• Create a Dashboard 00:03:13
• Adding Tiles to Dashboards 00:05:54
• Embedding Reports into Webpage 00:04:20
• Sharing Dashboards with Other Users 00:03:05

6. Power BI and Other Apps
• The Excel Power BI Add-in 00:02:38
• Pinning Excel Content into a Dashboard 00:03:22
• Managing Pins within a Dashboard 00:02:17
• Exporting Power BI to PowerPoint 00:03:13
• The Power BI Gateway 00:04:25
• Using Analyze in Excel 00:03:42
• The Power BI for Mobile 00:03:39

7. Conclusion
• Course Recap 00:01:24

Microsoft Power BI Recipes - 2:57 hours

FEATURES
Audio Narration
Video

Microsoft Power BI is a suite of tools to analyze your data and extract business insights from it through building interactive dashboards. This video course is your guide to getting the most out of Power BI and will help you solve any problems you might come across while using it.This tutorial contains practical recipes on the various tasks that you can do with Microsoft Power BI—from gathering your data to analyzing it.You will start with the basic installation and configuration of Power BI Desktop, and go on to connect your data sources with it. You’ll transform and get your data ready for analysis, and create effective data views using it. Then, you will see how you can create stunning reports and dashboards in Power BI.Finally, the course also contains some handy recipes on troubleshooting various issues in Power BI. We’ll ensure that you have the tricks of the trade in mastering Power BI to get effective visual analytics.

GET AND PREP DATA LIKE A SUPER NERD

The Course Overview

Desktop Layout, Features, and Views

Connecting to Common Data sources

Query Editor Layout and Functionality

Creating Relationships in Your Data Model


DEVELOP YOUR DATA NERD PROWESS

Built-in Aggregations

Calculated Columns and Measures

A Visual Demonstration

Some Slightly Advanced Measures


DEVELOPING REPORTS AND DASHBOARDS

Data Visualization Best Practices

Report and Dashboard Layout

Creating a Sales Analysis Report

Creating a Project Management Report


TIPS, TRICKS, AND CAPSTONE PROJECT

Telling the Story of Your Data

Thinking Outside the Visual Box

Theme-ing It Up

Capstone Project

Learning Microsoft Power BI - 4:00 hours

FEATURES
Audio Narration
Video

Tell your data story with Power BI and reach millions of users with a single click on any kind of a device. Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds. The goal of this course is to teach you how to use raw data, monitor it, and visualize it in a form that will provide rich insights with the help of dashboards. You will start with a set of business requirements for an example project from a client. Initially, you will connect to a data file. You'll run through the process of connecting to your data, transform it, and then build the data model. This will help you understand and determine which DAX calculations are needed to meet the business requirements. Finally, you will build out an interactive and functional report and a detailed dashboard, and publish them on PowerBI.com. When it comes to learning Power BI, this course will ensure that you have the necessary tricks of the trade for effective insights and simplified visual analytics.



PROJECT REQUIREMENTS AND GETTING DATA
The Course Overview

What Is the Flow of Report Development for a Business Analyst?

Reviewing Project Requirements and Determining Data Sources

Connecting to (Almost) Any Data Source with Power Query

Importing Data and Power Query Fundamentals

Connecting to a Folder as a Data Source

Table Types and Relational Data Modeling

COMMON DATA TRANSFORMATIONS
Common Data Transformations with Power Query

Intelligent Data Filtering with Power Query

Adding New Columns with Power Query

Merging Tables with Power Query

DATA MODELING AND RELATIONSHIPS
Creating Table Relationships in Power BI

Understanding the Data View in Power BI

Column Settings and Hierarchies In Power BI

DATA ANALYTICS WITH DAX MEASURES
Translating Report Requirements into DAX Measures

Report View Walkthrough

DAX Concepts and Fundamentals

Creating Basic DAX Measures

Creating a DAX Measures Table

Referencing DAX Measures

DATA VISUALIZATION AND MODERN REPORTING
Visual Cues and Chart Types

Creating Visualizations – Matrix Table

Creating Visualizations – Running Total Chart

Creating Visualizations – Column and Line Chart (Year-Over-Year Profits %)

Creating Visualizations – Conditional Formatting and Waterfall Charts

Creating Visualizations – Card Visualizations and Title Section

Slicers and Filter Settings

Formatting and Report Design

REPORT PUBLISHING AND THE POWER BI SERVICE
Publishing a Report to the Power BI Service

Creating an App Workspace

Creating a Dashboard

Setting Up Scheduled Refreshes

Learning Microsoft Power BI: Course Completed

Hands-On Data Visualization with Microsoft Power BI - 1:53 hours

FEATURES
Audio Narration
Video

Are you wasting time on compiling data from multiple sources instead of analyzing data? Are you relying on your Tech team to develop custom reports and dashboards? Power BI is a self-service business intelligence tool that reduces your dependency on the IT team to create reports and dashboards. Power BI is used to get insights from the data, saving your cost and time. This course aims to equip you with BI tools to make better business decisions and create accurate reports and dashboards in just few minutes. This course is specifically designed to give you hands-on experience of Power BI with more of a focus on practical applications in business environments. You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. By taking this course, you’ll build a solid ground in business intelligence and will be able to create real-time reports and dashboards in minutes.


GETTING STARTED WITH POWER BI

The Course Overview

Basic Concepts of Business Intelligence

Installing Power BI

Connecting to Different Data Sources


DATA TRANSFORMATION AND MODELING

Basic Data Transformations

Splitting Columns and Changing Data Types

Conditional Columns and Merge Queries

Creating Calculated Columns

Manage Your Data Relationships


POWER BI DESKTOP VISUALIZATIONS

Introducing Various Visuals

Communicating with Charts – Part 1

Communicating with Charts – Part 2

R Language Plotting Basics

R Visual Integration

Page Layout and Formatting


POWER BI SERVICE

Introduction to Power BI Service

Uploading Reports to Power BI Service and Quick Insights

Natural Language Querying

Alerts and Notifications in Power BI Service

Personal Gateway


WORKING WITH EXCEL IN POWER BI

Using Excel Data in Power BI

Connecting to Excel Workbook on OneDrive for Business

Pinning Excel Tables or Visuals


PUBLISHING AND SHARING

Introduction to Content Pack, Security, and Groups

Creating a Group

Creating, Using, and Editing Content Pack

Row-Level Security (RLS)

Integrate and Share OneDrive for Business with Power BI


POWER BI MOBILE

Introduction to Power BI Mobile

Mobile Dashboard Layout

Sharing and Annotating in Power BI Mobile

Using Custom Charts from Marketplace

Building Interactive Dashboards with Microsoft Power BI - 2:03 hours

FEATURES
Audio Narration
Video

Do you get confused when you analyze data from various sources? If yes, then this course will be your perfect guide and companion to analyze any data with ease. This course provides an introduction to Power BI's powerful dashboard design features and how you can use it to the advantage of your organization. You'll begin the course by building a simple, functional interactive dashboard. You'll present linked charts and KPIs. You'll develop dashboard examples suitable for publishing to analysts through managers and executives. At times, you need to walk users through the data so we introduce some storytelling features of Power BI. Finally, we'll wrap up with some tips to style your dashboards for publishing. At the end of this course, you’ll explore real-world examples, get started with Microsoft Power BI, and become comfortable with it so you can delve deeper.


POWER BI KICK START

The Course Overview

The Visualization Palette, Reports, and Dashboards

Link Them Up – Enabling Visual Interactions

Key to Performance – Calculating Your KPIs

Helpful Hints – Adding Tooltips and Legends


ANALYTICAL DASHBOARDS

Introducing the Analytical Dashboard Example

Time Matters – Time Series Chart

Some Like It Hot – Heat Map Charts

What-if – Using Parameters and Slicers to Filter and Explore

Detail Oriented – Exporting Data from Visuals


TACTICAL DASHBOARDS

Introducing the Tactical Dashboard Example

Point of Reference – Creating a Dot Plot

Statistics Never Lie – Box and Whisker Plots

Big Spenders – Building a Funnel Chart

Where It Is – Geographical Map Charts


STRATEGIC DASHBOARDS

Introducing the Strategic Dashboard Example

Are We There Yet? – Calculating Period-over-Period Changes

On Target – Visualizing Comparisons with Bullet Charts

Mash It Up – Pinning Visuals to Dashboards

Make It Pop – Adding Media Tiles to a Dashboard


DATA STORIES WITH DASHBOARDS

Introducing the Data Stories Dashboard Example

Meet the Players – Presenting Data with the Card Browser Custom Visual

Space Travel – Linking Together Dashboards with Actions

Time Travel – Telling a Story with Bookmarks

Click for More – Embedded Links and Hyperlink Dashboard Tiles


FORMATTING DASHBOARDS AND DATA

Formatting Concepts and Best Practices

Formatting Visuals and Reports

Creating Relevant Labels and Effective Number Formats

Formatting Dashboards

Course Conclusion
Course Description: Print It | Download PDF | Email It