Power BI eLearning Bundle Course

Office 365 Power BI – 3:08 hours

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

FEATURES
Video
Post-Assessment

Microsoft Power BI Recipes – 2:57 hours

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

FEATURES
Video
Audio Narration

Learning Microsoft Power BI – 4:00 hours

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

FEATURES
Video
Audio Narration

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

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

FEATURES
Video
Audio Narration

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

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

FEATURES
Video
Audio Narration