Skip to main content

Dashboards and Drill-Down Analytics


Development Academy of the Philippines

Course Overview

According to the Asia-Pacific Economic Cooperation (APEC) framework, operational analytics is one of the key competencies required of a data professional, whether one is a data scientist, a data engineer, a data steward, or a functional analyst or manager. This competency is the use of an integrated set reporting, analytical, and business techniques for the investigation of all relevant data to derive insight for and optimally execute decision making.

What You Will Learn

In this course, you will be equipped with fundamental skills and best practices to generate reports, dashboards, and insights that:

  • highlight risks and opportunities within departments, businesses, or organizations;
  • enable end-users to see possible causes of movements / trends in key performance indicators (KPIs); and
  • save a significant amount of time with automated and interactive features.

Requirements

You will need a computer or laptop with Microsoft Excel installed. Computer or laptop requirements are:

  • For Windows: Core i3 or better, 4GB RAM or better, MS Excel 2007 or better
  • For MacBook: ideally MS Excel 2013 or newer should be installed (some functions require this version on the Mac). If the version of MS Excel is 2011, download and install StatPlus.

Course Instructor

Course Staff Image #1

Frances Claire Tayco

Subject Matter Expert

Course Content

Week 1

11 Videos | 3 Activities

11 Videos

  • Welcome to the course!
  • What is analytics?
  • Types of Analytics
  • Analytics Implementation Process
  • Data Analytics Scenarios
  • What is a metric?
  • What are the Key Performance Indicators?
  • KPI Measurement
  • Balanced Scorecard
  • Strategy Map
  • Summary

3 Activities

  • Peer-Graded Assignment: Data and Analytics Scenarios
  • Peer-Graded Assignment: Developing Strategic Objectives
  • Peer-Graded Assignment: Balanced Scorecard Development

Week 2

9 Videos | 2 Activities

9 Videos

  • Overview of Descriptive Statistics
  • Data Preparation
  • Data Aggregation
  • Common Visualization Types
  • Comparison and Composition
  • Distribution and Relationship
  • Demonstration: Data Visualization
  • Data Visualization Best Practice
  • Summary

2 Activities

  • Quiz
  • Peer Graded Assignment: Data Visualization

Week 3

7 Videos | 1 Activity

7 Videos

  • What are dashboards?
  • Dashboard Principles
  • Data Storytelling
  • Dashboard Design and Layout
  • Dashboard Creation Process
  • Demonstration: Dashboard Creation
  • Summary

1 Activity

  • Learning Activity: Design Wireframe

Week 4

5 Videos | 1 Activity

5 Videos

  • Drill-Down Analytics
  • Demonstration: Hardware Sales Drill-Down
  • Demonstration: Bakery Sales Drill-Down
  • Demonstration: Subscription Rate Drill-Down
  • Summary

1 Activity

  • Peer Graded Assignment: Drill-Down Analysis

Week 5

2 Videos | 1 Activity

2 Videos

  • Capstone Instructions
  • Key Takeaways

1 Activity

  • Capstone Project
Enroll