📄️ Course Overview
This introductory course overview video will introduce you to the high-level capabilities of Hex. Learn how data scientists and data analysts use Hex to supercharge their data workflows.
📄️ Navigating the UI
Episode 2 of our Hex Foundations video course continues with a walkthrough of the Hex UI, providing insight into its layout and how to navigate it. We introduce you to the Notebook view, the core workspace of all the analysis you’ll ever do in Hex. We will guide you through adding and deleting cells, highlight the types of cells you can work with, and give you a glimpse of writing SQL code in your projects. With each step along this path, you’re inching closer to becoming a Hex master!
📄️ Getting data into Hex
Episode 3 of our Hex Foundations course shows you how to upload files to your Hex projects or connect data from a data warehouse or cloud storage integration. We also cover the Notebook view sidebar and how to manage multiple data sources in one project.
📄️ Writing SQL in Hex
In Episode 4 of our Hex Foundations video series, we will show you how to write SQL code in Hex so that you can analyze your data and build complex analyses. We'll show you how to configure SQL cells, write queries, chain SQL cells together to develop CTEs that are easier to read and debug, and how to work with large datasets using query mode and other Hex features.
📄️ Writing Python in Hex
In Episode 5 of our Hex Foundations video series, we cover how Python behaves in Hex projects, and how to write Python code in Python cells in your Notebook view. Learn about package installs, output variables, environment variables, and more.
📄️ Polyglot workflows
In Episode 6 of our Hex Foundations video series, we explore polyglot workflows in Hex. Leave behind the mess of database connection tools and the need to download SQL results as a CSV file. With polyglot workflows in Hex, you can effortlessly switch between SQL and Python to meet all your analytical needs.
📄️ How projects are executed
In Episode 7 of our Hex Foundations video series, we unveil the magic behind project execution. Learn about the project kernel, the little engine that powers the notebook experience, and what happens when the kernel gets into a stale state. At the end, we'll share some tips on how you can tailor the execution of your projects to your needs.
📄️ Adding context
In Episode 8 of our Hex Foundations video series, we discuss how to add helpful context and narrative to Hex projects to communicate insights and bring stakeholders along for the ride. We cover Text and Markdown cells, Single value cells, and Table display cells.