Join host Avery Smith, with Excel expert Matt Brattin about mastering data analytics with Excel in this episode of the Data Career Podcast.

From customizing shortcuts to leveraging advanced functions, Matt shares tips and tricks to take your Excel skills to the next level.

Get insights from an industry pro and boost your chances of landing your dream data job.

Tune in now!

Connect with Matt Brattin:

🤝 Connect on Linkedin

▶️ Subscribe to Youtube Channel

🎒 Learn About the Excel 4 Academy

🤝 Ace your data analyst interview with the interview simulator⁠

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(07:53) - 5 Concepts of Excel you should know

(20:35) - Top Excel Shortcuts

(26:54) - Can you make a dashboard in Excel?

(30:20) - Excel is like Thor’s hammer

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

This book, Alteryx Designer Cookbook, provides over 60 practical and detailed recipes that guide you in conquering data accessibility, preparation, and insights generation through Alteryx Designer. You will learn how to manipulate, blend, and analyze data sources effectively, improving your analytical productivity. What this Book will help me do Master efficient methods for cleaning, preparing, and shaping data accurately. Combine multiple data sources seamlessly using Alteryx Designer's blending tools. Implement essential data transformations such as pivoting and restructuring for analyses. Create reusable, automated solutions for repeated tasks using Alteryx macros. Generate rich, data-driven reports to enhance business intelligence efficiently. Author(s) None Guisande is an experienced data analytics professional with years of hands-on expertise in implementing data workflows using Alteryx Designer. Passionate about simplifying complex operations, None brings a practical approach to teaching, ensuring that readers can apply their skills immediately. Who is it for? This book is ideal for data analysts, professionals in business intelligence, and anyone proficient in Alteryx Designer's basics looking to deepen their understanding. If you aim to enhance your productivity and manual data tasks into efficient automated workflows, this book is a perfect fit.

Discover the utility of your organization’s data with Microsoft Power BI In Beginning Power BI for Business Users: Learning to Turn Data into Insights, accomplished data professional and business intelligence expert Paul Fuller delivers an intuitive and accessible handbook for professionals seeking to use Microsoft’s Power BI to access, analyze, understand, report, and act on the data available to their organizations. In the book, you’ll discover Power BI’s robust feature set, learn to ingest and model data, visualize and report on that data, and even use the DAX scripting language to unlock still more utility from Microsoft’s popular program. Beginning with general principles geared to readers with no or little experience with reporting or data analytics tools, the author walks you through how to manipulate common, publicly available data sources—including Excel files and relational databases. You’ll also learn to: Use the included and tested sample code to work through the helpful examples included by the author Conduct data orchestration and visualization to better understand and gain insights from your data An essential resource for business analysts and Excel power users reaching the limits of that program’s capabilities, Beginning Power BI for Business Users will also benefit data analysts who seek to prepare reports for their organizations using Microsoft’s flexible and intuitive software.

As Joe Reis recently opined, if you want to know what’s next in data engineering, just look at the software engineer. The MDS-in-a-box pattern has been a game changer for applying software engineering principles to local data development– improving the ability to share data, collaborate on modeling work and data analysis the same way we build and share open source tooling.

This panel brings together experts in data engineering, data analytics and software engineering to explore the current state of the pattern, pieces that remain missing today and how emerging tools and data engineering testing capabilities can refine the transition from local development to production workflows.

Speakers: Matt Housley, CTO, Halfpipe Systems; Mehdi Ouazza, Developer Advocate, MotherDuck; Sung Won Chung, Solutions Engineer, Datafold; Louise de Leyritz, Host, The Data Couch podcast

Register for Coalesce at https://coalesce.getdbt.com

