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.