Data Analytics and Dashboards: Leverage the Power of Microsoft Power BI

Mar 17 - Mar 18
8:00 - 4:00 p.m.

Penn State Great Valley - Main Bldg
Malvern - Map

16-Other
CPE Credits

Learn to perform powerful data analytics and create engaging dashboards, two of today's fastest growing skill sets in demand for CPAs.

Become the go-to person in your organization to help your management team and colleagues make better business decisions. Understand the various Power BI tools available and get to know which Power BI tool to use in various situation. Learn how to use Power Pivot to take your data analysis to the next level, and how to create measures that are not possible in regular PivotTables. Analyze date-based data in many new ways. Build interactive visuals to present your analysis and insights.


Highlights
  • Concepts of data analytics
  • Introduction to the Excel Power BI applications
  • Loading data into Power Pivot
  • Using Power Query to clean and transform data
  • Building a data model
  • Creating calculations using DAX functions and formulas
  • Using a date table to create time-intelligent measures
  • Building visuals using Power BI Desktop
  • Publishing data models and visualizations to Power BI Services

Registration

PICPA Member: $549
Nonmember: $649

More Information

Course No. 770000

Level: Intermediate

Prerequisites:

Some knowledge of PivotTables

Notes
Bring your laptop with the appropriate Power BI software installed. Instructions will be provided. Practice materials will be provided for you to follow along with the instructor.

Speaker(s)

Bryan Smith

DataSmith Pro LLC