Data Analytics Workshop Agenda

General introduction to Data Analytics
Follow a case study using Excel, including the process of importing, preparing and reporting data
Power BI Introduction

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	Power BI demo	Overview of Power BI Demonstration of Power BI
4	16:30 – 17:00	QA/Wrap up