Dashboards and Drill-Down Analytics
Development Academy of the Philippines
Enrollment is Closed
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.
Note to SPARTA scholars: Upon enrollment, you will have 6 months to finish a SPARTA course. Failure to complete the course in 6 months and/or inactivity for 3 months will result in course access revocation.
Course Instructor
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