Effective Quick Insights and Q&A in Power BI

By Jim Kay
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.
Course info
Level
Advanced
Updated
May 3, 2019
Duration
3h 34m
Table of contents
Course Overview
Simplifying Data Queries with Q&A
Simplifying Data Analysis with Quick Insights
Optimizing Data for Q&A by Making Your Data Tidy and Polished
Exploring Data with Q&A
Mining Data with Minimal Effort Using Quick Insights
Voicing Questions Using Cortana
Enabling Q&A for an On-premises Dataset
Migrating a Power BI Dataset to an SSAS Database
Description
Course info
Level
Advanced
Updated
May 3, 2019
Duration
3h 34m
Description

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.

About the author
About the author

Jim Kay has worked with SQL Server and many of the Microsoft Data-Related tools for almost as long as they have existed. This doesn't mean he knows everything about them, but he does know enough to be dangerous...

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Jim Kay, and welcome to my course, Effective Quick Insights and Q&A in Power BI. I am an IT security professional who has been working closely with Microsoft database technologies for over 20 years. Have you ever wanted to make it easier for people to query and access your data? What if it was as easy as letting them type a question into a textbox on a website? What if it was as easy as typing it right from the Windows Start menu? What if they didn't have to type at all? Also, wouldn't it be nice if instead of searching for answers, you could simply be presented with a list of useful insights about your data? In this course, we're going to examine the Q&A and Quick Insights features of Power BI. Some of the major topics that we'll cover include modeling your data to work with Q&A and Quick Insights, integrating Cortana with Power Bi, and using Q&A against on-premises data. By the end of this course, you'll be comfortable working with both Q&A and Quick Insights, and will understand how to optimize your datasets to allow these features to effectively work for you. Before beginning the course, you should already be familiar with Power BI in general, and while it will help if you have had some experience in the data modeling space, it's not required to understand the concepts presented in this course. I hope you'll join me on this journey to learn Q&A and Quick Insights with the Effective Quick Insights and Q&A in Power BI course, at Pluralsight.