Data Analyst Project - Cleaning Data with SQL for Insights | Power BI, SQL & Python

In this episode, we’re continuing our data analyst portfolio project by extracting and cleaning marketing data with SQL. This step in our data analyst project involves walking through various SQL transformations applied to each dataset table, preparing our data for visualization in Power BI.

We'll detail each SQL query, breaking down the transformations and explaining their purpose to ensure you have a clear understanding of each step. These skills are essential for any data analyst looking to build a comprehensive data analyst portfolio.

If you missed our introductory episode where we set up the project and explored the business case, I highly recommend watching it first—the link is in the description below. This will give you the foundational knowledge needed to follow along with this data analyst project.

Now, let's dive into the SQL details and start cleaning our marketing data!

Timestamps:
00:00 - Intro
00:46 - Product Table
07:00 - Customer Table
13:55 - Customer Review Table
16:28 - Engagement Table
19:05 - Customer Journey Table
29:24 - Next Episode

Resources and Downloads:

Series Overview:
Data Analyst Project - Solving a Business Problem - Power BI, SQL & Python

📩 Let’s stay in touch:

[aliahmad]

If there are corrections, additional instructions or updates then those will be listed below.

15.08.2024 - Backup file updated with a non-empty version. Name in GitHub is "Episode 2 -

Thanks for watching and keep up the good work 🤩

[omarisawesome]

Thank you. I want more tutorials like this ❤

[alenkadric]

Hey Ali greetings! Im very thankfull to you for creating this project for us future Analysts. But I have one problem, the bak database file that you created is on I belive 2022 SQL SERVER version, and my computer has a problem, so I can only install a 2014 SQL server version on my PC. Is there any possibility that you can downgrade the BAK file so that I'm able to restore it to my server, and complete this beautiful projects afterwards.💯💯🙌

[xtog]

hey Ali, thanks for your tutorial. Do we need to check all tables for duplicate rows like customer_journey table?

[sevalbzkrtt]

Thank you, I appreciate your effort. Can you also work on projects in the field of finance?

[peterkadar]

Hi Ali, Thank you for your great job. I executed the last customer journey query but unfortunately there are still some remaining NULL in the Duration column. For example I filtered Journey ID 1465. That is still NULL. Do you have the same on your side?

[mankiratsingh]

hey can you tell me from where you have taken the datasets for the project

[Sweetzee-vq]

hey ali, can i make this project under the topic digital marketing for my college project??

[CheySpice]

Hi Ali! Thank you again for another great project. I am coming across an issue when I am trying to restore the "Episode 2 - file in SSMS. The error reads "Restore of Database failed. It also states that "The operating system returned the error '5(Access Denied)'. Do you know why this could be?

[manelhnid]

Hello ali 😍 wish u reply soon 🤩 im new in sql and i didnt understand alors 🥲 do we need to write all of that or it is already written and thé data base is aleeady ready and ur only explaining im lost 😅 also i tried too many thi g but didnt know where to find thèse Line or Even where to write it 😂