{"id":423,"date":"2023-09-15T02:35:05","date_gmt":"2023-09-15T02:35:05","guid":{"rendered":"https:\/\/mathnodes.com\/?p=423"},"modified":"2023-09-15T02:35:05","modified_gmt":"2023-09-15T02:35:05","slug":"the-analytics-challenge-part-i","status":"publish","type":"post","link":"https:\/\/mathnodes.com\/index.php\/2023\/09\/15\/the-analytics-challenge-part-i\/","title":{"rendered":"The Analytics Challenge &#8211; Part I"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>Today marks the start of a new crowdfunding campaign by MathNodes. We have previously awarded Monero bounties to developers who contribute code to our GitHub codebases. Similarly, we will use this same strategy to gain insight into the Sentinel blockchain with our analytics dashboard, Metabase. <\/p>\n\n\n\n<p>Crypto currencies, especially privacy coins, enable fast, instant, and anonymous transactions and are an ideal way to crowdfund for development of resources on a global scale. Crypto currency was designed for such payments and we cannot think of a better way than to award participants that produce useful results with the ultimate privacy coin, Monero.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Idea<\/h2>\n\n\n\n<p>We have integrated the Metabase software into our backend and integrated it with data from the Sentinel blockchain. Metabase allows for easy construction of data metrics, charts, graphs, maps and many more interesting statistical insights into a data set. We have constructed node maps, node uptime charts, node decentralization pie charts, node ASN pie charts, timeseries, and many more interesting analytics to peer into the Sentinel Network.<\/p>\n\n\n\n<p>On September 12th, 2023 we released our Node leaderboard see here:<\/p>\n\n\n\n<center><iframe\n    src=\"https:\/\/metabase.mathnodes.com\/public\/question\/8c064447-9380-49e3-8595-30792722c6fd\"\n    frameborder=\"0\"\n    width=\"800\"\n    height=\"600\"\n    allowtransparency\n><\/iframe><\/center>\n\n\n\n<p>This leaderboard made use of the query builder inside Metabase to construct the final results shown above. The design of the query made possible by the Metabase query builder can be seen as follows:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"2806\" height=\"2044\" src=\"https:\/\/mathnodes.com\/wp-content\/uploads\/2023\/09\/Analytics-Challenge-Metbase-Query-Builder-Node-Leaderboard.png\" alt=\"MathNodes Metabase (MnM)\" class=\"wp-image-424\"\/><figcaption class=\"wp-element-caption\">MathNodes Metabase Query Builder<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">The Challenge<\/h2>\n\n\n\n<p>If you haven&#8217;t already signed up for MathNodes Metabase (MnM), please head over to <a href=\"https:\/\/meile.app\" target=\"_blank\" rel=\"noopener\">https:\/\/meile.app<\/a> and sign-up for a free account at the bottom of the page. An e-mail verification will be sent to your provided e-mail address and we contact the winners via e-mail so it is essential that you use a reliable e-mail account. Feel free to use a psuedonym as your name if you prefer to remain anon. <\/p>\n\n\n\n<p>Head over to the Sentinel Analytics section and find the Node Leaderboard query and open it <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"2806\" height=\"1616\" src=\"https:\/\/mathnodes.com\/wp-content\/uploads\/2023\/09\/Analytics-Challenge-MnM-Sentinel-Queries-Node-Leaderboard.png\" alt=\"MnM - Sentinel Analytics\" class=\"wp-image-428\"\/><figcaption class=\"wp-element-caption\">MathNodes Metabase &#8211; Sentinel Analytics<\/figcaption><\/figure>\n\n\n\n<p>You will be presented with the results of the constructed query. Click on the &#8216;Show Editor&#8217; icon to bring up the query builder so that you may begin the challenge. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1823\" height=\"1095\" src=\"https:\/\/mathnodes.com\/wp-content\/uploads\/2023\/09\/Analytics-Challenge-MnM-Sentinel-Node-Leaderboard-Editor.jpg\" alt=\"MnM - Node Leaderboard Editor\" class=\"wp-image-431\"\/><figcaption class=\"wp-element-caption\">MnM &#8211; Node Leaderboard Editor<\/figcaption><\/figure>\n\n\n\n<p>Once opened you will be presented with the MnM query builder interface as displayed earlier and below as a reminder.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"2806\" height=\"2044\" src=\"https:\/\/mathnodes.com\/wp-content\/uploads\/2023\/09\/Analytics-Challenge-Metbase-Query-Builder-Node-Leaderboard.png\" alt=\"MathNodes Metabase (MnM)\" class=\"wp-image-424\"\/><figcaption class=\"wp-element-caption\">MathNodes Metabase Query Builder<\/figcaption><\/figure>\n\n\n\n<p>Now, we finally get to the point of what we want you, the curator, to do to receive the Monero reward. <br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Node Leaderboard &#8211; Bandwidth Metric<\/h3>\n\n\n\n<p>We developed the Node Leaderboard for hourly subscriptions. Using the above instructions we want you to alter this query, using the query builder, to construct a node leaderboard based on two data points: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Allocated Bandwidth<\/li>\n\n\n\n<li>Consumed Bandwidth<\/li>\n<\/ul>\n\n\n\n<p>Use the Node Leadboard query and adjust it so it summarizes each of those data points. Once you think you have solved each of these two challenges, save the queries, with a different name so you don&#8217;t overwrite the Hourly Node Leaderboard. Preferably the query names should be<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Node Leaderboard &#8211; Allocated Bandwidth<\/li>\n\n\n\n<li>Node Leaderboard &#8211; Consumed Bandwidth<\/li>\n<\/ul>\n\n\n\n<p>If we tell you any more of what to do, we would give away the whole challenge. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Reward<\/h2>\n\n\n\n<p>Each query will be awarded <strong><em><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-text-link-color\">0.15 XMR<\/mark><\/em><\/strong> for a total of <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-text-link-color\"><strong><em>0.30 XMR<\/em><\/strong><\/mark> and we will decide the winner if there are multiple users who created the same query based on timestamp and accuracy. We will e-mail the user with instructions to receive the bounty shortly after we announce the winner(s). <\/p>\n\n\n\n<p>Good luck to all who attempt his straightforward challenge!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Contact<\/h2>\n\n\n\n<p>If you need to contact us in anyway please visit the MathNodes Telegram Channel or Discord Channel from the links in the header of this page. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introducing our latest challenge: The MathNodes Metabase Monero Challenge. Curate analytics to better understand the Sentinel Blockchain and be rewarded in Monero for your contributions. <\/p>\n","protected":false},"author":1,"featured_media":436,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,44],"tags":[41,7,9,8,40,32,18,42,17],"class_list":["post-423","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-metabase","category-monero","tag-analytics","tag-blockchain","tag-dvpn","tag-mathnodes","tag-metabase","tag-monero","tag-privacy","tag-sql","tag-vpn"],"_links":{"self":[{"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/posts\/423","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/comments?post=423"}],"version-history":[{"count":8,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/posts\/423\/revisions"}],"predecessor-version":[{"id":437,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/posts\/423\/revisions\/437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/media\/436"}],"wp:attachment":[{"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/media?parent=423"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/categories?post=423"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mathnodes.com\/index.php\/wp-json\/wp\/v2\/tags?post=423"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}