About this course
Legacy course. Superseded by Microsoft Power BI nevertheless Excel retains business intelligence capabilities and many have been enhanced and or new functionality added.
Microsoft Power Pivot is a tool to build relationships between database tables. Doing so enables us to ask powerful questions of our data. To clarify our objective for Power Pivot. We are appending merging, combining tables into a data model but I should emphasis our tables remain separate. The key learning point here is we are building relationships to allow us, to interrogate our, data.View Lesson
A pivot table is a data visualisation tool to summarise data. Users can control pivot table and or chart data by dragging and dropping fields graphically.View Lesson
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.