Excel to Power BI [Full Course] 📊

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: 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/lwtn-trial 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook:   / pragmaticworks   ✔️Instagram:   / pragmatic.works   ✔️LinkedIn:   / pragmaticworks   ✔️YouTube:    / pragmaticworks   Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 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 - Build ...   ~-~~-~~~-~~-~