r/mavenanalytics • • Jul 02 '26

Tool Help SQL users: you don't need to write this regex yourself. You just need to know it exists.

1 Upvotes

Say your data has a film column with values like "Toy Story," "Toy Story 2," "Toy Story 3," and "Toy Story 4." All slightly different strings, but you want to count them as one franchise.

(This exact scenario comes straight from our Pixar Films dataset in the Data Playground, so you can pull it up and try it yourself: https://mavenanalytics.io/data-playground/pixar-films)

The fix is a regex that strips the trailing space-and-number off any title:

REGEXP_REPLACE(film, ' [0-9]+$', '') AS series

In plain terms, it finds a space followed by one or more digits at the very end of the string, and replaces it with nothing. "Toy Story 2" becomes "Toy Story." "Toy Story 4" becomes "Toy Story."

Now GROUP BY series and you can count across the whole franchise instead of four separate rows. Four Toy Story movies, if you're counting.

You don't have to write that pattern from memory; ask ChatGPT for it and it'll hand you the syntax in seconds. What actually matters is recognizing the problem: messy, inconsistent text values that need to collapse into groups.

Once you know that's a solvable category of problem, you know what to ask for.

The syntax is a lookup. Spotting the problem is the skill.

One caveat: regex operations are computationally expensive. Great for exploration or a one-off cleanup on a small dataset like this one. For anything production-scale, clean the data at the source instead of regexing it every query.

What's a SQL problem you assumed you'd have to solve manually, until you found out there was already a function (or a prompt) for it?


r/mavenanalytics • • Jun 23 '26

Career Advice The difference between analysts who get promoted and those who stay stuck

5 Upvotes

It's rarely about technical skill.

The pattern we see most often is this:

The analysts who move up aren't necessarily the most technically skilled; they're the ones who learned to think and communicate like a decision-maker.

Here's what that actually looks like in practice...

  • They answer the question behind the question. When someone asks "what happened to revenue last quarter," they don't just pull the number. They think about what the person really needs to know and what they'll do with the answer.

  • They push back constructively. When a request doesn't make sense, they ask why before they start building. "What business problem are we trying to solve with this?" is one of the most valuable questions in data.

  • They translate, not just report. A chart is not an insight. They summarize what the data means for the business in plain language that anyone can act on.

  • They manage expectations on limitations. They say "this data only goes back 18 months, so the trend is directional" instead of presenting analysis as more certain than it is.

What's one communication or business skill that made a real difference in your career?


r/mavenanalytics • • Mar 17 '26

Career Advice Nobody talks about the career trap that's about to get a lot more dangerous for analysts

69 Upvotes

There's a version of a data analytics career that looks productive but is actually a dead end. You're writing SQL, maintaining dashboards, running the same reports on a slightly different date range, and passing outputs to someone else who makes the decision. The work gets done. Nobody complains. And you're not building anything that compounds.

This was always a risky place to be. AI is making it significantly more risky.

Tasks like routine querying, basic reporting, and manual data prep are exactly what's getting automated first. 

The questions worth asking honestly about any role you're in or considering: are you involved in scoping projects? Are you a thought partner with the business and consulting on areas where there may be bias or over-engineering? Or do you get a ticket after someone else has already decided what they want? That signal tells you more about your growth trajectory than the tech stack, the title, or the compensation.

The analysts who build durable careers are the ones who get into the room where problems are being defined, not just called in afterward to validate a conclusion someone is hoping to hear. That means developing the ability to challenge a project scope, push back on a poorly defined target variable, and reframe what the business is actually trying to solve before anyone writes a line of code or SQL.

AI is genuinely useful for helping you be a better analyst. It can close the gap on the business "polish" that technical people have historically struggled with, the communications, presentations, and positioning your work for a non-technical audience. AI can help you test edge cases, create top-notch documentation of your work, and help you think about additional questions to explore for your analysis. But the tools only help if you're pointed in the right direction. Faster execution on the wrong problem is still the wrong problem. Not only is your analysis not set up for success, but the lack of visibility and thought partnership gives leadership the impression that your role is neither difficult nor high-value.


r/mavenanalytics • • Apr 28 '26

Tool Help Import failure from .csv file containing accented/diacritical characters in MySQL

2 Upvotes

Hi everyone,

I’ve been working on a project recently and importing it into MySQL has been a bit challenging. The .csv file contains accented/diacritical characters that isn’t rendering as they should. I’ve previously posted about this in r/excel and did manage to find a fix for this using Power Query (Power BI).

However, I’d still love to learn about how to handle such in MySQL. The initial goal for my project was to practice some basic database, data cleaning and transformation skills using MySQL. Thereafter, I wanted to do some minor data cleaning, shaping and visualisation of the outputs in Power BI.

Here’s an example of some of the words that aren’t rendering as it should: Carmenè, Márga, Rosé, Gewürztraminer, etc.

FYI: I’m using the Wine Tasting dataset from the Maven Analytics Data Playground.

Here's what I've done:

In MySQL, I first tried the Table Data Import Wizard. I made sure to double check that the file encoding and import settings were set to utf-8 on import. However, in the preview below, it still seemed to render incorrectly.

This is also a dataset of 129 971 records and only 281 records imported. That’s a big red flag!

I also checked to see if my settings in MySQL were appropriate to handle accented/diacritical characters. In the screenshot below, this confirms that I was using the utf8mb4 character set. The only difference was in the character_set_system which uses utf8mb3, I’m not sure if this is the problem?

I checked this using:

SHOW VARIABLES LIKE 'character_set%';

I am aware of LOAD DATA but, I’m not very technical and would really need some help from the community if that is a viable option for this scenario.

Please can someone assist or guide me as to where I'm going wrong.

Thank you and much appreciated! :)


