Session Description

This session will demonstrate how to create your own dashboard using Aeries Queries and MS Excel.  We will combine beginning, intermediate and advanced query results to produce a dashboard that can be used by anyone in your district. Intended for any user that is interested in extracting actionable information from data.

Session Content

  • Use the Get Data feature in MS Excel to "automate" loading data from Aeries Query
  • Join multiple data queries & format the data using the Excel Power Query Editor
  • Analyze the data using Pivot Tables and Pivot Charts 
  • Drill down to see individual student data
  • Filter data using Slicers
  • Refresh the data in 3 easy steps!

Related Documentation

PDF documentation for this session is attached.