Lessons 1: Fundamentals of Data Analysis

• The Importance of Quality Source Data
• Data Structure Types
• Centralised Data Benefits
• Structured Vs. Unstructured Data
• Types of Data
• Typical Sources of Business Data
• Data Protection Policies
• Search Engine Optimisation
• Data Life Cycle Management (DLM)
• Data Analysis Process
• Lesson Summary

Lessons 2: 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
• Impact of Data Errors
• Importance of Organisational Strategy and Data Quality in Data Analytics
• Data Modelling
• Importance of Data Maintenance and Data Backup

Lessons 3: 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

Lessons 4: Tools for Capturing and Analysing Data

• Data Analytics Tools
• Capturing Data: Tableau Public
• Capturing Data: Google BigQuery
• Capturing Data: OpenRefine
• Overview: Hadoop-Based Environments
• Capturing and Analysing Data in Hadoop
• The R Project
• Additional Software for Data Capture

Lessons 5: Analysing and Reporting Data

• Network Traffic
• Data Integration
• Why Testing is Important?
• Statistical Computing and Programming
• 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

Appendix A: Data Analyst Objectives and Locations

Appendix B: Works Consulted

Fundamentals of Data Analysis

• Learning the Data Analysis Lingo
• Learning Structured and Unstructured Data in the Real World
• Analysing the Metadata and Understanding Search Engine Optimisation
• Using the AdSense and AdWords Services

Introduction to Big Data

• Analysing and Utilizing Big Data
• Adapting to Changing Data Requirements
• Comparing Relational Database Management Systems
• Analysing DDDM and Data for Blanket Technology

Working with Data Sources

• Calculating the Churn Rate
• Analysing Customer Relationship Management
• Calculating Consumer Lifetime Value in Banking
• Understanding the RFM Analysis for Customer Segmentation

Tools for Capturing and Analysing Data

• Creating a Stacked Bar Chart
• Using RStudio

Analysing and Reporting Data

• Creating a Gantt Chart
• Comparing Prezi and PowerPoint Presentations
• Creating a PowerPoint Presentation