Summary
Full Transcript
👉🏻 GET YOUR HANDS ON ALL OF THE PROJECT FILES https://learnbi.online/pizzaproject. (N.B. THIS IS A PAID DOWNLOAD. THANKS FOR YOUR SUPPORT!) (WATCH THE FULL PROJECT HERE IN A SINGLE VIDEO: https://youtu.be/0rB_memC-dA) 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 https://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 - https://youtu.be/MiAl2mQ718s Tips for Better Dashboard Design - https://youtu.be/nCrD5g8d3ow START YOUR BI JOURNEY HERE! - https://learnbi.online 🎥 MORE RECOMMENDED VIEWING 7 Steps to Your 1st BI Analyst Job - https://geni.us/7stepstobivid BI For Beginners Playlist - https://geni.us/biforbeginners-play 🎓 RECOMMENDED COURSES Power BI For Business Intelligence - https://geni.us/powerbi-udemy Ultimate Guide to Google Data Studio - https://geni.us/vbi-edu Google Data Analytics Course - https://geni.us/coursera_analytics Learn SQL - https://geni.us/learnsql SKILLSHARE - 30-day free trial! - https://geni.us/skillshare30day UDEMY - https://geni.us/udemy_vb 📕 FREE EBOOKS 7 Top Tips For Better Dashboard Design - https://geni.us/dashdes-ebook Skills You Need To Succeed In BI - https://geni.us/biskills-ebook 🧰 BI TOOLS Power BI - https://powerbi.microsoft.com/ Tableau - https://www.tableau.com/ Data Studio - https://datastudio.google.com/ 📊 DATA HUBS & WEBSITES: Power My Analytics: https://geni.us/YLc9Re Supermetrics: https://geni.us/5SNn Data Slayer: https://geni.us/dataslayer Kaggle - https://www.kaggle.com/ Statista - https://www.statista.com/ Data World - https://data.world/ 📕THE DATA VISUALISATION BIBLE - https://geni.us/iJTa8 🎥 MY YOUTUBE GEAR My Camera - https://amzn.to/3J5lbeo Most Used Lens - https://amzn.to/3hXoE2Q Main Key Light - https://amzn.to/366KaPI Softbox - https://amzn.to/35HrR46 LED Panel Kit - https://amzn.to/35K3Lpf Teleprompter - https://amzn.to/3hWGT8p Main Mic - https://amzn.to/3t1n1aK Lavalier Mic - https://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 - https://learnbi.online/contact CONSULTING CALL WITH ADAM - https://geni.us/bookacall-adamfiner JOIN MY MAILING LIST - https://geni.us/PSgRsF FACEBOOK GROUP - https://geni.us/learnbi-fbg #dashboarddesign #sqlproject #businessintelligence
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