r/mavenanalytics • • Aug 12 '25

Discussion How I used data skills to (accidentally) uncover a 160+ year-old family secret

13 Upvotes

It started with a Victorian-style burn.

Michael, my ancestor, disinherited his oldest son Timothy. "I bequeath my son one dollar, to show I've not forgotten him, but he's not to inherit from my estate." Only his oldest daughter, Mamie, benefitted.

It was like an itch in my brain I couldn't scratch. I had to know why.

That's when things got weird.

For context: Tim was born in 1838. Mamie was born 1840. Michael and his wife were born 1805.

For 15 years...nothing. Then suddenly in the mid 1850s-early 1860s, 4 babies appear.

So I started digging....

The TLDR is, you're already doing data analysis every day. Even if you're not a formal data analyst.

I'm curious, how have you leveraged your data skills inside or outside of work. Let me know in the comments.


r/mavenanalytics • • Jul 28 '26

Tool Help Excel tip: stop merging cells to center text.

5 Upvotes

Merging cells causes all kinds of downstream headaches (breaks sorting, filtering, copy/paste, references). This gets the same visual result without locking cells together.

How to do it:

Type in the desired text

Select the cells you'd want to center the text across

Press CTRL+1 to open the Format Cells dialog box

Go to the Alignment tab

In the "Horizontal" dropdown, select "Center Across Selection"

Click OK

Same visual result as merged cells, minus the downstream problems.

What's your equivalent "wish I knew this sooner" Excel tip?


r/mavenanalytics • • Mar 10 '26

Do you still need to learn SQL in 2026 if AI can write queries for you?

69 Upvotes

A lot of people who want to get into data are asking the same question right now:

If AI can write SQL for me, do I still need to learn SQL?

My honest answer is yes.

Not because you’ll be hand-writing every query forever.

But because SQL is still what helps you think clearly about data structure (so important), validate results, and avoid sending bad answers to stakeholders (immediate trust killer).

