Jump to main content
1010data makes it very easy to create dashboards in Excel that can leverage the power and speed of data analysis using the 1010data engine.
Using the 1010data Excel Add-in, we can run a query on 1010data from Excel and have the results directly downloaded into an Excel worksheet.
Our original query had date values hard-coded for the row selection. Let's add a little more flexibility by allowing the user to enter a date range using static inputs.
Let's set a result destination for our query results on the dashboard next to our input values.
You can apply basic and conditional formatting in Excel on the results that you got from running your 1010data query.
Leverage Excel's charting capabilities to visually represent the results from your query.
Let's create a drop-down to give the users of our dashboard the ability to select, from a static set of values, the column by which they want to group the results of the tabulation.
The contents of dynamic drop-downs can change based on selections in the dashboard or the results of queries.
We now want to aggregate the total sales by date for the same department and date range, and display those results in our dashboard.
We want to be able to run our queries by simply clicking a button on the dashboard.
Use more advanced charting techniques in Excel to show the details in the results returned by our 1010data queries.
You can make the Excel Add-in even more dynamic by accessing query code in libraries and blocks on 1010data.
If you are planning to share your workbook with other users, you may want to hide all q-sheets and lock the workbook to prevent accidental edits to your query code.