Finding Signals

planted 30 Jul 2021 · tended 28 Sept 2026 · 🌳 evergreen

In daily life, we face questions like "Do I go to Ladakh or Kerala", "Do I invest in ₿itcoin or Ethereum" 🤔...

To arrive at a conclusion, we look for Signals 🚩...

• What was the "Avg temp of Ladakh v/s Kerala for last Y days"
• What is the "Correlation b/w price of ₿itcoin & Ethereum"

Let us take an example & try to find "Avg temp of Ladakh for last 18 days":

• Non-Coder:
  1. Find the website that provides weather info. Copy data carefully to MS Excel / Google Sheets
  2. Repeat the process until you have information for all 18 days
  3. Clean the Data, remove HTML tags, etc. Apply the formula to calculate Mean
• Coder:
  1. Find & understand the Accuweather API
  2. Call the API, slice/dice data
  3. Design a function to calculate Mean, call the function

Overall time taken: at least 1 hr 🕐

In this world of readily available data & infinite computation power, why did it take so long & why was it so difficult?💭

Why is it so difficult to play with data 😵‍💫

How can one make an informed choice if they don't have access to these basic signals🥴

💡 Idea

No-Code Smart Table

1. The User is provided with plethora of data sources

2. She chooses a data source(say, Accuweather). Sees available data in sample format.

{
  date: 2021-07-30T09:15:00-0400,
  temperature: 20,
  humidity: 40
}

3. Going to the next step shows a table prefilled with values

3. Want humidity also? Just add another column.

4. Why table you ask? Because everyone is already familiar with it. It also allows easy filtering, sorting, and applying pre-built formulas.
5. Bored of tables? No Problem. We have auto-magically generated graphs for you.

That's it. Would love to know your thoughts. Thanks for reading! :)