Data Analyst Portfolio Project #1 | Build a Database | Develop SQL | Create a Dashboard
I am going to use Excel, Microsoft SQL Server Management Studio, and Power BI to follow a data analyst portfolio project.
These questions and step-by-step screenshots were stored in Notion as temporary signed file URLs. They should be downloaded and rehosted as stable website images before publishing them as permanent visual assets.
I am going to use Excel, Microsoft SQL Server Management Studio, and Power BI.
This connects with End-to-End SQL to Dashboard as another portfolio-building note.
The tutorial video:
<video src="https://www.youtube.com/watch?v=S2zBHmkRbhY"></video>
The documentation instruction: YouTube redirect
The dataset: YouTube redirect
Continue reading
Related posts
29 May 2026 / 5 min read
Build Your Own X: Learning by Rebuilding the Tools We Use
A personal reflection on the Build Your Own X repository, why rebuilding real technologies from scratch is such a powerful way to learn programming, AI, systems, and web engineering.
- Programming
- Learning
- Open Source
24 May 2026 / 28 min read
Anna: How I Built My Personal AI Chatbot
A deep technical case study on Anna, my personal AI chatbot for Max Hoang Journal, including the motivation, UX, RAG pipeline, markdown brain, memory layers, admin workflow, safety rules, and lessons learned.
- AI
- Chatbot
- RAG
22 May 2026 / 13 min read
Common NLP Questions and Answers
A study note answering common NLP questions about ABSA, tokenisation, Naive Bayes, vector semantics, logistic regression, RAG, fine-tuning, hallucinations, and ethics.
- NLP
- Machine Learning
- Text Classification