Enrolment

Author

Rich Lanza, CPA, CFE, CGMA

Overview

Learn about the internal and external Big Data sources which you can easily access now. Utilising Microsoft Excel, you will be able to transform that data into insight about your business, market conditions, business partners and competitors.

Focusing on practical application, you will learn to obtain, import and analyse data from a variety of free, internal and external sources.

Topic discussed

• Internal sources of Big Data
• External sources of Big Data
• Excel as a tool for Big Data analysis
• Structured accounting data analysis
• Unstructured textual analysis

Learning Objectives

• Appreciate the data already available within your organisation to serve as internal Big Data sources.
• Access varied volumes of external data sources to better understand your business, markets, and partners including company watch lists (i.e. CIA World Leaders List, OFAC Data, etc.), financial statement industry statistics, social media, and more.
• Quickly use Excel techniques to understand these data sets from a who, what, when, and where perspective using summary and other statistical analysis.
• Apply structured accounting data analysis and unstructured textual analysis