Web-based tool for Data Trending

Good Morning Brilliant Friends!

Is anyone aware of web based database tools that are ideal for data analysis and ongoing process capability analysis? Airtable is great for project management, but is extremely limited in it’s ability to crunch data.

We could use Microsoft Access, but it’s not exactly intuitive and I am hoping to find a beautiful interface like Airtable, but focused on data analysis.

Thank you!
Paul Warren

Tableau is considered to be the leader in this industry.

Scott, Thanks! Tableau looks exactly like what I’m looking for.

1 Like

Indeed. Here’s how I approach this challenge.

  • Charting is pretty basic in Airtable but if you have good data, you can make it look pretty useful to analysts and managers with very little effort and fully integrated.
  • Mapping is also pretty basic and despite good data, it won’t put a dent in any location science usability.
  • In mapping and charting, analytics (i.e., crunched data) is key - I call this viz-ready or report-ready data. It is typically summations, aggregations, etc where some degree of data science has been applied to elevate the data to tell deeper stories or explain causal outcomes.
  • I use a number of platforms to blend data science into Airtable and there’s no shortage of posts from me about this topic. Some of them are actually driven by Script Blocks like this one which allows data science solutions and machine learning to exist wholly within Airtable.

A key requirement in data science is the ability to crunch data locally (i.e., in Script Blocks, roll-ups, etc) and then push those results into other systems. Airtable has an ideal pathway in javascript for building processes to make local aggregations and computations inherently prepared for higher-level analytical conclusions.

I recommend you try looking inward by finding someone on your team that can code in javascript; use the Script Block environment a little and see if this isn’t a good approach to building a unified solution at least as it pertains to the data crunching.

The map shown below is 100% computationally dependent on a script block, but rendered as a custom Mapbox solution. It performs extensive geometries concerning distance and nearness of B2B and B2C cohorts.

Almost every one of these apps are driven by Airtable data.

I tend to steer clear of Tableau for a variety of reasons too many to touch on here - the biggest is how tightly it is tied into Microsoft and its ability to embrace web services and modern web architectures represent a retrofit into a long and storied past of desktop analytics.

Bill,

Those are some cool applications, and impressively all built with Airtable! However, I am looking for a zero-code or minimal code approach.

We are medical device manufacturer, so we will be looking at millions of data points per month over an incredibly wide variety of processing steps. We have already begun (I understand nearly finished) the process of establishing a database to collect the inspection data after each process, definitely not Airtable, but I am trying to look ahead to what we will do to actively track our process capability. We will need to leverage this data on a deep level to improve yields, etc…

If you have other suggestions, I am all ears!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.