Getting Started with Cosmic Frog, Part 5: Working with Data in Cosmic Frog

You’ve explored the engines. You’ve toured the platform. You’ve built your first models. Now it’s time to tackle the heart of every supply chain project: the data.

In this episode, Ved Patel from Optilogic shows you how to get comfortable working with data inside the Cosmic Frog interface. You’ll learn how to clean up your tables, filter columns by engine type, hide what you don’t need, and pin what you do — turning overwhelming spreadsheets into focused, usable views. From there, Ved demonstrates quick fixes for data errors, bulk updates that save hours, and smart shortcuts like duplicating or deleting records on the fly.

But it’s not just about editing — it’s about understanding. You’ll see how aggregations and pivot tables reveal trends in your models at a glance, and how filters (even saved “named filters”) help you zero in on exactly the slice of data you care about.

Key features explained 🏆

  • Opening an Example Model
  • Hiding Empty Columns by Technology
  • Showing and Hiding Custom Columns
  • Pinning or Freezing Important Columns
  • Finding Data-Related Errors in the Model
  • Bulk Updating Columns
  • Importing Data into Cosmic Frog
  • Adding a New Record by Duplicating Rows
  • Deleting Records from the Model
  • Summarizing and Visualizing with Excel-like Pivots
  • Getting Column Totals
  • Creating Excel-like Pivot Tables for Quick Analysis
  • Creating Custom Views with Column Filters
  • Saving Named Filters for Scenario Management

Suggested Pre-Work 💻

Before starting this E-Webinar, please ensure that you have:

Get answers to your burning questions 🔥

Ask us questions at any time during your session through private 1:1 chat.

We are excited for you to start using our product and look forward to helping you take your first step on that journey!

Ved Patel

Ved Patel
Data Scientist
Optilogic
  • Ved Patel
    Data Scientist
    Optilogic