IBM Cognos Analytics Portfolio

📈 IBM Cognos Analytics

Interactive Dashboard Development & Cloud Deployment

Overview:
This project highlights my end-to-end workflow using IBM Cognos Analytics to create dynamic, interactive dashboards that address business-critical questions. Leveraging Excel for rapid prototyping and Cognos for scalable visualization, I developed insights across vehicle recalls, customer sentiment, and profitability trends.

Tools: Cognos Analytics (Cloud), Excel
Visualizations: Bar chart, treemap, heatmap, combo line-bar chart
Focus Areas: Recall tracking, sentiment analysis, sales trends, system impact

🧪 Initial Prototyping in Excel

Early-stage Excel dashboards enabled exploratory analysis across profitability, dealership performance, and model-specific trends.

Profit by Date and Model — 📈 Monthly Profit by Vehicle Model — Line chart reveals upward trends across Champion, Hudson, LeMans, and Sabre.

Profit by Year and Dealer — 💰 Dealer Profit Comparison (2018–2019) — Bar chart visualizes dealership performance side-by-side for two fiscal years.

Hudson Model Dealer Profit — 🚗 Hudson Profit Analysis by Dealer — Dealer ID 1234 emerges as top contributor, with over $721K in profit.

Quantity Sold by Dealer — 🛒 Sales Volume by Dealer — Dealer 1288 leads with 2,644 units sold; total across all dealers exceeds 21K.

Cloud Provisioning of Cognos

Cloud instance provisioned for IBM Cognos Analytics, enabling secure dashboard development, data modeling, and exploratory analysis.

Interface Navigation & Advanced Visualization

Interactive drill-downs, filterable storyboards, and embedded analysis supported business decisions in design, outreach, and product development.

Cognos Dashboard Gallery

📊 Recalls by Model — Beaufort shows highest recall frequency across automotive systems.

Sentiment Hierarchy — 💬 Sentiment Treemap — Positive sentiment dominates customer feedback hierarchy.

Profit and Quantity — 📈 Monthly Profit & Quantity Sold — Combo chart reveals strong sales and profit surge in Q2.

Recalls by System and Model — 🔥 Recalls Heatmap — Shows concentration of Airbag and Engine issues across multiple models.

Business Scenario

How can a mid-size automotive manufacturer reduce recall incidents while improving customer satisfaction and profitability?
My dashboard surfaces strategic relationships between product issues, consumer responses, and financial trends—providing a foundation for informed decision-making in design, outreach, and resource allocation.

Key Outcomes

Transformed complex datasets into clear, actionable visual stories
Demonstrated analytical agility across platforms and use cases
Delivered insights aligned with business strategy and user experience

Lessons Learned & Next Steps

Through this project, I deepened my experience with interactive dashboard development and gained practical insight into navigating enterprise-grade analytics platforms. My next steps include integrating forecasting models and expanding interactivity through embedded filters and cross-tab panels.

Contact

Want to explore the full dashboard or collaborate on similar projects?
Let’s connect.