Skip to main content
Version: 3.0.0

Otto's Expeditions (demo)

These how-to guides walk through setting up an Ascend Repository and Ascend Project for Otto's Expeditions, our premier getting started demonstration project.

Before you start your journey with Ascend, let's get acquainted with the whimsical world of Otto and the data challenges you'll solve together!

πŸ“– Otto's Lore

πŸŽ‰ Welcome aboard Otto's Expeditions as our newest Data Engineer! You'll be trotting with Otto, our visionary founder and legendary data pipeline goat.

At Otto's Expeditions, we craft unforgettable mountain adventures that are anything but baah-ring! Our expert Guides lead our valued customers (affectionately known as "Ascenders") on extraordinary journeys discovering local goat cultures.

Today, you'll start onboarding to our primary data pipelines that empower Otto's Expeditions to ascend to new heights!

πŸ—ΊοΈ Route planning system​

Our comprehensive system for designing and managing expedition routes. Let's get those hooves moving!

πŸ“¦ Route storage​

Central repository for all our tried-and-tested mountain routes.

  1. Read in route data from Azure
  2. Clean the data with Python

🚫 Route closure management​

Optimize adventure experiences by monitoring and managing route accessibility.

  1. Import and process route closure data from a CSV file
  2. Transform route information using Python
  3. Create a task to maintain a real-time route closures calendar

β›ˆοΈ Weather intelligence​

Monitor and analyze weather patterns - safety is nothing to kid about!

  1. Import weather sensors and weather routes data from GCS
  2. Combine the sensors and routes to create a unified weather dataset

πŸ‘₯ Team management​

Comprehensive oversight of our amazing expedition staff.

πŸͺ Retail and warehouse operations​

Manage our store and warehouse staff - we've goat this covered.

  1. Read in stores (Azure) and warehouse data (GCS)
  2. Consolidate staff records from warehouses and stores

πŸ§—β€β™€οΈ Guide excellence program​

Empower and support our expert mountain guides, the real GOATs.

  1. Access and process guide profiles using a Custom Python Read component
  2. Perform data maintenance tasks

πŸ’° Revenue analytics​

Track our business performance metrics - let's make those numbers climb!

  1. Aggregate sales data from our store, vendors, and website (GCS and Azure)
  2. Validate data completeness on the timestamp columns
  3. Generate unified sales analytics from all sources

πŸ’­ Customer feedback​

Collect and analyze valuable customer insights to make sure every Ascender feels herd!

  1. Read in feedback from Ascenders, stores, and the website via GCS
  2. Collect feedback from all sources into a unified dataset

πŸ“‘ Telemetry tracking​

Capture real-time expedition data to keep track of our flock.

  1. Read in telemetry from Ascenders and guides via GCS

πŸ“± Social media marketing​

Track and optimize our digital presence.

  1. Read in data from Metagram and Twitter (GCS) as well as Metabook and InLinked (Custom Python)
  2. Order all data tables by the most recent timestamp
  3. Collect all channels into one unified social media table
  4. Create a task to respond on every single post and thank the poster for their comment. You better billy-ve we value every impression!

πŸ”οΈ Ascenders dataset​

Manage and analyze customer journey information to ensure everyone is hooving a great time!

  1. Combine the staff, routes, guides, closures, telemetry, weather, sales, social media, and feedback data to build the Ascenders dataset - this one's bigger than a mountain goat's appetite!
  2. Create a SQL data quality test to ensure the dataset IDs are working as expected
  3. Create a Python data quality test to ensure the dataset is not empty

πŸ“ˆ Reporting​

Generate insights from our business data - it would behoove us to keep our metrics climbing!

  1. Create a task that uses the Ascenders dataset combined with staff and sales data to send feedback to each staff member

🐐 Goats dataset​

Celebrate our greatest-of-all-time adventurers with exclusive rewards - they've really earned their horns!

  1. Sample the combined Ascenders, routes, and telemetry data to create the goats dataset
  2. Create a task that sends prizes to the selected goats

⭐ NPS calculation​

Monitor and improve customer satisfaction metrics - making sure nobody gets our goat!

  1. Sample the Ascenders dataset to extract metrics
  2. Use a customized application to dynamically generate the NPS categories of Ascenders:
  • Detractors (the gruff ones)
  • Neutral (the grazing type)
  • Promoters (our true mountain goats!)

πŸŽ‰ Congrats, you're all finished!​

Not baaah-d at all! You're a perfect fit at Otto's Expeditions, where business is reaching new peaks! We're not kidding when we say the sky's the limit! 🐐✨