I’ve used SQL on the job for close to two decades, and now I use AI all the time too. AI is genuinely useful. I use it for syntax help, troubleshooting, rough drafts of queries, and exploring alternate approaches.

But here’s the part I think beginners are missing:

The biggest danger is not that AI writes SQL that throws an error.

The biggest danger is that it writes SQL that runs, returns numbers that look reasonable, and is still wrong.

That happens more than people think.

Usually it’s stuff like:

  • bad joins that double count

  • joining on the wrong key

  • grouping at the wrong level

  • filtering in the wrong place

  • counting users when you meant to count events

  • NULL behavior doing something you didn’t expect

And if you don’t know enough SQL to catch that, then you’re the one owning the mistake.

That’s why I still think SQL is one of the highest ROI skills for anyone early in a data career.

Not just for writing the code (yes, AI can do that for you today*...sort of*).

For:

  • getting your own data without waiting on someone else

  • asking better questions because you understand the data

  • checking whether dashboards and outputs are actually right

  • using AI well instead of blindly trusting it

If I were starting from zero today, I’d focus on:

  1. The Big 6 SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

  2. Aggregates COUNT, SUM, AVG, MIN, MAX, DISTINCT

  3. Joins + database structure Primary keys, foreign keys, INNER JOIN, LEFT JOIN, cardinality

  4. Then the accelerators CTEs, temp tables, window functions (you could skip these for a while tbh)

That gets you a lot farther than people realize.

I also think AI is amazing for learning SQL faster if you use it the right way.

A few prompts I like:

  • “Explain why this query is failing and rewrite it correctly.”

  • “Give me 3 ways this query could be wrong.”

  • “Show me 2 alternate approaches and explain the tradeoffs.”

  • “Explain each clause like I’m new to SQL.”

That said, the rule is simple:

If AI gives you the SQL, your job is to verify it.

If you can’t verify it, you can’t trust it.

And if you can’t trust it, you can’t use it in a real analytics job.

So yes, you should learn SQL in 2026.

AI didn’t make SQL irrelevant.

It made judgment, validation, and fundamentals more valuable.

Curious where other people land on this.

If you’re hiring, working in analytics, or trying to break in right now, do you think SQL is still a must-have?


r/mavenanalytics • • Sep 10 '26

Career Advice Here's the change that can increase your value 10x at work

5 Upvotes

Want to be a better Analyst?

Here's an easy "hack" for any data person to seem (and be) more valuable...

Before you share any analysis, pretend you are the P&L owner.

Don't stop at insights.

Ask: what should be done to improve the business?

Make recommendations for ACTION.

Do this EVERY TIME you work on something.

You have a huge advantage.

You're seeing the data before anyone else.

When you present your work, others will be seeing your findings for the first time. You've had plenty of time to formulate ideas.

Use your extra time to be the thoughtful driver of improvement.

Insights are always valuable. They are a great start.

IMPACT is better.

Take it all the way.


r/mavenanalytics • • Sep 30 '25

How to build a SQL portfolio project that doesn't stink (most get it wrong, and doing it right is pretty simple - all in the packaging)

6 Upvotes

Sharing this for two reasons...

1. I hear the question a lot: "how can I share my SQL project in a portfolio?"
-- sharing a Tableau or Power BI project is a lot more straight forward for folks. There is an obvious visual to present. But putting together a SQL project stumps people.

2. Most SQL portfolio projects STINK
-- they are done wrong, in a way that immediately loses their intended audience. Doing it right isn't much additional effort, if you know how a potential hiring manager thinks and what they are actually looking for in a project like this.

Before getting into how you should structure your SQL projects, let's quickly cover the most common format of a SQL project.

"Here's this complex SQL code I put together. Isn't it impressive?"

Sound familiar?

This is what most people do (especially those relatively new to data) when they are sharing a SQL project trying to flex their skills.

