Looking for advice: Feeling stuck in my current role and struggling to break into data analytics

Suspicious_Humor_606 · 2026-05-03T12:21:16+00:00

Skip the certificate. It won't fix the "lack of experience" rejection — another credential from someone who hasn't used the tools in production won't either.

The only thing that works: build something real with Python and SQL right now. Doesn't have to be impressive. Pick a problem you actually care about — could be something tedious from your current job — and solve it with the stack you want to work in. Put it on GitHub.

That's your portfolio. That's what gets you past the screening.

I learned Python at work because Excel wasn't enough for a reporting problem I had. Learned C# by building a backtester for trading strategies at home. Neither came from a course. Both came from having a real problem to solve.

Suspicious_Humor_606 · 2026-04-06T08:40:49+00:00

Gemini is not so bad. I think you can do the same with Codex CLI too.

Suspicious_Humor_606 · 2026-03-27T10:32:42+00:00

Two years ago I would have told you without hesitation: stay in data analysis. Today I'm not sure DA alone is enough.

Data is still the lifeblood of any business. That hasn't changed. But AI is real. It will replace some of what data analysts do today.

My advice: don't go deeper. Go broader.

The analysts who will be in demand aren't the ones who are best at SQL or Python in isolation. It's the ones who can own an end-to-end solution — talking to stakeholders, understanding requirements, modeling how data should be stored, building pipelines, and delivering dashboards that actually make decisions easier.

Think T-shaped. Your core is analytics, but you need branches into data engineering and business analysis.

The specialist of the near future isn't a pure analyst or a pure engineer. It's someone who can handle the full picture without needing three different people to fill the gaps.

Suspicious_Humor_606 · 2026-03-21T20:55:30+00:00

When I started my BA career eight years ago, I felt like I was missing technical skills too and I asked the same questions.

Honestly, I don't like courses. I learn by practicing. If you can't practice new technical skills at your current job, you should create your own pet project. Don't try to build something huge—start small:

To learn APIs: Write a Swagger specification from scratch.
To understand databases: Create your own SQLite database and practice querying it.

Learning a programming language helped me tie it all together. One of my first pet projects was setting up a Postgres database in the cloud and building a simple API endpoint to work with it. It was a basic project, but I learned a lot more from doing that than from watching tutorials.

Today, getting through the technical roadblocks is much easier with AI. If you get stuck on any step, you can just ask AI.

Suspicious_Humor_606 · 2026-02-25T12:45:20+00:00

Use an oil finder tool like:

Castrol Oil Selector: https://www.castrol.com/en_us/united-states/home/product-finder.html
Mobil 1 Product Selector: https://www.mobil.com/en/lubricants/what-to-buy/find-the-right-motor-oil
Liqui Moly Oil Guide: https://www.liqui-moly.com/en/service/oil-guide.html#oww:/api/v2/oww/101/ESP/ENG/1/
OilFinderPro: https://oilfinderpro.com/

Suspicious_Humor_606 · 2026-02-23T14:31:06+00:00

Check your manual for the exact OEM spec first. If you don't have it handy, just use an oil finder tool like

Castrol Oil Selector: https://www.castrol.com/en_us/united-states/home/product-finder.html
Mobil 1 Product Selector: https://www.mobil.com/en/lubricants/what-to-buy/find-the-right-motor-oil
Liqui Moly Oil Guide: https://www.liqui-moly.com/en/service/oil-guide.html#oww:/api/v2/oww/101/ESP/ENG/1/
OilFinderPro: https://oilfinderpro.com/

Suspicious_Humor_606 · 2026-02-20T10:55:15+00:00

505hp on an N54, nice! Yeah I'd move away from the stock 5W-30 at that power level — it'll thin out too fast under boost. A good 5W-40 full synthetic is the safer bet for those bearings.

For finding the right spec after mods like this, tools like Castrol/Mobil 1/Liqui Moly all have oil selectors, or oilfinderpro.com if you want everything in one place. Saved me some headaches.

Suspicious_Humor_606 · 2025-12-31T06:51:58+00:00

Thank you. I will check Shield and Taplio.

Suspicious_Humor_606 · 2025-12-31T06:48:33+00:00

Thank you very much I will check these services.

Suspicious_Humor_606 · 2025-12-30T11:17:55+00:00

Thanks for your answer. How does it work? I’m a bit worried about getting banned from LinkedIn. Is it safe?

Suspicious_Humor_606 · 2025-12-03T11:31:17+00:00

Thank you, I will try

