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. |
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