Skip to main content

Workshop Setup

Before we dive into building with Cube, let's get your environment ready.

Prerequisites​

Cube Cloud Account​

You'll need a Cube Cloud account to complete this workshop. If you don't have one yet, we'll set one up in the next section: Deployment Setup

Local Development Environment​

For the React application portion, you'll need Node.js installed locally.

Check Node.js Version​

node --version

You should see version 20.x or higher. If you don't have Node.js installed:

Option 1: Download from nodejs.org

  1. Visit nodejs.org
  2. Download and install the LTS version

Option 2: Using Homebrew

brew install node

Code Editor​

Your favorite IDE or text editor should work just fine.

Workshop Files​

Throughout the workshop, you'll be copying code snippets and downloading starter files. All code examples will be available in this documentation.

GitHub Repository

Complete code examples and solutions are available at: https://github.com/cube-js/cube-workshop/tree/main/static

Test Your Setup​

Let's verify everything is working:

# Check Node.js
node --version

# Check npm
npm --version

# Create a test directory
mkdir cube-workshop-test
cd cube-workshop-test

# Initialize a simple project
npm init -y
npm install react

# Clean up
cd ..
rm -rf cube-workshop-test

If all commands run successfully, you're ready to begin!

TPCH Dataset Overview​

We'll be working with TPC-H data stored in an open PostgreSQL database that represents TPCH's business data:

  • Customer data - B2B companies purchasing industrial parts
  • Orders - Purchase orders with dates, priorities, and status
  • Line items - Individual products within each order
  • Parts - Industrial components and their specifications
  • Suppliers - Vendors providing parts to TPCH
  • Nations/Regions - Geographic data for global operations

This dataset provides realistic e-commerce scenarios perfect for learning analytics concepts.

Next: Let's start setting up the Cube Deployment Deployment Setup →