Session | Time | Topic | Content |
1 | 9:30 – 10:00 | Introductions/background | · What is Data Analytics?
· Advantages? · Possible tools? |
1 | 10:00 – 11:00 | Plan, Import and Prepare | · What to consider when planning
· Import data · Common preparation tests |
Break | 11:00 – 11:15 | ||
2 | 11:15 – 12:45 | Analysis | · Incorrectly sequenced dates
· Invoices by inactive vendors · Weekend transactions · Bank holidays transactions · Duplicate invoices |
Lunch | 12:45 – 13:15 | ||
3 | 13:15 – 14:45 | Reporting | · Create overview sheet
· Statistics · Visuals · Slicers
|
Break | 14:45 – 15:00 | ||
4 | 15:00 – 16:30 | Practice | · Start with fresh data
· Plan/Import/Prepare/Analysis/Report · Consolidate earlier learning |
4 | 16:30 – 17:00 | QA/Wrap up |