fbpx

NEED HELP? TALK TO AN EXPERT (904) 638-5743

Learn with the Nerds – Excel to Power BI (Recorded Live Event)

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • The most advanced capabilities available in Excel (Power Query & Power Pivot)
  • Understand how to migrate your existing Excel work into Power BI
  • Learn the best opportunities to use Excel & Power BI together
  • How to transform existing manual reporting into actionable insights
This course includes:

Course Description

For decades, Excel has been the primary reporting tool of choice for businesses to develop data analytics solutions. While those skills are still important, learning Power BI opens you up to a more interactive and visually appealing experience by offering more powerful analytics and reporting features.

In this session, Jonathon Silva will teach you about some of the most advanced capabilities available in Excel, and how to bridge those skills into a new world within Microsoft Power BI where manual, complex, and arduous reports are a thing of the past. You’ll also learn how Excel and Power BI best work together and understand the migration path to take your existing Excel work into Power BI.

Outline

 

Module 01 | Intro

 

Module 02 | Power Query Explanation and Import Files from a Folder

 

Module 03 | PowerPivot and the Data Model in Excel

 

Module 04 | Power Query: Using Unpivot

 

Module 05 | Power Query: Splitting Column by Delimiter and Fill Down

 

Module 06 | Full Report Demo

 

Module 06A | Part 1: Data Cleansing in Power Query)

 

Module 06B | Part 2: Data Modeling

 

Module 06C | Migrating from Excel to Power BI

 

Module 06D | Part 3: Data Visualizations

 

Module 06E | Part 4: Publishing a Power BI Report

 

Module 07 | Using Analyze in Excel

 

Module 08 | Adding Excel charts to a Power BI Dashboard and App

Instructor

JONATHON SILVA

Training Content Manager
Jonathon Silva has his master’s degree in Education from James Madison University. He has 9 years of teaching experience in high school economics and history, where he was consistently recognized as a top educator in the field of history and a leader in curriculum development. As a Microsoft Certified Trainer that specializes in the Power Platform and Excel, Jonathon focuses on providing a welcoming learning environment to ensure that all participants are capturing the necessary skills for their continued development.

System Requirements

What to Know Before Class

  • No experience require needed.
REVIEWS

Pending reviews - check back later

Pending reviews - check back later

Pending reviews - check back later

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!