Loading component...
Business Modelling Using Big Data
Overview
In this recorded webinar, you will learn how to import data from an Excel file into Excel's data model. This will allow you to connect the imported data with lookup tables, making it easier to create DAX formulas for generating Power Pivot reports in Excel. With the resulting pivot table reports, you can create a concise one-page summary dashboard. By following these steps, you can minimise the need for ongoing maintenance and updates to your reports.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Generate data inside the data model from loading
- Link the various data sources based on a shared set of criteria
- Create calculations in the form of DAX calculated columns and measures that draw on the RELATED, CALCULATE, FILTER, ALL, MAX, BLANK DAX formulas
- Generate a range of pivot tables that splits the data by a number of different metrics and presents that data in neat summary report
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step-by-step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Clickherefor Marcus' biography.
Course updated: May 2023
IMPORTANT: You must complete this course by the expiry date. Extensions to this timeframe will not be provided.
What you'll learn
- Explain how to upload data into the data model
- Explain how to link data from multiple tables
- Generate some calculated columns and calculated measures in DAX
- Create succinct output reports in pivot table format drawing on multiple datasets
Who is this for ?
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles in job functions such as external reporting, financial control and management accounting.
