-
IPD Intelligence Hub — Built with AI, Powered by OAC MCP
1. Which dataset did you use? I used a custom dataset named DS_IPD_01, built on a simulated enterprise IPD (Integrated Product Development) database. The dataset contains 7 interconnected tables: Projects, Tasks, Risk_Register, Resource_Allocation, Phase_Gate_Reviews, BOM_Cost, and Monthly_Metrics — covering 10 hardware…
-
Spend Analysis Report
1. Which dataset did you use? I used the Spend Transactions dataset provided for the Challenge. 2. How did you analyze or prepare the data?I structured the Spend Transactions fields into analysis-ready attributes and measures, then built interactive views to analyze spend by invoice date, supplier, and category. The…
-
Match Rings: At-a-Glance Progress and Breakdown
I noticed that our communications office created a one-off visual ring chart for our Match Day communications and wanted to recreate that fast, at-a-glance readability in Oracle Analytics with a custom visualization focused on progress and breakdowns. I view this as a great method for conveying percentages across…
-
Global Workforce Risk Index
1. Which dataset did you use? I used publicly available, authoritative global datasets, integrated into a single analytical model: World Bank – unemployment rates and macroeconomic indicators ILO (International Labour Organization) – employment and labor force statistics OECD – productivity and workforce-related indicators…
-
Visualizing the Intersections of Data
I was inspired by some of the visualizations that our research faculty designed and wanted to see if I could reproduce it in Oracle Analytics. See the link I posted for an explanation of the use of an Upset Chart by one of its originators since it is better than I could put into words here. Which dataset did you use? An…
-
Evolution of EV Market in United States
1.Which dataset did you use? Evolution of the EV Vehicle in United States 2. How did you analyze or prepare the data? Downloaded from Data.Gov, and make use of Insights, and the Best Visualizations and the reports used in Market 3. Who is the intended audience for your visualization? Analysts, policymakers, and automotive…
-
Amusement Park Analytics Dashboard
How did you analyze or prepare the data? I cleaned the data by removing missing values and correcting errors. Then I organized the columns properly and created key calculations like total revenue, average spend, total visitors, and average rating. I also used a visibility parameter to control which visuals are shown based…
-
Commercial Performance Dashboard
These dashboards provide a comprehensive view of sales performance across products, customers, channels, and regions. It enables business and operations leaders to identify key revenue drivers, understand demand patterns, and evaluate performance across multiple dimensions. The analysis supports data-driven decisions to…
-
Auto Insurance Profitability and Risk Analysis
These dashboards analyze auto insurance performance by linking premiums, claims, and customer risk profiles through the Loss Ratio metric. It provides a structured view of where profitability is generated or lost, highlighting high-risk segments, geographic concentrations, and key drivers of claim costs. The analysis…
-
One Click. Two Dashboards. Zero Confusion. Where Sales Performance Meets Customer Voice
Built on my own dataset — AAA Reviews and Invoices — this dashboard was designed for a Sales & Marketing VP who needs fast, authoritative answers without switching tools, digging through reports, or losing the narrative. To power the analysis, I built a suite of custom calculations covering sales performance,…