#powerbi #sql #tableau #excel
Data Analyst Portfolio Project | Power BI + SQL | Beginner to Advanced |End to End

Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - https://topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - https://topmate.io/data_tutorials

Welcome to this comprehensive Data Analyst Project tutorial! In this tutorial, I will guide you through the complete process of building a data analysis project using popular tools such as Power BI, Tableau, SQL, and Excel.

Whether you are a beginner or an experienced data analyst, this tutorial will provide you with the necessary knowledge and hands-on experience to successfully complete a data analysis project. Join me on this journey and unlock the power of these essential data analysis tools.

Data Download - https://drive.google.com/drive/folders/17U0ah6Q4MJM_wIn_Xl4fHc-1fO6Q4s6z?usp=sharing

Follow me on Facebook - https://www.facebook.com/profile.php?id=100095047697882&mibextid=ZbWKwL
Follow me on LinkedIn - https://www.linkedin.com/in/swapnjeet-s-58a673273

For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.

Content
Introduction 0:00
Steps in Project 08:25
Problem Statement 13:25
Software Used 18:51
Raw Data 20:28
Import Data in SQL 23:01
SQL Queries for KPI's 30:24
SQL Queries for Daily and Monthly Trend 44:30
SQL Queries for % of Sales by Category & Size 51:33
SQL Queries for Top 5 & Bottom 5 01:03:46
Power BI Intro 01:10:28
Connecting Power BI to SQL DB 01:12:23
Data Cleaning using Power Query 01:15:57
KPI's Building 01:22:29
Data Processing in Power Bi 01:46:21
Building Daily and Monthly Trend Charts 01:49:09
Building % of Sales by Category & Size 02:05:44
Adding Insights 02:17:30
Worst and Best Sellers Dashboard 02:15:49
Add Navigator Buttons 02:42:08
Outro 02:46:04

Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-

Data Modelling - https://youtu.be/JQ9wX1d7dGE?si=RAxnrVsGOiQEwUgq

Data Cleaning - https://youtu.be/AWcmiyra7qs?si=eYkqejnXeuZOkGea

Data Analyst Portfolio Projects - https://www.youtube.com/watch?v=3Acmk-rqn6c&list=PLO9LeSU_vHCWpfLDRTT5nBz9Z0libOs5k

Power BI Projects - https://www.youtube.com/watch?v=-sOHVl_iCHA&list=PLO9LeSU_vHCWUvkE1FrGeNxSve7YtJrYl

Tableau Projects - https://www.youtube.com/watch?v=oAIubTqg-Kw&list=PLO9LeSU_vHCU_DHaLzEvsLxFdmB3Qcao_

Excel Projects - https://www.youtube.com/watch?v=xHTUP1Dxu-M&list=PLO9LeSU_vHCWWRghKgAQRg_TrgtRl5-4Y

SQL Projects - https://www.youtube.com/watch?v=4l7GgWmaTGc&list=PLO9LeSU_vHCVbT81nMD2S_YMRJ1OpnXZi

Power BI Interview Questions with Answers - https://www.youtube.com/watch?v=bBYIvOytMwo&list=PLO9LeSU_vHCUAh-OkfoKUx6PlNJHAxgCK

Tableau Interview Questions with Answers - https://www.youtube.com/watch?v=S7ArMgAdOIE&list=PLO9LeSU_vHCUvp3KfoWQULRXAghIOh8Kx
=


Tableau Material available-
1. Tableau hand written notes
2. Tableau printed notes
2. Tableau important formulae print notes
3. Tableau important interview questionnaire
All these are available at very minimal cost of Rs.200 only, ping me on WhatsApp to get these.


Reach out to me for any personal or Business related Dashboard/ Report development on my email- [email protected]
WhatsApp - +91 9579005495


Related keywords:
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst
sql project for data analyst
project for beginners
sql portfolio project
data analyst sql project
data analyst full project
data analyst resume project
sql project
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project