BI Tool For Stellar Community
SCF #24 Activation Award Data Tool $27,700 View in SCF
Stellar Network integration for No-Code Web3 Business Intelligence, Community Analytics, and Visualization
Team

reach_abhinav

Project Categories

Product Type [If Services for understanding what is happening on chain (data tools)]

Section

read

Product & Architecture

DappLooker is a No-Code Web3 Business Intelligence, Analytics, and Visualization platform, that empowers projects with a suite of user-friendly tools.

 

DappLooker not only provides smart contract analytics on 15+  networks, but also provides unique and exclusive tools for community analytics, and Off-Chain Analytics and Visualizations all in an easy-to-use no-code platform. 

 

Create, Fork, Share, and Embed custom charts, dashboards, and visualizations within minutes without SQL queries. Our commitment to user-centric design and simplified data-driven decisions sets us apart.

 

The DappLooker suite includes:

Analytics - Easy and Intuitive No-Code Analyzer

AI Studio - AI-Assisted Analytics Tool

Feature Projects: The community can do analytics on the featured projects instantly.

DataBOTs - Custom data retrieving bots for your Discord and - Telegram

API SDK - Chart APIs and Robust SDK for developers

 

 

Problem Solving and Benefits:

- Analytics & Ease of Use: Community and network-level data analytics are usually complex and demand technical expertise. DappLooker removes this barrier, making it accessible to a wider audience, including developers, product managers, and marketing professionals, to analyze Stellar network data.

DappLooker no-code visual SQL editor empowers users to effortlessly query, filter, join, and group various types of Stellar data—such as Ledgers, Wallet level, and token data—with an advanced editor.

AI Studio: AI-assisted Stellar analyzer to automatically create charts queried with natural language on stellar network data such as Ledgers, Wallet level, and token data.
 

Real-time On-Demand Data: The Stellar community can seamlessly convert data, including Ledgers, Wallet level, and token data, into intelligent bots using DappLooker. These bots integrate with Discord, Telegram, and other communication platform, offering real-time, on-demand metrics presented in a visual format.

Community Empowerment: DappLooker empowers the Stellar community by providing featured projects that help to analyze Stellar data such as Ledgers, Wallet level, and token data instantly.

Integrate Powerful Analytics with Your Projects: The Stellar community will receive a developer-friendly API for the analysis built by the community on Stellar data such as Ledgers, Wallet level, and token data, and easily integrated into your projects/dApps.


- Visualization: Users can create a wide variety of charts, dashboards, and reports, making data more understandable and actionable.


- Collaboration: Stellar community will be enabled to collaborate, share, and export their analytics results, fostering a collaborative data-driven culture.


How it works and how it uses Stellar and/or Soroban.

Stellar Data Retrieval and Analysis

We will leverage Horizon APIs and other integrations like Subquery(DappLooker has integration with Subquery)  to efficiently retrieve a comprehensive set of Stellar data, such as Ledgers, assets,  wallet data, and token data.

Data Processing Strategy:

We will implement a robust Stellar network indexer and execute ETL processes on top of it. This implementation will empower the Stellar community with DappLooker Analyzer, featuring a no-code visual SQL editor that provides both read and write capabilities for streamlined data analysis.

User-Friendly Data Schema:

To further optimize the user experience, we are dedicated to defining a user-friendly data schema for effortless browsing. This will ensure that users can analyze and compare data across diverse Stellar network datasets, covering Ledgers, Wallet levels, and token data, with both read and write capabilities.

In summary, DappLooker is an innovative offering that democratizes data analytics & visualization within the Stellar Network, benefiting both technical and non-technical users with its different suits of products.

Technical Architecture Doc

https://docs.google.com/document/d/19u-4cN1FXrbBT3K5xvhvjZfDvl6aO6-j6Vi1I8aY0FI/edit?usp=sharing

Project URL

https://dapplooker.com/

Code URL

https://github.com/dapplooker

Video URL

https://www.youtube.com/watch?v=V-gUvqPMkgw&t=8s

Pitch Deck URL

