Module 1: Introduction 1. Course introduction Free Preview 2. Objectives Free Preview 3. Downloadable files 4. Storytelling with data 5. Data visualization Free Preview 6. Bad vs good visuals Free Preview 7. Interactive exercise 1Module 2: Context 1. Objectives 2. Know your audience 3. Tailor your message 4. The main idea 5. Storyboarding 6. Interactive exercise 2Module 3: Visuals 1. Objectives 2. Text, tables and heatmap 3. Line chart 4. Scatter plot 5. Column and bar charts 6. Combination charts 7. Tornado chart 8. Waterfall chart 9. Gauge and bullet charts 10. Interactive exercise 3 11. What not to do 12. Visual exercise 13. Visual exercise - solution and demonstrationModule 4: Focusing Attention 1. Focusing attention objectives 2. Pre-attentive attributes 3. Examples of pre-attentive attributes Free Preview 4. Color 5. Enclosure 6. Shape and positioning 7. Other attributes 8. Interactive exercise 4 9. Focusing attention exercise 10. Focusing attention exercise - solution and demonstrationModule 5: Design Principles 1. Objectives 2. Guides 3. Accessibility 4. Color Blindness 5. Aesthetics 6. Interactive exercise 5Module 6: Dashboard #1 1. Objectives 2. Downloadable files 3. Why use dashboards 4. Executive decision making 5. Dashboard making process 6. Interactive exercise 6 7. Page orientation and print area 8. Making sections 9. Two-series line chart 10. Area chart 11. Column and marker chart 12. Gauge charts - data setup 13. Gauge charts - doughnut 14. Gauge charts - pie 15. Creating multiple gauge charts 16. Dashboard #1 final product 17. QuizModule 7: Dashboard #2 1. Dashboard #2 preview 2. Downloadable files 3. Page layout and heading 4. Stacked column chart 5. Setting up for actual vs forecast 6. Combo - stacked column and line chart Free Preview 7. Waterfall chart 8. Stacked area chart 9. Five-year performance summary table 10. Sparklines 11. Conditional formatting for variance analysis 12. P&L summary and balance sheet summary 13. Dashboard #2 final productModule 8: Dashboard #3 1. Dashboard #3 preview 2. Downloadable files 3. Net earnings waterfall 4. Combo - cash flow and cash balance 5. Bullet charts preview 6. Creating bullet chart 7. Formatting bullet charts 8. Setting up data tables for bullet charts 9. Dashboard #3 final product 10. Excel vs BI Dashboard ToolsModule 9: Conclusion 1. Summary Free PreviewModule 10: Qualified Assessment 1. Qualified assessment 2. Share Your Feedback 3. Course Completion

Get flat 10% off  on CFI's all-access subscription plans

English

United States dollar

This comprehensive dashboards course will show you how to create a custom Excel dashboard by using professional data visualization techniques. You will be able to combine data, charts, graphs and other visuals in order to tell a story.

Wayan Subagia

Christopher Johnson

Muhammad Riad Hossain

Marco Pelser

Learn "Dashboards & Data Visualization" "Certification" by "Corporate Finance Institute (CFI)" and upskill your career by acquiring skills like Design Thinking etc with Careervira.

Dashboards & Data Visualization

Dashboards & Data Visualization

Description

Features

Duration

Skills

Learning Goals

Course Content

Target Audience

Instructors

Wayan Subagia

Christopher Johnson

Muhammad Riad Hossain

Marco Pelser

FAQs

Can I download the Excel files and financial modeling templates for the course?

How long do I have to complete the courses?

Are CFI courses officially accredited?

Are there any additional fees or costs?

What currency are your courses priced in?

How do I earn my certificates?

Will these courses help me advance my career?

Can I email the instructor if I have questions?

What is the price of the subscription?

What is included in the subscription?

More Questions?

₹3,018