Introduction to Data Analytics and Microsoft PowerBI Tools (2 hours)

Previous Add to Calendar Next

Cancelled - Apr 13, 2020

Registration: 6:30 AM / Program: 7:00 AM - 9:00 AM

Fees

Member Fee: $0.00
Nonmember Fee: $0.00

Available Discounts

AICPA Member: None
Full time Accounting Educator: None

Description

Excel is the #1 data analysis tool for accountants, yet most accountants don't even know the basics of Excel data analysis functions and tools. Many accountants may have learned to analyze data using PivotTables but quickly realized that there are many weaknesses with PivotTables, leading to complex calculations for simple tasks. After much needed development, Microsoft released Power Pivot in 2010. It is a new data analytic tool that removed the weaknesses of PivotTables. This single product took Excel from a low-end data analytic tool to one of the most sophisticated and comprehensive tools. Since 2010, Microsoft has continued their development of end-user data analytic tools. This entire suite of products is called PowerBI. In this webcast, we will provide an overview of the exciting PowerBI tools and discuss Microsoft's PowerBI strategy. We will begin by explaining the challenges many accountants face when analyzing data in Excel. You will learn how each PowerBI tool reduces the challenges and improves your data analytic skills. Through detailed examples, you will gain a comprehensive understanding of when and why to use each tool.

Designed For

All accounting professionals.

Objectives

Understand how the PowerBI tools can help with your data analysis needs.

Identify when and why to use each PowerBI tool.

Understand how each PowerBI tool will meet your organization's strategy.

If you would like to register for this event, please contact OSCPA at 800-255-1470, 503-641-7200, or email profdev@orcpa.org.