How to build a KPI dashboard from warehouse SQL with an agent with DBT Charts

Related use cases from other repos

• Forecast future candlesticks from one price history

  Load a pre-trained Kronos model and get a forecast of future OHLCV candles from your own historical data.

  • Kronos
  • Data and analytics
  • Intermediate
  View prompt

  Using the Kronos repo, load NeoQuasar/Kronos-small with its tokenizer, forecast the next 120 candles for <CSV path with open, high, low, close columns and timestamps>, and return the pred_df table. Verify that the forecast index matches the y_timestamp values you passed in and that the lookback is no more than 512 rows.

  Share Save

• Measure shelf attention from a fixed store camera video

  Run the gaze pipeline on a fixed-camera clip to rank which shelf zones draw attention.

  • Brandpose
  • Data and analytics
  • Intermediate
  View prompt

  Using the repo escudero/brandpose, run scripts/gaze_sim_v2.py on the fixed-camera video at <video path> with --max-seconds 60, using the flags in the README. Report the number of estimated gazes, shoppers and zones with attention, and the output folder. Verify that outputs/v2 contains results and that the attention figures are labeled as model estimates, not ground truth.

  Share Save

• Check delayed IHSG quotes and valuation from a terminal

  Install Idx and pull delayed prices, P/E and dividend yield for several IDX tickers in one command.

  • Idx
  • Data and analytics
  • Intermediate
  View prompt

  Use the idx command from the fzn0x/idx repo to fetch quotes for <tickers such as BBCA,BBRI,TLKM> by running `idx -o json stocks quote <tickers>`. Return price, change percent, P/E and dividend yield for each ticker as a short list. Verify that the response includes a last trade timestamp and state that the data is delayed.

  Share Save

Disclaimer

Deduped lists open-source repositories that belong to other people. We do not own, maintain, audit, or vouch for any of them, and a repo appearing here is not an endorsement or a safety check. The use cases, steps, and prompts are written by AI and may be incomplete, outdated, or just wrong. Where a use case is marked "Seen in the wild", we link to public posts where someone described something similar, but we have not verified those posts and the use case itself is still our AI's own write-up. Use all of this at your own risk. Only run code, commands, or agents on systems and accounts you are authorized to use, and read the code and every command before you run it, especially anything that touches credentials, files, or the network. Nothing here is professional, security, legal, or financial advice. All trademarks and project names belong to their respective owners, and their use here does not imply affiliation. Content is provided as is, without warranties of any kind. Found a mistake, a safety problem, or something you want removed? Email [email protected] and we will look at it promptly. Full disclaimer page