保姆级教程区块链数据分析工具指南（1）

欢迎关注微信公众号【双语数字世界】，本文首发站：【保姆级教程】区块链数据分析工具指南（1）

阅读提示

Dune Analytics（以下简称Dune）是一款强大而易用的区块链链上数据分析平台。

对于初次接触Dune Analytics的我们来说，需要一份提供详细指引步骤的Dune Analytics指南帮助我们初步掌握该平台的玩法。

从初识Dune Analytics到构建我们的第一个查询和清理仪表板，一起来探索这个令人兴奋的工具，深入挖掘区块链数据的无限潜力吧。

Q1：Dune Analytics是什么类型的平台？

A1：Dune Analytics是一个链上数据分析平台，专注于区块链数据的分析和可视化。

提供给我们友好的界面和强大的查询工具，使用户能够深入挖掘和理解区块链的各个方面。

Q2：Dune Analytics的主要功能是什么？

A2：Dune Analytics的主要功能是让我们能够自定义查询和分析区块链数据。

支持多个主流区块链网络，提供了SQL查询语言和可视化工具，让我们能够灵活地探索数据、创建仪表板，并将分析结果以图表和图形的形式展示出来。

Q3：使用Dune Analytics有哪些优势和价值？

A3：使用Dune Analytics可以带来几个重要的优势和价值。

首先，它提供了丰富的数据集，让我们能够从多个区块链网络中获取数据，进行全面的分析。

其次，Dune Analytics支持协作和共享，可以与其他人合作并分享查询和仪表板，促进学习和交流。

最重要的是，Dune Analytics提供了强大的可视化工具，使我们能够更直观地理解数据和趋势，从而做出更明智的决策。

在Dune Analytics中，仪表盘是由各种图表、指标和数据可视化组成的集合，用于展示和监控关键数据和指标。

可以根据我们的需求和偏好进行定制，并提供一目了然的数据呈现方式，以求更好地理解和分析区块链数据。

用一个职场新人的例子来解释仪表盘的作用吧，可以让我们对仪表盘更深有体会，一起来看看吧！

假设我们读者中有一位名为"职场小天才"的95后职场新人，刚刚加入一家大公司，面对着繁忙的工作和各种数据，感到有些无从下手。

突然有一天发现了一个神奇的工具，名叫"职场指挥台"，它竟然成为了非常有用的个人助手，经过一番研究发现就是由各种图表和指标组成的仪表盘。

"职场指挥台"上有各种数据和指标，比如工作进度、任务完成情况、团队表现等等。

我们可以根据自己的需求和关注点，定制仪表盘上展示的数据内容。这样，每天只需打开"职场指挥台"，就能一目了然地了解自己的工作情况。

现在，让我们加入一些幽默元素。比如说我们中的一位"懒洋洋职场小天才"，总是懒得整理工作报告、统计数据，但又想在职场中获得成功。

于是，将"职场指挥台"放在办公桌上，每天早上只需要瞥一眼，就能知道自己的工作状态。

某一天，早上来到办公室，打开"职场指挥台"，发现一个图表显示任务完成情况达到了超高水平。

自然就会欣喜若狂地想："哇哦！我可真是职场小天才！看来我今天可以放松一下，享受一顿美味的午餐了。"于是，就毫不犹豫地放下工作，和同事们一起去品尝美食。

这个幽默的例子展示了仪表盘的作用。它就像是我们的职场小助手，帮助我们快速了解自己的工作状态，让我们在职场中更加游刃有余。

无论是管理任务、掌握工作进度，还是评估团队表现，仪表盘都能够帮到我们！

下面，我就来实操下吧，首先打开网址：https://dune.com/home（无需科学上网），点击Sign up：

进入注册界面，操作如下：

显示以下界面就是注册成功了，可以开启Dune的探索之旅啦~

下面我以传奇人物@hildobby的以太坊等数据仪表盘。在这里，我们可以看到从Dune的数据库中提取的各种数据，以集合或者时间序列图的形式显示。

在Dune 中，每个仪表盘都是公开的。这就是说，任何人都可以查看和复制我们构建的所有内容！这样的好处是大大节省了我们自己独自创建仪表盘的时间，并且可以让我们从其他人的查询中学习。

仪表盘，简单来讲，是查询的集合。如果我们单击任何一个仪表盘元素的标题，都会被带到该图表的SQL查询（如下图所示）：

小科普之SQL

仪表盘的SQL查询是指在使用Dune Analytics的仪表盘功能时，通过编写SQL查询语句来获取所需的数据并展示在仪表盘上。

SQL（Structured Query Language）是一种用于管理和操作关系型数据库的编程语言。

在Dune Analytics中，仪表盘可以展示各种数据图表，例如折线图、柱状图、饼图等。

