|
Hello Reader, This week's newsletter is a bit different. There's SQL in here, but the real topic is career strategy. Because one of the most common questions I get from readers is some version of: "I've been learning SQL for a few months. How do I prove I can actually do this job?" The honest answer: a portfolio of 2-3 projects that demonstrate business thinking, not just technical syntax. The problem is most portfolios I've reviewed look the same. A Kaggle competition. A tutorial from YouTube. Maybe a COVID dataset analysis. They show that you can write SQL. They don't show that you can think like an analyst. Here's what I'd recommend instead. The Three-Project FrameworkEach project demonstrates a different skill that hiring managers care about: Project 1: Business Question Analysis (SQL-focused) Shows you can translate a business question into data and back into recommendations. Project 2: Dashboard or Visualization (Tableau, Power BI, or Python) Shows you can present findings visually for decision-makers. Project 3: End-to-End Analysis (SQL + interpretation + recommendations) Shows you can own the full analytical workflow from question to action. Let me walk through what each one looks like in practice. Project 1: The Business Question AnalysisWhat it proves: You can take a vague business question, figure out what data you need, write the queries, and produce a clear answer. Example using Summit Adventures: "Lindsey, the CEO, asks: Which customer segments should we focus on for next quarter's marketing budget?" Your approach:
What makes this portfolio-worthy: It's not the SQL (which is intermediate-level CASE WHEN + GROUP BY). It's the analysis.
You'd write up: "19 VIP customers (1.9% of the base) generate 10.3% of revenue. But 479 customers ā nearly half ā have never made a purchase. The biggest marketing lever isn't upselling VIPs; it's converting Never Purchased into Light customers. Even moving 10% of that group (48 customers) to a single booking at the average Light value ($1,057) would add $50K in revenue." That's the kind of thinking that gets you hired. Project 2: The DashboardWhat it proves: You can take SQL results and present them visually for executives. This is where tools beyond SQL come in. A Tableau dashboard, a Power BI report, or even a Python dashboard with Plotly or Matplotlib. Your Project 1 data is the foundation. Take those customer segments and build:
You don't need to learn Tableau or Python deeply to build one portfolio-quality dashboard. You need to learn enough to present one analysis well. The SQL is the hard part. The visualization is the finishing touch. If you've been wondering whether to learn visualization tools alongside SQL, this is why. Not because you need them for every analysis, but because a well-presented dashboard is what makes a hiring manager say "this person can communicate findings." Project 3: The End-to-End AnalysisWhat it proves: You can own the entire workflow: question, data, analysis, and recommendations. This is your capstone piece. Pick a realistic business question, document your entire process, and present findings with actionable recommendations. Example: "Question: Where is Summit Adventures losing money, and what should they do about it?" Your analysis would include:
The write-up matters more than the code. Document your thinking. Explain why you chose these metrics. Show how your findings connect to business outcomes. How to Structure Your PortfolioKeep it simple. You don't need a personal website (though it helps). A GitHub repository with clear README files works well (especially if you are focusing on SQL and more technical roles).
Each project takes 4-8 hours. That's 12-24 hours total for a professional portfolio that stands out from tutorial screenshots and Kaggle competition entries. What Hiring Managers Actually Look ForāI've reviewed portfolios when hiring analysts, and here's what separates the ones that get interviews: They care about:
They don't care about:
Try This Over the Next Month
By the end of the month, you'll have something to link on your resume that demonstrates real analytical thinking, not just SQL syntax snippets. Until next time, Brian P.S. SQL for Business Impact walks you through exactly this kind of business analysis across 8 modules. Every module ends with a real business scenario where you produce executive-ready insights ā the kind of work that builds a portfolio naturally. Check it out at sqlforbusinessimpact.com. P.P.S. If you've built a portfolio project you're proud of, hit reply and share it. I'd love to see what you're working on. I read every response. |
Learn to build analytics projects with SQL, Tableau, Excel, and Python. For data analysts looking to level up their career and complete beginners looking to get started. No fluff. No theory. Just step-by-step tutorials anyone can follow.
Quick note: Before you read this week's newsletter, can you fill out this 5-minute subscriber survey so I know what you want to know more about? I've got a mix of SQL and AI & Agentic Analytics right now. Thanks in advance! Hello Reader, A manager sends you a database login and says, "Can you pull a few customer insights before Friday." You connect to the database and you pause: Because, as a business analyst, there are two ways to respond: Panic and start feverishly writing the SQL, joining...
Hello Reader, This week's newsletter is different. No SQL code. No database queries. I lead a team of 30 data professionals, and we use tools like Claude and Copilot to get oriented, draft, review, and explain routine analysis. The useful part is moving faster without handing over the judgment your team relies on. We call this "human in the loop". Agentic Analytics means using AI as part of your analytical process: give it context, check its work, and keep responsibility for the decision. I...
Hello Reader, Real quick: if you haven't completed this subscriber survey -- now's your chance. Most people are looking to learn more about Agentic Analytics and AI topics. I want to build something that would be useful to you, based on the work I've been doing for the past year or so. Interested? Take 5 minutes to let me know what's on your mind. Take the 5-Minute Survey Now š Imagine it's your first week at a new job. Someone from IT sends over database credentials and a two-line email:...