You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Overview

This tutorial will walk you through how to use Microsoft Excel to build a simple dashboard using CommCareHQ data exports.  By the end of the tutorial you will be able to create a dashboard that:

  1. Refreshes automatically when you download a new data export from CommCareHQ.
  2. Allows users to filter the dashboard for information relevant to them.

The final result will contain the following:

A graphical dashboard

Individual pages with data:

User definable filters:

 

 

Create the data export and download data

  1. See this page for details on creating the data export: Raw Data
  2. Be sure to rename your Display columns to how you want them to display in your reports.
    Raw Data
  3. Download your export and save it with the name: "Raw Data.xlsx".  
  4. It is important to choose a name for this file that you will remember. Every time you save a new update it will need to have the same name.
  5. Your exported data will look like this.

  

  1. Create the Report file
  2. Create a Pivot Table
  3. Create the Filters
  4. Protect the Sheets

 

  • No labels