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
  • Power BI Introduction

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  Power BI demo 
  • Overview of Power BI 
  • Demonstration of Power BI 
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.