Representing, Processing, and Preparing Data

سرفصل های دوره

This course covers the different data processing tools - including spreadsheets, Python, and relational databases - and deals with data quality issues and visualizing data for insight generation.

1. Course Overview

1. Course Overview

2. Understanding Data Cleaning and Preparation Techniques

1. Version Check

2. Module Overview

3. Prerequisites and Course Outline

4. Finding and Connecting Dots - Data Collection and Analysis

5. Dealing with Missing Values - Deletion and Imputation

6. Identifying and Coping with Outliers

7. Summary

3. Preparing Data for Analysis Using Spreadsheets and Python

1. Module Overview

2. Excel - Working with Duplicates and Missing Values

3. Excel - Identifying and Eliminating Outliers Using Z-scores

4. Excel - Clamping Outliers

5. Python - Filling Missing Values

6. Python - Working with Missing Values on Real World Data

7. Python - Identifying and Removing Outliers

8. Python - Training an ML Classifier Using the Cleaned Dataset

9. Summary

4. Collecting Data to Extract Insights

1. Module Overview

2. Standardization

3. Normalization

4. Binning

5. Transactional and Analytical Processing

6. Vertical and Horizontal Scaling

7. Batch and Streaming Data

8. Event Time, Ingestion Time, and Processing Time

9. Summary

5. Loading and Processing Data Using Relational Databases

1. Module Overview

2. Creating an Azure SQL Database

3. SQL Server Management Studio

4. Loading and Querying CSV Data

5. Uploading Data to Blob Storage and Creating a Data Factory

6. Load Data Using Azure Data Factory

7. Summary

6. Representing Insights Obtained from Data

01. Module Overview

02. Continuous and Categorical Data

03. Numeric Representations of Text Data

04. Representing Image Data as Matrices

05. Azure Data Products

06. Installing and Working with Azure Data Studio

07. Visualizing Insights Using Azure Data Studio

08. Installing and Visualizing Data in Power BI

09. Creating Different Visualizations in Power BI

10. Summary and Further Study

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight