Excel Power BI Tools – Using PowerPivot
PowerPivot for Excel allows you to query and analyse millions of rows of data quickly and easily. Analysing data from databases, Excel worksheets and other sources together in one PowerPivot and using ‘Dashboards’ to build interactive applications to review the data at the click of a button.
In addition to the graphical tools, PowerPivot includes Data Analysis Expressions (DAX) – a new formula language that extends the data manipulation capabilities of Excel to enable more sophisticated and complex grouping, calculation and analysis with performance enhancements.
An introduction into adding a PowerView perspective to easily add dynamic & meaningful graphics to data is also included in the day.
This content rich, intense course allows you to learn about the PowerPivots tools – see our website for additional courses on using the Power BI tools