Transportation and Shipment Analysis

Akhila Gujjala

1.Which dataset did you use?

Transportation and Shipment Analysis.dva

I used a comprehensive Transportation & Shipment dataset containing shipment-level details such as:

Shipment ID
Customer and Supplier information
Route and Region details
Shipment Type and Material
Distance (KM)
Delivery Time (Actual)
SLA Time (Expected Delivery Time)
Cost of Shipment
Priority (High, Medium, Low)
On-Time / Delay status

This dataset enabled end-to-end logistics analysis, including delivery performance, cost efficiency, SLA compliance, and operational bottlenecks.

2. How did you analyze or prepare the data?

I performed data preparation and transformation within Oracle Analytics Cloud (OAC) by:

I performed data preparation and transformation within Oracle Analytics Cloud (OAC) by:
Standardizing key measures such as:
Delivery Time
, Distance
, Cost
Creating calculated KPIs:
Total Shipments
On-Time %
Delay %
Average Delivery Time
Total Cost
Designing filters:
Region
Supplier
Shipment Type
Priority
Structuring data to support:

Region-wise performance
Cost vs efficiency analysis

3. Who is the intended audience for your visualization?

This dashboard is designed for:

Operations Managers → to monitor delivery efficiency and delays
Logistics Teams → to optimize routes and supplier performance
Supply Chain Analysts → to analyze cost, SLA compliance, and performance trends
Business Leaders / Decision-Makers → to improve operational efficiency and customer satisfaction

4. What is your visualization about, and what problem does it address?

This dashboard provides a complete view of transportation and shipment operations, focusing on:

Delivery performance
SLA compliance
Cost efficiency
Route and supplier effectiveness

It answers key business questions:

How efficiently are shipments being delivered?
Which routes and suppliers are causing delays?
Are we meeting SLA commitments?
Is cost impacting delivery performance?

The dashboard helps to:

Identify high-delay routes and regions
Detect SLA breaches and operational inefficiencies
Analyze cost vs performance trade-offs
Improve customer delivery experience

5. Did you use any Oracle Analytics AI features? If so, how?

Yes, I used Oracle Analytics AI capabilities to enhance the dashboard:

Generated AI-driven insights highlighting:
High delay rates

Underperforming routes
Identified key drivers of delays, such as:
Specific regions
Supplier inefficiencies
High-priority shipment delays

These features helped convert data into actionable intelligence rather than just visualization.

6. Did you upload your visualization image and DVA file?

Yes, the dashboard image and DVA file have been successfully uploaded, ensuring:

Full reproducibility of the analysis
Easy access for evaluation
Complete demonstration of the dashboard design and functionality