Hex Basics
This tutorial is intended for users with an Editor, Manager, or Admin role and includes features only available on the Enterprise plan.
This tutorial covers the basics of getting started as an Editor in Hex. We'll cover key concepts to help you confidently start building analyses in Hex. Once you’ve reviewed the basics of this tutorial, check out Hex Advanced to level up.
📒 Intro to Projects 📒
First things first, we're kicking things off by introducing key Hex vocabulary to help you better understand how to make the most of Hex.
- Projects: Projects are the main entity that you will be creating in Hex, which you can do via the green + New Project button in the upper right corner of your Home screen. Every Hex project starts as a notebook and can be published into an app.
- Notebooks: Notebooks are an interactive workspace where you can access your data, write code, analyze data, create visuals, and document your work with different cell types, assisted by Magic, Hex’s AI features.
- Cells: Cells are the main building block of notebooks. Hex has many different cell types that you can use to access data and build your analyses.
- Apps: Apps are a published subset of cells from your notebook that can be rearranged and shared with stakeholders. Apps can be built to look like evergreen dashboards, ad hoc reports, internal tools, data apps, etc.
Kickstart your analysis in a new, empty project by asking Magic a question in the purple bar. What percent has profit increased this year? How many leads does each sales team member have, and how does that compare to this time last quarter?
For another starting point, import the Dashboard template into a new project. Create a new project from your workspace’s Home screen, click into the question mark icon in the bottom left corner, select “Dashboard” under Templates, and then select Insert template from the pop up.
For some more advanced projects, browse the Use Case Gallery of sample projects to get inspired.
🛢️ Accessing Data 🛢️
Hex is quite flexible, giving you many options to access data in whichever way is easiest for you. Review the options below and choose one to get started.
- SQL cells: A classic! Add a SQL cell to your project and write a query against a data connection that an Admin has granted you access to. This query is returned in a tabular format (a pandas dataframe, for the Python savvy) that can be used in any other cell you add next.
- Browse warehouse tables: Don’t know exactly where to start? Open up the Data browser to search and explore the tables in your warehouse. Once you’ve identified a table you’d like to work off of, you can pull in the data in the cell type of your choice.
- File uploads: Have a local CSV floating around you’d like to work with? Upload it to your project in the “Files” tab of the left sidebar. Additionally, if an Admin has established a connection to an external file integration, you can access files in Google Drive, GCS, or S3.
- Pull in data via API: Just about anything you can do in Python, you can do in Hex. Add a code cell to write python and pull in data programmatically. For an example of this workflow using Google Sheets, check out this tutorial.
If you’re struggling with SQL or Python syntax, try asking Magic for help via the interlocking circles icon in the upper right corner of SQL and Code cells.
All Hex workspaces come equipped with demo data for Editors to explore. If you’re not yet set up to work with your production data in Hex, take a look at the [Demo] Hex Public Data Snowflake connection in the Data browser.
🔨 Building with cells 🔨
Hex notebooks are composed of different types of cells used to iteratively build your analysis. As a new Hex user (soon-to-be-Hexpert), we’ll start by covering three cell types that give you the most bang (insights) for your buck (time).
- Chart cells: Add a chart cell to make a rich visual of your data in just a few clicks. Whether you’d like to get a quick look at your data for some exploratory analysis or you’re building a dashboard-quality stylized viz, chart cells have you covered. Review the linked docs for the many configuration options.
- Table cells: Create a table cell to apply spreadsheet-style filters, calculations, and aggregations to your dataframe. No coding skills required 😎.
- Input cells: The very powerful lineup of input cells allows your apps to be interactive. Inputs store variables that can be referenced downstream to parameterize visuals in your app. If you imported the “Dashboard” template from 📒 Intro to Projects 📒, you’ll see a simple example of a multi-select input at work. More to come in Hex Advanced…
Along with SQL and Python, Magic is also at your disposal in Chart cells. Access Magic via the interlocking circles icon in the upper right corner of a Chart cell and have it apply an edit. For example, “Filter to orders in the last year and format these values as dollars”.
Add context to your project with Text and Markdown cells.
📊 Sharing and Publishing Apps 📊
Hex projects are private by default, meaning only you (and your Admins) have access. Review the topics below to ensure you’re making the most of Hex’s collaborative environment.
- Sharing: Share your project with teammates via the “Share” button in the upper right corner. To collaborate in the notebook, your teammate will need at least an Editor role. Check out this matrix for a visualization of who can access what. To quickly grant access to your entire workspace, flip the “Invite only” dropdown to “Everyone at your workspace.”
- Collaborating: Hex notebook’s are multi-player, meaning you and your teammates can be working in the same project at the same time (a la Google Docs, Figma, etc.). Once you’ve granted another user “Can edit” or “Full access,” they can visit your notebook, tag you in comments, or complete a review.
- App building: When your analysis in the notebook is complete, click over to the App Builder tab on the top of your screen. This is where you can add, remove, drag and drop whichever cells from your analysis you’d like to be displayed in your app. For inspiration on what’s possible, check out our Use cases page.
- Publishing: Lastly, the final step in the project lifecycle—publishing! Once your app is configured to your desires, hit publish in the upper right corner. Voila! You’ve crafted a data application that you can be shared across your team.
You made it to the end of Hex Basics 🎉. See the Hex Advanced tutorial to level up. If you’re looking for more resources, check out our Hex Foundations Video library, Use Case Library, and the rest of our Learn site.