这些图表的数据来源就是通过SQL查询语句从底层的数据源中提取出来的。

假设我们想在仪表盘上展示公司每个月的销售额趋势。就可以使用SQL查询语句从公司的销售数据库中提取相应的数据。

查询语句可能类似于："SELECT month, SUM(sales) AS total_sales FROM sales_table GROUP BY month;"，这条语句的作用是从销售表中按月份分组，计算每个月的销售额总和。

通过在Dune Analytics的仪表盘中添加一个折线图，并将上述SQL查询语句作为数据源，就可以将每个月的销售额数据展示在折线图上了。

这样，可以直观地看到销售额的变化趋势，并据此做出相应的决策。

通过仪表盘的SQL查询，可以根据自己的需求和业务场景，灵活地提取和展示数据。

无论是分析用户行为、监控业务指标，还是进行市场调研，SQL查询可以帮助我们获取准确的数据，并将其可视化在仪表盘上，方便我们快速获取关键信息并做出决策。

仪表盘查询编辑器的展示

然后点击如下按钮，它会自动利用如今非常热门的ChatGPT-4帮你分析，这就非常与时俱进了：

如果我们想将整个仪表盘或者仅图表的查询保存到自己的账户，可以点击右上角的“Fork”，分叉屏幕上的所有内容都将复制到一个新的窗口，可以在其中进行编辑，并且将视图保存到我们的账户里。显示的界面如下：

如果对其中的某部分或者全部仪表盘都感兴趣的话，可以点击Save，如下图所示：

点击Save之后，会跳出如下界面，主要是需要为我们的仪表盘起个名字，然后看是否设为隐私，最后依然需要点击Save按钮，如下图所示：

今天，我们对Dune Analytics的仪表盘工具进行了初步的分析，从仪表盘的介绍、查询的编写，到分叉Fork的应用，我们已经初步掌握了使用Dune Analytics构建自己数据分析仪表盘的基本技能。

然而，Dune Analytics并不止于此。作为一个不断发展和创新的平台，Dune Analytics正在不断探索未来的可能性，为我们提供更多令人兴奋的功能和工具。

在后续的文章里，我们将继续学习数据集浏览器和数据类别的功能，那时我们能够更轻松地浏览和探索各种数据集。

此外，数据集选择和搜索功能的引入将进一步提升我们的数据分析体验，使我们能够更快速地找到自己需要的数据，并进行深入的分析和挖掘。

随着Dune Analytics的不断演进，我们可以期待更多功能和工具的推出，以满足对数据分析的不断增长的需求。

通过使用Dune Analytics，我们将能够更加高效地利用链上数据，发现隐藏在数据背后的价值和见解，从而做出更明智的决策和判断。

在Dune Analytics的引领下，让我们一同探索数据分析的无限可能性吧！

友情提醒，以下是英文部分，可以速览至文末~

Reading Tips

Dune Analytics, hereinafter referred to as Dune, is a powerful and user-friendly on-chain blockchain data analytics platform. For those of us who are new to Dune Analytics, we need a detailed guide to help us get started and master the platform's capabilities.

From getting acquainted with Dune Analytics to building our first query and cleaning dashboard, let's explore this exciting tool together and delve into the infinite potential of blockchain data.

Q1: What type of platform is Dune Analytics?

A1: Dune Analytics is an on-chain data analytics platform that focuses on analyzing and visualizing blockchain data.

It provides a user-friendly interface and powerful query tools that allow users to delve deep into various aspects of blockchain.

Q2: What are the main features of Dune Analytics?

A2: The main feature of Dune Analytics is the ability to customize queries and analyze blockchain data.

It supports multiple mainstream blockchain networks, provides SQL query language and visualization tools, enabling flexible data exploration, dashboard creation, and presenting analysis results in the form of charts and graphs.

Q3: What are the advantages and value of using Dune Analytics?

A3: Using Dune Analytics offers several important advantages and value. Firstly, it provides a rich dataset that allows comprehensive analysis from multiple blockchain networks.

Secondly, Dune Analytics supports collaboration and sharing, enabling cooperation with others and sharing queries and dashboards, facilitating learning and communication.

Most importantly, Dune Analytics offers powerful visualization tools that allow us to intuitively understand data and trends, enabling us to make more informed decisions.

In Dune Analytics, a dashboard is a collection of various charts, metrics, and data lake visualizations to present and monitor key data and metrics.

It can be customized according to our needs and preferences, and provide an at-a-glance data presentation method for better understanding and analysis of blockchain data.

Use an example of a workplace new bee to explain the role of the dashboard, let us have a deeper understanding of the dashboard, let's take a look!

Suppose one of our readers is a post-95s workplace new bee named "workplace genius". He has just joined a large company and feels a little helpless in the face of busy work and various data.

