Business modelling using big data in Excel (60560695) - Recorded webinar

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

• 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