https://docs.google.com/presentation/d/1NoU8VDcJ6PhrVanDN_kqv6Mg95vKGnO44sKAmOAjzqg/edit?usp=sharing

Other Chain Description

We've proudly established strategic and financial partnerships with more than 15 leading blockchain networks like Ethereum, Polygon, Celo, Moonbeam, NEAR, BNB, Gnosis, Arbitrium One, Optimism, and Avalanche. The integration with the Stellar network for the Soroban smart contract stands out due to its incorporation of DappLooker's robust analytics and visualization tools. DappLooker's developer-friendly environment is a distinctive feature, offering the Stellar community & Soroban smart contracts a suite of user-friendly tools. These encompass plug-and-play SDKs, the Soroban smart contract data API, and a dedicated focus on facilitating effortless analysis for every user on the Stellar network. This integration is tailored precisely to meet the needs of the Stellar community.

Section

read

Deliverables List

[Deliverable 1] - Stellar Network Testnet Integration for No-code Community Analytics  - 3 Weeks
 

APIs/Node Integration:

  • We will integrate Stellar network open APIs to retrieve network data. This process entails establishing a system to collect data from various sources on the Stellar testnet for integration purposes. 
  • The obtained data requires careful cleanup to extract the relevant information.
 

Stellar Network Indexer Development:

  • We plan to implement and configure a Stellar indexer to fetch deployed Stellar network data. 
  • Additionally, we will apply ETL (Extract, Transform, Load) transformations to the Stellar network data, enabling no-code community analytics. 
  • To maintain consistency and facilitate easy data access, a defined data schema will be established to structure and format the indexed data.
 

Infrastructure Upgrade:

  • After fetching and transforming the data through ETL processes, we will store it in PostgreSQL. 
  • To support close to 100% uptime and ensure seamless no-code community analytics, an upgrade to the PostgreSQL Database is necessary.
  • The infrastructure will be upgraded and optimized to facilitate the successful integration of the Stellar testnet with DappLooker.
     

Dashboard Development: All the charts and dashboards will be built here and come with the following features:

  • Anyone can easily fork them to create their version of charts and dashboards.
  • Easily obtain the API for charts and integrate it into their dApp/ projects.
  • Can be easily converted into Intelligent DataBots for Discord and Telegram with just one click.
  • Community can easily create charts using AI studio by simply writing their requirement in natural language.

Stellar Network Dashboard - Testnet: The Network Dashboard will showcase essential metrics, including:

  • Transaction Volume (Daily, Weekly, Monthly) with Trend (a combo chart with Bar and Trend chart).
  • Success vs. Failed Transactions (Daily, Weekly, Monthly).
  • Total Assets (Daily, Weekly, Monthly) with Trend (a combo chart with Bar and Trend chart).
  • Total Active Addresses in the last 30 days.
  • Total Blocks in the Last 30 Days.
  • Transactions Per Second.
  • Daily Blocks in the Last 90 Days.
  • Unique Wallets.
  • Recent Transactions.

Wallet-level Dashboard: Users can filter based on their wallet address and view essential metrics such as:

  • Balance.
  • Total Transactions (Daily/Weekly/Monthly).
  • Average Transactions (Daily/Weekly/Monthly).
  • Min & Max Monthly Transactions.
  • TVL in USD (Daily/Weekly/Monthly).


Stellar Token Dashboard:

  • List all Stellar network tokens.
  • Display Daily TVL for each token(Daily/Weekly/Monthly).
  • Provide the total supply of the token and its distribution among different wallets (Top 10).
  • Show Gas consumed (Daily/Weekly/Monthly).
  • Analyze the types of transactions (payments, contract interactions, etc.).
     


How to measure completion

  • Infrastructure Upgrade to support Stellar testnet.
  • Any charts on the Stellar network datasets can be easily created by the community with AI studio by writing their requirements in natural language.
  • Stellar testnet users & and the community can browse and do advanced no-code analytics & visualization on Stellar network data.
  • Users & Community will be able to transform any chart or dashboard into intelligent DataBots easily.
  • Stellar Network Dashboard will be available.
  • Wallet-level Dashboard will be available for the community.to do wallet-specific analysis or make a version of their dashboard. 
  • Stellar Token Dashboard will be available for the community.
  • API will be available stellar community for every chart to integrate with dApps and projects.

