Data Analysis for Newbies

What will you learn from this Data Analysis Course For Beginners?

  • Complete understanding of the data analysis
  • A proper explanation on why the data analysis exists in this world
  • Cleaning, analyzing and visualization of the excel data
  • Complete knowledge about why the databases are important
  • Complete explanation about the existence of databases
  • Execution of the basic SQL commands
  • Complete understanding of the method to model a database
  • An accurate explanation on what exactly is Star Schema
  • Complete understanding of what is a data warehouse
  • Capability for increasing confidence to speak regarding the big data in an intelligent way.
  • Proper understanding of what is data visualization
  • Complete explanation on how the perception and color assists in the data visualization process
  • Developing dashboards and charts in Tableau
  • Constructing an effective and useful presentation

Course Requirements

  • The students should be familiar with the functionality of the MS Excel
  • They should have access to the MS Excel on their device

Data Analysis Course For Beginners Details

It is an exciting and wonderful course that will allow you to learn about the all the important basics in data analysis Excel, Tableau, and SQL. You will get a chance to learn about the method to analyze, clean, and visualize the data in the MS Excel. After that, we will tell you about the databases and what role it plays in data analysis. The course will end up by telling you about the communication and visualization with Tableau.

After completing this Data Analysis Course For Beginners, you will attain a wonderful understand the things mentioned below:

  • What is the exact definition of the data analysis
  • Why there is a need for analyzing data in an organization
  • How you can clean the excel data by sorting, filtering and implementing conditional formatting. You will also learn about the use of VLOOKUPs
  • Method to analyze excel data with the help of Pivot Tables
  • What are databases and how it can be used
  • What is the exact method for the execution of basic extraction by using SQL
  • What is the definition of Big Data and how it works
  • Why Big data present and how it can be utilized
  • Why is the data warehousing and how we can utilize it
  • What is the role of data modeling and how a database can be modeled
  • Why exactly is a data visualization and why it is mandatory? You will also have complete understanding about its working

Please Note: You should be aware of the fact that it is a starter course where our main purpose is to teach you about the basics of data analysis. However, if you already have complete knowledge about data analysis and how to conduct it, then this course might not suit you.

Who is the target audience for Data Analysis Course For Beginners?

  • All the starters who have a deep interest to learn about the data analysis
  • Individuals who are looking to begin their career as a data analyst

1
Introduction
2
Skills
3
Story
4
What Is Data Analysis?
5
Why Does Data Analysis Exist?
6
How Does Data Analysis Work?
7
Introduction To Excel Basics
8
What Is Excel?
9
Why Use Excel?
10
How Does Excel Work?
11
Workshop: Excel Formatting Cells
12
Workshop: Excel Formatting and Functions
13
Introduction To Data Cleaning
14
What Is Data Cleaning?
15
Why Clean Data?
16
How To Clean Data?
17
Workshop: Excel Duplicate Values
18
Workshop: VLOOKUPS
19
Introduction To Analyzing Data In Excel
20
What Is Data Analytics?
21
Why Do We Analyze Data?
22
How To Analyze Data With Excel?
23
Workshop: Excel Pivot Tables
24
Workshop: Visualizing Data In Excel
25
Database Overview
26
What Are Databases?
27
Why Use Databases?
28
Workshop: Download PostgreSQL
29
Workshop: Creating Databases With PGAdmin
30
Introduction To SQL
31
What Is SQL?
32
Why Use SQL?
33
Basic SQL Commands
34
How SQL Works
35
Workshop: Basic SELECT statement
36
Workshop: Filtering Results
37
Workshop: Ordering Results
38
Workshop: Aggregation
39
Introduction To Data Modeling
40
What is Data Modeling?
41
Why Do You Need To Model Your Data?
42
Key Concept: Relationships
43
Key Concept: Normalization
44
Workshop: Creating A Data Model in PGAdmin III
45
Workshop: Creating Relationships in PGAdmin III
46
Introduction To Data Warehousing
47
What Is Data Warehousing?
48
Why Use Data Warehousing?
49
How Does Data Warehousing Work?
50
Key Concept: ETL
51
Key Concept: Dimensional Modeling
52
Key Concept: Star Schema
53
Workshop: Creating A Star Schema in PGAdmin III
54
Introduction To Big Data
55
What Is Big Data?
56
Why Does Big Data Exist?
57
How Does Big Data Work?
58
Key Concept: Distributed Computing
59
Introduction To Data Visualization
60
What Is Data Visualization?
61
Why Do We Visualize Data?
62
How Does Data Visualization Work?
63
Key Concept: Visual Perception
64
Key Concept: Color
65
Key Concept: Chart Types
66
Key Concept: Dashboards
67
Introduction To Tableau
68
What Is Tableau?
69
Why Use Tableau?
70
How Tableau Works?
71
Workshop: Installing Tableau Desktop
72
Workshop: Connecting Data Sources
73
Workshop: Creating Charts In Tableau
74
Workshop: Calculations In Tableau
75
Workshop: Creating Dashboards In Tableau
76
Introduction To Presentations
77
What Are Presentations?
78
Why Use Presentations?
79
How To Present Findings?
80
Key Concept: Audience
81
Key Concept: Story
82
Key Concept: Slides

Be the first to add a review.

Please, login to leave a review
Enrolled: 87 students
Duration: 48 Hrs
Lectures: 82

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed