Overview

1010data gives its users the ability to manipulate and analyze large amounts of data using a familiar spreadsheet interface. It is for that very reason that the 1010data GUI is known as the Trillion Row Spreadsheet. Many of our users also like to use Microsoft Excel for its widely-known functionality and its ability to create user-interactive dashboards. Because of that, we’ve made it very easy to create dashboards in Excel that can leverage the power and speed of data analysis using the 1010data engine. In fact, it is fairly simple to incorporate user-specified parameters in a query that is run on 1010data and have the results displayed directly in an Excel dashboard with charts and conditional formatting.

Let's say we want to build a dashboard in Excel that displays the results of two 1010data queries. One simply aggregates total sales for a specified department and date range, while the other aggregates total sales by date for the same department. We want to give the user the ability to specify the start and end dates for the date range and to select the department for which they want to see total sales figures. In addition, we want to give the user the choice to aggregate either by group description or by brand. Finally, we want to see visualizations of the results in the dashboard using Excel's charting capabilities.

When we're finished with this tutorial, we want our dashboard to look something like the following:

Though this may look a little complex, it is created via a number of simple steps that this tutorial will guide you through:

Let's build the dashboard one step at a time.

We'll use the 1010data Excel Add-in to run a 1010data query from Excel and download the results directly into an Excel worksheet. Let's start with a 1010data query.