Visual data modeling, parameters and CSV uploads are here.
We’ve been working overtime to bring some exciting new features to Sigma. It’s now easier than ever to find and explore your company data. Read on to learn more about parameters, CSV upload, modeling, better scheduling, export to Google sheets and more.
Curate Data with the Visual Modeling Layer
When Sigma launched last year, we changed the analytics game with our visual spreadsheet interface for data exploration. Now we’ve brought that same visual experience to one of the most time-consuming aspects of analytics: data modeling. Sigma’s new visual modeling layer brings the ease and collaboration you expect from our product to the traditional modeling workflow. It’s never been easier to build centralized data definitions and curated starting points for analysis—allowing data teams and business experts to work in collaboration.
Here’s what the first wave of our new modeling features look like:
- Data catalog: Every table in your connected database is automatically added to Sigma’s new data catalog. All existing descriptions are pulled in and made clearly visible, bringing context to your data. Admins can easily add new descriptions to tables and columns, helping guide other Sigma users. Flags can also be added, guiding users to endorsed data, and warning them away from tables that may require more knowledge to use correctly. Users can browse all of the data in the data catalog directly from the left hand navigation menu.
- SQL Runner: One of the biggest benefits of Sigma is that you don’t have to use SQL. But we know that many people still want to write queries or utilize their existing library of SQL. That’s why we built Sigma’s new SQL runner. It offers a first-class SQL experience, without the need to use other tools outside of Sigma. Browse the data catalog to select the table to run your SQL against. All of the keyboard shortcuts you’re used to are there to make your SQL writing experience seamless. Utilize auto-fill to ensure you always have the correct name. Preview the results from your SQL query or preview data from other columns. See the history of all the SQL queries you have run, so you don’t have to start from scratch. Once you have the data you want, turn the query into a Worksheet to share and explore.
It has everything you need to run SQL in Sigma.
Create Interactive Dashboards with Parameters
Parameters are a powerful tool that allows defined user input on worksheets and dashboards, replacing constant values in equations. Changing the value of the parameter can change the result of several equations in the worksheet. It’s a great way to set up user-input analysis and what-if analysis.
The best part? Creation of parameters happens through a 100% visual interface. There’s no code needed to create or modify parameters. Learn more about Parameters
CSV Upload Brings Local Data to the Cloud
Data belongs in the cloud where it’s accessible and safe. That’s why we’ve added CSV uploads to bring all of your data together in a centralized place. Sigma now has the option to allow users to upload CSV data into Sigma and have that data materialize to the data warehouse. Uploaded data can be joined to all of the other data in the data warehouse. It lets users bring the data they need into Sigma, rather than them downloading data to join it together in local spreadsheet programs. Learn more about CSV Uploads
Getting Better All the Time
At Sigma, we’re on a constant mission to improve your analytics experience. Here’s a look at some of the smaller improvements you may have noticed in Sigma that last few weeks.
- Improved Search Results: Search now allows you to filter your results. You can choose what document types you want to see and also sort based on what badge the document has.
- Custom Cron on Scheduler: Not everything fits in the standard schedule. When you need to send reports at a specific time on a specific schedule, you can now used a custom cron string to set your delivery options.
- Export to Google Sheets: Set up an immediate or scheduled export to Google Sheets. Just authorize your Google account, and then export up to 150k rows at a time.