📄️ Course Overview
In 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
In 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
In 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.
📄️ Visualizing data in charts
In episode 9 of our series on Hex fundamentals. In this episode, we show you how to enhance the visual quality of your Hex projects through charts. We cover building charts with no code, custom color palettes, and how you can build charts directly in SQL! Hex is a collaborative workspace for exploratory analytics and data science. With Hex, teams can quickly reach insights in AI-powered notebooks using SQL, Python, & no-code, and instantly share their work with anyone.
📄️ Input parameters
In episode 10 of our series on Hex fundamentals. This episode is all about interactivity and how you can make your Hex apps more dynamic. We cover each input parameter giving you a taste of what it can do. Next episode, we’ll dive into a more real world setting around using input parameters. Hex is a collaborative workspace for exploratory analytics and data science. With Hex, teams can quickly reach insights in AI-powered notebooks using SQL, Python, & no-code, and instantly share their work with anyone.
📄️ Parameterization with jinja
In episode 11 of our series on Hex fundamentals. In this episode, we expand on the world of interactivity and making Hex more dynamic. Using jinja, we show you how you can add parameterization throughout your entire project. Hex is a collaborative workspace for exploratory analytics and data science. With Hex, teams can quickly reach insights in AI-powered notebooks using SQL, Python, & no-code, and instantly share their work with anyone.
📄️ Map cells and geospatial data
In episode 12 of our series on Hex fundamentals. We leave the comfort of our humble abode (or office) and begin traveling the world through the art of cartography. In Hex the map cells is one of the many no code cells that makes it super easy to get some geospatial data visualizations up in no time! Hex is a collaborative workspace for exploratory analytics and data science. With Hex, teams can quickly reach insights in AI-powered notebooks using SQL, Python, & no-code, and instantly share their work with anyone.
📄️ No code transformation cells
In episode 13 of our series on Hex fundamentals. In this episode, we dive into the under appreciated art of not coding. Yes, you heard that right. In this video we will not be writing a single line of code as we explore filter cells and pivot tables. Hex is a collaborative workspace for exploratory analytics and data science. With Hex, teams can quickly reach insights in AI-powered notebooks using SQL, Python, & no-code, and instantly share their work with anyone.
📄️ Apps and publishing
In episode 14 of our series on Hex fundamentals. In the final episode, we show you how Hex isn’t too dissimilar from most multiplayer games. We show how to leave comments for your teammates, jump in a project, make some edits, then turn all of that into an app once finished. It concludes with a demonstration of sharing apps and publishing them. Hex is a collaborative workspace for exploratory analytics and data science. With Hex, teams can quickly reach insights in AI-powered notebooks using SQL, Python, & no-code, and instantly share their work with anyone.