Data Analyst Portfolio Project - Environment Setup - SQL & Power BI
In this video, I'll guide you through setting up a local practice environment on your laptop to follow along with my Data Analyst Portfolio Project series.
You will learn how to install and configure the essential tools: Power BI Desktop, SQL Server Express Edition, and SQL Server Management Studio (SSMS).
Timestamps:
00:00 - Intro
00:13 - File Overview
01:00 - Walkthrough of Installation and Setup
01:12 - SQL Server Express Edition
02:22 - SQL Server Management Studio
03:12 - AdventureWorks Database Backup File
05:17 - Power BI Desktop
05:54 - Data Analyst Portfolio Projects
Resources and Downloads:
Power BI Desktop - https://www.microsoft.com/en-us/power...
SQL Server Express Edition - https://www.microsoft.com/en-us/sql-s...
SQL Server Management Studio (SMSS) - https://learn.microsoft.com/en-us/sql...
AdventuerWorksDW2022.bak - https://learn.microsoft.com/en-us/sql...
Python (Optional) - https://www.python.org/downloads/
Although I don't cover Python installation in this video, having it set up can be useful as Python is used in some of data analyst portfolio projects.
📩 Let’s stay in touch:
Instagram – @iamaliahmadd
LinkedIn – / aliahmad1987