ONLINE WORKSHOP - INTERACTIVE VISUAL DASHBOARD REPORTING AND ANALYSIS

ONLINE WORKSHOP - INTERACTIVE VISUAL DASHBOARD REPORTING AND ANALYSIS

0.0
Be the first to write a review
ONLINE WORKSHOP - INTERACTIVE VISUAL DASHBOARD REPORTING AND ANALYSIS
ONLINE WORKSHOP - INTERACTIVE VISUAL DASHBOARD REPORTING AND ANALYSIS
0.0
Be the first to write a review

ONLINE WORKSHOP - INTERACTIVE VISUAL DASHBOARD REPORTING AND ANALYSIS

About

SBL KHAS- REGISTERED ONLINE WORKSHOP

Session Timing : 9:00am to 5:00pm

Duration : 2 days ( 27-28 Jan 2022 )

Course Description

Data Visualisation is increasingly becoming an essential need in enhancing business decisions. This course brings users to the forefront on the technology of data visual display to enhance reporting, analysis and performance management. With visual analytics, users can spot business issues and problems needing attention at a glance and take action on a timely manner. Microsoft Excel is an ideal tool in putting all these data together, making meaning out of it and displaying the analysis easily in an interactive dashboard form.

 

Who Should Attend

This course is relevant to data analysts, managers in Sales, Human Resources, Finance who need to analyse, design and present meaningful dashboards.

 

Course Pre-requisites

Participants are required to have the knowledge of Excel Functions prior to attending this course.

 

Training Platform:

  • Microsoft Teams

 

Software Requirement:

  • Microsoft Excel 2010 / 2013 / 2016

 

Hardware Requirement:

  • Laptop / computer with operating system Windows 8.1 and above

  • Speaker

  • Microphone

  • Camera (if any)

 

E-course manual  and  e-course certificate of attendance will be given to all participants.

 

Course Outline

Lesson 1: What is Visual Reporting

  • Outlining the steps of creating reports

  • Identifying what to do and what to avoid in creating reports

 

Lesson 2: Identifying the Right Charts in Visual Reporting

  • Excel Charts as the key element in visual reporting

  • Identifying the different charts:-Thermo-meter charts, Tornado Charts, Indexed Charts, Funnel Charts, Sparklines and Interactive Chartings

 

Lesson 3: Form Controls

  • Leveraging Form Control, an interactivity tool in creating interactive, user friendly and powerful reports.

  • Uncovering the `big mystery’ of Form Controls.

  • Exploring and mastering the usage of the 5 important Form Controls.

 

Lesson 4: Conditional Formatting

  • Extending the functional capabilities of Conditional Formatting in creating Visual Reporting.

  • Leveraging on the 5 conditional formatting `tips and tricks’ in transforming your reports into impressive visual reports.

 

Lesson 5: Applying Functions in Visual Reporting

  • Applying the relevant functions in Visual Reporting.

  • Leveraging the creative combination/fusion of Excel Functions and Form Controls in creating a visual report.

 

Lesson 6: Evaluating Case Studies

  • With the practical approach in using both the KPI (Key Performance Indicators) and Sales Interactive Visual Reports (SIVR) case studies throughout the class, users evaluate and learn the applicability of Visual Reporting at their own environment.

 

 

For  Enquiries and Enrolment details, kindly  email  kim@empowering38.com

 

 

Hours

Open Now
Sunday: Closed
Monday: Closed
Tuesday: Closed
Wednesday: Closed
Thursday: 9:00 am - 12:00 am
Friday: 12:00 am - 5:00 pm
Saturday: Closed