Description
- Course Overview
- Understanding Real-world Data
- Session 1: Identifying Basic Concepts of Data Schemas
- Identify Relational and Non-Relational Databases
- Understand the Way We Use Tables, Primary Keys, and Normalization
- Session 2: Understanding Different Data Systems
- Describe Types of Data Processing and Storage Systems
- Explain How Data Changes
- Session 3: Understanding Types and Characteristics of Data
- Understand Types of Data.
- Break Down the Field Data Types
- Session 4: Comparing and Contrasting Different Data Structures, Formats, and Markup Languages
- Differentiate between Structured Data and Unstructured Data
- Recognize Different File Formats
- Understand the Different Code Languages Used for Data
- Session 5: Explaining Data Integration and Collection Methods
- Understand the Processes of Extracting, Transforming, and Loading Data
- Explain API/Web Scraping and Other Collection Methods
- Collect and Use Public and Publicly Available Data
- Use and Collect Survey Data
- Session 6: Identifying Common Reasons for Cleansing and Profiling Data
- Learn to Profile Data
- Address Redundant, Duplicated, and Unnecessary Data
- Work with Missing Values
- Address Invalid Data
- Convert Data to Meet Specifications
- Session 7: Executing Different Data Manipulation Techniques
- Manipulate Field Data and Create Variables
- Transpose and Append Data
- Query Data
- Session 8: Explaining Common Techniques for Data Manipulation and Optimization
- Use Functions to Manipulate Data
- Use Common Techniques for Query Optimization
- Session 9: Applying Descriptive Statistical Methods
- Use Measures of Central Tendency
- Use Measures of Dispersion
- Use Frequency and Percentages
- Session 10: Describing Key Analysis Techniques
- Get Started with Analysis
- Recognize Types of Analysis
Every topic will be done with real world use cases, using many examples that allow you to see how the real work is in a role related to data management. Understanding Data Analysis you will be able to work as a Business Data Analyst, Data Analyst, Report Developer, and more.
Price: $1249.00
Offer for Enrollments this Month: $929
Duration: 20 hours
Available Schedules:
- To be determined.