Data Analyst Portfolio Project - Intro & Setup - Power BI & SQL
In this series I am going to show you guys How to Build a Data Analyst Portfolio Project from scratch!
Todays video is an introduction to the series and how you can set up a necessary environment to create a data analyst portfolio project. You can also use the environment for your own practice purposes, but we will use it for the rest of this data analyst portfolio project series as we create each necessary element.
Click here to subscribe! https://bit.ly/3xL8Dm6
Video Content:
0:00 Welcome
0:08 Series Content
1:19 - Necessary Files
2:34 - Installing SQL Server
3:17 - SQL Server Management Studio
5:03 - Connect Databases
7:12 - Update Data
You can find the necessary files here:
SQL Server Express: https://www.microsoft.com/en-us/sql-s...
SQL Server Management Studio: https://docs.microsoft.com/en-us/sql/...
AdventureWorks DBs: https://docs.microsoft.com/en-us/sql/...
Power BI Desktop: https://powerbi.microsoft.com/en-us/d... (recommend using AppStore in Windows!)
Update SQL Data Script: https://github.com/techtalkcorner/Sam... or download already updated .bak file from here: https://www.sendspace.com/file/z2s0gv
Budget File And More: https://github.com/AnalyzeWithAli/Dat...
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 portfolio 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