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

Focused View

Graeme Gordon

7:57:57

128 View

1. Introduction

1. Introduction.mp4

01:08

2. SQL

1.1 Script for Classic Models.txt

1. Download MySQL Workbench and Classic Models Database - Windows.mp4

05:04

2.1 Script for Classic Models.txt

2. Download MySQL Workbench and Classic Models Database - MacOS.mp4

06:29

3.1 MySQL-Sample-Database-Diagram-PDF-A4.pdf

3. What is SQL And a Relational Database.mp4

04:37

4.1 Select, From, Where.pdf

4. Select, From And Where Statement.mp4

06:41

5.1 Select Statement Exercise.pdf

5. Select Statement Q And A.mp4

03:54

6.1 Upper And Lower.pdf

6. Upper And Lower.mp4

04:42

7.1 In And Not In.pdf

7. In And Not In.mp4

04:00

8.1 Distinct, Like, Order By.pdf

8. Distinct, Like And Order By.mp4

06:04

9.1 Inner Join.pdf

9. Inner Join.mp4

06:12

10.1 Left And Right Join.pdf

10. Left And Right Join.mp4

04:10

11.1 Join Exercises.pdf

11. Joins Q And A.mp4

07:26

12.1 Union And Union All.pdf

12. Union And Union All.mp4

05:49

13.1 Sum, Round, Group by, Having.pdf

13. Sum, Round, Group by And Having.mp4

07:13

14.1 Count, Max, Min, Avg.pdf

14. Count, Max, Min, Avg.mp4

06:13

15.1 Aggregate Functions Exercise.pdf

15. Aggregate Functions Q And A.mp4

04:48

16.1 Subquery.pdf

16. Subquery.mp4

03:55

17.1 CTE.pdf

17. Common Table Expression (CTE).mp4

03:04

18.1 Case Statement.pdf

18. Case statement.mp4

04:37

19.1 Flag using Case statement.pdf

19. Create a Flag using Case Statement.mp4

04:22

20.1 Row Number.pdf

20. Row Number.mp4

05:19

21.1 Lead And Lag.pdf

21. Lead And Lag.mp4

04:22

22.1 Row Number Exercise.pdf

22. Row Number Q And A.mp4

05:01

23.1 Date Functions.pdf

23. Date Functions.mp4

05:44

24.1 String Functions.pdf

24. String Functions.mp4

06:17

3. Excel with Netflix Dataset

1.1 netflix titles.csv

1. Download Excel and Netflix Dataset.mp4

03:33

2.1 Excel shortcuts_cheat_sheet.pdf

2. Common Excel Shortcuts.mp4

05:32

3. Split Text to Columns - Part 1.mp4

05:46

4. Split Text to Columns - Part 2.mp4

03:49

5. Trim And Separate Data.mp4

08:55

6. Sort And Filter Data.mp4

02:18

7. Common Calculations - Sum, Avg, Max, Min.mp4

02:54

8. If Function.mp4

06:35

9. Sumifs And Countifs.mp4

03:59

10. Unique, Left, Right.mp4

03:26

11. Vlookup.mp4

03:53

12. Pivot Tables.mp4

04:08

13. Excel - Exercises and Answers.mp4

08:39

14. Separate Sheets and Find And Replace Blanks.mp4

07:28

15. Import Netflix Data to MySQL Workbench.mp4

07:24

16.1 Create Cast Table.docx

16.2 Create Countries Table.docx

16.3 Create Directors Table.docx

16.4 Create Listed In Table.docx

16. Set Up Relational Tables for Power BI.mp4

04:45

4. Power BI Dashboard - Netflix

1. Download Power BI and Connect to Data.mp4

05:23

2. Power BI Overview.mp4

05:51

3. Create Area Chart.mp4

08:59

4. Create Shows by Rating And Top 10 Categories Charts.mp4

05:22

5.1 logo.zip

5. Create Countries Available Map and import Netflix logo.mp4

03:37

6. Create Single Title View Page - Part 1.mp4

06:22

7. Create Single Title View Page - Part 2.mp4

07:47

5. Classic Models Data Analysis Exercises

1. Sales Overview by Product.mp4

18:27

2. Sales Overview by Country.mp4

06:18

3. Products Purchased Together.mp4

11:44

4. Customers Sales Value by Credit Limit.mp4

13:47

5. Sales Value Change from Previous Order.mp4

13:53

6. Office Sales by Customer Country.mp4

15:29

7. Customers Affected by Late Shipping.mp4

03:49

6. Power BI Dashboard - Classic Models

1. Create View in My SQL Workbench for Power BI.mp4

09:32

2. Connect Power BI to Data Source And Prepare Canvas.mp4

06:49

3. Create Overview Cards.mp4

06:48

4. Create Overview Line Charts.mp4

07:12

5. Set up Measures for Sales And Net Profit Buttons.mp4

09:13

6. Add Actions to Buttons and Create Bar Chart.mp4

07:48

7. Create Scatter, Column And Donut Charts.mp4

06:40

8. Add Conditional titles to Charts.mp4

07:52

9. Create Decomposition Tree.mp4

08:32

10. Create Sales Overview Table with MoM % and YTD Calculations.mp4

10:05

11. Add Filters and Page Navigation Buttons.mp4

07:16

7. Electric Vehicle Dashboard with Tableau

1.1 Electric Vehicle_Population_Data.xlsx

1. Download Tableau Public and Electric Vehicle Dataset.mp4

03:54

2. Tableau Overview.mp4

05:17

3. Create Bar Chart - Vehicle Year.mp4

04:43

4. Create Map.mp4

04:04

5. Top 10 Counties Column Chart.mp4

03:06

6. Make And Model Column Chart and Parameter.mp4

05:42

7. Create Donut Chart.mp4

05:21

8. Put Dashboard Together.mp4

10:02

9. Format and Publish Dashboard.mp4

10:58

Description

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

What You'll Learn?

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.

Who is this for?

Beginners: Individuals who have little to no prior experience with data analysis or the mentioned tools but are eager to learn and build a foundation in data analysis.

Aspiring Data Analysts: Individuals who want to pursue a career in data analysis and need to develop a strong understanding of SQL, Power BI, Tableau, and Excel.

Anyone interested in Data Analysis: Individuals with a general interest in data analysis and a desire to learn SQL, Power BI, Excel, and Tableau to explore and analyze data in various contexts.

What You Need to Know?

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.

More details

Description
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.
Who this course is for:
Beginners: Individuals who have little to no prior experience with data analysis or the mentioned tools but are eager to learn and build a foundation in data analysis.
Aspiring Data Analysts: Individuals who want to pursue a career in data analysis and need to develop a strong understanding of SQL, Power BI, Tableau, and Excel.
Anyone interested in Data Analysis: Individuals with a general interest in data analysis and a desire to learn SQL, Power BI, Excel, and Tableau to explore and analyze data in various contexts.

User Reviews

Rating

average 0

Total votes0

Focused display

I am a self taught Data and Insights Analyst with over 4 years experience working with data. I use SQL, Tableau and Microsoft Excel at an advanced level in my job every day and want to share my skills and teach how I would have wanted to learn these topics which can help you become a data analyst quickly. I aim to make my courses practical so you are getting real experience and getting a feel for what the job will be like. It is the best way to learn in my opinion. Please get in touch if you have any questions.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.