Data Analytics Workshop Agenda

Purpose

  • General introduction to Data Analytics
  • Follow a case study using Excel, including the process of importing, preparing and reporting data
  • Practice entire process from start to finish on fresh data

Agenda

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

Contact us

3 Appleton Court, Calder Park
Wakefield, WF2 7AR

+44 (0) 1924 254 101

enquiries@dataconsulting.co.uk

Mailing List

Subscribe to our newsletter.