Two of the most important skills that every CFO, CPA, or auditor should develop are applying data analytics and creating visual dashboard reporting models. This two-day course will teach you both skills using one of the most popular tools available: Microsoft Power BI. When you complete this course, you will have advanced to the top of the profession in your ability to perform powerful data analytics and create engaging dashboards You will be sought after in your organization as the go-to person to tap into these skills to help your management team and colleagues make better business decisions. You will leave with knowledge that will set you apart in your profession. To optimize your learning experience, we highly recommend that you bring your laptop with the appropriate software installed. Instructions will be provided. We will provide practice materials for you to follow along with the instructor.
Upon completing this course, you will …Understand the various Power BI tools available; Know which Power BI tool to use in various situations; Know how to use Power Pivot to take your data analysis to the next level; Create measures that are not possible in regular PivotTables; Analyze date-based data in many new ways; Build interactive visuals to present your data analysis
The key topics that will be covered in this course: 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
All CPAs and accounting professionals who need to analyze data
Thorough understanding of PivotTables