Machine Learning with Qlik Sense introduces practical applications of machine learning within the Qlik platform. Through this book, you will gain a thorough understanding of fundamental ML concepts, learn to apply these within Qlik Sense, and see how to use predictive analytics to solve real-world problems. The hands-on examples ensure you can translate learnings into actionable insights. What this Book will help me do Understand the key principles of machine learning and how to apply them using the Qlik platform. Develop skills in data preprocessing and analysis to prepare datasets for machine learning models. Learn to validate and interpret machine learning models and evaluate their performance. Master advanced visualization techniques for presenting insights derived from data. Apply newfound knowledge to practical business problems through real-world use-case examples. Author(s) Hannu Ranta is an expert in data analytics and has extensive experience utilizing the Qlik platform to derive actionable insights from data. With years of practical exposure and a focus on teaching, Hannu brings a clear and structured approach to using machine learning for analytics. His writing seeks to empower readers to achieve practical solutions using Qlik's powerful tools. Who is it for? This book is perfect for data analysts, data scientists, or anyone working in data analytics who wants to incorporate machine learning into their skill set. It is especially suited to those with a basic familiarity with Qlik tools or data analysis concepts. Beginners in machine learning can also benefit because the book starts from foundational concepts and builds step-by-step.

Join Avery Smith with special guest Tim Beecher to discuss his incredible journey from a locksmith to a successful data analyst in this inspiring episode of the Data Career Podcast.

Discover how Tim's determination, networking skills, and project-based learning led him to a fulfilling career and learn valuable tips on how to make a similar transformation in your life.

Don't miss this opportunity to gain insights and practical advice from Tim's experiences - tune in now!

💼 Connect with Tim Beecher on Linkedin

🤝 Ace your data analyst interview with the interview simulator⁠

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(09:27) - Why data analytics

(10:18) - Get paid to learn data

(24:14) - Using your network to land a job

(36:04) - Day in the life as a Marketing Data analyst

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

In this session, Yijun Cao and Dakota Kelley highlight how dbt plays a key role in MuleSoft’s modern data analytics framework. As MuleSoft continues to grow, the data platform engineering team encountered some challenges with the data transformations. The session dives deeper into the specific challenges faced by the team and demonstrates how dbt’s features including CI/CD, testing, documentation and lineage help overcome these challenges.

Speakers: Yijun Cao, Data Platform Engineer, Salesforce; Dakota Kelley, Solution Architect, phData

Register for Coalesce at https://coalesce.getdbt.com

In this session, learn how Prime Therapeutics' data team was able to implement dbt for multiple teams and environments in a highly-controlled way without compromising security or performance. With multiple teams and environments, it was essential to manage and maintain consistent policies across environments while helping share best practices to improve their dbt implementations.

Speakers: Jill Aakhus, Principal Analytics Engineer, Prime Therapeutics; Anubhav Pareek, Data Analytics Engineer, AICG

Register for Coalesce at https://coalesce.getdbt.com

As analytics engineers, we know that getting the data model right is crucial for successful data analytics. However, communicating requirements and needs can be a challenge, especially for junior data team members. After noticing too many post-PR revisions and missed requirements, Wellthy began developing a communication framework that has helped streamline and clarify the requirements gathering process for new models.

Their framework is designed to help analysts visualize and anticipate what they need from a dataset, resulting in a more efficient and effective data modeling process for the analytics engineer. In this talk, Kelly Pook shares Wellthy's experiences and best practices using these frameworks, as well as the benefits seen in terms of accuracy, efficiency, and time savings.

Speaker: Kelly Pook, Senior Analytics Engineer, Wellthy

In this session, you'll learn tips and tricks from La-Z-Boy on how to modernize infrastructure and tackle complex retail and manufacturing data problems using dbt and Fivetran. Hear from a data leader about their experience and how you can replicate their success. Start your session off with some comfortable data movements to make sure you can extract as much information as possible from our loaded session on data transformation.

Speakers: Alex Hauer, Lead Product Marketing Manager, Fivetran; Selwyn Samuel, Director of Data Analytics & Enterprise Architecture, La-Z-Boy

Register for Coalesce at https://coalesce.getdbt.com

Advances in LLM technology and the semantic layer have made AI-powered data analytics easy. Nothing special. Par for the course.

