Launching the Sales Pilot

Case Study: Sales Analytics with Databricks Genie

Stan Konkin

ML Content Developer, DataCamp

The data team's firehose

An overwhelmed data analyst at a desk surrounded by a flood of incoming paper tickets and question marks pouring in from three directions, busy modern office, sense of overload

Before you start

Introduction to Databricks Genie - course page

Completed Introduction to Databricks Genie
Or comfortable with Genie basics → ask, read SQL
No SQL writing, but you'll read it to check Genie

Chapter 1: Launch the pilot

A small team launching a glowing dashboard like a rocket taking off from a laptop, optimistic morning light, fresh start

Chapter 2: Go department-wide

A growing team connecting multiple data tables into one central glowing hub, more people gathering around a large screen, expansion

Chapter 3: Earn enterprise trust

A polished enterprise analytics dashboard with a protective shield emblem, executives nodding with confidence in a sleek control room

Your first scenario

A data analyst looking curiously at a single data table on a screen while a chat assistant returns an answer with a subtle hidden filter highlighted

Stakeholder → the Sales Ops Analyst
One table → payments
Ask with zero curation → spot the hidden assumption

Descriptions

A clear label tag being attached to a column of data, a magnifying glass bringing it into focus, clean minimal

Define what each table & column means
Remove guesswork on ambiguous columns
The foundation everything else builds on

Synonyms

Several different word bubbles converging with arrows into a single data column, a mapping concept, clean minimal

Map team vocabulary → real column names
"earnings", "sales", "revenue" → one column
Insurance that scales with the team

Default instructions

A data query passing through a set of preset filter rules that remove failed items, then coming out as a bar chart sorted from largest to smallest, clean minimal infographic, no text

Rules that fire on every query
Exclude failed payments by default
Sort breakdowns largest first

Entity matching

A spoken word snapping into the correct value in a short list, a connection lock clicking into place, clean minimal

Match user words → real column values
"successful" → status = 'completed'
Best on columns with a few fixed values

How to work through the course

Genie spaces list showing the "Ch1 - Start" and "Ch1 - Complete" checkpoint spaces

Best in one sitting → changes carry forward
Or finish chapter by chapter
Disconnected? Jump to a Start / Complete space

Let's practice!

Case Study: Sales Analytics with Databricks Genie