Course ID: EXPBI-UG

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. Leaders of tomorrow will require a strong foundation in data analytics, and that knowledge starts with the everyday tools that we all have.

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

* Recognize how Excel and PowerBI, although separate platforms are integrated and complementary tools

* Identify 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 PowerBI.com – 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


Advanced Preparations

None


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. 


Fields of Study

Information Technology

Prerequisites

None


Provider

Business Learning Institute

CPE Credits

8

Level

Basic

This course is available for your group as:

 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: 888-481-3500 or team@blionline.org
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×