And it makes sense why they do it this way...they just learned how to do something technical, which isn't easy. They are proud of what they can now do. Plus, they know employers value SQL skills. So they want to flex this new technical muscle, thinking it will impress. Makes total sense.

The problem with this approach... if you say "check out my SQL code", almost no one will actually read it.

Think about the 3 types of people you're trying to impress with a project like this:

  1. HR Rep / Recruiter... not technical, can't read your SQL code

  2. Business Stakeholder... not technical, can't read your SQL code

  3. Technical Hiring Manager... could read your code, but doesn't want to

OUCH... that third one. It hurts, but it's true. Stick with me and I'll explain.

The last thing anyone wants to do is read your SQL code without context.

So here's what you should do instead when presenting a SQL project (SQL code doesn't come in until the very end)...

1. Lead with a simple description of the business problem you solved (bonus points for a quick summary of the impact)
This works for, and is the most important context for, each of the 3 audiences we discussed above. Everyone cares about the business problems you can solve with your technical skills. This is how you "hook" them into actually checking out your project.

BUSINESS PROJECT & IMPACT EXAMPLE:
I analyzed a Meta ads campaign and was able to increase revenue by 40% by implementing more sophisticated geo-targeting.

2. Next, show some visuals to communicate the insights you found.
Gasp!... for a SQL project?? Yes, absolutely. Charts and graphs to tell the story. Excel or Google Sheets is totally fine here. You NEED to do this, because this is your chance to show off your communication skills. You're a data person. You're technical. Great. But can you tell a story with your skills? This is where your audience (people who might hire you) will find out. This is where they start to feel what it might be like to work with you.

VISUALS TO COMMUNICATE INSIGHTS EXAMPLE:

Cost per Click was much cheaper in CA and AU, despite comparable and slightly better conversion rates when compared with the US.

[chart showing conversion rates and cost per click for 3 countries: US, CA, AU]

3. Then, explain what the business should do (or did) about the insights you found.
What action should be taken and by who? This is how you turn data into impact. Don't skip this step! BONUS: illustrate the impact if this was a real on the job project and action was taken. If not and it's more of an academic project, that's okay. Just stick to the explanation of what should happen based on your insights if this were a real world case.

RECOMMENDATIONS & IMPACT EXAMPLE:

The recommendation was to shift budget from US to CA and AU to increase revenue and improve return on ad spend. The Marketing team moved 60% of the US budget into CA and AU, and it increased total revenue by 40%, without increasing ad spend.

