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

BI and business analytics are in high demand. Companies are adopting data analytics initiatives to enable better and faster decision making. Excel and Power BI are an advanced, yet easy, way to get started with self service business analytics / business intelligence.

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.