powerBi Stocks analysis
This Power BI dashboard analyzes stock performance for a group of major tech and retail companies, including Amazon, Apple, Microsoft, Netflix, Google, Shopify, Home Depot, and Walmart. The report tracks metrics such as price trends, gross profit, market cap, and PE ratio over time. By combining historical performance with comparative financial indicators, the dashboard supports a deeper understanding of each company’s position in the market.
Video Project Walkthrough:
Dashboard Key Insights
The dashboard offers a side-by-side look at how these companies compare across valuation, profitability, and stock behavior. Amazon leads in gross profit, while Shopify shows the highest PE ratio, suggesting growth potential but also elevated investor expectations. Home Depot, in contrast, has a much lower PE ratio, which may indicate a more stable or mature valuation.
The line chart tracking daily closing prices highlights strong upward trends in companies like Shopify and Amazon, with significant gains throughout 2020 and early 2021. Apple and Microsoft also show consistent growth but with lower volatility.
Market cap distribution shows that Amazon, Apple, and Microsoft make up the largest shares among the group, accounting for over 65 percent of the total market cap represented. This concentration may influence broader market movements more heavily.
The “Worst Performing Stock” view helps pinpoint periods of weaker performance, particularly across select months. Shopify and Microsoft are noted for larger dips in certain months, which could be tied to earnings reports or broader market corrections.
Overall, the dashboard offers a balanced view of short-term movement and long-term financial strength. It helps frame how each company is performing in context, making it easier to compare risk, value, and growth across the group.