This recorded webinar will connect PowerPivot to an external data source, devise formula and build reports.
Key topics:
Connecting PowerPivot to an external data source e.g. Microsoft Access
Summarising and aggregating data with DAX functions – RELATED, CALCULATE, DIVIDE, SUMX
Utilising disconnected tables to generate a slicer to give results based on commission
Introducing Time Intelligence functions to sort data by month to add value to reports
Learning objectives
Understand data modelling basics for building PowerPivot data models
Connecting PowerPivot to external data sources
Summarising and aggregating data with DAX functions
Utilising disconnected tables for sophisticated analysis
Introduce Time Intelligence functions
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.
Details
60560695
1 hour
365 Days
English
English
System is currently experiencing issues and we are working on a solution. If you encounter an error, please come back shortly and try again.