Effective Quick Insights and Q&A in Power BI
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.
Table of contents
- Acting on Data by Interpreting Insights 2m
- Finding Leaders Using Single Point Insights 2m
- Insight: Category Outliers 3m
- Insight: Major Factors 2m
- Insight: Low Variance 2m
- Remembering History Using Single Shape Insights 1m
- Insight: Change Points in a Time Series 2m
- Insight: Trends, Seasonality, and Time Series Outliers 4m
- Correlating Data Using Compound Insights 2m
- Insight: Clustering 3m
- Module Summary 1m
- Voicing Questions Using Cortana 3m
- Meeting Requirements for Cortana Integration with Power BI 2m
- Understanding Connections between Windows 10, Cortana, and Power BI 4m
- Demo: Connecting Windows 10 with Power BI 3m
- Finding Reports and Dashboards Across Workspaces Using Cortana 2m
- Demo: Power BI Report and Dashboard Search 6m
- Generating Rich Q&A Answers with Cortana Answer Cards 2m
- Demo: Converting Report Pages into Cortana Answer Cards 6m
- Demo: Filtering Answer Cards for Drillthrough Targets 4m
- Demo: Ditching the Keyboard by Simply Talking to Cortana 2m
- Demo: Troubleshooting Cortana Without Windows 10 2m
- Module Summary 2m
- Enabling Q&A for an On-premises Dataset 2m
- Understanding Capacity Limitations in Power BI 3m
- Comparing the Costs of Pro vs. Premium 4m
- Importing Data into Power BI 3m
- Scheduling Data Updates in Power BI 3m
- Using DirectQuery to Mash-up Source Data 2m
- Offloading the Data Model Itself Using Live Connection 4m
- Establishing Identity with Effective Username 2m
- Demo: Deploying the On-premises Data Gateway 5m
- Demo: Troubleshooting the On-premises Data Gateway 5m
- Module Summary 1m
About the author
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... more