Data Analysis Fundamentals

Data Analysis Fundamentals

OBJECTIVES

By the end of the course, participants will be able to:

• Identify the characteristics of data analysis solutions and the characteristics that indicate such a solution may be required
• Define types of data including structured, semistructured, and unstructured data
• Define data storage types such as data lakes, data warehouses
• Analyze the characteristics of and differences in batch and stream processing
• Analyze the characteristics of different storage systems for source data
• Analyze the characteristics of online transaction processing (OLTP) and online analytical processing (OLAP) systems and their impact on the organization of data within these systems
• Analyze the differences of row-based and columnar data storage methods
• Explore the concept of data schemas and understand how they define data and how this information is stored in metastores
• Analyze the concept of data versus information
• Recognize the ways to analyze data to produce information for reports
• Define how AWS services work together to visualize data

WHO SHOULD ATTEND?

• Data architects
• Data scientists
• Data analysts

COURSE OUTLINE

Introduction to data analysis solutions

• Data analytics and data analysis concepts
• Introduction to the challenges of data analytics

Volume – data storage

• Introduction to Amazon S3
• Introduction to data lakes
• Introduction to data storage methods

Velocity – data processing

• Introduction to data processing methods
• Introduction to batch data processing
• Introduction to stream data processing

Variety – data structure and types

• Introduction to source data storage
• Introduction to structured data stores
• Introduction to semistructured and unstructured data stores

Veracity – cleansing and transformation

• Understanding data integrity
• Understanding database consistency
• Introduction to the ETL process

Value – reporting and business intelligence

• Introduction to analyzing data
• Introduction to visualizing data

Key Takeaways

• Putting the pieces together