This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Data Analysis | SQL,Tableau,Power BI & Excel | Real Projects
4-in-1 bundle: Practical learning of the essential tools used in Data Science with hands on examples and projects
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.
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:
-
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.
-
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.
-
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.
-
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.
Excel with Netflix Dataset
-
3
Downloading MySQL Workbench -
4
Download MySQL Workbench and Classic Models Database - Windows -
5
Download MySQL Workbench and Classic Models Database - MacOS
-
6
What is SQL & a Relational Database
This lecture will help you understand what SQL and a Relational Database is, and you can download the entity Relationship Diagram for the Classic Models database.
-
7
A note on the SQL section
-
8
Select, From & Where Statement
-
9
Select Statement Q & A
-
10
Upper & Lower
-
11
In & Not In
-
12
Show all columns for customers who are from New York, London or Mumbai using IN -
13
Distinct, Like & Order By
-
14
Examples of Distinct and Like
-
15
Inner Join
-
16
Left & Right Join
-
17
Example and Use Case of Joins
-
18
Joins Q & A
-
19
Show all customers and their orders, even if they made no orders. Both tables have a cust_code field
-
20
Union & Union All
-
21
Show all Employees and Customers
-
22
Joins and Union
-
23
Sum, Round, Group by & Having
-
24
Show the sum of all orders on each day
-
25
Count, Max, Min, Avg
-
26
Count how many distinct customers there were on each day
-
27
Aggregate Functions Q & A
-
28
Subquery
-
29
Common Table Expression (CTE)
-
30
Case statement
-
31
Create a Flag using Case Statement
-
32
Examples of Case Statement
-
33
Quiz - Case Statement, Sub Query and CTE
-
34
Row Number
-
35
Lead & Lag
-
36
Row_Number and Lead/Lag
-
37
Row Number Q & A
-
38
Date Functions
-
39
String Functions
-
40
Date and String Functions
Power BI Dashboard: Netflix - Windows Users only
-
41
Download Excel and Netflix Dataset
-
42
Common Excel Shortcuts
-
43
Split Text to Columns - Part 1
-
44
Split Text to Columns - Part 2
-
45
Trim & Separate Data
-
46
Sort & Filter Data
-
47
Common Calculations - Sum, Avg, Max, Min
-
48
If Function
-
49
Sumifs & Countifs
-
50
Unique, Left, Right
-
51
Vlookup
-
52
Pivot Tables
-
53
Excel - Exercises and Answers
-
54
Separate Sheets and Find & Replace Blanks
-
55
Import Netflix Data to MySQL Workbench
-
56
Set Up Relational Tables for Power BI
Classic Models Data Analysis Exercises
Power BI Dashboard: Classic Models - Windows Users only
-
64
About this Section
-
65
Sales Overview by Product
-
66
Sales Overview by Country
-
67
Products Purchased Together
-
68
Customers' Sales Value by Credit Limit
-
69
Sales Value Change from Previous Order
-
70
Office Sales by Customer Country
-
71
Customers Affected by Late Shipping
-
72
Advanced Exercise - Customers who go over Credit Limit Part 1
-
73
Advanced Exercise - Customers who go over Credit Limit Part 2
Electric Vehicle Dashboard with Tableau
-
74
Create View in My SQL Workbench for Power BI
-
75
Connect Power BI to Data Source & Prepare Canvas
-
76
Create Overview Cards
-
77
Create Overview Line Charts
-
78
Set up Measures for Sales & Net Profit Buttons
-
79
Add Actions to Buttons and Create Bar Chart
-
80
Create Scatter, Column & Donut Charts
-
81
Add Conditional titles to Charts
-
82
Create Decomposition Tree
-
83
Create Sales Overview Table with MoM % and YTD Calculations
-
84
Add Filters and Page Navigation Buttons
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Related Courses
IT & Software
IT & Software