It is now time to Go and explore the Steem SQL database gby yourself! Happy with the result? You can download it as a JSON, XLS or CSV file or Save it to monitor the data in your Dashboard. Step 5: Explore the Steem SQL database by yourself We only want the result since July 2017, remember? To select a timeline, click on View and type Previous = 6 and change Day by Months. Hit Get Answer to see the result of your first query. Choose "Active: day" in the group section. + row n and help us getting track of the total number of comments)įinally, we want to group the comments by day. So we want to View the cumulative count of row (this cumulate row 1 + row 2 + row 3 +. The database shows all the comments from flauwy each comment represents a row. We only want the comments from Flauwy, so let's filter them by Author -> is -> flauwy and then hit Add filter. We want to see comments, so let's select Comments. See it as a Whiteboard where you can pin live data.įor this tutorial, we are going to "ask" Metabase to show us the evolution of the number of comments made since July 2017.įirst, click on "New Question." Then, choose "Custom."Ĭlick on "Select table" and choose the Steem Database. Dashboard: Get the answer to the questions you were looking? You can add them to your Dashboards.Help you "ask questions" to the Database. New Question: This is the main feature of Metabase.They are two sections that we are interested in: Since you are not a Team or a Company, you do not need the Questions and Pulses section on the navbar. The over cells are irrelevant, and you can leave them blank. Next, Metabase asks for the Database information. First, you need to enter your information such as your name, your email, and password. Open your favorite browser, then go to Let's start with the self-hosting installation. Step 3: Setup Metabase and the Steem SQL Database Note: Every time you want to launch Metabase, you SHOULD restart this step. When you see " Metabase Initialization COMPLETE," you can go to the next step. Open the folder where you download the Metabase.jar file, then drag and drop the. In your Command Prompt terminal, type the following command but don't hit enter: java -jar On other Windows versions, hit the Windows key, click on Execute, then type cmd.exe. To do that on Windows 10, just hit the Windows key on your keyboard, and type "cmd." To install Metabase, on a Windows computer, start a Command Prompt. Step 2: Install Metabase using your Command Prompt Depending on your location and your bandwidth speed, this can take some time. For Windows users, you need to Download the Metabase.jar file. Let's go to and download Metabase isntallation file. You can monitor Data over time using dashboardsįor this tutorial, I assume that you are NOT a company or a Team but a personal user who do not use the Pulses and Questions sections of Metabase.The main differences between Excell and Metabase are: As an example, we are going to cover the setup of Metabase, and we are going to make an elemental example of data counting the cumulative number of comments of since July 2017. They allow you to create dedicated space to monitor your saved data fetching. One of the significant "kill feature" of Metabase is the Dashboards panels. We are going to use the Steem SQL database by ( ) The purpose of this tutorial is to show you how to set-up Metabase, a self-hosted Open Source platform for database analysis.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |