DATA ANALYSIS & DASHBOARD REPORTING – ALMOST RUNNING

Covering dashboard reporting, balanced scorecards, visual design, we will also discuss the new charting and analysis features of Ms Excel

Bandung | 24 – 27 September 2019 | Rp 8.500.000 – ALMOST RUNNING
Bandung | 30 September – 03 Oktober 2019 | Rp 8.500.000/ peserta
Bandung | 19 – 22 November 2019 | Rp 8.500.000/ peserta 
Bandung | 17 – 20 Desember 2019 | Rp 8.500.000/ peserta 

 

DATA ANALYSIS TRAINING DESCRIPTION

With the huge amount of data available to us every day, a well-built and designed dashboard reports is one of the best ways to interpret and communicate large quantities of information. Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs.

Many of us struggle to make sense of all the data that is available in this information age. With such a deluge of reports and statistics which don’t mean anything or can’t be made sense of, it’s no wonder that data is often misinterpreted or not communicated at all.  Learn how to synthesise information into a logical framework, summarise it into a meaningful format, and then display the summary into easy-to-read tables and graphs.  Covering dashboard reporting, balanced scorecards, visual design of charts and tables, we will also discuss the new charting and analysis features of Excel 2013 and 2016.

This course is very hands-on and practical.  Each participant will be expected to create their own reports, charts and models utilising the tools and techniques covered during the course.

By the end of the day, participants will:

1. Understand the principles of data analysis
2. Learn to synthesise and summarise information into a logical framework.
3. Consider when to use a chart or a table
4. Know how to use visual effects to improve their reports and presentations
5. Explore how to summarise, present and communicate data clearly and concisely
6. Learn the principles of good dashboard design and presenting data graphically
7. Discover the tools to analyse data & build reports using your existing Excel tools and skills (and perhaps a few you didn’t know you had!)

 

DATA ANALYSIS TRAINING MATERIAL OUTLINE:

1. Using Excel as a Data Analysis Tool
   • Essential Excel tools & functions
   • Overview of must-know tools and functions for data analysis such as LOOKUPS, logical and aggregation functions
   • Creating a robust formula
   • Nest functions together to create succinct and robust formulas
   • Working with text
   • Using text and concatenation functions to string numbers and text together to show in a dashboard or chart.
   • Cleaning your data
   • Tools and tricks to clean data before using it to build a report or dashboard
2. Charting in Excel
   • Working with charts in Excel 2013/16
   • Overview of new charting features of Excel
   • Creating a Combo or Bubble chart
   • Show correlations by charting on different axes and chart types or bubble charts
   • Waterfall charts
   • Comparison of different methods of waterfall charts, create your own template for future use.
   • Charting with dynamic ranges
   • Explore various methods for dealing with varying data ranges in chart data sources
3. Chart and Table Design
   • Tables vs. Charts/Graphs
   • Deciding the best method for visual display
   • Visual Design
   • Design principles for effective graphic data presentation
   • Which chart?
   • Choosing the correct chart to use to display different data and messages from your findings
   • Charting dos and don’ts
   • Tips and tricks for a quicker chart build and was to making charts more robust and automated
4. Dashboard Reporting
   • What is a dashboard?
   • Purpose and benefits of Dashboards
   • Common mistakes when building a Dashboard
   • Creating a Dashboard in Excel
5. Dashboard Reporting
   • What is a dashboard?
   • History and definition of dashboard reports
   • Purpose and benefits of Dashboards
   • Why dashboards are so popular
   • Common mistakes when building a Dashboard
   • Critique of poorly built dashboards
   • Creating a Dashboard in Excel
   • Using provided data, create your own dashboard in Excel
6. Dashboard Design
   • Principles of dashboard design best practice
   • Dashboard layout, colour choice and display   principles
   • Selecting the correct chart to display data
   • Getting your message across most effectively by choosing the correct medium of display
   • Adding icons and images to dashboards
   • Quick and easy ways to add automated colour and icons to your reports
   • Effective use of colour and logos
   • Ways to make an impact with colour
   • Making dashboards dynamic
     Save time by using clever formulas which automatically update information on the dashboard

 

Practical exercise:  Using your own data, or examples provided, create a dynamic dashboard template incorporating the tools and techniques discussed during the course.

 

RECOMMENDATION FOR PARTICIPANT: Participant must bring Laptop for practice sessions

 

INSTRUCTOR :    Abdullah Fajar, S.Si.,M.Sc.

 

VENUE :  Bandung (Golden Flower, Banana Inn, Serela, Gino Feruci), Amaroossa Hotel, Noor Hotel, Grand Setiabudi Hotel, dll

 

TRAINING DURATION :   4 days

 

JADWAL TRAINING 2019

1. 24 Sep 2019-27 Sep 2019
2. 30 Sep 2019-03 Okt 2019
3. 19 Nop 2019-22 Nop 2019
4. 17 Des 2019-20 Des 2019

 

INVESTATION PRICE/PERSON :

1. Rp. 8.500.000/peserta (bayar penuh)  atau
2. Rp. 8.250.000/peserta (early bird, yang membayar 1 minggu sebelum training)  atau
3. Rp. 7.950.000/peserta (peserta bergroup yang terdiri dari 3 peserta atau lebih dari 1 perusahaan yang sama)

 

FACILITIES FOR PARTICIPANTS:

1. Modul Training
2. Flash Disk berisi materi training
3. Sertifikat
4. ATK: NoteBook dan Ballpoint
5. T-Shirt
6. Ransel
7. Foto Training
8. Ruang Training dengan fasilitas Full AC dan multimedia
9. Makan siang dan 2 kali coffeebreak
10. Instruktur yang Qualified
11. Transportasi untuk peserta dari hotel penginapan ke hotel tempat training – PP (jika peserta minimal dari satu perusahaan ada 4 peserta)

 

DATA ANALYSIS AND DASHBOARD REPORTING IN EXCEL

Formulir Permintaaan Informasi Lanjutan / Pra-Pendaftaran Public Training

1. INFORMATION OPTIONS
2. Judul Training(required)
3. Tanggal Training
4. Select a message type Registration Offering Letter (Permintaan Proposal Penawaran) Next Schedule Information (Jadwal selanjutnya) More Information (Informasi tambahan) Others (lain-lain) (required)
5. PERSONAL DATA
6. Your Name(required)
7. Job Title(required)
8. Company(required)
9. Company Address
10. Email(valid email required)
11. Mobile Phone(required)
12. Office Phone(required)
13. Extention No.
14. Facsimile (Fax)
15. Website
16. PRE REGISTRATION DATA (Tidak Mengikat)
17. Penanggung Jawab Training di Perusahaan
18. Email
19. Office Phone+Ext atau No. Handphone
20. Jumlah Peserta(required)
21. Nama-nama peserta
22. Payment Method Bank Transfers Submitting an Invoice Cheque or Cash on arrival ( If Possible)
23. MESSAGE FOR TRAINING PROVIDER
24. Pesan untuk penyelenggara Training
25. CC this registration / message to me
26. Isikan angka/huruf pada gambar

 

cforms contact form by delicious:days