Enter the sizzling hot wld 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 f impting data (from a database, text files, other sources) into Excel. The primary emphasis is on Power Query. Second, it devotes considerable time to the Excel Data Model and Power Pivot f 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 repts and maps with very little wk.
What am I going to get from this course?Over 51 lectures and 5 hours of content!An understanding of how the four components of Microsoft's Power BI suite (Power Query, Power Pivot, Power View, and Power Map) wk together to provide amazing data analysis possibilities, all within ExcelHow to impt data from various data sources into Excel, both with older tools and the newer Power Query tools, with emphasis on the latterAn understanding of the relationship between the Excel Data Model and Power PivotAn understanding of how Power Pivot adds significant power to Excel's existing data analysis toolsHow to use the Power Pivot user interface, and how to create pivot tables with Power PivotHow to use the DAX language in Power Pivot to create calculated columns and measures, and why DAX is so powerfulHow to create named sets, hierarchies, and KPIs (key perfmance indicats) with Power PivotHow Power View and Power Map can be used to create insightful repts and maps with very little wk
Home Page -
I recommends Buy premimum account for High speed+parallel downloads!