Hex’s first-class Python support unlocks a world of opportunity for data exploration.
With Hex, effortlessly visualize data from your SQL data warehouse using Python's robust tools like Matplotlib, Seaborn, Altair, and Plotly, ensuring a seamless transition from data storage to insightful visuals.
February 19, 2024
Hex provides a flexible workspace to parse unstructured text data and perform sentiment analysis with SQL and Python. Hex's polyglot environment means you can use Python packages like NLTK, TF-IDF, SpaCy, or just some good old fashioned regex and case statements in SQL directly against your data warehouse.
February 19, 2024
Unearth insights from your business text data using Named Entity Recognition (NER). Leverage Python libraries like SpaCy or NLTK, or employ SQL queries for precise entity extraction from your data warehouse. With Hex, it becomes easy to conduct deep-dive analyses like this comparison of entity profiles across famous Russian and American authors (spoiler: Chekhov likes "EVENTS"). Make your textual data exploration more efficient and intuitive, and let Hex transform the way you understand your data.
Understand and optimize your customer's lifetime value (CLV) with this comprehensive example of using Python and SQL to model future spending habits. You'll learn the basics of LTV modeling, explore several different scenarios like buy-till-you-die and gamma-gamma, and get a template of an interactive report on top of these models that anyone at your organization can use. Hex makes it easy to explore datasets, build complex predictive behavioral models, and then communicate findings in an interactive report— all from the same tool.
Hex provides a flexible and powerful workspace that empowers users to effectively parse unstructured text data and perform sentiment analysis seamlessly using SQL and Python. With VADER, an exceptional sentiment analysis tool, Hex allows you to gain valuable insights into the sentiment expressed by users on social media platforms regarding a wide range of topics. By leveraging VADER's capabilities within Hex, you can uncover and understand the emotional tone and opinions of social media users, enabling you to make data-driven decisions and enhance your understanding of customer sentiment.
Izzy Miller, Dev Advocate at Hex
Hex is your go-to platform for flexible time series forecasting directly with your data warehouse, enabling you to construct powerful predictive time series models using Python and SQL, without any needless data shuffling. It's particularly handy when integrated with libraries like Prophet for detailed daily temperature forecasting. Once you've nailed your model, it's simple to add interactive elements, making your forecasts not just informative, but engaging. You can take your model straight from creation to production, all from within the intuitive Hex interface. No fuss, no extra steps - just efficient, effective data science at your fingertips.
Hex simplifies linear dimensionality reduction, enabling efficient feature extraction from high-dimensional data. Whether you're visualizing high-dimensional data, discovering clusters, or training models, Hex provides a collaborative workspace that supports your preferred workflow. With seamless integration of Python and SQL, you can effortlessly apply popular techniques like PCA, ICA, and truncatedSVD.
Hex is a remarkably versatile interface for GIS and geospatial data analysis, giving you full access to the capabilities of top Python mapping libraries like GeoPandas, Plotly, and Mapbox, while ensuring a smooth integration with your data warehouse. Hex even has a native map cell for effortless visualization of geospatial data. With Hex, you're equipped with a plethora of both code and no-code tools for converting, scrutinizing, and visualizing geospatial data. When you've concluded your analysis, sharing your interactive maps and diagrams is just a few clicks away.
Discover how Hex data scientists and analysts use Hex for everything from dashboards to deep dives.
Table display cells are a way to visualize, filter, and format tabular data without writing any code. Simply choose a dataframe and use the Table display settings to apply any fitlers, change the data format of any column, hide any column, wrap text.
Chart cells let you visualize and explore the dataframes in a Hex project, without writing code.
Input parameters are a core, unique part of Hex. Input parameters can be created in the Notebook view and then added, optionally, to an app.