New MACPA.org Launching 4/1! Stay tuned for a brand new online experience.

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

Description

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
Provider
Business Learning Institute
Course Level
Intermediate
Professional Area of Focus
Technology
Future Ready
CPE Field of Study
Information Technology
2
Who Should Attend

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.

Instructor(s)
Donald Tomoff
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.

Location
LIVE- ONLINE WEBCAST
Event Information
When
Sep 27, 2023
10:00 am - 11:50 am EDT
Location
LIVE- ONLINE WEBCAST
Total CPE Credits
2
Format
Live Webcast

MEMBER


$ (% off)
$90.00

NON-MEMBER


$ (% off)
$110.00
Become A Member

Register for this Event

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


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×