Tableau + SQL Project | Data Analyst Portfolio Project | Beginner to Advanced | Start to End Build
Вставка
- Опубліковано 3 жов 2024
- #tableau #sql #powerbi
Tableau + SQL Project | Data Analyst Portfolio Project | Beginner to Advanced | Start to End Build
⭐Data Download - drive.google.c...
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.
Throughout this tutorial, you will learn how to extract, transform, and load data using SQL queries. We will then show you how to analyze and visualize the data using the powerful features of Power BI, Tableau & Excel.
📱Data Analyst Materials & Projects - topmate.io/dat...
📱Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/dat...
📱For Important Data Analyst Materials and Other Resources - topmate.io/dat...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
📱Follow me on Facebook - www.facebook.c...
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
⭐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 - • Data Analyst Roadmap 2...
Details mentioned below-
To Buy - topmate.io/dat...
email- swapnjeet555@gmail.com
WhatsApp - +91 9579005495
⭐For Tableau, Power BI and Excel Projects contact me on my mail id or WhatsApp number mentioned at the end of description box.
➖➖➖➖➖➖➖➖➖➖➖➖➖
Reach out to me for any personal or Business related Dashboard/ Report development on my email- swapnjeet555@gmail.com
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 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 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
tableau,tableau tutorial,tableau dashboard,tableau desktop,tableau training,tableau full course,what is tableau,tableau basics,tableau tutorial for beginners,tableau software,tableau server,tableau online,tableau public,tableau for beginners,tableau certification,tableau cert,tableau guide,using tableau,tableau cloud,tableau login,tableau class,power bi,tableau project,dashboard,sql,sql project,data analyst project,sql project start to end
You are AMAZING for troubleshooting the errors, that's what makes you different, others prefer to do the errors off screen, but you teach us the art of Reading Syntax errors rather than stressing out. You're clearness and troubleshooting on real time is what makes you different! IM SUBBED!
This was alot but pretty straight forward once youre following and understanding. I've added this to my list of projects :)
Really appreciate your work sir | Hats Off to you
Sir you did not share the tableau background ppt which you used in this video kindly share please
Your videos have been incredibly helpful, and there are truly no words to describe how much I appreciate the valuable insights and guidance you provide. Thank you from the bottom of my heart, and may your continued work bless and help many more.
Bro video is there on his channel
Sir please explain use case of Custom SQL in Tableau. Video was very good for understanding learned a lot.
your tutorials awesome bro please upload more project in tableau
Sure I will
Sir it is a humble request to kindly start a course from scratch so that we can learn the skills...😊😊😊
Very soon
@@datatutorials1yes me too i am interested
@@datatutorials1 sir humble request plz upload the power BI version for the same dataset please sir
Thank you for the tutorial.Can you share the way where we can calculate and analyse the month to month i.e. from January to December change in fund receive/application received or interest rate.That will be a really interesting insight.
YOU are Amazing Bro ... Thanku For This wonderful Video ..Can You please make a video for Healthcare Domain Project into SQL and Power Bi ?
Excellent tutorial!! Can you please tell me the source of your data?
Sir, please also upload Power BI dashboard using same data set
Thank you for this
When using the month to date
I was getting one and not getting the number shown
Also for the pmdt
same issue even i encountered
Sir even I am getting the same error can u plz help us
@ Data Tutorials please sir look into the issue
Good video, but your MOM i.e. month on month application KPI made no sense to me, can you please explain what was it? What are we trying to show here exactly? the number 6% shows what ? Please reply.
Thank you for this tutorial
You're welcome 😊
Great!!
Thanks
not ablr to import the data only 384 rows are being imported
Plz start tableau learning series,so that we could have strong grip of theortical knowledge
Already started, will be uploaded soon on my channel
Most of people waiting for your videos
Thank you so much brother and many blessing to you I pray.
Thanks dear
Good afternoon sir
Sir when will be the power bi version of this dashboard will be uploaded?
Can You make a video for the Healthcare Domain Project in SQL and Tableau?
I continued watching the video and it is same, the KPIs you are calculating are not valid. The second KPI total funded amount, why are we calculating MOM total funded amount, is it showing the increase in funded amount in the last month of the data set, if it is so then the formula you are using is not correct. Please reply.
I am quite confused with terms and calculations:
MTD means This month till Date and PMTD means Previous month till Date.
is it???
Hello sir where is the power bi version for this bank loan project???
Thank you for sharing this cool project. I don't see MS SQL server listed under 'Connect To a Server' on my Tableau. Do you know the reason and what I have to do to have it listed?
U r using Table Public??
@@datatutorials1 I believe yes tableau public desktop version
@@datatutorials1 Would you be able to advise on which Tableau version I need to have the SQL server listed?
@ntsps9614 tableau desktop and not public
Why did you query every KPI in SQL if you are going to create calculated fields again in Tableau? I don't understand. Can't you just code everything you need in one or a few queries and then export it to Tableau?
Thank you for sharing Sir but please not that there is a mistake maybe with the data file you shared. For December month month we only have one row which makes us get wrong values when we calculate the total funded amount
I will check
@@datatutorials1 sir any updates ?
Sir, background ppt has not been shared. Please share that as well.
Sir please update online banking projects using sql + powerbi
How to dynamicaly code for MTD ?
Hello, I want to know how the same report is created in power bi, I have tried several times facing some issues, If you upload a video for how to make reports on power bi for the same data , instead of tableau. I think this will help many people who are facing issues in the same way.
Hi
It is available in my website, check link in description of video
sir thet aggregate and non aggregate function is not possible in if statement its not solving by the way you said
Hello sir
Can you please share the link for financial loan project in power BI please
Dear friend, may I ask which bank's data set is this?
Please do videos on python as well
Can you please provide the source of this dataset ?
Sir i have a query
If they gave server access of mysql
We just need to ask them which tables i need to work right ?
We dont need to do import right?
Why when i imported the csv file to sql server all the float data type lost their comma ex. 1.2345 it become 2345 when imported everything is fine in previewed before imported helpp
I am getting null for Total Loan Applications for the second dashboard please help
Why it showing me 0 as good loan calculations everywhere . can anyone help me?
Mere tableau m to SQL s connect kr ne ka option hi show nhi ho rha h m kaise kru phir connect
Shall I do this project as my mini project!??
bro can you explain how to explain this project in interview
can anyone answer
why are we calculating MTD & MoM only for the month of December
not for all other months too?
Because thats the last month in the data we have, if its real data then its will be todays month
Please release power BI based for this project'
The background for this dashboard where can i find it?
Mhmm chatgpt says MTD Applications shouldn't be what you queried.
The query for MTD apps that you did returns the applications issued in December, not from December 1st to current date, am I missing something?
MTD means month to date data, in our case the last month in the data is say December, thats will be MTD for our case.
Id you are with real time data that is updated or added on daily basis, then for now MTD month would be April 2024
On your third dashboard (bank loan details) interest rates show 0 on every road. Surely, this is wrong. How would you fix it ? There arent loans with 0 interest.
Ohh, please change the number format to percentage and upto two decimal points.
Thanks for noticing!
Hello sir
Please check and let us know y we r getting just the number as 1 for Mtd and pmtd in total Loan application . Kindly let us know where we r going wrong plz help sir
same issue, if i replace MONTH to DAY I get the output I don't know why. The date format is messed up in the csv file
@@Ajinkya_Kuwar I found the issue if u convert the csv file to excel the issue date format gets messed up but if u use the csv file directly in tableau it is working correctly
Sir, how to import this in MYSQL it is giving me error
Kindly send background image link sir
Hello Sir , Pls tell what all topics are involved in SQL notes that are available on your website.
All that is required for a data analytics
@@datatutorials1 Have you used MYSQL Data Base or some other database.
Hi sir, would you please help me out to set up Azure Data studio, coz I try to set up as I started watching your videos where you use msSQL Server and before I was using MySql workbench. Now wanted to use msSQL Server but I stocked since 3 days I’m not able to set up. It actually says “A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
Encryption was enabled on this connection, review your SSL and certificate configuration for the target SQL Server, or enable 'Trust server certificate' in the connection dialog.
Note: A self-signed certificate offers only limited protection and is not a recommended practice for production environments. Do you want to enable 'Trust server certificate' on this connection and retry?” 😢😢
Hello sir, can you please tell which tableau version provides all features?
2022 and above
@@datatutorials1 Hello sir
Please check and let us know y we r getting just the number as 1 for Mtd and pmtd in total Loan application . Kindly let us know where we r going wrong plz help sir
Hi sir what is the bank name? plz
That’s confidential
why we use MS SQL ,can i use my SQL????
yes you can, but you will have to create your own table, your own columns and import data in existing table/columns
CREATE TABLE bank_data_loan (
id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,
address_state VARCHAR(50) NOT NULL,
application_type VARCHAR(50) NOT NULL,
emp_length VARCHAR(50) NOT NULL,
emp_title VARCHAR(100) NULL,
grade VARCHAR(50) NOT NULL,
home_ownership VARCHAR(50) NOT NULL,
issue_date DATE NOT NULL,
last_credit_pull_date DATE NOT NULL,
last_payment_date DATE NOT NULL,
loan_status VARCHAR(50) NOT NULL,
next_payment_date DATE NOT NULL,
member_id INTEGER NOT NULL,
purpose VARCHAR(50) NOT NULL,
sub_grade VARCHAR(50) NOT NULL,
term VARCHAR(50) NOT NULL,
verification_status VARCHAR(50) NOT NULL,
annual_income FLOAT NOT NULL,
dti FLOAT NOT NULL,
installment FLOAT NOT NULL,
int_rate FLOAT NOT NULL,
loan_amount INTEGER NOT NULL,
total_acc TINYINT NOT NULL,
total_payment INTEGER NOT NULL
)
Where's the power BI dashboard video ?
Will be uploaded soon
@@datatutorials1 plz upload it soon sir please 🙏🏻
@@datatutorials1waiting
Hello, I am getting issue with the date columns in the dataset provided, column does not have all the dates in same formate, can you me on this, Can I have proper data set please. Thank you
same problem for me
@@lkn-iw1my are you able to correct the Date format
same here
power bi aur my sql video