September 27, 2023


Live Webcast


2 Total CPE Credits

product-artwork-107143

Excel, Power BI and Data Analysis – Eliminating the Paralysis of the Analysis

  • Instructor

    Donald Tomoff

Learning Objectives

  • Explain the Excel “power tools” and better understand the capabilities of “modern” Excel
  • Understand how Excel and PowerBI, although separate platforms, are integrated and complementary tools
  • Explain the process of “ELTR” in data analytics – Extract, Transform, Load and Report
  • Understand basic reporting concepts and considerations for both Excel and PowerBI
  • Explore basic data sets and understand the basics of cleaning data using Excel (consistent with Power BI)
  • Use real-world data sets and examples to take back to your organizations and put to use

Major Topics

  • Concepts of modern Excel power tools and Power BI
  • Cleaning data (Power Query),
  • Shaping and modeling data (Power Pivot, Data Model and DAX)
  • Loading data and tips for creating basic dashboards and reports
  • Real-world data sets and examples

CPE Credits Available

2
Total CPE
2
Information Technology

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Future Ready
  • Technology

Prerequisites

Designed as an overview session, rather than a “how-to” deep dive. However, use of Excel on a regular basis and ability to navigate menus, options, etc. provided in the software would be beneficial – but not required.

Intended Audience

Designed as an overview session, rather than a “how-to” deep dive. However, use of Excel on a regular basis and ability to navigate menus, options, etc. provided in the software would be beneficial – but not required.

Provider

Business Learning Institute

Register For This Event

  • MACPA Member

    $ 90 90
    Join
  • MACPA Non-Member

    $ 110 110
    Your Price

Please login to register.