#sqltutorial #dataanalytics #dataanalystproject
Data analyst portfolio project for beginners and intermediates. This is useful to students learning Tableau and Power BI tools, or learning Data Analyst tools.
All the resources used in this data analyst project using SQL are free and links are shared below.

Book a 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
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

PostgreSQL download link - https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
Download data to import - https://drive.google.com/file/d/1EdtD-GtDsEaMw2vQ648rNKVMTuSG9p0n/view?usp=sharing
SQL Query File - https://docs.google.com/document/d/1IH7AGpMjIguD4ZfoDwzURd2HlkLwm2eX/edit?usp=sharing&ouid=116890999875311477003&rtpof=true&sd=true
Test Document for Tableau Reports- https://docs.google.com/document/d/1YWzBYaJQC8UPg1PC8FXAYosZTfKsseLo/edit?usp=sharing&ouid=116890999875311477003&rtpof=true&sd=true
Test Document for Power BI Reports- https://docs.google.com/document/d/1XCMlM1Mre0_00lPaFoW91qCOG2R5y0iX/edit?usp=sharing&ouid=116890999875311477003&rtpof=true&sd=true

Data Analyst Material available at very minimal cost of Rs. 999. This will include a complete Data Analyst Syllabus with video links, important pdf's, Q&A, this will also include Complete project on Excel (2 Projects), Tableau (2 Projects) and Power BI (1 Project). And the projects will be different from that uploaded on You Tube. If you are interested to buy contact me on my mail or WhatsApp.
For More info watch this Data Analyst Roadmap 2.0 video - https://youtu.be/_0i_VMeL-Zo
Details mentioned below-
email- [email protected]
WhatsApp - +91 9579005495


Do you want to become a Data Analyst or learn data analytics ? This channel is all about learning data science skills, tips and projects. My goal is to help you learn everything you need to start or switch your career into data science. I teach different Data Analyst tools like Tableau Desktop, Power BI, Excel, Advanced Excel, SQL, python, etc.

Content
00:00 Intro
01:29 Useful to
03:00 What to Test
04:01 Objective
06:23 Takeaway from video
08:17 Install PostgreSQL
13:20 Functional Validation
15:58 Create Database
18:10 Import Table
28:25 KPI Testing using SQL
53:30 Testing chart data using SQL
01:19:15 Test document


Checkout my other videos below-

Tableau Dashboard-
Road Accident Dashboard - https://youtu.be/jhv_HPjtTyU
Sales Overview Dashboard - https://youtu.be/NoppQVdd8U8
HR Dashboard - https://youtu.be/oAIubTqg-Kw
Ecommerce Sales Dashboard - https://youtu.be/pCpvlIr1yvs
IPL Dashboard - https://youtu.be/LX1LokapH4Q
Customer Complaint Dashboard - https://youtu.be/_EcRJQa3ZDM

Power BI Dashboard
Power BI Project - https://youtu.be/Hn9f13uoLAQ
HR Dashboard - https://www.youtube.com/watch?v=-sOHVl_iCHA&t=0s

Excel Dashboard
Road Accident - https://youtu.be/XeWfLNe3moM
HR Dashboard - https://youtu.be/4WUzvr9jxGc
IPL Dashboard - https://youtu.be/urhI3pEBEBY
Ecommerce Sales Analysis - https://youtu.be/xHTUP1Dxu-M


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 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
Python data visualization tutorial
Python machine learning projects
Data cleaning with Python
Data manipulation in Python
Python data analysis libraries
Data analysis project
Data analyst project
Data analytics project
Data analysis python project
Data analysis end to end project
Data analysis project walkthrough
Data analysis case study with Python
Data analysis project for beginners
End-to-end project for data analyst
SQL project
SQL data analysis project
data analysis project using SQL
SQL project for data analyst
SQL project for portfolio
Data analyst SQL project
SQL portfolio project
Portfolio project for data analyst
data analysis portfolio project
portfolio project
projects for resume
project for data analyst
data analysis tutorial
data analysis tutorial for beginners

Disclaimer: All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for.
Data used in the video is a demo data, modified data and does not belong to any real time industry/ company/ government etc. Data used is only for practice purpose.