Audience
Technical users/data modellers who need to create and develop data modules. The Data Module will provide Report Authors with a framework from which they can select fields (data items) to build their reports. Data modelling will be discussed as well as referencing various data sources that will be included within the Data Module.
Prerequisites
A background on your business requirements would be beneficial.
Understanding and working with BI Reports would be highly beneficial.
To be familiar with a web browser and comfortable with using laptops/PC’s and a mouse.
Duration
1 day.
Course Objectives
- To obtain an overview of data Modules and Data Sources
- The Data Module Interface
- Feeding a Data Module - Creating and selecting a Data source
- Building a simple Data Module and testing
- Modifying Data Modules and applying customisations
- Building in relationships and re-testing
Course Content
Discuss and provide an overview of data Modules
Practice with the Data Module Interface
Overview of data modelling
Creating a user defined data source from an input file (eg Excel)
Build a data module from scratch and add different data sources
Explaining and using joins/relationships and test as you go
Adding filters and calculations, editing and refining Data Modules
Grouping data and building navigation paths
Sharing data modules
Overview of advanced data modelling techniques
Working with time & aggregation within your data module
Security Overview
Course Review and Feedback, including recap and Q/A session