CIW - Data Analyst

Curriculum

Fundamentals of Data Analysis

• Pre-assessment questions
• The importance of good data
• Centralised data benefits
• Structured vs. unstructured data
• Forgetting Steve Jobs
• Typical sources of business data
• Search Engine Optimisation (SEO)
• Business decisions in the non-profit industry

Introduction to Big Data

• Big data
• The importance of IT data management
• IT business environments
• Cloud-based data
• Cloud-native data
• In-house data
• When to migrate in-house data to the cloud
• Variations of cloud-based systems
• Typical databases used for data analysis
• Data-driven business decisions
• The internet is worthless

Working with Data Sources

• Data E-harmony: working with different departments to bring data together
• The purpose of Customer Relationship Management (CRM)
• CRM integration: a banking scenario
• Obtaining data from email and user forums
• Obtaining data from other knowledge bases
• Obtaining data from CRM and business-to-business frameworks
• Transaction, payment and inventory data
• Using multiple data sources
• InStyle publishing

Tools for Capturing and Analysing Data

• Capturing data: Tableau Public
• Capturing data: Google Fusion Tables
• Capturing data: OpenRefine
• Overview: Hadoop-based environments
• Capturing and analysing data in Hadoop
• The R Project
• Additional software for data capture
• Playing with big data
• Analysing and reporting data network traffic
• Organisational efforts and business outcomes
• Best methods to capture and report-specific data
• Data analysis and reporting dashboards
• Create reports and charts
• Create a presentation for reporting data
• Frequently asked questions for presentations
• Better business through data