Representing, Processing, and Preparing Data

Focused View

Janani Ravi

2:44:36

22 View

1.Course Overview

01.Course Overview.mp4

01:52

2.Understanding Data Cleaning and Preparation Techniques

02.Module Overview.mp4

01:06

03.Prerequisites and Course Outline.mp4

01:29

04.Finding and Connecting Dots - Data Collection and Analysis .mp4

06:31

05.Dealing with Missing Values - Deletion and Imputation.mp4

05:29

06.Identifying and Coping with Outliers.mp4

06:48

07.Summary.mp4

01:02

3.Preparing Data for Analysis Using Spreadsheets and Python

08.Module Overview.mp4

01:05

09.Excel - Working with Duplicates and Missing Values.mp4

05:40

10.Excel - Identifying and Eliminating Outliers Using Z-scores.mp4

07:07

11.Excel - Clamping Outliers.mp4

03:27

12.Python - Filling Missing Values .mp4

05:17

13.Python - Working with Missing Values on Real World Data.mp4

06:45

14.Python - Identifying and Removing Outliers .mp4

05:58

15.Python - Training an ML Classifier Using the Cleaned Dataset.mp4

03:13

16.Summary.mp4

01:20

4.Collecting Data to Extract Insights

17.Module Overview.mp4

02:02

18.Standardization.mp4

03:25

19.Normalization.mp4

04:54

20.Binning.mp4

02:48

21.Transactional and Analytical Processing.mp4

04:29

22.Vertical and Horizontal Scaling.mp4

05:23

23.Batch and Streaming Data.mp4

03:50

24.Event Time, Ingestion Time, and Processing Time.mp4

02:36

25.Summary.mp4

01:24

5.Loading and Processing Data Using Relational Databases

26.Module Overview.mp4

03:46

27.Creating an Azure SQL Database.mp4

06:30

28.SQL Server Management Studio.mp4

04:44

29.Loading and Querying CSV Data.mp4

04:47

30.Uploading Data to Blob Storage and Creating a Data Factory.mp4

05:50

31.Load Data Using Azure Data Factory.mp4

06:48

32.Summary.mp4

01:25

6.Representing Insights Obtained from Data

33.Module Overview.mp4

01:05

34.Continuous and Categorical Data.mp4

03:29

35.Numeric Representations of Text Data.mp4

05:04

36.Representing Image Data as Matrices.mp4

03:09

37.Azure Data Products.mp4

02:29

38.Installing and Working with Azure Data Studio.mp4

04:38

39.Visualizing Insights Using Azure Data Studio.mp4

07:22

40.Installing and Visualizing Data in Power BI.mp4

04:15

41.Creating Different Visualizations in Power BI.mp4

02:47

42.Summary and Further Study.mp4

01:28

Description

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.

What You'll Learn?

Data science and data modeling are fast emerging as crucial capabilities that every enterprise and every technologist must possess these days. As the process of actually constructing models becomes democratized, the general view is shifting toward using the right data and using the data right.

In this course, Representing, Processing, and Preparing Data, you will gain the ability to correctly represent information from your domain as numeric data, and get it into a form where the full capabilities of models can be leveraged.

First, you will learn how outliers and missing data can be dealt with in a theoretically sound manner.

Next, you will discover how to use spreadsheets, programming languages and relational databases to work with your data. You will see the different types of data that you may deal with in the real world and how you can collect and integrate data to a common destination to eliminate silos.

Finally, you will round out the course by working with visualization tools that allow every member of an enterprise to work with data and extract meaningful insights.

When you are finished with this course, you will have the skills and knowledge to use the right data sources, cope with data quality issues and choose the right technologies to extract insights from your enterprise data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Janani Ravi

Instructor's Courses

Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework. After spending years working in tech in the Bay Area, New York, and Singapore at companies such as Microsoft, Google, and Flipkart, Janani finally decided to combine her love for technology with her passion for teaching. She is now the co-founder of Loonycorn, a content studio focused on providing high-quality content for technical skill development. Loonycorn is working on developing an engine (patent filed) to automate animations for presentations and educational content.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.