Wait, you haven't seen yet? Don't worry, we'll show you. But I gotta warn you, it's pretty boring stuff. You just ask for whatever data you want, and then the computer gets it for you. Yes, seriously!

So what is still impressive in October 2023? Well, good old fashioned human ingenuity and improvisational skill. Computers may have gotten pretty good at crunching the numbers, but you still can't replace good old fashioned meat and bone when it comes time to present those numbers to the big boss.

In this session, Izzy Miller and Matt David put that to the test with a live game of Dashboard Karaoke— with an AI twist. Random audience members take turns using Hex's Magic AI to generate entire analytical reports on datasets of their choosing. Then, our handpicked data practitioners have to improvise a compelling presentation of the results on the spot, explaining the intricacies and trends of data they've never seen. And of course, there will be plenty of time for audience questions ;)

Speakers: Izzy Miller, Developer Advocate, Hex; Matt David, Product Marketing Lead, Hex

Register for Coalesce at https://coalesce.getdbt.com

In this episode, Avery shows you how you can become a Data Analyst in just 90 days.

Join him as he debunks the myths, provides practical advice, and inspires you to achieve the seemingly impossible.

You got this. Tune in and level up your data career today!

🤝 Ace your data analyst interview with the interview simulator

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(05:44) - Stop thinking small

(06:40) - Speed is key

(15:12) - Portfolio, experience, shadowing, learn from others

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

All cloud architects need to know how to build data platforms that enable businesses to make data-driven decisions and deliver enterprise-wide intelligence in a fast and efficient way. This handbook shows you how to design, build, and modernize cloud native data and machine learning platforms using AWS, Azure, Google Cloud, and multicloud tools like Snowflake and Databricks. Authors Marco Tranquillin, Valliappa Lakshmanan, and Firat Tekiner cover the entire data lifecycle from ingestion to activation in a cloud environment using real-world enterprise architectures. You'll learn how to transform, secure, and modernize familiar solutions like data warehouses and data lakes, and you'll be able to leverage recent AI/ML patterns to get accurate and quicker insights to drive competitive advantage. You'll learn how to: Design a modern and secure cloud native or hybrid data analytics and machine learning platform Accelerate data-led innovation by consolidating enterprise data in a governed, scalable, and resilient data platform Democratize access to enterprise data and govern how business teams extract insights and build AI/ML capabilities Enable your business to make decisions in real time using streaming pipelines Build an MLOps platform to move to a predictive and prescriptive analytics approach

Join Avery Smith and Jordan Temple in this episode of the Data Career Podcast.

Jordan shares his insights on breaking into the data industry with a non-technical background, leveraging skills in Power BI and the power of a solid online presence.

Tune in now to gain inspiration and guidance for your data career journey.

Connect with Jordan Temple:

🤝 Connect on Linkedin

🤝 Ace your data analyst interview with the interview simulator

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps: (07:02) - Excel + Power BI

(12:20) - Landing a job with a DM

(15:10) - Hybrid > Remote

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

Join Avery for a captivating episode with Data Consulting expert Leon Gordon, to delve into the world of data consulting and the skills needed to excel in this field.

Don't miss out on this fascinating conversation filled with valuable insights and advice for data professionals looking to make a difference as consultants.

Tune in now to better understand the data consulting industry and how you can navigate your way to a successful career!

Connect with Leon Gordon:

🤝 Connect on Linkedin

🎒 Learn About Onyx Data

🤝 Ace your data analyst interview with the interview simulator⁠

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(5:56) - Data Consulting

(9:45) - Power BI

(25:00) - Data Projects

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

Join me with Tableau expert Andy Kriebel about data visualization tips! 📊

Andy shares his expertise to help you level up your data skills, from creating purposeful dashboards to the power of dot maps.

Tune in now and take your data visualizations to the next level! 🎧

Connect with Andy Kriebel:

🤝 Connect on Linkedin

▶️ Subscribe to Youtube Channel

📔 Buy #MakeoverMonday Book

🎒 Learn About The Data School