[chart showing spend by country and revenue by country over comparable before and after periods, and total spend and revenue by period, illustrating a shift in spend out of US and into CA and AU and an improvement in performance, and a quick explanation...

4. Finally, hit them with that SQL code you're so proud of. Now you flex your technical skills AFTER you've shown them what your skills can do for a business. This is the way. At this stage, you've dazzled them with what really matters, your ability to make an impact, and your SQL skills will be the technical flex you want it to be. When you do it in this order, they've stuck with it, and flashing the code leads them to... "oh wow, they are technical and know their way around the database too? Impressive!"

Hope this helps! Let me know if you've got any specific questions. I'm happy to answer them or take a look at a project if you link it here in a comment.


r/mavenanalytics • • Apr 13 '26

Career Advice Unpopular opinion: Technical skills aren’t the most important skill in data.

6 Upvotes

If we had to rank the 5 skills every data professional should master, it would look like this:

  1. Problem Solving

  2. Critical Thinking

  3. Communication & Advocating for Action

  4. Business Acumen

  5. Technical Skills

Yes, technical skills are last on the list. That usually surprises people.

To be clear: tools matter.

SQL, Python, Power BI, Tableau: these are powerful and highly marketable skills. They’re essential for getting your foot in the door.

But tools alone don’t create impact. What separates strong data professionals from average ones isn’t just technical ability. It’s the ability to:

  • Frame the right problem

  • Question assumptions

  • Connect analysis to business context

  • Communicate insights clearly

  • Influence decisions

Companies don’t invest in data for dashboards.

They invest in data to drive better decisions.

Technical skills are the entry ticket. The differentiator is how you apply them.

That’s why we believe learning data should go beyond tools.

Foundations, AI fluency, and human skills together are what make careers resilient, especially as the field evolves.

Curious how others would rank this:

If you had to reorder the list, what would you put at #1?


r/mavenanalytics • • Oct 05 '25

Tool Help Is it okay if Power BI and I are no longer on speaking terms?

7 Upvotes

So...my mentor told me to learn Power BI, and also talk to fabulous data people. These fabulous data people also said to learn PBI over Tableau. I am trying to....not hate it.

But I'm failing hard (at the not hating it). Every time I try to save my work, I get an error message. Or I'm told there are too many windows open...even when it's just the one.

I understand that PBI is the cool kid on the block, but is it okay to be uncool? Because so far...the cool kid makes me want to scream into a pillow.

I've dabbled in Tableau a bit. I even had a baptism by fire with Looker for an hour when someone asked me for help troubleshooting a dashboard and that felt easier than PBI.

My apologies to any PBI fans! I'm just struggling to get into the hype.


r/mavenanalytics • • Jun 10 '26

Tool Help Excel quick tip: the way to make your dashboards look instantly more polished!

7 Upvotes

It's a small thing, with a BIG impact...

Turn off the gridlines.

That's it. View tab → uncheck "Gridlines."

Gridlines are genuinely useful when you're working in a spreadsheet. They help you navigate. But on a dashboard, they become visual noise that competes with your charts and layout without adding anything.

The funny part is how many people discover this after spending time filling every cell with white to achieve the same effect. If that's you, no judgment — we've all done it. But there's a faster way.

One checkbox and the whole thing reads cleaner immediately.

Anyone else have small formatting changes that make a bigger difference than they should?


r/mavenanalytics • • Sep 29 '25

Tool Help Excel vs Power BI vs SQL vs Python - Which Tool Wins?

10 Upvotes

We just dropped a new Data Drill episode and it turned into a pretty fun battle:

Excel vs Power BI vs SQL vs Python.
Four Maven Analytics instructors (Enrique Ruiz, Aaron Parry, John Pauler, Chris Bruehl) each tackled the same challenge with their favorite tool.

The drill: join promo details to a transactions table, but only for the correct active sales periods. Everyone was on the clock, and the best solution takes the crown.

It’s part skill-sharpening, part nerdy competition, and a cool way to see how different tools approach the same real-world problem.

Curious to hear...if you had to pick just one tool for this type of challenge, which would you choose?


r/mavenanalytics • • Oct 04 '25

Career Advice How to Tell Clear & Effective Stories with Data

12 Upvotes

One of the most underrated skills in analytics is the ability to tell a clear story with your data.

If you can't get your point across, all the technical skills in the world won't make an impact on an organization, so your value is limited.

You NEED to be good at storytelling if you want to be a high impact player.

In this video, Chris walks through a practical framework for turning data into compelling stories that actually land with your audience and get them to take action. He covers:

  • Defining the purpose of your analysis

  • Choosing the right metrics

  • Presenting data effectively

  • Eliminating clutter & noise

  • Using layout to focus attention

  • Structuring your findings into a clear narrative

If you want to level up your data skills and make your work more impactful, this is a great place to start.


r/mavenanalytics • • Mar 17 '26

Career Advice Want to learn Python for data analysis? Start with SQL. (Here's why!)

16 Upvotes

1. Almost every data job that requires Python also requires SQL

If a role uses Python for analysis, modeling, or automation… it almost always uses SQL too.

You’ll rarely see:

“Python required, SQL optional.”

It’s usually the opposite.

2. More jobs require SQL than Python

There are tons of analyst roles that require SQL and not Python. The reverse? Much less common.

If you’re trying to maximize job opportunities early on, SQL gives you more surface area.

3. SQL is usually how you acquire the data you'll use in Python.On the job, you’re usually not analyzing clean CSVs.

You’re pulling data from data warehouses, production databases, cloud platforms; if you can’t write a query, you can’t get the data you need.

And if you can’t retrieve the data… Python doesn’t help much.

4. In interviews you are more likely to be tested on your SQL skills than Python skills.

In interviews, it's extremely common to be tested on SQL. It’s common to be tested on both SQL and Python. But it’s more common to be tested on SQL and not Python than the other way around.

If you're prepping for data interviews, SQL is non-negotiable.

5. SQL is easier to learn than Python.

Your time to proficiency will be much shorter and that can help you get your foot in the door while you build Python skills.

Additionally, while its generally true that Python is one of the easiest programming languages to learn, SQL is much easier than Python, especially at the analyst level, because it has a single purpose.

Learning SQL is a great way to dip your toe into coding and build some confidence and transferrable skills that will help you push through the challenging parts of Python.

This doesn’t mean skip Python. It means sequence matters.

SQL → then Python

Not the other way around.

Curious to hear from the community: which did YOU learn first? If you disagree, we'd love to hear why!


r/mavenanalytics • • Oct 05 '25

Tool Help How to use SQL Window Functions (Practice Data Included)

18 Upvotes

Window functions can feel confusing at first, but once you get them, they unlock a whole new level of SQL power (and they aren't as tough as you think!)

In this 7-minute walkthrough, Alice breaks down how window functions work step by step.

Below you can find the CREATE and INSERT statements to produce this data set, in case you want to follow along and get your hands dirty. Timestamps are at the bottom too, in case you want to jump to a specific function.

Happy learning!

📄 CREATE & INSERT Statements 📄

CREATE TABLE baby_names (
Gender VARCHAR(10),
Name VARCHAR(50),
Total INT
);

INSERT INTO baby_names (Gender, Name, Total) VALUES
('Girl', 'Ava', 95),
('Girl', 'Emma', 106),
('Boy', 'Ethan', 115),
('Girl', 'Isabella', 100),
('Boy', 'Jacob', 101),
('Boy', 'Liam', 84),
('Boy', 'Logan', 73),
('Boy', 'Noah', 120),
('Girl', 'Olivia', 100),
('Girl', 'Sophia', 88);

⏱️ Timestamps ⏱️
00:00 Intro
0:09: View the table
0:28: ORDER BY
1:18: Window function with ROW_NUMBER
1:40: OVER
2:36: Breaking down the window function
3:28: ROW_NUMBER vs RANK vs DENSE_RANK
5:13: PARTITION BY
6:52: Window function in a subquery


r/mavenanalytics • • Mar 18 '26

Discussion THIS OR THAT? DATA EDITION! Share your picks 👇

23 Upvotes

Since we’re fully remote, our Team Maven doesn’t really get to see each other that often. But when we do, we like to have a little bit of data-themed fun!

Our team weighed in:

PC or Mac?

Light Mode or Dark Mode?

Standing Desk or Sitting?

Early Bird or Night Owl?

Excel: Underrated or Overrated?

SQL: Underrated or Overrated?

What are YOUR picks? Let’s talk about it!


r/mavenanalytics • • Oct 15 '25

All Courses 100% Free at Maven Analytics

31 Upvotes

Maven Analytics is making all courses free starting next week as part of Open Campus.

You'll also be able to join live sessions with experts from around the data industry.

It's totally free for anyone to join, you don't even need a credit card to sign up.

During the event, you'll get unlimited access to all of our Courses (Excel, SQL, Power BI, Tableau, Python, AI, and more) and Guided Projects.

You can even earn badges and certificates that are yours to keep for life.

It's a really fun event, and we only do it once a year, so hope you'll take advantage of it.

GET ALL THE DETAILS HERE: --> http://bit.ly/4nY0RQK


r/mavenanalytics • • Oct 02 '25

How to Learn Power BI: a Roadmap for Beginners

36 Upvotes

If you’re building a career in data, chances are you’ll run into Power BI at some point. It’s one of the fastest-growing BI tools out there, and adding it to your skill set makes you a lot more marketable.

The tricky part is figuring out how to learn it. Power BI has a lot of moving pieces, and without a roadmap, it’s easy to get lost. Here’s a path I recommend:

1. Learn the basics of Power BI Desktop
Download it, open it, and get familiar with the interface. Knowing where things live and how the workflow fits together will save you headaches when you build your first project.

2. Connect and shape data
This is where you start working with real-world files. Learn how to:

  • Connect to different sources

  • Transform tables (merge, append, pivot, unpivot)

  • Build calculated columns

  • Group and aggregate data

This step gives you control over messy raw data so you can turn it into something useful.

3. Build a data model
Once you can pull in data, the next step is modeling it. You’ll need to understand:

  • Relationships between tables

  • Lookup vs. fact tables

  • Star vs. snowflake schemas

  • Filter flow and cardinality

Good models make your life easier when you get into DAX and reporting. Bad ones make everything harder.

4. Add calculated fields with DAX
DAX (Data Analysis Expressions) is Power BI’s formula language. Learn the fundamentals:

  • Calculated columns vs. measures

  • Implicit vs. explicit measures

  • Filter context

  • Common DAX functions

This is where you start to unlock serious analytical power.

5. Build reports and dashboards
Now comes the fun part. Start with the basics:

  • Charts and visuals

  • Report filters and interactions

  • Drillthroughs and bookmarks

  • Role-level security

Keep visualization best practices in mind. Simple and clear usually beats flashy and cluttered.

6. Explore AI visuals
Power BI has some great AI-driven visuals like Q&A, key influencers, and decomposition trees. They can surface insights quickly but always remember the golden rule: correlation isn’t causation.

7. Go advanced when you’re ready
Once you’ve nailed the fundamentals, you can dive deeper into:

  • Advanced DAX (time intelligence, table functions, relationships)

  • Power BI Service (sharing, collaboration, row-level security, administration)

  • Premium features if you’re working at enterprise scale

Learning Power BI can feel overwhelming at first, but with the right roadmap, you can move step by step without burning out. Master the basics, build projects as you go, and layer on more advanced skills when you’re ready.

Happy learning!

PS - what questions do you have? Let's hear 'em :)


r/mavenanalytics • • Oct 01 '25

Tool Help A beginner’s roadmap to learning Python for analytics

51 Upvotes

Over the last decade, Python has gone from a niche tool to one of the most important skills in analytics. If you’re aiming for an analyst or data science role at a tech company, Python is a must-have in your toolkit.

That said, learning Python can feel intimidating. It’s a general purpose programming language, which means there’s way more to learn than you’ll ever need for analytics. And within analytics itself, there are dozens of libraries. So where do you even start?

Here’s a simple roadmap I recommend for beginners:

1. Base Python
You don’t need to know how to engineer software to do analytics with Python. Focus on the essentials: Python syntax, data types, conditional logic, loops, and functions. That foundation makes everything else easier.

2. Pandas
Pandas is the analytics library in Python. Think of the DataFrame as an Excel sheet or SQL table, but with superpowers. It can handle millions of rows, summarize or pivot data, and connect directly to databases. The challenge is that Pandas has hundreds of functions, so a good beginner-friendly course is worth the time.

3. Data Visualization
Pick one library to start.

  • Matplotlib: the original workhorse. Powerful but clunky.

  • Seaborn: built on matplotlib, better defaults, and easier to use. My go-to for quick insights.

  • Plotly: beautiful, interactive charts. Great if you need dashboards or presentations.

4. Beyond the essentials
Once you’re comfortable with the basics, branching out is easier.

  • Want to scrape websites? Try Scrapy.

  • Curious about machine learning? Start with scikit-learn.

  • Need to scale to massive datasets? PySpark is your friend.

The bottom line: Don’t get overwhelmed by the Python ecosystem. Nail the fundamentals, get fluent with Pandas, learn one solid viz library, and build from there. If you practice consistently, you’ll be ready for those tech interviews faster than you think.

Happy learning!

PS - what questions do you have. We are happy to answer them if you drop a comment.


r/mavenanalytics • • May 08 '26

Project Feedback Show us what you're building!

6 Upvotes

What are you working on this week?

If you can, we'd love to see a screenshot of a dashboard, a query you finally got right, a chart you're weirdly proud of. Even a work-in-progress you want a second opinion on.

Big or small, drop it below!

This community has people at every skill level, and there's usually someone who's either been stuck in the same place or has a tip that helps.


r/mavenanalytics • • Mar 30 '26

Maven Mondays This week at Maven

5 Upvotes

Happy Monday!

Here’s what’s new:

Last week, John hosted an AMA right here on r/mavenanalytics…and you guys had some awesome questions! You can dig into that thread here: https://www.reddit.com/r/mavenanalytics/comments/1ry45cn/ama_ive_worked_in_data_for_2_decades_lets_talk/

If you’re a fan of Maven’s Data Drills, keep an eye out – a new one launches VERY soon! 

We’ve got some AWESOME things happening at Maven this month, so be sure to keep checking back here and on our other channels.

We’ve loved seeing everyone post and comment here in the last few weeks, and we’re looking forward to what you guys are working on next and hearing your thoughts on industry developments. Can't wait to see what you have to share with us this month!

If you're new here, feel free to introduce yourself and your interests below -- and welcome to r/mavenanalytics :)


r/mavenanalytics • • Apr 23 '26

Tool Help PSA: Stop using “Compact Form” if you want usable data from a Pivot Table

5 Upvotes

By default, Excel uses Compact Form report layout.

Which means:

  • All your row labels get crammed into one column

  • You get those weird spacer rows

  • And the whole thing doesn’t look anything like a normal table

Great for quick analysis… not great if you actually want to use that data somewhere else.

Here’s the fix:

Go to the Design tab → Report Layout → Show in Tabular Form

Then:

Click “Repeat All Item Labels”

Turn off subtotals: “Do Not Show Subtotals”

Now your Pivot looks like a proper table, has clean, repeatable rows, and is actually usable for copy/paste or downstream work!

This is one of those small tweaks that makes Excel way more practical once you know it.

Anyone else have a quick Excel tip to share?


r/mavenanalytics • • Jun 26 '26

Discussion Monthly wins thread! What did you get done in June?

4 Upvotes

What are you proud of from this month? It could be:

  • Attending (or watching) one of the Live Workshops

  • Finishing a course or module you'd been putting off

  • Building something: a dashboard, a script, a portfolio project

  • Finally understanding something that's been confusing you for a while

  • Landing an interview, an offer, or a new role

  • Showing up consistently, even when progress felt slow

No win is too small to share.

Drop it below. We want to celebrate with you!


r/mavenanalytics • • Oct 07 '25

Tool Help How to Plot a Normal Distribution (Bell Curve) in Excel, with Shading

7 Upvotes

Ever wondered how to make a bell curve in Excel, and actually shade the area under it?

In this short tutorial, Enrique walks you through it step by step, using a simple combo of line and area charts to create a clean, professional-looking visualization.

🎥 Watch here: How to Plot a Normal Distribution (Bell Curve) in Excel – with Shading!

You’ll learn how to:

  • Build a normal distribution curve from scratch

  • Add custom shading under the curve

  • Make your chart look slick enough to drop straight into a dashboard or presentation

What do you think? Is this something you would typically do in Excel? Or would you switch to Python or Power BI for something like this?