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 ([ Ссылка ])
✔️ Download student files ([ Ссылка ])

After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - [ Ссылка ]

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:
👉 On-Demand Learning - Start With The FREE Community Plan: [ Ссылка ]

🔗Pragmatic Works On-Demand Learning Packages: [ Ссылка ]
🔗Pragmatic Works Boot Camps: [ Ссылка ]
🔗Pragmatic Works Hackathons: [ Ссылка ]
🔗Pragmatic Works Virtual Mentoring: [ Ссылка ]
🔗Pragmatic Works Enterprise Private Training: [ Ссылка ]
🔗Pragmatic Works Blog: [ Ссылка ]


Let's connect:
✔️Discord: [ Ссылка ]
✔️Facebook: [ Ссылка ]
✔️Instagram: [ Ссылка ]
✔️LinkedIn: [ Ссылка ]
✔️YouTube: [ Ссылка ]

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com

**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 "
[ Ссылка ]
-~-~~-~~~-~~-~-

свернуть