Data Analyst Portfolio Project - Clean Data - Power BI & SQL
Welcome to the third video in my series on How to Build a Data Analyst Portfolio Project from scratch!
In todays video I focus on data cleaning and transformation of tables that we need for dashboard and reports which is part of the data analyst portfolio project. The purpose is just to show you some different types of cleansing and transformations I think are good to showcase and include in a data analyst portfolio project.
Click here to subscribe! https://bit.ly/3xL8Dm6
Video Content:
0:00 Welcome
0:29 - Fact Table vs Dimension Table
2:29 - Identify necessary tables
5:11 - Data Cleansing & Transformation
23:21 - Wrap Up & Ending
Some of the following tings are exemplified:
AS Statement (Renaming Columns)
Combining columns
Commenting in SQL Script
Formatting of SQL statements
WHERE Clause
ORDER BY
LEFT JOIN
Case() Function
IsNull() Funtion
You can find all the T-SQL statements below and the exported data that was created based on the SQL statements. This is the data we will use to create dashboards and reports for the data analyst project.
Budget File And More: https://github.com/AnalyzeWithAli/Dat...
If you want to learn more about FACT and DIMENSION I can recommend this video here:
• What is Dimension and Fact in Data Wa...
The formatter which I used in the video for the SQL statements can be found here:
https://codebeautify.org/sqlformatter
A data analyst portfolio project can be a great supplements to a resume when you apply for a job. The resume lists up which skills you have, but the data analyst project can showcase it and be something you can use to your advantage as you are trying to get a job.
Entire series:
#1 - Intro & Setup: • Data Analyst Portfolio Project - Intr...
#2 - Business Request & Planning: • Data Analyst Portfolio Project - Busi...
#3 - Data Clean & Transformation: • Data Analyst Portfolio Project - Clea...
#4 - Create Dashboard: • Data Analyst Portfolio Project - Crea...
#5 - Putting Portfolio Together: • Data Analyst Portfolio Project - Asse...
#6 - Final Result & Portfolio Summary: • Data Analyst Portfolio Project - Fina...
// Ali
________________________
Let’s stay in touch:
📸 Instagram – @iamaliahmadd
🔗 LinkedIn – / aliahmad1987
#DataAnalyst #DataAnalytics #DataAnalysis #Data #Analysis #AliAhmad #PowerBI