Making Big Data And Analytics Work For All Sizes Of Business

TIMING

Registration Course starts CoffeeCourse ends
09:00 09:30 11:00 12:30

COURSE FEE

£105+VAT. (click here for information on the Flexiticket discount scheme - fees as low as £50.83+VAT per place). The courses ‘Making Big Data and Analytics Work’, ‘Practical Excel Techniques to reduce spreadsheet risk‘, 'More Power to your Pivot' and '50 Advanced Techniques for creating inspirational spreadsheets', if booked individually are available to IT Faculty members  for £60+VAT each.

COURSE CODE

SE17A8

SPEAKER

Simon Hurst

OBJECTIVES

The term ‘Big Data’ generally refers to data sets that are too large to be interpreted by desktop software packages or utilities. Often super-computer capabilities are required to trawl through terabytes or petabytes of data and machine learning is used to recognise patterns in order to extract meaning from the data. As the Internet, apps and connected devices generate more and more data the opportunities to derive value from seemingly unrelated data resources increases. For example, the Met Office uses wind speed and direction information from millions of commercial flights to help understand weather patterns.  

Although, working directly with data sets this large and with such advanced analysis techniques, is unlikely to be part of the daily role of many accountants, understanding the capabilities of Big Data techniques can provide useful examples for extracting more value from much smaller and more accessible data sources, whether these are held within an organisation or externally. Often, combining external data with internal data can generate additional insights and improve the value and accuracy of key business predictions. The workshop will concentrate on making practical use of Big Data techniques, using generally available Microsoft tools to work with business data. The emphasis will be on extracting more information from your existing data more quickly, more automatically and presenting it with significantly increased impact. Please note this is not a ‘hands-on’ course, but will provide practical advice, demonstrated through examples and with comprehensive documentation. The Examples will be based on Excel 2016 but where an earlier version (2007 onwards) differs substantially this will be highlighted on the course.  

WHO SHOULD ATTEND?

If your use of Excel includes summarising, analysing, auditing and reporting on any form of financial data you should find this course of value. This course is suitable for the levels “General User to Developer” under the ICAEW IT Faculty Spreadsheet Competency Framework. For more information visit www.icaew.com/en/technical/information-technology/excel/spreadsheet-competencyframework. It will focus on the practical rather than deeply technical considerations. As such, it is not intended for those who already possess considerable expertise in data acquisition, manipulation and presentation.

TOPICS

  1.  What does 'Big Data' mean?
  2.  Understanding data and how to work with it
  3.  The Excel tools for working with data, Power Tools and Power BI Desktop
  4.  Presentation – how to present results for maximum impact
  5.  Case studies: from raw data and Facebook to interactive dashboard

VENUE

Coppid Beech Hotel, Binfield near Bracknell

DISTRICT

Thames Valley

Course fee
with 25 place
Flexiticket

£99.00 +VAT

Speakers

Sorry, no speakers were found.