Course Content
Introduction To Data Analysis
Managing and Analyzing Data
Structure data for optimum usage
12:01Converting lists to tables
12:01
Sorting Data
Sorting concepts and sort menu options
11:04Sorting from menu icons
07:07Multiple-key sorting
05:15Sorting based on the order of data in custom lists
06:12Sorting by cell color, font color, or cell icon
04:57Sorting columns (sorting left-to-right)
02:24Sorting data in random order
02:19
Creating Automatic Subtotals In Sorted Lists
Setting up single and multiple-level subtotals
04:55Expanding and collapsing with grouping and outlining symbols
07:00
Filtering Data
Single and multiple-column filtering
05:19Using text filters
03:07Using date filters
04:00Using numeric filters
03:20Using the Top Ten (value or percent) option
04:17Creating custom filters
03:36
Advanced Filtering
Using Advanced Filter for complex OR criteria
09:10Using Advanced Filter for specialized filters
05:42Using Advanced Filter to create unique lists from repeating field data
04:15
Eliminating Duplicate Data
Using the Remove Duplicates command
03:01Using a specialized array formula to identify data that’s been duplicated
05:12Using an array formula to count the number of unique items in a list
06:36
Master SQL for Data Analysis
Exercise Files
Understanding SQL
01:06How to use the Exercise files
01:01external-assets-links
SQL Installation
Installing on Windows
06:49
SQL Overview
- 03:52
Database Organisation
02:49The SELECT Statement
05:26Selecting Rows
02:56Counting Rows
02:02Deleting Data
01:10
Fundamental Concepts
Inserting Rows
03:21The NULL Value
06:29Constraining Columns
04:38Changing A Schema
02:30ID Columns
03:17Filtering Data
07:24Removing Duplicates
03:07Ordering Output
03:01Conditional Expressions
02:29
Relationships
Understanding JOIN
02:17Accessing Related Tables
06:49Relating Multiple Tables
05:24
Strings
About SQL Strings
01:38Finding The Length Of A String
01:59Selecting Part Of A String
03:46Removing Spaces
01:32Folding Case
02:17
Numbers
Numeric Types
02:59What Type is That Value
02:15Integer Division
02:05Rounding Numbers
02:17
Date & Time
Date and Times
02:06Date and Time Related Functions
02:15
Aggregates
What are Aggregates
05:03Using Aggregate Functions
01:30Aggregating DISTINCT Values
01:41
Transactions
What are Transactions
02:01Data Integrity
04:07Performance
02:40
Triggers
Automating Data With Triggers
04:08Preventing Updates
03:44Example Timestamps
03:15
Views & Subselects
Creating a Subselect
03:19Searching Within A Result Set
02:59Creating a View
02:19Creating a Joined View
02:56
CRUD Applications
Embedding SQL
05:16The SELECT Function
05:49INSERT, UPDATE and DELETE Functions
03:41
Data Reporting and Analysis in SQL
Introduction to Data Reporting and Analysis in SQL
00:37Get familiar with phpMyAdmin
03:43Understand the demo database
01:33Retrieve data with SELECT
05:30Filter results with WHERE clause
05:04Use LIKE, IN, and wildcards with WHERE
05:39Sort SQL results with ORDER BY
01:41Use string functions on your data
06:41More advanced string functions
08:34Change report headings with alias
02:27Use date functions with WHERE
08:49
Grouping Your SQL Results
Use GROUP BY with count
05:46Filter grouped results with HAVING
04:31De-duplicate with SELECT DISTINCT
06:30Merge rows with GROUP BY
02:24
Merge Data From Multiple Tables
Make your queries faster
01:47Understand SQL Indexes and keys
07:15Visualise your database
07:59Merge data across tables with JOINS
05:02Understand SQL JOINS
04:16Combine rows with SQL UNION
04:48Merge data across tables with IN
02:10Select from a selection with subqueries
02:55
More Advanced SQL
Use variables
05:17Use functions
08:03Use procedures
06:00
Introduction to Python Programming
Introduction to Python Programming
04:11Raw Descriptions
05:00Text
02:51Exporting
03:24Overview
04:48Text 2
04:49Saving & Exporting
03:00
Data Analysis With Python
Introduction to Data Analysis with Python
01:01Working with Identifiers in Python
12:54Write Comments in python
07:09Working with strings in python
03:25Variables in Python
09:04Naming Python Variables
07:40Defining output Function
02:30Defining input Functions in Python
07:57Importing Libraries in Python
04:53
Statistical Operations In Python
Addition of Data points Python
02:13Comparing Strings and variables in Python
01:53Performing Logic in Python
07:39Performing Bitwise Manipulations of Data in Python
07:51Assigning Variables in Python
03:34Assigning Special Variables in Python
02:00Assigning Members in Python
02:52
HANDS-ON DATA ANALYSIS PRACTICE WITH PYTHON
- 00:50
Uber Loading Dataset and Preparation
21:31Uber Analysis Of Categories Of Trips
02:14Uber Analysis Of Length Of Trips
01:33Uber Analysis Of Hot Hour Of Trips
04:33Uber Analysis Of Purpose Of Trips
04:56Uber Analysis Of Day With Highest Number Of Trips
01:43Uber Analysis Of Number Of Trips Per Day
01:54Uber Analysis Of Number Of In The Month
01:36Uber Analysis Of Starting Point Of Trips
03:34
Student Ratings & Reviews
No Review Yet