The Power Pivot, Power Query in Excel and Power BI Bundle

Learn Excel Power Query, Power Pivot, DAX, Power BI Tools and 3D Maps. Build Excel Data Analyst Models with Excel 365

Created by: Andreas Exadaktylos
Best Selling Teacher | Msc Computer Scientist

What Will I Learn?

• Learn in depth Power Query, PowerPivot, DAX, Power BI and Power Map tools
• Learn from the beginning – blank canvas – until a completed report & dashboard. We show you how to best use the core elements of Power BI to conduct meaningful
• Quickly turn mass quantities of data into meaningful information using Excel Power Pivot and DAX
• Create business intelligence reports and dashboards
• Analyze huge amounts of data fast and accurate
• Learn the most current version of Microsoft Excel (Excel 2019 & Office 365)
• Improve general Excel knowledge
• Follow along with included Excel project files
• Course updated regularly
• Learn from an instructor with over 20 years of experience, teaching thousands of students in his own computer learning school
• An instructor ready to answer your questions in less than 24 hours
• Watch high-quality video lectures with lifetime access
• Certificate of completion

Requirements

• IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)
• This course is designed for PC users (Power Pivot is currently NOT available for Mac)
• The functionality of Power View is now accessible from the Power BI Desktop. All the functionality is still available (and supported in Excel 2016/2019) but the ribbon command has been removed.
• Willingness for learning

Target audience

• Everyone who wants to master Excel Dashboards
• Business analysts
• Data analysts
• Students
• Entrepreneurs