Lesson Outcomes
After completing this practical lesson, learners will be able to:
- Explain hierarchies and time-based data
- Create data hierarchies in spreadsheet tools
- Configure date and time fields
- Group and organise time-based information
- Analyse trends using hierarchical data
- Present hierarchical reports visually
Overview
Hierarchies and time data structures are used to organise information into logical levels such as year, quarter, month, and day. Businesses and Robotic Process Automation (RPA) environments use hierarchical data structures to analyse trends, monitor performance, and improve reporting accuracy.
This practical lesson introduces learners to hierarchy creation, date grouping, time-based analysis, and structured reporting using spreadsheet and business intelligence tools. Learners will complete practical activities involving sales and operational data analysis across time periods.
Scenario: Time-Based Sales Reporting
A retail company requires a reporting system that analyses sales performance over different time periods including years, quarters, months, and days.
Learners are required to create and configure hierarchies and time data structures that allow management to analyse business trends efficiently.
PA0501 — Create Data Hierarchies
Tools/Resources
- PC or laptop
- Spreadsheet or BI software
- Sales dataset
Activity Instructions
- Open the provided dataset.
- Identify suitable hierarchy levels.
- Create hierarchical structures using categories or dates.
- Verify the hierarchy configuration.
- Save the completed workbook.
Expected Outcome
Hierarchies are created successfully using structured data levels.
Evidence Required
- Screenshot of hierarchy creation
- Screenshot of configured hierarchy levels
- Screenshot of organised dataset
PA0502 — Configure Time Data
Tools/Resources
- Spreadsheet software
- Date and time fields
- Dataset
Activity Instructions
- Identify date and time fields within the dataset.
- Configure fields for year, quarter, month, and day grouping.
- Apply suitable date formatting.
- Verify configured outputs.
Expected Outcome
Time data is configured correctly for analysis and reporting.
Evidence Required
- Screenshot of configured time fields
- Screenshot of grouped date information
- Screenshot of formatted outputs
PA0503 — Group and Analyse Time-Based Data
Tools/Resources
- Spreadsheet software
- Pivot tables or dashboards
- Dataset summaries
Activity Instructions
- Group data according to time periods.
- Analyse trends across different periods.
- Generate summaries and comparisons.
- Verify analysed outputs.
Expected Outcome
Time-based data is grouped and analysed successfully.
Evidence Required
- Screenshot of grouped data
- Screenshot of analysed trends
- Screenshot of summary reports
PA0504 — Visualise Hierarchical and Time Data
Tools/Resources
- Spreadsheet software
- Chart tools
- Dashboard tools
Activity Instructions
- Create charts using hierarchical or time-based data.
- Label charts appropriately.
- Insert visualisations into reports or dashboards.
- Verify chart accuracy.
Expected Outcome
Hierarchical and time data is visualised successfully.
Evidence Required
- Screenshot of charts and visualisations
- Screenshot of labelled reports
- Screenshot of completed dashboard or report
Key Notes
- Hierarchies organise information into structured levels.
- Time data supports trend analysis and forecasting.
- Date grouping improves reporting efficiency.
- Hierarchical analysis supports business decision-making.
- Visualisation improves interpretation of time-based information.
- Correct configuration improves reporting accuracy.