Integrating Web Services with Microsoft Excel and Google Sheets
The "Aha" Moment: How to Onboard an API Service and Get Active Users
Introducing Serverless Data Feeds
Share Data Without Sharing Credentials: Introducing Pipe-level Permissions
Just Binge-Listened to 95 SaaStr Podcasts, Here's What I Learned
Lessons from the Data Ecosystem: Part 2
What We've Learned from Exploring the Data Ecosystem: Part 1
We're Reinventing the Query Builder (Well, Kinda)
Talking With Data Journalists: 5 Takeaways from Our Summer Research Project
Data Journalism Survey Results: Crunching the Numbers
Prepare your Data. Rinse. Repeat.
As everyone knows by now, data is the new black. Conventional wisdom says businesses will either be data-driven or be at a serious competitive disadvantage.
But, as everyone also knows by now, it takes significant effort to get raw data refined before you can extract its sweet analytic elixirs.
Flex.io is a productivity tool that falls squarely into this world of data preparation. However, data preparation is a pretty broad category itself — and can mean a lot of things to a lot of people.
So, we recently set out to create a ~1 minute explainer video to help highlight what Flex.io brings to this data preparation party:
- Get the data
- Change the data
- Use the data
It’s a seemingly basic set of steps, although in practice data preparation gets hairy pretty quickly. To make this process more efficient, you can try approaching it in a variety of ways.
One way might be to focus on the ultimate goals, such as data mapping or data discovery or data cleaning or data enrichment and so on.
Another way would be look at the types of data and the users involved – say a librarian working on cleaning up a set of civic data or a data scientist making sense out of social media data or an IT person setting up a data feed for sending purchase order data to a supplier.
Another way to approach data preparation is to determine whether the project is a one-off effort with a single set of data (static) or something that is needed again and again (repeatable). This is where Flex.io comes in.
As a bunch of data geeks, we certainly love data exploration and have done (more than!) our fair share of one-off data projects. In fact, because it’s such an important facet of the process, we’ve built exploratory functionality into the app itself (our “workspaces”). This is really useful for getting your hands dirty and prototyping processes interactively.
But — when you get down to it — the core of Flex.io is the flow.
If you’re a team of folks with a bunch of data sets flying around and are having to repeatedly transform/combine/clean them, we aim to make this process a snap. As we see it, the best kind of data process is one that’s quick to set up and valuable enough to keep running again and again.
Got a need for repeatable data flows? Give us a shout; we’d be happy to help.