Systems | Development | Analytics | API | Testing

Businesses have been scaling rapidly in the cloud, driven by the pandemic and lured by the promise of agility and flexibility. But here’s a dirty little secret anyone who works in data knows. Despite the value of the cloud, tons of data hasn’t made it there. So, where is it? Spreadsheets. Still the stalwart workhorse, hero, and bane of the business world. We all love how Google revolutionized this world by bringing spreadsheets to the cloud.

SQL is the universal language of data modeling. While it is not what everyone uses, it is what most analytics engineers use. SQL is found all across the most popular modern data stack tools; ThoughtSpot’s SearchIQ query engine translates natural language query into complex SQL commands on the fly, dbt built the entire premise of their tool around SQL and Jinja. And within your Snowflake data platform, it’s used to query all your tables.

I’ve been following the Streamlit framework for a while, since Snowflake announced that they would acquire it to enable data engineers to quick spin up data apps. I decided to play around with it and see how we could leverage the speed of creating an app along with the benefits that ThoughtSpot provides, especially around the ability to use NLP for search terms. Streamlit is built in Python.

If you haven’t heard of dbt, you’re missing out on one of the hottest technologies in data. dbt has been adopted by more than 15,000 organizations looking for a SQL-friendly workflow to transform the data inside their cloud data platform.

The difference between consuming data and actioning it often comes down to one thing: effective data visualization. Case in point? The John Snow’s famous cholera map. In 1854, John Snow (no, not that one) mapped cholera cases during an outbreak in London. Snow’s simple map uncovered a brand new pattern in the data—the cases all clustered around a shared water pump.

Data modeling is the process of organizing your data into a structure, to make it more accessible and useful. Essentially, you’re deciding how the data will move in and out of your database, and mapping the data so that it remains clean and consistent. ThoughtSpot can take advantage of many kinds of data models, as well as modeling languages. Since you know your data best, it’s usually a good idea to spend some time customizing the modeling settings.

Think about the times you've wished you had more insight into your business data. Or all of the times you wished you could answer questions about your business performance without waiting for someone else to get back to you. Gone are the days when businesses rely solely on IT staff to provide reports and analytics. With self-service business intelligence (BI), users can create their own reports, dashboards, and data visualizations without relying on IT help.

As ThoughtSpot’s SVP of Corporate Marketing I oversee a field marketing team that acts as the glue between our Marketing and Field Sales teams. When people talk about field marketing, they’re often just thinking of events — but we have a far broader remit than that. Each member of the Field Marketing team sits within a specific sales region, acting as a kind of regional CMO.

In 1895, a German physicist was trying to determine if he could observe cathode rays escaping from a glass tube and noticed an unexpected glow on a fluorescent screen several feet away. On further examination, it turned out to be a different kind of radiation that we now know as X-ray. Fast forward to today and you can’t even imagine diagnosing many medical problems without the X-ray.

Every data team wants to make insights more actionable for frontline business users. The only question is how. You know they spend the majority of their time in business-critical tools like HubSpot, Slack, and Microsoft Teams. So why not bring the data-driven insights created in ThoughtSpot to the apps they use most? With ThoughtSpot Sync, you can. Starting today, ThoughtSpot customers will be able to send insights directly from ThoughtSpot to Google Sheets, Slack, and Microsoft Teams.