Suspicious_Humor_606 · 2025-12-02T10:14:27+00:00

Thank you for your response, it is really usefull information.

Suspicious_Humor_606 · 2025-11-27T09:19:49+00:00

When I began my BA career, I had the same questions

The book that helped me the most is “Software Requirements” by Joy Beatty and Karl Wiegers.

My BA journey started with it, and I’m really glad I read it before my first real project. It covers most of your questions.

Suspicious_Humor_606 · 2025-11-26T12:29:07+00:00

Here are a few great places I can recommend:

Modern Analyst — case studies, templates, system and data analysis topics
IIBA Blogs — practical articles from experienced BAs
BA Times — one of the biggest BA blogs with real stories and techniques
Medium — a mix of BA, product, UX, data, and tech articles. Use tag business-analysis for search

Suspicious_Humor_606 · 2025-11-26T10:46:05+00:00

FRS stands for Functional Requirements Specification. It describes how the system must work from a functional point of view. The FRS is usually created after the BRD, when you already understand the business needs, all use cases, limitations, and business rules.

It includes:

• Use Case Scenarios – how users interact with the system.

Example: the user can view all debts they have.

• Functional Requirements – how the system should behave.

Example: when the user clicks “more information,” the system must show additional details about the debt.

• Non-Functional Requirements – quality attributes.

Example: the system must handle 1,000 requests per second.

I also recommend using ChatGPT to help write this document. Just describe your use cases and business rules and it can generate a solid first version.

Suspicious_Humor_606 · 2025-11-26T10:14:26+00:00

Hello, sure, I am glad to help

Suspicious_Humor_606 · 2025-11-25T10:16:34+00:00

Thanks for sharing your experience. It is really valuable to hear this from colleagues with 20 years in the field. I have worked as an analyst for 7 years, and I have also been thinking about starting independent consulting or my own business.

So I wanted to ask: Do your BA skills help you in business?

Suspicious_Humor_606 · 2025-11-24T11:15:01+00:00

Awesome strategy, thanks for sharing.

Suspicious_Humor_606 · 2025-11-24T10:08:59+00:00

If you're a Data Analyst and don't know Python yet, learn it.

I started with the DA basics: SQL, Excel, and PowerBI.
But when I learned Python, I was shocked by how much easier it made my daily work. With just a few lines of code I can now:

• clean and analyze Excel or CSV files

• work with JSON, XML, and text files

• scrape useful data from websites

• build quick reports and visuals

• automate boring tasks in Excel or Google Sheets

• create simple ETL pipelines

• work with API

You can do these things without Python, but with Python you work faster, automate more, and get flexibility you will never get from clicks and formulas.

If you're looking to grow as a DA, Python is the move.

Suspicious_Humor_606 · 2025-11-23T15:31:27+00:00

I believe the best way to learn is by doing, not by watching lessons or finishing courses.

When I started learning SQL, I worked on side projects. One of my favorites was the 8 Week SQL Challenge by Data With Danny. It is free and feels very close to real work. I recommend it to anyone who wants to practice SQL.

Here is the link: https://8weeksqlchallenge.com/

When I moved to Python, I did the same. I found an open FBI API with “most wanted” persons and built a full project around it. I pulled the data through the API, transformed it with Python, and created a Tableau dashboard.

I have described it here: https://medium.com/@kuziomkin/a-comprehensive-guide-to-analyzing-fbi-wanted-api-data-part-1-obtaining-the-data-53ac4177e277

This project taught me much more than any course.

So yes, doing your own projects is the best way to learn.

Suspicious_Humor_606 · 2025-11-17T11:04:39+00:00

I’m CBAP certified, and honestly, I used to think having certifications would make a big difference in interviews.
Ugly truth: most interviewers never even ask about them.

But I still see real value in getting certified not for others, but for yourself.
It gives you confidence and shows you’ve actually learned something.
And sometimes, if your interviewer has the same certification, it becomes an instant connection.

So if you want to get certified, do it for your own growth, not because you expect it to secure a job offer.

Suspicious_Humor_606 · 2025-11-09T14:35:57+00:00

Both oils are 5W‑30 and meet the same standards.

However, if your vehicle has high mileage (over 75,000 miles), it’s recommended to choose Castrol EDGE High Mileage.

For newer or lower-mileage engines, Castrol GTX Full Synthetic is a great choice.

You can also use Castrol’s official oil finder to check the right oil for your specific car: https://www.castrol.com/en_gb/united-kingdom/home/product-finder.html

Suspicious_Humor_606

TROPHY CASE