Maven Analytics

Did you participate in our Cart Combos Data Drill? So did our instructors! Four experts. Four tools. One winner… 🏆 In this video, Maven Analytics instructors Aaron Parry, Enrique Ruiz, John Pauler, and Chris Bruehl battle it out with their favorite tools to earn the title of Data Drill Champion. For Data Drill #13: Your dataset contains one year of point-of-sale transactions from a grocery store, including approximately 88,000 line items across 20,000 customer orders. Your task is to identify the five product pairs that are purchased together most often. Each expert will be on the clock as they solve the drill, and the best solution takes the crown. Excel. Power BI. SQL. Python. Who will come out on top? 👀 FIND OUT NOW! 📽️: https://lnkd.in/gewSUaU8

AI can save hours... ...But it can also send you down a rabbit hole of confidently wrong answers. Most people who use AI regularly at work have hit at least one of these walls: 👉 It gave you something that sounded right... but wasn't. 👉 You knew what you wanted, but couldn't figure out how to ask for it. 👉 The output was fine, but you weren't sure if you could actually trust it. We're not here to pile on the hype. We want to know what's actually happening in the field. When you use AI at work, what's your biggest frustration? We'd love to hear what you're seeing. 👇

Could you build an end-to-end Databricks pipeline on your own? By the end of the day on Thursday, your answer could change! Databricks is one of the most widely used data platforms in the industry, but getting a clear picture of how it all fits together isn't always easy when you're starting out. Most tutorials cover individual features in isolation, leaving you with fragments rather than a full workflow. In Thursday's Live Workshop with Kimberly Fessel, PhD, you'll build a simple end-to-end pipeline from scratch, connecting the core pieces of Databricks in a real-world context so you can see exactly how they work together...in just 90 minutes! By the end of the Live Workshop, you will... ✅ Understand the core components of Databricks and how they interact ✅ Build an end-to-end pipeline from raw data ingestion to analysis-ready output ✅ Describe the purpose of Delta Lake, medallion architectures, and Databricks workflows ✅ Navigate the Databricks workspace and identify the role of its major tools and features Learn more & register 👉 https://bit.ly/4f0M3xd

Are you a SQL user? If you've mastered SELECT, JOIN, and GROUP BY, it's time to learn one of SQL's most powerful features: window functions. They let you analyze data across related rows without collapsing your dataset, making it easy to: ✅ Rank products, customers, or employees ✅ Calculate running totals ✅ Compare values to previous or next rows ✅ Find top performers within each category Window functions can seem intimidating at first, but once you understand the OVER() clause, they quickly become an essential part of your SQL toolkit. Ready to dig in? Alice breaks it all down with clear explanations and practical examples in our latest article. Read it here 👉 https://bit.ly/4pkoowL

Tired of exporting flat files out of your SQL database for analysis in Excel or Tableau? In this quick video, we show you how to streamline that workflow using Python.

Here's a quick Excel tip for creating a named range for each column in a range: 1) Select your data range, including column headers 2) Press CTRL+SHIFT+F3 3) Select ""Top row"" in the Create Names from Selection window 4) Press OK Excel will use each column header as the name for that range automatically. One thing to keep in mind: column names with spaces won't work cleanly. Use a table instead if your headers have spaces.

If every SQL query you write needs five joins just to answer a simple business question, you don't have a query problem. You have a data modeling problem. In this video, Alice Zhao breaks down why normalized databases are painful to query and how dimensional modeling fixes it for good. You'll learn: 👉 Why normalized schemas require so many joins 👉 What fact tables and dimension tables are and how they work together 👉 How a star schema transforms a 5-table join into a single join 👉 The difference between a database that's painful to query and one that's a joy 📽️: https://lnkd.in/gQJ8j9WJ

Looking to level up your data-wrangling skills? Try our new Readmission Radar data drill! Your dataset contains 623 inpatient stay records from a small hospital. Each record represents a patient discharge, and includes the patient ID, admission date, and discharge date. Your task is to calculate the hospital's 30 day readmission rate. Use any tool you like (#Excel, #SQL, #Python, #PowerBI, etc.) and share your solutions here on LinkedIn by tagging @Maven Analytics! Ready to give it a shot? Download the dataset here: https://bit.ly/4vWU7GG We’ll share instructor solutions across various tools next month; stay tuned! 👀

Big news…👀 Data Modeling for Analytics Engineering is LIVE! The second course in Alice Zhao’s analytics engineering series, this course is designed to give you a solid foundation in data modeling, from core concepts to a step-by-step process that you can apply on the job. We'll cover… ✅ Data modeling overview ✅ Table fundamentals ✅ Fact & dimension tables ✅ Schema designs ✅ Handling data changes ✅ Modern data workflow ✅ Data modeling process …and more! Whether you're building your first dimensional model or looking to formalize your approach, this course will give you the theory and process to do so with confidence. Hope to see you there! COURSE DETAILS: 👉 https://bit.ly/4gqhTWL

Have you attended one of our Live Workshops yet? We've got more ahead, and July's sessions are packed with more in-demand content... If you've been waiting for us to teach Databricks, it’s finally here! These Live Workshops are worth clearing your calendar: 👉 Databricks Essentials: Build Your First End-to-End Pipeline Thursday, July 16th @ 12PM ET with Kimberly Fessel, PhD 👉 AI Project Lab: From Messy Data to Exec-Ready Reports Tuesday, July 21st @ 12PM ET with Mo Chen 👉 Prompt AI Like a Pro: The BRIDGE Framework Thursday, July 30th @ 12PM ET with Chris Bruehl All our workshops are live, interactive, and included with Maven Pro or a team account. Register now 👉 https://bit.ly/4fmGv1n