Learning to Analyze Portfolios as a Data Analyst (With a Financial Mindset)

1.How can I analyze portfolios using data… without ignoring fundamentals?

I’m currently training to become a Data Analyst, and one of my main goals is to apply that knowledge to financial analysis.

Over time, I’ve realized that two worlds often seen as separate can actually work together:

Classic fundamental analysis (ratios, margins, balance sheets) and modern data analysis (automation, visualization, modeling)

This post isn’t an expert guide — yet. It’s a transparent snapshot of how I’m building a hybrid framework to make smarter investment decisions.

2.Just returns aren’t enough — context matters

Many investors focus only on the stock price or PER. Others look only at past returns.

I’m learning that a portfolio has layers. It’s not just about performance — it’s about why it performs, how each asset behaves, and what value each position brings.

That’s where I see data analysis enhancing traditional finance.

3. Key fundamentals I’m currently learning

Here are some of the classic metrics I’m integrating into my learning process — and that I aim to automate in the future:

• Forward PER, PEG, EV/EBITDA: to assess valuation
• EPS growth, revenue growth, ROE: to gauge quality and momentum
• Reasonable debt levels and operating margins
• Share buybacks and dividend yield
• Competitive moats (harder to quantify, but key)
• Beta, sector, and geography: to understand risk and exposure

4.How I plan to integrate data analytics

My goal is to use tools like Python and Excel to:

• Evaluate portfolios based on those metrics
• Build custom quality and risk scores
• Automate company filtering and screening
• Visualize the impact of each holding on portfolio performance
• Study correlations, volatility, drawdowns, and sector impact

I’m not there yet — but I’m building both the technical and strategic foundation for it.

5.What I’ve done so far

• Started formal training in Data Analytics (SQL, stats, Python, viz tools)
• Built a personal watchlist of quality companies, organized by sector
• Defined my investment criteria and scoring approach
• Practiced with Excel and Power BI to explore financial datasets
• Plan to apply it in real-world projects once my course is complete

6. Final thoughts

This isn’t a how-to guide. It’s a clear intention.

I’m learning to think like an analyst — someone who combines data with judgment, and tech with strategy.

If you’re on the same journey or curious about how I apply this in future projects, feel free to follow along. I’m documenting everything as I grow.