Hornbill Academy

course
Academy Live: Hornbill Reporting: Empower your insights – Part 2
Academy Live: Hornbill Reporting: Empower your insights – Part 2
Academy Live: Hornbill Reporting: Empower your insights – Part 2

About the Course

~120 mins

The recording of this session is from 5/6/2024.


This course contains an edited video of the session and the session handout including activity instructions.


In this follow-on session on reporting, you will build on the topics learnt in our Hornbill Reporting Part 1 training and delve into sophisticated reporting techniques within Hornbill, with a focus on harnessing the power of Entities and SQL for data retrieval and analysis. 


You will explore how to utilize joint tables reporting to extract valuable insights from their data and create customized reports tailored to specific business needs to help strengthen your reporting metrics.


Please note, this session is for those who attend session one (or work through the on-demand version that will be published shortly after it takes place), or for anyone who is comfortable with Hornbill's reporting tools and wants to learn some tips and tricks using some examples and Advanced Analytics tools.


Learning Objectives: 


    - Strengthen your understanding of advanced reporting options available in Hornbill, including entities, filtering techniques, and advanced analytics. 


     - Provide hands-on activities in SQL usage  to extract and manipulate data for reporting requirements. 


    - Explore the limitations, considerations, and best practices associated with designing reports in Hornbill. 

Course Topics

Find relevant courses based on these topics
Course Progress
Not started
Enroll
Course Outline
  1. Reporting - Advanced session
    1. Overview
    2. Session handout
  2. Introduction and recap
    1. Introduction
    2. Recap on reporting basics
    3. Entities recap
  3. Using entities or SQL for reporting
    1. Entities and SQL for reporting
    2. Entities vs SQL
    3. How the SQL Schema designer simplifies reporting.mp4
    4. Entity viewer and database schema viewer
    5. Demo - Configure a report using SQL schema designer
  4. Activities 1 and 2
    1. Activity 1 Intro - Create a report using SQL schema designer
    2. Activity 1 Review
    3. Activity 2 Intro - Create a report using joins
    4. Activity 2 Review
  5. Reporting tips and limitations
    1. Tips for designing effective reports
  6. Activity 3
    1. Activity 3 Intro - Open challenge
    2. Activity 3 Review
  7. Advanced Analytics
    1. Advanced Analytics walkthrough
  8. Takeaways and next steps
    1. Key takeaways
    2. Rate this course
    3. Course completion checklist
course
Academy Live: Hornbill Reporting: Empower your insights – Part 2
Academy Live: Hornbill Reporting: Empower your insights – Part 2
Course Progress
Not started
Enroll

About the Course

~120 mins

The recording of this session is from 5/6/2024.


This course contains an edited video of the session and the session handout including activity instructions.


In this follow-on session on reporting, you will build on the topics learnt in our Hornbill Reporting Part 1 training and delve into sophisticated reporting techniques within Hornbill, with a focus on harnessing the power of Entities and SQL for data retrieval and analysis. 


You will explore how to utilize joint tables reporting to extract valuable insights from their data and create customized reports tailored to specific business needs to help strengthen your reporting metrics.


Please note, this session is for those who attend session one (or work through the on-demand version that will be published shortly after it takes place), or for anyone who is comfortable with Hornbill's reporting tools and wants to learn some tips and tricks using some examples and Advanced Analytics tools.


Learning Objectives: 


    - Strengthen your understanding of advanced reporting options available in Hornbill, including entities, filtering techniques, and advanced analytics. 


     - Provide hands-on activities in SQL usage  to extract and manipulate data for reporting requirements. 


    - Explore the limitations, considerations, and best practices associated with designing reports in Hornbill. 

Course Outline
  1. Reporting - Advanced session
    1. Overview
    2. Session handout
  2. Introduction and recap
    1. Introduction
    2. Recap on reporting basics
    3. Entities recap
  3. Using entities or SQL for reporting
    1. Entities and SQL for reporting
    2. Entities vs SQL
    3. How the SQL Schema designer simplifies reporting.mp4
    4. Entity viewer and database schema viewer
    5. Demo - Configure a report using SQL schema designer
  4. Activities 1 and 2
    1. Activity 1 Intro - Create a report using SQL schema designer
    2. Activity 1 Review
    3. Activity 2 Intro - Create a report using joins
    4. Activity 2 Review
  5. Reporting tips and limitations
    1. Tips for designing effective reports
  6. Activity 3
    1. Activity 3 Intro - Open challenge
    2. Activity 3 Review
  7. Advanced Analytics
    1. Advanced Analytics walkthrough
  8. Takeaways and next steps
    1. Key takeaways
    2. Rate this course
    3. Course completion checklist

Course Topics

Find relevant courses based on these topics