👨🎓 Mentoring:
Are you seeking personalized guidance to navigate the data analytics landscape? I'm here to mentor you one-on-one. My services are for to those who desire an extra edge in their career journey.
The different services are: Resume Optimization Review, Portfolio Analysis & Advice, Interview Strategy Session & Data Career Mentorship
Read more about that here: topmate.io/aliahmad
About The Video:
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! 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: github.com/AnalyzeWithAli/Dat...
If you want to learn more about FACT and DIMENSION I can recommend this video here:
• What is Dimension and ...
The formatter which I used in the video for the SQL statements can be found here:
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...
#2 - Business Request & Planning: • Data Analyst Portfolio...
#3 - Data Clean & Transformation: • Data Analyst Portfolio...
#4 - Create Dashboard: • Data Analyst Portfolio...
#5 - Putting Portfolio Together: • Data Analyst Portfolio...
#6 - Final Result & Portfolio Summary: • Data Analyst Portfolio...
// Ali
________________________
Let’s stay in touch:
📸 Instagram - @iamaliahmadd
🔗 LinkedIn - / aliahmad1987
#DataAnalyst #DataAnalytics #DataAnalysis #Data #Analysis #AliAhmad #PowerBI
Негізгі бет Ғылым және технология Data Analyst Portfolio Project - Clean Data - Power BI & SQL
Пікірлер: 201