Suddenly one day he discovered a magical tool called "workplace console", which turned out to be a very useful personal assistant.

After some research, it was found to be a dashboard composed of various charts and indicators. There are various data and indicators on the "Workplace Console", such as work progress, task completion, team performance, etc.

We can customize the data content displayed on the dashboard according to our own needs and concerns. In this way, just open the "Workplace Console" every day, and you can see your work situation at a glance.

Now, let's add some humor. For example, one of our "lazy workplace geniuses" is always lazy to organize work reports and Statistical Data, but he wants to be successful in the workplace. So, put the "workplace podium" on the work desk, and you can know your work status with just a glance every morning.

One day, when I came to the work room in the morning, I opened the "Workplace Console" and found a chart showing that the task completion had reached a super high level. Naturally, I would be ecstatic and think: "Wow! I'm such a professional genius! Looks like I can relax and enjoy a delicious lunch today." So, without hesitation, I put down work and went to taste food with my colleagues.

This humorous example shows the role of a dashboard. It is like our workplace assistant, helping us quickly understand our work status and making us more comfortable in the workplace. Whether it's managing tasks, tracking work progress, or evaluating team performance, a dashboard can help us!

Below, I will come to practice it, first open the URL:

https://dune.com/home (without scientific Internet access), click Sign up:

Enter the registration interface and operate as follows:

If the following interface is displayed, the registration is successful, and you can start the exploration journey of Dune~

Below I dashboard with data such as Ethereum from the legendary @hildobby. Here, we can see various data extracted from Dune's database, displayed in the form of collections or time series graphs.

In Dune, every dashboard is public. This means that anyone can view and copy everything we build!

The benefit of this is that it saves us a lot of time creating dashboards ourselves and allows us to learn from other people's queries.

A dashboard, in simple terms, is a collection of queries.

if we click on the title of any dashboard element, it will be taken to the SQL query of that chart (as shown in the following figure):

SQL for popular science

SQL query for dashboard refers to writing SQL query statements to obtain the required data and display it on the dashboard when using the dashboard function of Dune Analytics.

SQL (Structured Query Language) is a programming language for managing and manipulating relational databases.

In Dune Analytics, dashboards can display various data charts, such as line charts, column charts, pie charts, etc.

The data source of these charts is extracted from the underlying data source through SQL queries.

Suppose we want to display the company's monthly sales trend on the dashboard. You can use SQL query statements to extract the corresponding data from the company's sales database.

The query statement may be similar to: "SELECT month, SUM (sales) AS total_sales FROM sales_table GROUP BY month;", the purpose of this statement is to group the sales table by month and calculate the sum of sales for each month.

By adding a line chart to the Dune Analytics dashboard and using the above SQL query as the data source, you can display the sales data for each month on the line chart.

In this way, you can visually see the changing trend of sales and make corresponding decisions accordingly.

Through the SQL query of the dashboard, you can flexibly extract and display data according to your own needs and business scenarios.

Whether analyzing user behavior, monitoring business metrics, or conducting market surveys, SQL queries can help us obtain accurate data and visualize it on dashboards, allowing us to quickly obtain key information and make decisions.

Display of dashboard query editor

Then click the following button, it will automatically use the very popular ChatGPT-4 to help you analyze, which is very up-to-date:

If we want to save the entire dashboard or just the chart query to our account, we can click "Fork" in the upper right corner, and everything on the fork screen will be copied to a new window where we can edit and save the view to our account. The interface displayed is as follows:

If you are interested in some or all of the dashboards, you can click Save, as shown in the figure below:

After clicking Save, the following interface will pop up. Mainly, we need to name our dashboard, and then see if it is set to privacy. Finally, we still need to click the Save button, as shown in the figure below:

Today, we have a preliminary analysis of the dashboard tools of Dune Analytics.

From the introduction of the dashboard, the preparation of queries, and the application of the fork Fork, we have initially mastered the basic skills of building our own Data Analysis dashboard using Dune Analytics.

However, Dune Analytics doesn't stop there. As a constantly evolving and innovative platform, Dune Analytics is constantly exploring the possibilities of the future, providing us with more exciting features and tools.

In the following articles, we will continue to learn the functions of Dataset Browser and Data Categories, so that we can more easily browse and explore various datasets.

In addition, the introduction of dataset selection and search functions will further enhance our Data Analysis experience, allowing us to more quickly find the data we need, and conduct in-depth analysis and mining.

As Dune Analytics continues to evolve, we can expect more features and tools to be introduced to meet the growing demand for Data Analysis.

By using Dune Analytics, we will be able to more efficiently utilize on-chain data, uncover the value and insights hidden behind the data, and make more informed decisions and judgments.

Let's explore the endless possibilities of Data Analysis with the leadership of Dune Analytics!