Effective Quick Insights and Q&A in Power BI

Focused View

Jim Kay

3:34:05

51 View

01.Course Overview

0101.Course Overview.mp4

01:44

02.Simplifying Data Queries with Q&A

0201.Course Objectives and Assumptions.mp4

02:44

0202.Q&A Target Audience.mp4

03:12

0203.Q&A Benefits and Requirements.mp4

04:51

0204.Q&A Demo Against a Clean Dataset.mp4

04:02

0205.Setting up the Sample Database.mp4

06:15

0206.Uploading the Sample Data to Power BI.mp4

04:58

0207.Q&A Demo Against a Raw Dataset.mp4

02:56

0208.Module Summary.mp4

00:39

03.Simplifying Data Analysis with Quick Insights

0301.Analyze Your Data with Quick Insights.mp4

00:36

0302.Quick Insights Benefits and Requirements.mp4

04:07

0303.Quick Insights Demo Against a Clean Dataset.mp4

04:28

0304.Quick Insights Dataset Mode Limitations.mp4

02:28

0305.Quick Insights Demo Against a Raw Dataset.mp4

06:53

0306.Module Summary.mp4

01:01

04.Optimizing Data for Q&A by Making Your Data Tidy and Polished

0401.Introducing Tidy Datasets.mp4

03:56

0402.Demo Creating a Tidy Dataset.mp4

05:22

0403.Demo Creating a Tidy Dataset - Part 2.mp4

06:26

0404.Demo Polishing Your Dataset.mp4

06:57

0405.Demo Polishing Your Dataset - Part 2.mp4

03:33

0406.Demo Polishing Your Dataset - Part 3.mp4

04:21

05.Exploring Data with Q&A

0501.Understanding the Vocabulary of Q&A.mp4

07:09

0502.Demo Adding Q&A Questions to Reports.mp4

05:51

0503.Demo Exploring Data with the Q&A Button.mp4

05:50

0504.Module Summary.mp4

01:13

06.Mining Data with Minimal Effort Using Quick Insights

0601.Acting on Data by Interpreting Insights.mp4

01:55

0602.Finding Leaders Using Single Point Insights.mp4

01:31

0603.Insight Category Outliers.mp4

02:32

0604.Insight Major Factors.mp4

02:17

0605.Insight Low Variance.mp4

02:15

0606.Remembering History Using Single Shape Insights.mp4

01:24

0607.Insight Change Points in a Time Series.mp4

02:18

0608.Insight Trends, Seasonality, and Time Series Outliers.mp4

04:14

0609.Correlating Data Using Compound Insights.mp4

01:31

0610.Insight Clustering.mp4

02:48

0611.Module Summary.mp4

00:51

07.Voicing Questions Using Cortana

0701.Voicing Questions Using Cortana.mp4

02:41

0702.Meeting Requirements for Cortana Integration with Power BI.mp4

02:21

0703.Understanding Connections between Windows 10, Cortana, and Power BI.mp4

04:05

0704.Demo Connecting Windows 10 with Power BI.mp4

02:50

0705.Finding Reports and Dashboards Across Workspaces Using Cortana.mp4

01:36

0706.Demo Power BI Report and Dashboard Search.mp4

06:27

0707.Generating Rich Q&A Answers with Cortana Answer Cards.mp4

01:34

0708.Demo Converting Report Pages into Cortana Answer Cards.mp4

06:16

0709.Demo Filtering Answer Cards for Drillthrough Targets.mp4

03:56

0710.Demo Ditching the Keyboard by Simply Talking to Cortana.mp4

02:13

0711.Demo Troubleshooting Cortana Without Windows 10.mp4

02:14

0712.Module Summary.mp4

01:38

08.Enabling Q&A for an On-premises Dataset

0801.Enabling Q&A for an On-premises Dataset.mp4

02:15

0802.Understanding Capacity Limitations in Power BI.mp4

02:47

0803.Comparing the Costs of Pro vs. Premium.mp4

04:18

0804.Importing Data into Power BI.mp4

02:38

0805.Scheduling Data Updates in Power BI.mp4

03:04

0806.Using DirectQuery to Mash-up Source Data.mp4

01:42

0807.Offloading the Data Model Itself Using Live Connection.mp4

03:42

0808.Establishing Identity with Effective Username.mp4

02:08

0809.Demo Deploying the On-premises Data Gateway.mp4

05:14

0810.Demo Troubleshooting the On-premises Data Gateway.mp4

04:58

0811.Module Summary.mp4

00:55

09.Migrating a Power BI Dataset to an SSAS Database

0901.Migrating a Power BI Dataset to an SSAS Database.mp4

03:31

0902.Scripting the Creation of a Power BI Model Using SQL Management Studio.mp4

05:11

0903.Loading the New SSAS Database into Visual Studio.mp4

04:08

0904.Cleaning Connections in the Model.bim File.mp4

03:11

0905.Module Summary.mp4

01:24

Description

Learn to query your data (including on-premises data) using questions such as "Can you show me revenue by region for the last three months?". Also, discover how to easily mine valuable insights from your data without needing a degree in data science.

What You'll Learn?

Have you ever wanted to provide a simple, self-service way for data consumers to query your data? What if they could just type a question or even just speak their question and have a useful chart or report 'magically' appear with the answer? In this course, Effective Quick Insights and Q&A in Power BI, you will gain the ability to optimize your Power BI datasets so that they will work seamlessly with the powerful Q&A and Quick Insights features. First, you will learn what these features are capable of doing when applied to a 'tidy and polished' dataset. Next, you will discover how to optimize your datasets so they will support these features. Finally, you will explore how to extend the Q&A feature to work with data stored not in the cloud, but inside your own on-premises data center. When you're finished with this course, you will have the skills and knowledge of data modeling needed to supercharge your Power BI datasets using both Q&A and Quick Insights.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Jim Kay

Instructor's Courses

Jim has spent most of his career looking at data in one form and trying to figure out how to put it into another form. His official responsibilities have changed over the last 20 years as he has moved through roles in desktop support, server support, patch management, Active Directory management, virtualization, collaboration engineering, SharePoint engineering and now Identity & Access Management. As different as those roles are, they all need data, and for the last 20 years he has used many of Microsoft's data technologies to solve complex problems in those spaces. When he isn't having fun with data, he's relaxing at home with his wife and two dogs in New Jersey.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.