🤝 Ace your data analyst interview with the interview simulator

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(11:15) - When dealing with time series, your best friend is the versatile line chart 📈

(13:34) - Dive into dot maps for super-detailed visualizations 🌍

(17:30) Want to compare rankings over time? Bump chart!📊📈

(21:10) Keep your graphs simple and spiced up with context📉

(26:45) Dashboards should tell a story; ensure they have a purpose and context to keep folks engaged. 📋💡

(34:27) Prepping for an interview? Be chatty, be prepared with your interviewers. 🗣️🤝

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

In this episode of the Data Career Podcast, I sit down with Luke Barousse, a data analyst and data star on YouTube, to discuss the impact of AI on the role of data analysts.

We delve into the question of whether AI will replace data analysts or enhance their work, sharing insights and perspectives on the topic.

Connect with Luke Barousse:

🤝 Connect on Linkedin

▶️ Subscribe on Youtube

📊 Datanerd.tech

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(05:22) - ChatGPT Code Interpreter

(09:09) - Will AI Steal Your Job?

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

What skills should you learn when studying to be a Data Analyst?

Join me with data legend Luke Barousse to discuss where you should focus your time.

Is it Python? Is it SQL? Is it Excel? Is it Power BI?

Listen to find out 👀

Connect with Luke Barousse:

🤝 Connect on Linkedin

▶️ Subscribe on Youtube

📊 Datanerd.tech

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(03:42) - Analyzing 1.2M data jobs (DataNerd.tech)

(06:21) - The most important data skills

(12:13) - More senior skills

(22:52) - Data job titles

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

Join me with data interview expert Nick Singh to discuss how to ace your data science and analytics interviews, from preparation tips to tackling SQL technical questions, in this must-listen episode of the Data Career Podcast—you won't want to miss it!

Connect with Nick Singh:

🎁 Free SQL Tutorial from Data Lemur: https://datalemur.com/sql-tutorial

🤝 Connect on Linkedin

📕 Buy "Ace the Data Science Interview" book

🐵DataLemur

👔 Get a discount on my data interview prep course: https://www.datacareerjumpstart.com//interview

📩 Get my weekly email with helpful data career tips

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(16:10) - 📊 Best interview tips

(36:30) - 🔄 Mock interview practice

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode: Join the last cohort of 2025! The LAST cohort of The Data Analytics Accelerator for 2025 kicks off on Monday, December 8th and enrollment is officially open!

To celebrate the end of the year, we’re running a special End-of-Year Sale, where you’ll get: ✅ A discount on your enrollment 🎁 6 bonus gifts, including job listings, interview prep, AI tools + more

If your goal is to land a data job in 2026, this is your chance to get ahead of the competition and start strong.

👉 Join the December Cohort & Claim Your Bonuses: https://DataCareerJumpstart.com/daa https://www.datacareerjumpstart.com/daa

Prepare for the Azure Data Engineering certification—and an exciting new career in analytics—with this must-have study aide In the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203, accomplished data engineer and tech educator Benjamin Perkins delivers a hands-on, practical guide to preparing for the challenging Azure Data Engineer certification and for a new career in an exciting and growing field of tech. In the book, you’ll explore all the objectives covered on the DP-203 exam while learning the job roles and responsibilities of a newly minted Azure data engineer. From integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions, you’ll get up to speed quickly and efficiently with Sybex’s easy-to-use study aids and tools. This Study Guide also offers: Career-ready advice for anyone hoping to ace their first data engineering job interview and excel in their first day in the field Indispensable tips and tricks to familiarize yourself with the DP-203 exam structure and help reduce test anxiety Complimentary access to Sybex’s expansive online study tools, accessible across multiple devices, and offering access to hundreds of bonus practice questions, electronic flashcards, and a searchable, digital glossary of key terms A one-of-a-kind study aid designed to help you get straight to the crucial material you need to succeed on the exam and on the job, the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203 belongs on the bookshelves of anyone hoping to increase their data analytics skills, advance their data engineering career with an in-demand certification, or hoping to make a career change into a popular new area of tech.