Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Business
Business Analytics & Intelligence
Data Analysis
Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects

Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects

Loại khoá học: Business Analytics & Intelligence

4-in-1 bundle: Practical learning of the essential tools used in Data Science with hands on examples and projects

image
50.000 VND
85 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

If you're interested in becoming a data analyst you're in the right place!

In this course, you will learn how to master the key techniques and concepts required to extract, manipulate, visualize, and analyze data effectively. Whether you're a beginner or have some experience with data analysis, this course will cater to your needs and help you gain a competitive edge in the rapidly growing field of data analytics.


Here's what you can expect to learn:


  1. SQL Fundamentals: Dive into the world of structured query language (SQL) and learn how to write powerful queries to extract and manipulate data from databases. From basic SELECT statements to advanced JOINs, subqueries and aggregate functions, you'll gain a comprehensive understanding of SQL. This section is available for Mac and Windows laptops and computers.

  2. Tableau Fundamentals: Unleash the potential of Tableau, a leading data visualization and exploration tool. Learn how to connect to data sources, create stunning visualizations using drag-and-drop techniques, and build interactive dashboards to uncover valuable insights. This section is available for Mac and Windows laptops and computers.

  3. Power BI Essentials: Explore the capabilities of Power BI, Microsoft's powerful business intelligence tool. Discover how to import, transform, and model data from various sources, create interactive visualizations, and design compelling reports and dashboards. This section is only available for Windows users.

  4. Excel for Data Analysis: Excel remains a fundamental tool for data analysis, and in this course, you'll harness its power. Explore common features used by data analysts such as formulas, pivot tables, data cleaning, and conditional formatting to efficiently analyze and present data. This section is available for Mac and Windows laptops and computers.

Why Enroll in this Course?

  • Comprehensive Approach: Gain proficiency in four essential tools used by data analysts, allowing you to tackle a wide range of data analysis tasks.

  • Hands-On Learning: Through practical exercises and real-world examples, you'll apply your knowledge to solve realistic data analysis challenges.

  • Practical Projects: Work on exciting projects that simulate real-world scenarios, enabling you to build a portfolio of practical data analysis skills.

  • Expert Instruction: Learn from experienced instructors who have extensive industry knowledge and a passion for teaching data analysis.

  • Career Advancement: Equip yourself with the skills demanded by the job market and unlock lucrative career opportunities as a data analyst or business intelligence professional.

Bạn sẽ học được gì

Learn and Understand SQL and it's role in Data Analysis.

Develop proficiency in writing complex SQL queries to extract, manipulate, and analyze data.

Develop the skills to clean, transform, and prepare data for analysis using Excel.

Learn how to effectively use Power BI to create interactive visualizations.

Apply the learned concepts and techniques to real-world data analysis projects.

Gain expertise in Tableau to create compelling data visualizations and interactive reports.

Build a solid foundation for a career in data analysis and be prepared for further learning and professional growth in the field.

Yêu cầu

  • MySQL Workbench, Excel and Tableau can be downloaded on a Windows or Mac computer/laptop for free, however Power BI will require a Windows laptop or computer.
  • No prior experience required, only curiosity and eagerness to learn - Data Analysis requires a curious mindset and a willingness to explore and experiment with data.
  • An understanding of basic mathematical concepts such as arithmetic operations, percentages and averages would be helpful.

Nội dung khoá học

9 sections

Introduction

2 lectures
Introduction
01:21
Important Introduction to Udemy and Where to Ask A Question
01:37

SQL

42 lectures
Downloading MySQL Workbench - Please Read
00:45
Download MySQL Workbench - Windows
05:38
Download MySQL Workbench - MacOS
05:30
MySQL Workbench Overview
04:11
What is SQL & Data Definition Language (DDL)
10:26
Insert Data Into a Table
06:32
Create Classic Models Schema
01:16
What is a Relational Database?
04:01
A note on the SQL section
00:22
Select, From & Where Statement
06:41
Select Statement Q & A
03:54
Upper & Lower
04:42
In & Not In
04:00
Show all columns for customers who are from New York, London or Mumbai using IN
1 question
Distinct, Like & Order By
06:04
Examples of Distinct and Like
04:25
Inner Join
06:12
Left & Right Join
04:10
Example and Use Case of Joins
04:37
Joins Q & A
07:26
Show all customers and their orders, even if they made no orders. Both tables have a cust_code field
1 question
Union & Union All
05:49
Show all Employees and Customers
1 question
Joins and Union
5 questions
Sum, Round, Group by & Having
07:13
Show the sum of all orders on each day
1 question
Count, Max, Min, Avg
06:13
Count how many distinct customers there were on each day
1 question
Aggregate Functions Q & A
04:48
Subquery
03:55
Common Table Expression (CTE)
03:04
Case statement
04:37
Create a Flag using Case Statement
04:22
Examples of Case Statement
06:50
Quiz - Case Statement, Sub Query and CTE
3 questions
Row Number
05:19
Lead & Lag
04:22
Row_Number and Lead/Lag
3 questions
Row Number Q & A
05:01
Date Functions
05:44
String Functions
06:17
Date and String Functions
4 questions

Excel with Netflix Dataset

