Dashboard Design Tutorial For Beginners | Data Analyst Portfolio SQL Project (Part 3/3)

👉🏻 GET YOUR HANDS ON ALL OF THE PROJECT FILES
learnbi.online/pizzaproject.
(N.B. THIS IS A PAID DOWNLOAD. THANKS FOR YOUR SUPPORT!)
(WATCH THE FULL PROJECT HERE IN A SINGLE VIDEO: • Data Analyst Portfolio... )
In this third and final part of my data analyst portfolio SQL project, we’re going to be designing and building dashboards using data we collected in the database we designed in part 1 and then wrote custom SQL queries for in part 2. Let’s dive in.
There are 3 different dashboards that the client has asked for. One for orders, one for inventory and one for staff. We’ll build out the dashboards in that order.
🔵 OUR SPONSOR - LEARNSQL.COM
geni.us/learnsql
⏱ TIMESTAMPS
00:00 Intro
02:11 Connecting to SQL data in Data Studio
04:38 Orders dashboard build
15:26 LearnSQL.com sponsor
16:16 Inventory dashboard build
22:55 Staff dashboard build
26:00 Dashboard design
30:46 Outro
LINKS I REFERRED TO IN THIS VIDEO:
Part 1 of the Project - • SQL Database Design Tu...
Tips for Better Dashboard Design - • 7 Top Tips for Better ...
START YOUR BI JOURNEY HERE! - learnbi.online
🎥 MORE RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
BI For Beginners Playlist - geni.us/biforbeginners-play
🎓 RECOMMENDED COURSES
Power BI For Business Intelligence - geni.us/powerbi-udemy
Ultimate Guide to Google Data Studio - geni.us/vbi-edu
Google Data Analytics Course - geni.us/coursera_analytics
Learn SQL - geni.us/learnsql
SKILLSHARE - 30-day free trial! - geni.us/skillshare30day
UDEMY - geni.us/udemy_vb
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
🧰 BI TOOLS
Power BI - powerbi.microsoft.com/
Tableau - www.tableau.com/
Data Studio - datastudio.google.com/
📊 DATA HUBS & WEBSITES:
Power My Analytics: geni.us/YLc9Re
Supermetrics: geni.us/5SNn
Data Slayer: geni.us/dataslayer
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
📕THE DATA VISUALISATION BIBLE - geni.us/iJTa8
🎥 MY KZbin GEAR
My Camera - amzn.to/3J5lbeo
Most Used Lens - amzn.to/3hXoE2Q
Main Key Light - amzn.to/366KaPI
Softbox - amzn.to/35HrR46
LED Panel Kit - amzn.to/35K3Lpf
Teleprompter - amzn.to/3hWGT8p
Main Mic - amzn.to/3t1n1aK
Lavalier Mic - amzn.to/3vVUi8V
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
#dashboarddesign #sqlproject #businessintelligence

[@Hameedhudeen]

Thank you so much for this 3 part series. I've learned a lot of new things.

[@LearnBI]

Great! It's my pleasure

[@rc_burst]

Thank you, Adam. This is inspiring to learn SQL and dashboard.

[@LearnBI]

You're welcome. Thank you for your feedback

[@abdelrahmanashraf7636]

Just finished the 3 parts. Thanks a lot Adam for the amazing explanation and the great effort

[@LearnBI]

You're very welcome!

[@sanyas3324]

Exactly what I was looking for

[@LearnBI]

Great!

[@beilulbilly2636]

Learned a lot, Thank you

[@LearnBI]

You’re welcome

[@Adiyat_Coto]

Thank you so much, Adam! To conclude, from your 3 parts of videos, I already understand so much what to do to make a Point of Sales (POS) System. Awesome! I will get more creative for looking the idea for the other SaaS Software cases from this knowledge foundation. Cheers!

[@LearnBI]

You’re welcome. Glad it was helpful.

[@print_the_code9156]

It is just a wonderful 😊👍 vd for creating dashboard .👍

[@LearnBI]

Thank you for your kind feedback

[@equiwave80]

Hi Adam, This was an excellent video to round off the playlist. Thanks for all your efforts!!! 🙏👍 As you had mentioned it would be great if you could show how to create an instance in Google Cloud of a MySQL database in a separate video (not urgent). I am currently trying to learn cloud related techniques so it will be very helpful. Regards, Deepak.

[@camronroberts]

Thank you, Adam. I am really enjoying this project. I would appreciate it if you could show us how to create instances. I've been trying for a week now and I still can't figure it out 😄.

[@LearnBI]

That's a great idea, I was thinking about doing a video like that but you've convinced me! 😁

[@neptoonpalace4027]

Could you please provide a video on how to setup MySQL instance

[@LearnBI]

I was thinking about it but there are already loads of videos on how to install MySQL.

[@neptoonpalace4027]

@@LearnBI but how to configure Google cloud instance like you did

[@claraandres3772]

How do I create and import data into the Google Cloud MySQL instance ?

[@LearnBI]

As I said in my reply to your other comment, the instance belongs to me and isn’t open to the public. I’ll be creating a video soon for an introduction to Google Cloud. I’ll cover how to create an instance and import data.

[@arcaneknight9799]

Tried Connecting Google Looker to MySQL (didn't try using the Google Cloud version, as I thought I heard it wasn't free), and I had errors. I then tried to connect MySQL to Power BI and ran into a separate issue. Any tips?

[@LearnBI]

It’s impossible for me to help with such little information, sorry

[@arcaneknight9799]

@@LearnBI Finally got it to work, thanks. Connected MySQL to Power BI, but I needed a separate download. On part 2 of the dashboard, but in Power BI rather than Looker.