Webinar: Introduction to Power Pivot

FREE

Duration: 1.5 hours

Power Pivot enables you to combine data from multiple sources into a single report. You can summarise tables in relational databases without involving the database administrator or having to have a View created.

THIS IS AN ADVANCED SESSION.

Its a pivot table on steroids (in a good way). Power Pivot can report on virtually any relational data base as well as bringing together data from different sources into a single report. Eg combining a csv file; an Access database and an Excel table.

We will use an Access database in this session.

YOU DO NOT NEED TO HAVE THE ACCESS APP INSTALLED ON YOUR PC/LAPTOP.

The session will cover

  • background information on using relational databases
  • creating a PowerPivot report from a large relational database
  • adding tables to the data model to expand the reporting possibilities
  • techniques to make the report more reader-friendly
  • hiding fields to simplify the interface
  • using Slicers
  • an introduction to DAX
  • books and websites to help you learn more
Date: 26/09/2024
Time: 1:00 PM AEST
Event: FREE Intro to Power Pivot (1.5 hours)
Topic: Introduction to PowerPivot
Public: Public
Registration: Click here to register.