Learn how each PowerBI tool eliminates challenges and improves your data analytic skills. Go beyond the conventional analysis to visualising the data that matters and empower your decisions like never before.
You will also:
Earn certificate from AICPA (the world's largest accounting body). CPAs and CMAs will also be awarded 24 CPE credit hours.
For more info, click on the following links: https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS1/PC-VCXOPBIS1.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS2/PC-VCXOPBIS2.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS3/PC-VCXOPBIS3.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS4/PC-VCXOPBIS4.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS5/PC-VCXOPBIS5.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS6/PC-VCXOPBIS6.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS7/PC-VCXOPBIS7.jsp https://www.aicpastore.com/AST/Main/CPA2BIZ_Primary/PRDOVR~PC-VCXOPBIS8/PC-VCXOPBIS8.jsp
Introduction to Data Analytics and Microsoft PowerBI Tools
Get Started with the Right Data
Introduction to Data Analysis in Excel
Improve Data Analysis with DAX Measures
Power Pivot for Advanced Data Analysis
Fundamentals of Power Query
Fundamentals of the PowerBI Desktop App
Fundamentals of the PowerBI Dashboards
|Date||Start time||Duration||Topic||Session Focus|
|July 15, 2019||9:30 PM IST onwards||2 hours||Introduction to Data Analytics and Microsoft PowerBI Tools||Excel is the #1 data analysis tool for accountants, yet most accountants don’t know the basics of Excel data analysis functions and tools. In this webcast, we will help you expand your knowledge of data analysis in Excel and provide an overview of the new and exciting PowerBI tools.|
|July 16, 2019||9:30 PM IST onwards||2 hours||Microsoft PowerBI - Get Started with the Right Data||This webcast discusses the importance of having data in a data model versus in a spreadsheet. We will introduce some of the basic features of the Microsoft PowerBI Power Query, as well as Get and Transform in Excel 2016.|
|July 17, 2019||9:30 PM IST onwards||2 hours||Microsoft PowerBI - Introduction to Data Analysis in Excel||Before you start using all of the PowerBI tools, you first need to understand the data analysis tools available in Excel. This webcast introduces you to the relevant Excel data analysis tools and focuses what you can do with your data once it is in Excel.|
|July 18, 2019||9:30 PM IST onwards||2 hours||Microsoft PowerBI - Improve Data Analysis with DAX Measures||This webcast digs into major PowerBI tools. We will introduce DAX formulas and how they are used to create calculations. You will also learn about Power Pivot as a means to demonstrate calculations and measures.|
|July 19, 2019||9:30 PM IST onwards||4 hours||Microsoft PowerBI - Power Pivot for Advanced Data Analysis||This webcast focuses on using the Power Pivot features to enhance your data analysis. You will also learn how to use a date or calendar table to perform date analysis.|
|August 12, 2019||9:30 PM IST onwards||2 hours||Microsoft PowerBI - Fundamentals of Power Query||This webcast focuses on using the PowerBI Power Query, as well as Get and Transform in Excel 2016, to clean, shape and transform your messy data while still allowing you the one-click refresh.|
|August 13, 2019||9:30 PM IST onwards||4 hours||Microsoft PowerBI - Fundamentals of the PowerBI Desktop App||This webcast focuses on learning the PowerBI Desktop interface, connecting to data sources and creating visualizations. We will tour the PowerBi Desktop interface and create each of the various visualizations.|
|August 14, 2019||9:30 PM IST onwards||4 hours||Microsoft PowerBI - Fundamentals of the PowerBI Dashboards||Microsoft's cloud-based platform on PowerBI.com allows you to share your data and create meaningful dashboards. This webcast introduces you to the interface and explores its differences from PowerBI Desktop.|
Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.
Qualifications and Experience: