Welcome to MakerDojo, an AI-powered data analytics platform for the Web3 ecosystem. Our platform makes it easy for you to extract valuable insights from blockchain data, without having to write any SQL. In this tutorial, you’ll learn how to use our platform to create a dashboard that provides insights into the USDC token on the Ethereum blockchain. Specifically, you will learn how to:
- Use our intuitive “Ask” interface to quickly access insights
- Utilize our query editor to customize your queries and fine-tune the results
- Build a simple dashboard using the insights obtained
By the end of this tutorial, you’ll be able to create your own USDC dashboard, and stay up-to-date with the latest blockchain data.
Step 1: Ask a Question
To begin building our USDC dashboard, the first step is to ask a question about the insights we want to see. For example, we might be interested in understanding the total number of wallets holding USDC.
To ask this question, simply select the Ethereum blockchain from the left dropdown, and type in “Total number of wallets holding USDC?” as shown in the screenshot below.
Our platform will automatically generate a SQL query based on your question, run the query, and generate a plot displaying the results.
Step 2: Utilize the Query Editor
For more advanced use-cases, you may also want to ask questions using our query editor. For example, to understand the daily number of users transferring USDC in the last month.
To access the query editor, you can visit New Query Page, or by visiting the “Queries” tab on the left sidebar and clicking the “New Query” button.
In the query editor, you can type in the specific insights you want to see and hit the “Ask” button (or use the keyboard shortcut Ctrl + Enter). Our platform will automatically generate a SQL query based on your question, and display the SQL in the query editor.
You can now make any necessary changes to the query, such as adjusting the time period or adding additional parameters. This is useful when you have specific requirements that our natural language processing (NLP) system was not able to pick up. In most cases, however, the generated SQL query will be accurate, and you won’t need to make many changes.
Step 3: Building a Dashboard
Once the SQL query has been run, our platform will automatically generate a plot based on the results. In case you are using the SQL editor, you can click on the “+” button to add the plot to the dashboard.
You can now add the chart to your dashboard, or share it with others by clicking on the three dots on the bottom left corner. You can also add widgets such as tables, maps, and pivot tables to display your data in a more comprehensive manner.
Congratulations on completing this tutorial on how to create a USDC dashboard using MakerDojo! You have learned how to use our intuitive “Ask” interface to quickly access insights, utilize our query editor to customize your queries and fine-tune the results, and build a simple dashboard using the insights obtained.
|USDC Tutorial dashboard||Logged-in Link||Logged-out Link|
By following these steps, you’ll be able to draw your own insights, and stay up-to-date with the latest blockchain data. Our platform’s aim is to make it easy for you to access the data you need and extract valuable insights in a simple, user-friendly manner.
If you have any further questions or need assistance in creating your own dashboard, please don’t hesitate to reach out to us on Discord.