16 lectures
Download Excel and Netflix Dataset
03:33
Common Excel Shortcuts
05:32
Split Text to Columns - Part 1
05:46
Split Text to Columns - Part 2
03:49
Trim & Separate Data
08:55
Sort & Filter Data
02:18
Common Calculations - Sum, Avg, Max, Min
02:54
If Function
06:35
Sumifs & Countifs
03:59
Unique, Left, Right
03:26
Vlookup
03:53
Pivot Tables
04:08
Excel - Exercises and Answers
09:14
Separate Sheets and Find & Replace Blanks
07:28
Import Netflix Data to MySQL Workbench
07:24
Set Up Relational Tables for Power BI
04:45

Power BI Dashboard: Netflix - Windows Users only

9 lectures
Please Read if You're Starting Course Here
00:29
Are you Having Issues Downloading a Connector to MySQL?
00:24
Download Power BI and Connect to Data
08:07
Power BI Overview
05:51
Create Area Chart
08:59
Create Shows by Rating & Top 10 Categories Charts
05:22
Create Countries Available Map and import Netflix logo
03:37
Create Single Title View Page - Part 1
06:22
Create Single Title View Page - Part 2
07:47

Classic Models Data Analysis Exercises

10 lectures
About this Section
00:19
Sales Overview by Product
18:27
Sales Overview by Country
06:18
Products Purchased Together
11:44
Customers' Sales Value by Credit Limit
13:47
Sales Value Change from Previous Order
13:53
Office Sales by Customer Country
15:29
Customers Affected by Late Shipping
03:49
Advanced Exercise - Customers who go over Credit Limit Part 1
10:39
Advanced Exercise - Customers who go over Credit Limit Part 2
12:40

Power BI Dashboard: Classic Models - Windows Users only

12 lectures
Create View in My SQL Workbench for Power BI
09:32
Connecting to Power BI Data Source
00:31
Connect Power BI to Data Source & Prepare Canvas
06:49
Create Overview Cards
06:48
Create Overview Line Charts
07:12
Set up Measures for Sales & Net Profit Buttons
09:13
Add Actions to Buttons and Create Bar Chart
07:48
Create Scatter, Column & Donut Charts
06:40
Add Conditional titles to Charts
07:52
Create Decomposition Tree
08:32
Create Sales Overview Table with MoM % and YTD Calculations
10:05
Add Filters and Page Navigation Buttons
07:16

Electric Vehicle Dashboard with Tableau

9 lectures
Download Tableau Public and Electric Vehicle Dataset
03:54
Tableau Overview
05:17
Create Bar Chart - Vehicle Year
04:43
Create Map
04:04
Top 10 Counties Column Chart
03:06
Make & Model Column Chart and Parameter
05:42
Create Donut Chart
05:21
Put Dashboard Together
10:02
Format and Publish Dashboard
10:58

Bike Sales Dashboard with Tableau

10 lectures
Connect Tableau to our dataset
02:03
Top 10 Products chart
04:38
Stacked Bar Chart showing Profit by Sub Category
04:02
Bubble Chart showing Revenue by Age Group
03:48
Map showing Profit by Country
02:49
Profit and Year on Year % Change Cards, and Year Parameter
11:35
Revenue Card and Line Chart
04:03
Product Category Cost card
03:19
Put Dashboard Together - Part One
13:25
Put Dashboard Together - Part Two
12:38

Congratulations and Thank You!

1 lectures
Congratulations and Thank You - What you can do now
01:30

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Ethical Hacking Course by Black Hat Pakistan

Ethical Hacking Course by Black Hat Pakistan

26 VND
50.000 VND
AWS Cloud for beginner (Vietnamese)

AWS Cloud for beginner (Vietnamese)

90 VND
50.000 VND
OpenStack Essentials

OpenStack Essentials

1.499.000 VND
50.000 VND
Java Certification : OCA (1Z0-808) Exam Simulation [2023]

Java Certification : OCA (1Z0-808) Exam Simulation [2023]

1.399.000 VND
50.000 VND
Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

1.049.000 VND
50.000 VND
Reverse Engineering and Malware Analysis Fundamentals

Reverse Engineering and Malware Analysis Fundamentals

1.399.000 VND
50.000 VND
Microsoft Windows Server 2016 Training for Beginners

Microsoft Windows Server 2016 Training for Beginners

1.799.000 VND
50.000 VND
Learn Autocad API with C# - MVVM - WPF

Learn Autocad API with C# - MVVM - WPF

25 VND
50.000 VND
Ultimate AWS Certified Solutions Architect Associate SAA-C03

Ultimate AWS Certified Solutions Architect Associate SAA-C03

185 VND
50.000 VND
Website Hacking / Penetration Testing

Website Hacking / Penetration Testing

95 VND
50.000 VND
10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

26 VND
50.000 VND
MongoDB : A Complete Database Administration Course

MongoDB : A Complete Database Administration Course

999.000 VND
50.000 VND
Become Zabbix Administrator For Expert

Become Zabbix Administrator For Expert

799.000 VND
50.000 VND
Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

90 VND
50.000 VND
C++ Data Structures & Algorithms + LEETCODE Exercises

C++ Data Structures & Algorithms + LEETCODE Exercises

120 VND
50.000 VND
From Wire to PLC , A Bootcamp In Industrial Automation

From Wire to PLC , A Bootcamp In Industrial Automation

2.499.000 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi