Now available: purchase a #MarylandCPAProud face mask and support the MACPA Educational Foundation! BUY NOW

Excel, Power Tools and PowerBI: Upping Your Data Analytics Game


A 2019 Business Learning Institute / MACPA survey identified “Big Data and Data Analytics” as the top technology trend impacting the accounting profession in the next three years. Excel is the #1 data analysis tool for business professionals, yet most professionals aren’t aware of and don’t take advantage of Excel’s advanced data analysis capabilities. Companies are rapidly adopting data analytics initiatives to enable better and faster decision making and accountants are poised to take advantage of this trend.

Excel and Power BI are an advanced, yet easy, way to get started with self service business analytics / business intelligence. This hands-on, interactive session will have you comfortable navigating and working with data sets using Excel’s power tools, which will translate directly into PowerBI.​

Learning Objectives

* Understand the basics of data analysis – data structure, Excel Tables and Pivot Tables
* Explain the Microsoft “power tools” – Power Query, Power Pivot and PowerBI
* Explain the process of “ETLR” in data analytics – Extract, Transform, Load and Report
* Understand how Excel and PowerBI, although separate platforms, are integrated and complementary tools
* Explore basic data sets and understand the basics of cleaning and transforming data using Excel (consistent with Power BI)

Major Topics

* Importance of data structure and creating a “proper data set”
* Walk-through of the data analytics “ETLR” construct, and how Excel and PowerBI fit
* Cleaning and transforming data (Power Query)
* Shaping and modeling data (Pivot Tables, Power Pivot, Data Model and DAX)
* Loading data and tips for creating basic dashboards and reports
* PowerBI Desktop and – what are they and how do they fit
* Use of real-world data sets and examples to take back to your organizations and put to use​

Business Learning Institute
Course Level
Professional Area of Focus
Accounting & Auditing
BLI Leadership
Business & Industry
Employee Benefits
Future Ready
Nonprofit / Not-For-Profit
Personal Financial Planning
CPE Field of Study
Information Technology
Who Should Attend

Accounting and finance professionals, and leaders in the finance organization that are interested in better understanding the data analytics opportunities that exist with Microsoft’s readily available spreadsheet and BI solutions. Leaders of tomorrow will require a strong foundation in data analytics, and that knowledge starts with the everyday tools that we all have.

Donald Tomoff

A reasonable working knowledge of Excel is highly recommended (including exposure to basic pivot tables). Experience with Excel’s Power Tools (Power Query and Power Pivot) is not required, although the interactive exercises will be using these tools. PowerBI experience is not required.

Event Information
Mar 25, 2020
8:00 am - 12:00 pm EDT
Total CPE Credits
Live Webcast


$ (% off)


$ (% off)
Become A Member

Register for this Event

Excel, Power Tools and PowerBI: Upping Your Data Analytics Game

Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now