Estimated date of completion

9 Mar 2024

Budget

$16,400 

 

[Deliverable 2] - Stellar Network Mainnet Integration for No-code Community Analytics  - 2 Weeks
 

  • Infrastructure Upgrade and APIs/Node Integration 
  • Stellar Network Indexer Development:
  • Dashboard Development 
    • Stellar Network Dashboard - Mainnet
    • Wallet-level Dashboard - Mainnet 
    • Stellar Token Dashboard - Mainnet
       

Co-Marketing & Operations:

  • Co-marketing with Stellar Team
  • Twitter, Blog, Email Campaign
  • Workshops, Video Tutorials

 

How to measure completion:

  • Infrastructure Upgrade to support Stellar testnet.
  • Stellar testnet users & and the community can browse and do advanced no-code analytics & visualization on Stellar network data.
  • Stellar Network Dashboard will be available.
  • Wallet-level Dashboard will be available for the community.to do wallet-specific analysis or make a version of their dashboard. 
  • Stellar Token Dashboard will be available for the community.
  • Users & Community will be able to transform any chart or dashboard into intelligent DataBots easily.
  • Any charts on the Setyllar network data can be easily created by the community with AI studio by writing their requirements in natural language.
  • API will be available stellar community for every chart to integrate with dApps and projects.

 


Estimated date of completion

25 March 2024
 

Budget

$11,300
 

Requested Budget in USD ($)

27700

Section

read

Public Entity Name

DAPPLOOKER SOLUTIONS PRIVATE LIMITED

Entity Description

DappLooker is a No-Code Web3 Business Intelligence, Analytics, and Visualization platform, that empowers projects with a suite of user-friendly tools.

Team bio

We are a 12+ dedicated team with different skills including blockchain engineering, backend engineering, frontend engineering, and marketing. Below are the names of core Team members
1. Abhay Singh - 12+ years of experience in blockchain development, analytics, and marketing.
2. Abhinav Singh - 8+ years of experience in front-end development, and blockchain analytics.
 

Previous Partnership Highlights:
 

  • Polygon Dapp Store Kit Announcement: Tweet
  • Aave V3 Grant Announcement: Tweet
  • Moonbeam Partnership Announcement: Tweet
  • NEAR Protocol Partnership Announcement: Tweet
  • BNB Chain Partnership Announcement: Tweet
  • PEAQ Integration Announcement: Tweet
  • Flipside Partnership Announcement: Tweet
  • NFTX Partnership Announcement: Tweet
  • MatricsDao Partnership Announcement: Tweet
Prazenti Grant Announcement: Tweet

Existing, Significant and Active Userbase?

DAU - 700 - 800

MAU - 20000 - 22000

Monthly Views/Impressions - 50k - 55k

Networks Integrated - 15+

Dapps Onboarded - 330+

Dashboards - 400+

Analysis - 4000+

Impressions/Views - 3.2M+

Users Data - 350M+

Queries successfully executed - 3.5M+

API Calls - 200k+

Total Expected Roadmap

Total Cost to complete the  Project: $27,700

 
  • Product Overview:

DappLooker is a no-code powerful tool to empower the Stellar Network community by simplifying the understanding of Stellar network data. It provides no-code analytics and visualization capabilities, enabling the creation of visually appealing explorers, charts, and dashboards. 

 
  • Vision and Objectives:

Our vision is to empower the Stellar community by simplifying data visualization and dApps using the DappLooker no-code tool. We aim to break down barriers for both technical and non-technical users, making analytics accessible, saving valuable time, and ultimately reducing costs.

 
  • Deliverables:
 

[Deliverable 1] -  Stellar Network Testnet Integration for No-code Community Analytics - 

[Deliverable 2] -  Stellar Network Mainnet Integration for No-code Community Analytics - 

  • We will organize Workshops to educate the community for no-code business intelligence, and analytics along with twitter space.
  • We will onboard Stellar network dApps and community for data driven analytics.