Microsoft 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.

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

Prerequisites: (to follow along or review later)
✔ Install Power BI Desktop (https://tinyurl.com/33rcb3rn)
✔ Download student files (https://share.hsforms.com/1DW6j0yH2RY...)

After you finish this course:
If you have completed this class and would like a certificate, fill out this form https://share.hsforms.com/1JYYgjCoITT...

0:00 Intro
4:31 Session starts
22:31 Power Query Explanation and Import Files from a Folder
41:15 PowerPivot and the Data Model in Excel
49:15 Power Query: Using Unpivot
58:16 Power Query: Splitting Column by Delimiter and Fill Down

Full Report Demo:
1:10:32 Part 1: Data Cleansing in Power Query
1:54:48 Part 2: Data Modeling
2:02:50 Migrating from Excel to Power BI
2:09:35 Part 3: Data Visualizations
2:29:27 Part 4: Publishing a Power BI Report

2:36:03 Using Analyze in Excel
2:50:15 Adding Excel charts to a Power BI Dashboard and App



Next step on your journey:
OnDemand Learning Start With The FREE Community Plan: https://prag.works/lwtntrial

Pragmatic Works OnDemand Learning Packages: https://pragmaticworks.com/pricing/
Pragmatic Works Boot Camps: https://pragmaticworks.com/bootcamps/
Pragmatic Works Hackathons: https://pragmaticworks.com/privatetr...
Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtualme...
Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/privatetr...
Pragmatic Works Blog: http://blog.pragmaticworks.com/


Let's connect:
✔Twitter:   / pragmaticworks  
✔Facebook:   / pragmaticworks  
✔Instagram:   / pragmatic.works  
✔LinkedIn:   / pragmaticworks  
✔YouTube:    / pragmaticworks  

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 6385743
Email: [email protected]

**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.

~~~~~~~~~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
   • Free Power Apps Component Library  B...  
~~~~~~~~~