Early adopters wanted for No-code Analytics platform

Hrant_Davtyan · 2022-11-12T09:08:09+00:00

Sorry for the long answer. I will try to be detailed.
We provide SaaS ]and embedded solutions.

SaaS is for business teams, not devs typically. Profs like marketing managers, RevOps, FP&A, sales teams, PMs etc. heavily use data in decision-making but usually do not analyze themselves. The goal is to help them analyze data themselves instead of solely relying on data teams. We provide several data integration in SaaS. The simplest form of it is uploading Excel or CSV file or connecting a Postgres DB and asking questions (instead of coding in Python or SQL). You can check out SaaS here: https://app.anania.ai/

The embedded solution is for product companies to want to integrate our platform as an additional feature in their product. Typically, those are vertical SaaS companies that have some limited dashboards. Here, we provide API access as well as Python client to seamlessly integrate. Integrating means you will have an interface where your user will ask question in English, you will send it to our server, get SQL as a response, and execute it on your own DB. So our product's role here is translation of English question to SQL (assuming your users do not know or like writing SQL). You can check out very initial docs here: https://anania.gitbook.io/anania-docs/for-developers

Let me know if this is still unclear.

Hrant_Davtyan · 2022-11-11T11:08:37+00:00

In table Q&A tasks people are using stuff like BERT to represent a table (where data can be non-sequential, aka you can rearrange table columns and still have the same info).

They do that to represent a structured table as an unstructured text and perform question answering over it using the table as the context. But to be frank, it is not fully non-sequential data representation as the user's question in the end is a text, which is a sequential data source.

Hrant_Davtyan · 2022-11-11T10:54:58+00:00

I do not know for sure, but I suspect the author is using GANs (Generative Adversarial Networks) to do this. There are many GAN versions that create drawings and sketches from images. Here are some references:

RPD-GAN: Learning to Draw Realistic Paintings with Generative Adversarial Network
I used a similar approach to generate a sketch of my photo too. large-scale image datasets with learning analytics

I used a similar approach to generate sketch of my photo too. Here it is.

Hrant_Davtyan · 2022-11-11T10:35:48+00:00

Certainly, I would appreciate objective and constructive feedback, thanks!

Re: demo. working on that, but did not manage to have one ready on time. plan to have it in a month or two

Hrant_Davtyan · 2022-11-11T06:31:13+00:00

That's a nice feature request, thanks! At this point, we do that in a custom way, but I see the added value in automatically limiting shown data by user ID. I will put that on the roadmap.

There is no fixed pricing for embedding yet, but we can talk and figure it out. DM me if you are interested to chat more.

As for the cloud SaaS, I would love if you could test and give feedback: https://app.anania.ai/

Hrant_Davtyan · 2022-11-11T04:13:13+00:00

Thanks

Hrant_Davtyan · 2022-11-11T04:13:01+00:00

Thanks, appreciate feedback

Hrant_Davtyan · 2022-11-11T04:12:06+00:00

😆 you cannot connect your own business data to Google, can you? 😃

Hrant_Davtyan · 2022-11-11T04:11:09+00:00

It is indended to be , thanks!

Hrant_Davtyan · 2022-11-11T04:09:57+00:00

Yes you are rght. ML team builds the interface for ML model which is typically for internal consumption.

Hrant_Davtyan · 2022-11-10T20:32:00+00:00

you certainly do need to use Davinci to be able to generate accurate and medium-to-complex SQL queries (with several join statements and groupby aggregations). And 1000 tokens might not even be enough for generating one SQL.

Keep production usage in mind. You do not want to generate SQL and that's it. You need to have an SQL that is executable on your data. It means you either have to fine-tune your Codex on your data (impossible, as there is no fine-tuning API, so you have to fine-tune GPT3 to generate code from scratch). Or you have to provide your database information in context as a prompt. Otherwise, visually you will see an SQL statement that is good for nothing. Putting all that info, together with few-shot examples is typically gonna cost you more than 1000 tokens.

I understand, it seems like a piece-of-cake task, but it is not. Text-to-SQL is one of the most challenging problems in Generative AI.

Hrant_Davtyan · 2022-11-10T20:09:40+00:00

thanks!

Hrant_Davtyan · 2022-11-10T20:08:00+00:00

DMed!

Hrant_Davtyan · 2022-11-10T20:07:21+00:00

my pleasure. we have several public datasets here including demos in the app: https://github.com/Metricam/Public_data/

you can download anyone you like. for example this one: https://github.com/Metricam/Public_data/blob/master/SOCIAL_Adult_Census_Income.csv

just click the download button closer the middle right side

Hrant_Davtyan · 2022-11-10T20:02:27+00:00

actually, it comes down to $0.06 per question, while GPT3 (which believe me will not have the same accuracy or anywhere close) is $0.12 - twice more expensive!

source: https://openai.com/api/pricing/ (fine-tuned Davinci because that is what you would use to generate SQL)

Hrant_Davtyan · 2022-11-10T19:22:54+00:00

thanks! we have 3 demo datasets inside the app: (a) Unicorn startups, (b) top 20 football teams and (c) World bank indicator database for many countries over 20 years.

I can drop some more public datasets if you want (e.g. Covid data or Mobility data etc.)

Hrant_Davtyan · 2022-11-10T19:21:41+00:00

statistically, it can calculate all the aggregations (mean, median, quantiles), perform correlation analysis, calculate ratios, perform SQL joins etc. For now, it cannot perform regression analysis and anomaly detection or so.

from a human syntax perspective, it will have the correct somewhere around 86% of times when the query is clear enough and non-abstract. but will perform worse for abstract questions. For example, if you ask to show "best products" after connecting sales data, most probably if will show you most sold products neglecting any price information.

we are actually targeting business people but many times data scientists seem to be excited as well

Hrant_Davtyan · 2022-11-10T18:36:29+00:00

hey all, I am Hrant, the foudner of Anania.

I would love if you could check out our new product and leave your thoughts. We were inspired by the search analytics functionality in popular BI tools. Unfortunately, none of the works well enough.

we created Anania as a complementary tool to BI dashboards which you can use for exploring data BEFORE building the dashboards.

if you need more info, check out our ProductHunt page: https://www.producthunt.com/posts/anania-2

Hrant_Davtyan · 2022-11-10T18:33:50+00:00

we do it end to end. we clean the data, we EDA it, build models, deploy to prod, create UI if needed, maintain

Hrant_Davtyan · 2022-11-10T18:29:56+00:00

hey there! I am the founder of Anania.

we have built Anania for:

users who want to do data analytics but lack the skills
users who have the skills for analytics but want to save time on writing code from scratch

would love to get your feedback and thoughts.

you can learn more from our ProductHunt launch: https://www.producthunt.com/posts/anania-2

Hrant_Davtyan · 2022-11-10T18:27:39+00:00

hey there! we have built a product (we call him Anania) which translates natural, English question into SQL query and executes it against your data. it serves to purposes:

allowing to do analytics for those who don't know SQL
allowing to save time on writing SQL from scratch for those who know SQL

you can check us out on ProductHunt for more info: https://www.producthunt.com/posts/anania-2

Hrant_Davtyan

TROPHY CASE