Channel Title: Maven Analytics Channel Description: At Maven Analytics, we empower everyday people to land their dream jobs in data analytics and business intelligence. We've helped more than 1,000,000 students launch or accelerate their data careers, and we're just getting started. Learn tools like Excel, SQL, Power BI, Tableau and Python, and build your FREE portfolio at www.mavenanalytics.io <video> Learn 12 Advanced SQL Concepts in 20 Minutes (project files included!) Description: Level up your SQL skills in just 20 minutes with SQL Pocket Guide author, Alice Zhao. In this video, we'll cover 12 advanced SQL concepts: ✔ UNION ✔ UNION ALL ✔ Subqueries ✔ LEFT JOIN ✔ INNER JOIN ✔ CTEs ✔ Recursive CTEs ✔ Date Expressions ✔ CAST ✔ COALESCE ✔ ROUND ✔ Window Functions …all in less than 20 minutes! 🔗 Helpful links: 👉 Downloadable project file: https://maven-datasets.s3.us-east-1.amazonaws.com/YouTube+Downloads/maven_advanced_sql_demo.sql 👉 Advanced SQL Querying Course: Maven: https://bit.ly/4amQMqA Udemy: https://bit.ly/40A6ZVW 👉 MySQL Specialist Path: https://bit.ly/4gghp1L 👉 Follow us on LinkedIn: Alice: https://www.linkedin.com/in/alicexzhao/ Maven Analytics: https://www.linkedin.com/company/maven-analytics 🎉👀 IT’S HAPPENING!!! 👀🎉 Our January Jumpstart event is officially LIVE!!! Here's what you can expect this month… 🔓 FREE ACCESS TO 6 MAVEN EXCLUSIVE COURSES! During January Jumpstart, Free Users will have unlimited access to our Data Career Roadmap Learning Path! 📅 LIVE WORKSHOPS! Workshop your resume, portfolio, and LinkedIn profile with industry leaders! 🏆 WIN AWARDS! Join live sessions, engage with the community, and showcase the improvement you’ve made for your chance to earn the coveted January Jumpstart MVP award! 🛠️ LIMITED OFFER: BONUS CAREER COACHING SESSIONS! Be one of the first 50 people to purchase lifetime access or the cohort immersive 4-pack bundle during January Jumpstart, and receive a bonus offer of private, one-on-one career coaching from some of the biggest names in data! Are YOU ready to Jumpstart your January?! 👉 https://bit.ly/4fUE5o1 Hope to see you there! ⏱️Timestamps ⏱️ 0:00 Intro 01:05 UNION vs UNION ALL 03:01 Subqueries 04:14 LEFT JOIN vs INNER JOIN 06:44 CTEs 10:02 Recursive CTEs 11:16 Date Expressions 12:16 CAST 14:28 COALESCE 15:55 ROUND 16:33 Window Functions (ROW_NUMBER, LAG & LEAD) 19:35 Final Query 21:09 Outro At Maven Analytics, we empower everyday people with life-changing data & AI skills. Head to http://mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE! Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: https://mavenanalytics.io/guided-projects </video> <video> How to Build Custom Slicer Panels in Power BI Desktop (PBIX File Included!) Description: It's time for a Power BI Pro Tip! In this video, Maven Analytics Founder Chris Dutton will demonstrate how to build interactive Power BI reports and apps using custom slicer panels. We’ll start by adding a button to our navigation pane on the Adventure Works report we developed in our Power BI Desktop course. From there, we’ll design the slicer panel, add slicers for years and continents, and add buttons and bookmarks that allow users to toggle the slicer panel on and off. 🔗 Links to Resources 👉 Microsoft Power BI Desktop Course Maven: https://mavenanalytics.io/course/microsoft-power-bi-desktop Udemy: https://www.udemy.com/course/microsoft-power-bi-up-running-with-power-bi-desktop/?referralCode=3AF54DD57F039A574572&utm_source=video&utm_medium=youtube&utm_campaign=pbisnippet2&couponCode=LEARNNOWPLANS 👉 Power BI Specialist Path: https://bit.ly/3P93Nu2 👉 AdventureWorks Power BI file (pbix): https://maven-datasets.s3.amazonaws.com/AdventureWorks+Power+BI+Report/AdventureWorks+Report_FINAL.pbix.zip Interested in learning more about Power BI from the pros? Check out our cohort learning experiences! Admissions for our Power BI and Python immersive programs are OPEN; in just 10 weeks, you could master a new tool and take your data career to the next level! ✔️ Guided portfolio projects! ✔️Access to your own private learning community! ✔️ Weekly, 1-hour live sessions with recordings! ✔️ Live support from expert instructors! ✔️ Unlimited Maven access extending two months past the end of the program! ...and all of this is built into a program that's designed to fit into your busy life, at a more affordable price. Save 25% on our upcoming cohorts until January 3rd. Space is limited; secure your seat today! 👉 https://bit.ly/3ZFnZs0 ⏱️ Timestamps: 00:00 - Intro 00:12 - DEMO 09:42 - Resources Happy learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground </video> <video> 6 LinkedIn Tips to Land a Job in 2025 #data Description: Looking to land your dream job in 2025? Here are 6 tips to help you revitalize your LinkedIn profile! Want expert feedback? Join our LIVE LinkedIn workshop on 1/23, where YOUR LinkedIn profile could be reviewed by the pros! Check it out at mavenanalytics.io/january-jumpstart Happy learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground </video> <video> Is Your Resume Broken? #jobsearch Description: If you are struggling to get your first data job, Kristen has some great tips for success! If you want to build a strong career in data, this show is for you. Last week, we welcomed the new face of Mavens of Data, Kristen Kehrer, who shared her best advice for data professionals and those aspiring toward a data career. You’ll leave the show with some actionable tips and some of the best career advice directly from one of our favorite data pros of all time. What You'll Learn 💡 What you should focus on if you’re trying to land your first job 💡 How to succeed once you are in that initial role 💡 How to think about building a successful career long-term Catch the full replay: 🔗 https://mavenanalytics.io/mavens-of-data/928160f1-c356-4b30-a013-58c66b2ffd60 Happy Learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground For those interested in a more hands-on learning approach with our instructor team, check out our Immersive Cohorts, currently open for enrollment: https://mavenanalytics.io/cohort-learning </video> <video> How Analysts Change a Light Bulb #data Description: How many analysts does it take to change a light bulb?! 💡 Happy Learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground For those interested in a more hands-on learning approach with our instructor team, check out our Immersive Cohorts, currently open for enrollment: https://mavenanalytics.io/cohort-learning </video> <video> 5 Resume Tips to Land a Job in 2025 #data Description: Trying to land your dream job in 2025? It all starts with a standout resume! Here are 5 tips to help you get noticed by hiring managers. Want expert feedback? Join our LIVE resume workshop on 1/16, where YOUR resume could be reviewed by the pros! Check it out at mavenanalytics.io/january-jumpstart Happy learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground </video> <video> How to Use Numeric Range & Fields Parameters in Power BI Desktop (PBIX File Included!) Description: It's time for a Power BI Pro Tip! In this video, Maven Analytics Founder Chris Dutton will introduce Numeric Range and Fields Parameters, and show how to use them to add custom, interactive elements to your Power BI reports. 🔗 Links to Resources 👉 Microsoft Power BI Desktop Course Maven: https://mavenanalytics.io/course/microsoft-power-bi-desktop Udemy: https://www.udemy.com/course/microsoft-power-bi-up-running-with-power-bi-desktop/?referralCode=3AF54DD57F039A574572&utm_source=video&utm_medium=youtube&utm_campaign=pbisnippet2&couponCode=LEARNNOWPLANS 👉 Power BI Specialist Path: https://bit.ly/4fKRdvX 👉 AdventureWorks Power BI file (pbix): https://maven-datasets.s3.amazonaws.com/AdventureWorks+Power+BI+Report/AdventureWorks+Report_FINAL.pbix.zip Interested in learning more about Power BI from the pros? Check out our cohort learning experiences! Admissions for our Power BI and Python immersive programs are OPEN; in just 10 weeks, you could master a new tool and take your data career to the next level! ✔️ Guided portfolio projects! ✔️Access to your own private learning community! ✔️ Weekly, 1-hour live sessions with recordings! ✔️ Live support from expert instructors! ✔️ Unlimited Maven access extending two months past the end of the program! ...and all of this is built into a program that's designed to fit into your busy life, at a more affordable price. Save 25% on our upcoming cohorts until January 3rd. Space is limited; secure your seat today! 👉 https://bit.ly/404vRVD ⏱️ Timestamps: 00:00 - Intro 00:14 - What are Parameters 02:43 - DEMO 16:01 - Resources Happy learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground </video> <video> An Introduction to Financial Modeling (w/ Giles Male) | Mavens of Data Description: If you work in data or are trying to break into a data career, you might want to consider adding some Financial Modeling skills to your tool kit. In this episode, you’ll get a great overview of Financial Modeling and what it takes to succeed in that career path, from none other than Giles Male, Co-Founder of Full Stack Modeller and “Humblest MVP in the world”. You’ll leave with a better understanding of the Financial Modeling career path, and whether or not it might be something you should consider for your own career. What You'll Learn: 1) What a Financial Modeler does on the job 2) Keys to success as a Financial Modeler 3) Giles’ best advice for your career If you liked this, check out our upcoming Mavens of Data live shows: https://bit.ly/4j7jEH8 Note: Mavens of Data will return with live shows in February! In the meantime, don’t miss our January Jumpstart event—featuring expert-led live coaching sessions, free access to the full Data Career Roadmap Path.... and more! : https://bit.ly/3W8UWML . . . Download the full podcast here: Apple: https://podcasts.apple.com/us/podcast/mavens-of-data/id1752013464 Spotify: https://open.spotify.com/show/39G7vZKgfPJhrN3zPZlh38 🗣️ Follow Maven Analytics on Social Media: https://linktr.ee/mavenanalytics About our guest: ⭐️ Giles Male ⭐️ Giles is a co-founder of Full Stack Modeller, an award-winning training programme and community for modellers at every level, with an opportunity to gain Full Stack Modeller accreditation. 🤝 Follow Giles on LinkedIn: https://www.linkedin.com/in/giles-male-30643b15/ 🔗 Full Stack Modeller: https://www.fullstackmodeller.com/ </video> <video> Learn Excel: Number all your rows in less than 10 seconds! #excel Description: Learning Excel? Did you know there’s a way to number all of your rows for a large data set in less than 10 seconds?! Here’s how! Happy Learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground For those interested in a more hands-on learning approach with our instructor team, check out our Immersive Cohorts, currently open for enrollment: https://mavenanalytics.io/cohort-learning </video> <video> “Ordinary people are going to have power that they never had before!” #shorts Description: “Ordinary people are going to have power that they never had before!” If you’re interested in AI but not sure if you’re leveraging it to its full potential, this show is for you. Last week, Michael Tiffany, CEO of Fulcra Dynamics, joined Mavens of Data to help you get your head around AI, its best use cases today, and where things are heading in the future. You’ll leave the show with a better understanding of AI, trends to keep an eye on, and how you can take full advantage of exciting new technology in your work and your personal life. What You'll Learn 💡 AI use cases you should have on your radar at work 💡 How to leverage AI effectively to augment your personal life 💡 Where AI is headed and how you can make sure you’re not falling behind Catch the full replay: 🔗 https://mavenanalytics.io/mavens-of-data/4c69dd80-8f19-49ce-9b97-64253ef58481 Happy Learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground For those interested in a more hands-on learning approach with our instructor team, check out our Immersive Cohorts, currently open for enrollment: https://mavenanalytics.io/cohort-learning </video> <video> An Introduction to Data Strategy (w/ Dylan Anderson) | Mavens of Data Description: If you’re considering a career as a Data Strategy Consultant or just want to learn more about what that is, then this one is for you! In this episode, Dylan Anderson walks us through the life of a Data Strategy Consultant, the work they do, keys for success in the role, and also gives his general advice to anyone looking to build a career in data. You’ll leave with a better understanding of Data Strategy Consulting work and whether or not it might be the right fit for you and your career. What You'll Learn: 1) What a Data Strategy Consultant does 2) How to thrive as a Data Strategy Consultant 3) Dylan’s best advice for anyone pursuing a career in data If you liked this, check out our upcoming Mavens of Data live shows: https://bit.ly/3WnV3Ei Note: Mavens of Data will return with live shows in February! In the meantime, don’t miss our January Jumpstart event—featuring expert-led live coaching sessions, free access to the full Data Career Roadmap Path.... and more! : https://bit.ly/4ajU4e4 . . . Download the full podcast here: Apple: https://podcasts.apple.com/us/podcast/mavens-of-data/id1752013464 Spotify: https://open.spotify.com/show/39G7vZKgfPJhrN3zPZlh38 🗣️ Follow Maven Analytics on Social Media: https://linktr.ee/mavenanalytics About our guest: ⭐️ Dylan Anderson ⭐️ Dylan Anderson is a Data Strategy Consultant, bridging the gap between data and strategy. 🤝 Follow Dylan on LinkedIn: https://www.linkedin.com/in/dylansjanderson/ 🔗 The Data Ecosystem Substack: https://thedataecosystem.substack.com/ </video> <video> Transform Your Career by Learning from the Best! #career Description: "The part that benefited me most…was interacting with industry-leading instructors who I very much look up to” Looking for a way to make a real impact on your career in 2025? Mike Leshanksy knows the secret sauce! Our Power BI and SQL immersive Cohort Learning programs are open for enrollment now – don’t miss the chance to take your career to the next level! Happy learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground </video> <video> AI Ethics & Data Usage | What You Need to Know Description: If you are a data professional, navigating Data & AI ethics is a skill you can't ignore. In this video, Alice Zhao talks to Lead Python Instructor Chris Bruehl about his new course Data & AI Ethics. Some of the topics they cover include: 👉 What are Data & AI ethics? 👉 What do data professionals need to know about Data & AI ethics? 👉 How do you think Data & AI ethics will evolve over the next few decades? 👉 What are some simple, practical suggestions for people who are just getting started with Data & AI ethics? COURSE DETAILS 🔗: Maven: https://bit.ly/3W3UsHt Udemy: https://bit.ly/4gGrqGv 🎉👀 IT’S HAPPENING!!! 👀🎉 Our January Jumpstart event is officially LIVE!!! Here's what you can expect this month… 🔓 FREE ACCESS TO 6 MAVEN EXCLUSIVE COURSES! During January Jumpstart, Free Users will have unlimited access to our Data Career Roadmap Learning Path! 📅 LIVE WORKSHOPS! Workshop your resume, portfolio, and LinkedIn profile with industry leaders! 🏆 WIN AWARDS! Join live sessions, engage with the community, and showcase the improvement you’ve made for your chance to earn the coveted January Jumpstart MVP award! 🛠️ LIMITED OFFER: BONUS CAREER COACHING SESSIONS! Be one of the first 50 people to purchase lifetime access or the cohort immersive 4-pack bundle during January Jumpstart, and receive a bonus offer of private, one-on-one career coaching from some of the biggest names in data! Are YOU ready to Jumpstart your January?! 👉 https://bit.ly/4a6iSWC Hope to see you there! At Maven Analytics, we empower everyday people with life-changing data & AI skills. Head to http://mavenanalytics.io and master in-demand tools like Excel, SQL, Power BI, Tableau, Python and more. Design your own personalized learning plan and get started for FREE! Looking for more opportunities to sharpen your skills? Explore sample datasets and practice solving real business problems with unique, expert-led guided projects: https://mavenanalytics.io/guided-projects </video> <video> Is this the Christmas Season or Spooky Season?! #data Description: Christmas Season or Spooky Season?! 😱 Happy Learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground For those interested in a more hands-on learning approach with our instructor team, check out our Immersive Cohorts, currently open for enrollment: https://mavenanalytics.io/cohort-learning </video> <video> 5 Portfolio Tips to Land a Job in 2025 #data Description: Looking to land your dream job in 2025? A strong portfolio can make or break your application, so here are 5 quick tips to take your portfolio to the next level! Want to dive deeper? We've got a LIVE portfolio workshop coming up on 1/9 where YOUR portfolio could be reviewed by the pros! Check it out at mavenanalytics.io/january-jumpstart Happy learning! Want to learn data analysis and business intelligence? Our guided learning model gives you the flexibility to create your perfect path, with live support and expert coaching to keep you on track every step of the way. https://www.mavenanalytics.io/ Want to practice your skills? Explore and download sample datasets hand-picked by Maven instructors. Apply your data analysis and visualization skills to real-world data, from flight delays and movie ratings to shark attacks and UFO sightings. https://www.mavenanalytics.io/data-playground </video>

Contacts and Links

Description

At Maven Analytics, we empower everyday people to land their dream jobs in data analytics and business intelligence. We've helped more than 1,000,000 students launch or accelerate their data careers, and we're just getting started.

Learn tools like Excel, SQL, Power BI, Tableau and Python, and build your FREE portfolio at www.mavenanalytics.io

Videos from channel