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.
Tableau is considered to be the leader in this industry.
Scott, Thanks! Tableau looks exactly like what I’m looking for.
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.
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.
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.