Summary
Full Transcript
🏠 JOIN THE LEARN BI ACADEMY - https://geni.us/lbi_academy 🚀 BECOME A BI ANALYST - https://geni.us/lbia_biasp 🏆 TAKE THE BI CONSULTANT MASTERCLASS - https://geni.us/lbia_bicm In this video, we'll be walking you through the steps required to create a data analyst portfolio project in SQL. This project will give you a chance to demonstrate your skills and knowledge of SQL, and will help you build a portfolio of data analysis projects. If you're interested in learning more about data analysis, then this portfolio project is a great way to start! By following along with this step-by-step guide, you'll be able to create a data analyst portfolio that will show off your skills and knowledge of SQL. We'll cover everything from data collection to data analysis to data visualization! 👉🏻 GET YOUR HANDS ON ALL OF THE PROJECT FILES https://learnbi.online/pizzaproject. (N.B. THIS IS A PAID DOWNLOAD. THANKS FOR YOUR SUPPORT!) 👉🏻 CHECK OUT ALL OF OUR PROJECTS HERE https://geni.us/lbia_projects 😸 NEW NAVICAT TUTORIAL - https://youtu.be/f4TzPRJ6gLA 🚨 This is a data analyst portfolio project that was originally posted as 3 separate videos, here they are combined to make the project easier to follow in one place. 00:00:00 Intro 00:01:41 Designing a Relational Database 00:14:44 Writing Custom SQL Queries 00:32:12 Building Interactive Dashboards 01:00:58 Outro ============================= 🚀 WORK WITH ME (BI CONSULTING & AI SOLUTIONS) ============================= If you're struggling to make sense of your data, I help businesses: • Connect and structure their data • Eliminate manual reporting and messy spreadsheets • Build dashboards and AI-powered insight systems • Turn raw data into clear, actionable decisions 👉 Book a call: https://geni.us/dataconsultcall Need guidance instead? 👉 1-to-1 Coaching: https://geni.us/coaching-adamfiner ============================= 🎯 LEARN BUSINESS INTELLIGENCE ============================= Become a BI Analyst – https://geni.us/lbia_biasp BI Consultant Masterclass – https://geni.us/lbia_bicm ============================= 🛠️ LEARN BI TOOLS ============================= Excel – https://geni.us/lbia_excel SQL – https://geni.us/lbia_sql Power BI – https://geni.us/lbia_powerbi Tableau – https://geni.us/lbia_tableau Looker Studio – https://geni.us/lbia_lookerstudio ============================= 📊 PRACTICE PROJECTS ============================= All Projects – https://geni.us/lbia_projects Ben’s Pizzeria – https://geni.us/pizzaproject Hotel Reservations – https://geni.us/hotelproject Multi-Channel Marketing – https://geni.us/multichannelproject Call Centre – https://geni.us/callcentreproject ============================= 🎥 RECOMMENDED VIDEOS ============================= 7 Steps to Your 1st BI Job – https://geni.us/7stepstobivid Learn Basic SQL (15 min) – https://geni.us/learnbasicsql15-1 BI For Beginners Playlist – https://geni.us/biforbeginners-play ============================= 📚 FREE RESOURCES ============================= Dashboard Design Tips – https://geni.us/dashdes-ebook Skills for BI Success – https://geni.us/biskills-ebook 7 Steps to Your 1st BI Job – https://geni.us/7stepstobi-ebook 100 BI Analyst Interview Questions – https://geni.us/100-bi-questions ============================= 📈 DATA SOURCES & TOOLS ============================= Power My Analytics – https://geni.us/YLc9Re Windsor.ai (10% off) – https://geni.us/windsorai Kaggle – https://www.kaggle.com/ Statista – https://www.statista.com/ Data World – https://data.world/ ============================= 📬 CONNECT ============================= LinkedIn – https://geni.us/adamfiner-linkedin Contact – https://learnbi.online/contact Join My Mailing List – https://geni.us/PSgRsF --- *Some links are affiliate links...* #dataanalyst #sqltutorial #businessintelligence
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
