Complete Data Analysis Course For Beginners
4.2 (105 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
546 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Complete Data Analysis Course For Beginners to your Wishlist.

Add to Wishlist

Complete Data Analysis Course For Beginners

Learn the basics of data analysis, big data, database warehousing, visualizations, and more using a life like dataset
4.2 (105 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
546 students enrolled
Created by Shafiq Marediya
Last updated 7/2017
English
Current price: $10 Original price: $195 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand what data analysis is
  • Explain why data analysis exists
  • Clean, analyze, and visualize data in Excel
  • Understand the importance of databases
  • Explain why databases exist
  • Execute basic SQL commands
  • Understand how to model a database
  • Explain what the Star Schema is
  • Understand what a data warehouse is
  • Speak intelligently about big data
  • Understand what data visualization is
  • Explain how color and perception help in data visualization
  • Build charts and dashboards in Tableau
  • Construct an effective presentation
View Curriculum
Requirements
  • You should be familiar with basic MS Excel funtionality
  • You need to have MS Excel downloaded on your machine
Description

In this course, you will learn the basics of data analysis Excel, SQL, and Tableau from Learn Analytics. You will learn how to clean, analyze and visualize data in MS Excel. Then, you will learn about databases and their role in data analysis. You will finish off by learning about visualization and communication with Tableau.

At the end of this course you should have a solid understanding of the following:

  • What data analysis is
  • Why we need to analyze data
  • How clean data in excel by filtering, sorting, using VLOOKUPs and applying conditional formatting
  • How to analyze data in excel with the power of Pivot Tables
  • What databases are
  • Why databases are important, and how they work
  • How to execute basic extraction with SQL 
  • What is Big Data
  • Why Big Data Exists and how they work
  • What data warehousing is
  • Why we use data warehousing
  • What data modeling is and how to model a database
  • What data visualization is
  • Why data visualization is important and how it works

Please note this is a beginner course, so we teach the foundations of data analysis. If you already know what data analysis and how to conduct analysis this course might be too basic for you.


Who is the target audience?
  • Beginners how is interested in learning about data analysis
  • Beginners that wants to start a career as a data analyst
Students Who Viewed This Course Also Viewed
Curriculum For This Course
82 Lectures
02:41:23
+
Excels Basics With Excel
6 Lectures 20:53



How Does Excel Work?
00:24

Workshop: Excel Formatting Cells
05:14

Workshop: Excel Formatting and Functions
12:26
+
Data Cleaning In Excel
6 Lectures 14:54
Introduction To Data Cleaning
00:15

What Is Data Cleaning?
00:24

Why Clean Data?
00:22

How To Clean Data?
00:47

Workshop: Excel Duplicate Values
05:48

Workshop: VLOOKUPS
07:18
+
Analyzing Data In Excel
6 Lectures 13:11
Introduction To Analyzing Data In Excel
00:34

What Is Data Analytics?
01:50

Why Do We Analyze Data?
01:40

How To Analyze Data With Excel?
00:23

Workshop: Excel Pivot Tables
05:06

Workshop: Visualizing Data In Excel
03:38
+
Databases
5 Lectures 14:24
Database Overview
05:27

What Are Databases?
01:10

Why Use Databases?
00:49

Workshop: Download PostgreSQL
00:54

Workshop: Creating Databases With PGAdmin
06:04
+
SQL
9 Lectures 10:20
Introduction To SQL
00:16

What Is SQL?
00:57

Why Use SQL?
00:24

Basic SQL Commands
01:39

How SQL Works
00:37

Workshop: Basic SELECT statement
01:53

Workshop: Filtering Results
01:02

Workshop: Ordering Results
01:14

Workshop: Aggregation
02:18
+
Data Modeling
7 Lectures 13:25
Introduction To Data Modeling
00:16

What is Data Modeling?
00:36

Why Do You Need To Model Your Data?
00:33

Key Concept: Relationships
01:05

Key Concept: Normalization
02:06

Workshop: Creating A Data Model in PGAdmin III
04:18

Workshop: Creating Relationships in PGAdmin III
04:31
+
Data Warehousing
8 Lectures 24:19
Introduction To Data Warehousing
00:17

What Is Data Warehousing?
01:41

Why Use Data Warehousing?
01:12

How Does Data Warehousing Work?
01:46

Key Concept: ETL
01:11

Key Concept: Dimensional Modeling
01:54

Key Concept: Star Schema
01:25

Workshop: Creating A Star Schema in PGAdmin III
14:53
+
Big Data
5 Lectures 07:49
Introduction To Big Data
00:09

What Is Big Data?
01:32

Why Does Big Data Exist?
02:33

How Does Big Data Work?
01:58

Key Concept: Distributed Computing
01:37
+
Visualizing Data
8 Lectures 09:53
Introduction To Data Visualization
00:16

What Is Data Visualization?
01:36

Why Do We Visualize Data?
02:09

How Does Data Visualization Work?
00:59

Key Concept: Visual Perception
01:28

Key Concept: Color
01:26

Key Concept: Chart Types
00:48

Key Concept: Dashboards
01:11
2 More Sections
About the Instructor
Shafiq Marediya
4.3 Average rating
149 Reviews
1,306 Students
3 Courses
Instructor and Founder of Learn Analytics.io

Hi, my name is Shafiq Marediya! I am the founder of Learn Analytics, where I teach students to become professional data scientist and data analyst. Professionally, I have worked with data in industries like retail, healthcare, non-profit, finance, and technology. Over my years of studying data, I have covered topics like big data, data warehousing, data analysis with SQL, Excel, Python, and R, and visualizations with Tableau.

Many of the topics I cover in my courses are topics I learned on my own, without formal education. My courses are designed for beginners that have no prior knowledge on the topic. I clearly communicate each topic in a way that anyone can pick it up and start learning today by using the step-by-step approach I used when I was in your shoes. I am passionate about data and want to share my enthusiasm and knowledge with you! 

I hope you enjoy my courses!