Excel 2016 PowerPivot, PowerMap, PowerQuery, PowerView & BI

Size: 1.16GB | Duration: 4h 48m | Video: AVC (.mp4) 1274x720 30fps | Audio: AAC 44.1KHz 2ch

Genre: eLearning | Level: Advanced | Language: English

Enter the sizzling hot world of BI, Power Pivot, DAX, and big data. Excel 2016 Power Tools are a total game changer!

This course takes up where the Optima Train Excel 2016 Pivot Tables and Pivot Charts course leaves off. It all revolves around the fairly new suite of Microsoft “Power” tools, often referred to as Power BI. The course has three primary themes. First, it teaches you a number of methods for importing data (from a database, text files, or other sources) into Excel. The primary emphasis is on Power Query. Second, it devotes considerable time to the Excel Data Model and Power Pivot for analyzing data with pivot tables. These take traditional pivot tables to a whole new level. Third, it shows how Power View and Power Map can be used to create insightful reports and maps with very little work.