Data Analysis with SQL: Mastering Data Analysis

Focused View

Kauann Henrique Oliveira

41:45

840 View

1. Introduction

1. Introduction.mp4

00:55

2. What is Data Analysis.mp4

01:28

3.1 dealership - public.zip

3. Understanding McQueen Dealership Database.mp4

01:49

4.1 dealership.zip

4. Preparing The Ground.mp4

04:55

2. Profit Analysis

1. Section Introduction.mp4

01:45

2.1 section 2 lecture 2.zip

2. Profitability By Model.mp4

02:32

3.1 section 2 lecture 3.zip

3. Profitability By Region.mp4

02:29

4.1 section 2 lecture 4.zip

4. Profit Difference Between Quarters.mp4

01:57

5.1 section 2 lecture 5.zip

5. Impact On Quarter Profit.mp4

01:52

6.1 section 2 lecture 6.zip

6. Net Margin Per Vehicle.mp4

02:16

7. Section 2 Quiz.html

3. Ranking Vehicles, Sellers and Regions

1.1 section 3 lecture 1.zip

1. Top 10 Returning Customers.mp4

02:30

2.1 section 3 lecture 2.zip

2. Top 5 Regions With Highest Number Of Vehicles Sold.mp4

02:12

3.1 section 3 lecture 3.zip

3. Top 2 Sellers Per Store Per Month.mp4

02:00

4.1 section 3 lecture 4.zip

4. Top 15 Best-Selling Vehicles Per Country.mp4

02:18

5. Section 3 Quiz.html

4. Customer and Marketing Analysis

1.1 section 4 lecture 1.zip

1. Where Are Our Customers.mp4

01:46

2.1 section 4 lecture 2.zip

2. Marketing Campaigns.mp4

02:22

3.1 section 4 lecture 3.zip

3. Customers Feedbacks.mp4

02:30

4.1 section 4 lecture 4.zip

4. Categorizing Vehicles.mp4

01:45

5. Deserved Vacations!.mp4

02:03

5. EXTRA SECTION!

1.1 SQL The Complete Guide.html

1. SQL The Complete Guide!.mp4

00:21

Description

Mastering Data Analysis with SQL, Start Your Journey as a Beginner - Learn and Apply Essential Analytical Skills!

What You'll Learn?

Implement the acquired knowledge and techniques in practical data analysis projects
Gain a comprehensive grasp of the data analyst position
Participate in a comprehensive case study using an exclusive dealership database and put your analytical skills to use
Comprehend SQL and its significance in Data Analysis
Acquire expertise in crafting complex SQL queries to retrieve, manipulate, and analyze data
Participate in coding exercises designed to prepare you for the role
Apply critical thinking and problem-solving abilities to tackle data analysis hurdles

Who is this for?

Who want to pursue a career in data analysis, business intelligence or related areas

Professionals who work with data analysis and want to increase their skills

People who want to start learn about data analysis

Technology students learning about Data Analytics

Data Analysts enthusiasts :)

What You Need to Know?

An understanding of basic SQL concepts

Curiosity and eagerness to learn new things!

More details

Description
DO YOU WANT A DATA ANALYST JOB?

During this course you will be working as a DATA ANALYST for McQueen Dealership, you will be the first data analyst in this dealership and they need your help to extract some insights, URGENT!

Job Title: Data Analyst (SQL)

Job Description:
We are looking for a highly advanced Data Analyst to join our team in multinational delivery. The ideal candidate will be responsible for extracting data from relational databases, developing detailed reports for the board, and collaborating closely with the marketing department. The professional will play a crucial role in understanding and interpreting data to meet the company's analysis needs.

Responsibilities:

Extract and analyze data from related company databases.
Develop detailed reports and key insights for the directory.
Actively collaborate with marketing team to identify opportunities and challenges.
Using SQL to perform complex queries and manipulate large sets of data.
Interpret and communicate analysis results clearly and effectively.
Assist in resolving doubts and problems related to data.

Interested? Of course I'll be your teammate, and you will not be alone during this journey! So, if you accept the job we can help the McQueen dealership using SQL and Data Analysis Methods to generate valuable reports and extract insights for them!

Check out the free preview videos for more information!
Who this course is for:
Who want to pursue a career in data analysis, business intelligence or related areas
Professionals who work with data analysis and want to increase their skills
People who want to start learn about data analysis
Technology students learning about Data Analytics
Data Analysts enthusiasts :)

User Reviews

Rating

average 0

Total votes0

Focused display

Hello, I'm Kauann Henrique de Oliveira and I have over 10 years of experience in the IT market. I'm excited to share my knowledge and help you achieve your goals.I'm a dedicated and enthusiastic professional who found his passion in data. Over the years, I have accumulated hands-on experience in software development and data engineering. My commitment is to provide engaging and practical courses that not only teach concepts, but also inspire practical application.Throughout my professional journey, I have worked in a number of companies and helped deliver projects that have generated a lot of value for them, where I have been able to apply and hone my skills. My approach is focused on providing practical and relevant knowledge that students can use immediately in the real world.What you can expect:Practical and engaging courses that tackle the area of data.Real-world examples and use cases for in-depth understanding.Ongoing support and active interaction in the course community.Why Learn With Me: I believe that learning is an ongoing journey, and my goal is to empower you to achieve your goals. Join me on a journey of discovery and professional growth. Let's learn, grow and reach new heights together!

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.