Advanced Secrets of Microsoft Power BI
Author: Stephen M. Yoss
| CPE Credit: |
2 hours for CPAs |
Microsoft Power BI is an incredible tool for processing your organization’s data into insightful analysis. It can be used to produce any type of analytics, from simple charts to responsive maps, to KPI indicators to in-depth statistical analysis and everything in between. This incredible tool should be the backbone of reporting for all organizations. Helping to give decision markers the right information they need, at the right time, to make good and effective decisions for their organizations. While exceedingly versatile and powerful, Power BI comes with a steep learning curve. It takes months and years to master this application and its many functionalities. It has many hidden features and unknown best practices which can stymie and frustrate new users.
This course is going to focus on the hidden secrets, capabilities, features, and functions of Microsoft Power BI. This intermediate course will focus on helping users master the capabilities of the application and produce more effective reports. It will discuss capabilities such as best practices for data management, creating more interactive reports, and recommendations for more efficient use of the application. This practically focused course will demonstrate many of the more complicated functionalities which are often not discussed in introductory-level courses. Additionally, it will take a particular focus on the most recently released functionalities of the application such as new visualizations, data connectors, collaboration services, and more.
Publication Date: December 2021
Topics Covered
- Hidden secrets, capabilities, features, and functions of Microsoft Power BI
- Helping users master the capabilities of the application and produce more effective reports
- Best practices for data management
- Creating more interactive reports
- Recommendations for more efficient use of the application
- Demonstrate many of the more complicated functionalities
Learning Objectives
- Identify and implement best practices for working with large data sets with Power BI
- Recognize the specific intention and use case of Power BI's various visualizations of charts, graphs, maps, KPIs, and more
- Recognize how to develop more complex, integrated, and useful dashboards for their organizations
- Describe the various additional tools and resources which can be helpful for reporting projects
- Identify how to leverage advanced capabilities such as row-level security, quick measures, and DAX for delivering more comprehensive reports
- Identify the Power BI Pro price per month per user
- Identify which method of getting data into Power BI is good for when data sets are too large to practically load and refresh
- Identify which method of getting data into Power BI supports DAX calculated tables
- Describe formatting best practices
- Recognize which of the top 5 visual apps is used to add in-canvas filter buttons
Level
Intermediate
Instructional Method
Self-Study
NASBA Field of Study
Information Technology (2 hours)
Program Prerequisites
Intermediate knowledge of Power BI and Excel and knowledge of databases.
Advance Preparation
None
