Excel 2016 PowerPivot, PowerQuery, PowerView & BI
Enter the sizzling hot world of BI, Power Pivot, DAX, and big data. Excel 2016 Power Tools are a total game changer!
4.11 (340 reviews)
1,905
students
4 hours
content
Aug 2017
last update
$19.99
regular price
What you will learn
An understanding of how the four components of Microsoft’s Power BI suite (Power Query, Power Pivot, Power View, and Power Map) work together to provide amazing data analysis possibilities, all within Excel
How to import data from various data sources into Excel, both with older tools and the newer Power Query tools, with emphasis on the latter
An understanding of the relationship between the Excel Data Model and Power Pivot
An understanding of how Power Pivot adds significant power to Excel’s existing data analysis tools
How to use the Power Pivot user interface, and how to create pivot tables with Power Pivot
How to use the DAX language in Power Pivot to create calculated columns and measures, and why DAX is so powerful
How to create named sets, hierarchies, and KPIs (key performance indicators) with Power Pivot
How Power View and Power Map can be used to create insightful reports and maps with very little work
Related Topics
668996
udemy ID
11/13/2015
course created date
3/22/2020
course indexed date
Bot
course submited by