Building Dynamic MongoDB Dashboards Using SlamData’s Chained and Nested Cards

Chris Dima
Chris Dima

Marketing

The following is an excerpt for a discussion with Damon LaCaille, SlamData's solutions architect, on the features the drive adoption of SlamData's MongoDB analytics solution.

Damon LaCaille
I think probably one of the most useful is the fact that you can do what we call nesting of decks inside of other decks. The reason I say it’s the most useful is because if you remember in version 2.5 and earlier, our approach to this was using a notebook which is a fairly two dimensional way of approaching analytics workflow. You had one cell, followed by another cell and they would build on top of each other physically and literally in the screen, and what would happen is, to interact with users, you would have these markdown cells where you could select something and that could impact the next query based on what they select. And that’s great and we still allow that in our workspaces version as well here in version 3 but there’s two key things now that enable much better workflow and user interaction here.

That is, one, markdown cards can now be nested or chained together so selecting something from the first markdown card can affect the second markdown card. As an example you’d select a state in the first one and then you’d select a city from that state in the second one. Previously you couldn’t do that because we didn’t have the coding inside the [inaudible 01:09] so we had that. The second thing is now that we can nest these, what we’ll call a deck of cards, and I’ll get to that in a minute, inside of another deck, you can actually combine two markdown cards or two markdown decks next to each other, below each other, however, and it’ll appear as one interface so really what you’re building here [inaudible 01:30] has an application builder in that sense. It allows you to interact with the data, it allows you to get very technical with it, view the results, chart it, all that kind of stuff. That’s what I’m going to do with the demo today.

Chris Dima
Are you going to show us a quick chained markdown?

Request A Demo

No ETL. No Mapping. No Stale Extracts.

Damon LaCaille
Yeah, I sure will. In fact let me go into my workspaces here and what I’ve got is a number of different examples obviously but let me go into chained markdown here and what you’ll see is three separate decks. The first deck has a query and in fact let me zoom out a little bit so it can be seen and I’ll move these around so we can actually see the code in most of these. Here’s my original markdown source. I have the header which is just three pound signs and then something else, and that’s just standard markdown. I create a variable called state and inside of that state I populate that, or excuse me inside of that variable, I populate it with the results of this query. This basically says select all the distinct states from this collection and order it in descending order. You’ll notice we assign the variable name here. Then once I’ve typed that in, I would type run query and then I would slide over… I created a show markdown card and you can see here now that we have all the different states.

From there what I did is, I flipped the deck and then I did a mirror deck and what happened is it came up with a new deck and I’ll show you this one. You can see it looks just like the first one so if I change this one in here you’ll see that it updates over here as well. So they’re changed or synchronized or mirrored up to this point. Now this new deck I added another markdown so what I’ve done is I’ll slide over now to show you the actual code. This one’s a little bit different, I defined city and now I’m selecting all the distinct cities from that same collection, but now I’m saying or the state field is equal to colon state and then the colon of course is the preface key used, the preface you use for variable. Now when I click run query on this one, now the drop down shows you just the cities inside of Georgia or whatever state you’re looking in.

This collection has a very small data set, probably about 10,000 I think. If we go and we look at Boulder for example, you’ll see this third deck update here in just a second. Let me slide these back a little bit to make them smaller and you’ll see why I’m doing this. I’ve got these three separate decks and you’ll notice they’re inside of this kind of white border here. This is also a deck, or a card, excuse me, and that is inside of another one. The reason I’ve done this is so that when you put these all next to each other inside of a draft board card, it makes it appear as if it’s all one application. You can see these are all separate decks, you know in the workspace area here, you can see the lines delineating the response. Now if I flip the deck and I go to Publish you can see that you can do a preview. Now you go back to it in Publish mode, it looks like just one application so you don’t see the [inaudible 04:34], you can’t move things around, you can’t see the code behind it, or anything like that.

This literally is like a miniature application builder.

TRENDING BLOGS

Now Available: the Definitive Guide To JOINs On MongoDB

Lots of business come to us looking for help with doing BI on MongoDB. Specifically, many people want to just do what they’ve always done: query data with SQL. Here's the definitive guide!

Webinar Replay: Plug-And-Play Analytics for Your SaaS App Built On MongoDB

Check out the replay of this webinar to learn how US Mobile uses SlamData to deliver interactive reporting across its business.

The Five Money-Saving Tricks MongoDB Doesn’t Want You To Know

If you listen to your friendly MongoDB sales rep, it's easy to think they are a one-stop shop for all things MongoDB.

Chris Dima
Yeah so you would then share that around your company or stick that, embed that in application and that’s exactly what you would see.

Damon LaCaille
Yeah exactly and I should change what I said. I said it was kind of like a mini application builder, no, it truly is an application builder, it’s just focused at analytics at this point so. Yeah you can have all sorts of interaction, you can embed this, you can secure it and lock it down. All sorts of things like you said.

“This literally is like a miniature application builder.” –Damon LaCaille

Chris Dima
Every time you select a different city, is that going to MongoDB and pulling the freshest data? Is that like initiating a fundamentally new query each time?

Damon LaCaille
That’s exactly right Chris. Everything we do in SendData is on live data. If you look at the original deck, I’ll look at this workspace, and you’ll see that I mirrored this, the second deck, I mirrored it into a new one. All I did basically was take the results from a query, so I wrote this query, I selected all the count and the gender type from that collection where state is equal to the variable, city is equal to that variable, and then I grouped it by gender. Then I created a set-up chart card. We have a number of different options here for this. We actually have quite a few other charts available but the data set that is presented from the previous card isn’t applicable to a lot of chart types so only half a dozen show up here. I selected the gender, at this point we don’t have a third option for series so we just leave that blank then we go to Show Chart Card.

Get Updates And News From SlamData

If I choose Denver instead of Boulder, you’ll see that… It should update here in one second. Again this is fetching over AWS and… just like all of our charts, you can interact with it in the legend. You can even take certain data sets out. Yeah.

Chris Dima
Does that morph into the nested decks or is that a uniquely separate feature?

Damon LaCaille
You can use what we just did, which is the chain markdown, and I kind of showed you all in one. The chain markdown allows you to have one cell impact another cell if they’re both markdown. The other option was to, and I’ll show you what this looks like from scratch, was to merge those windows into one window. As an example, and this can be with any of the different decks, I’ll create a query card. I’ll just do something like select from AWS Data Patients, then I will run that query. I’ll go and I’ll do a Show Table and this is just standard Slam Data type of stuff we’re doing. I’m going to flip the deck, I’m going to wrap it. Now this is the first step. You want to wrap it so you get this big draftboard in the background. Now you’ll see we have this deck.

If I were to Publish this deck just like it is, you would see just this window. In fact, if I flip the deck, we go to Publish, and we’ll preview it, you’ll see that window and it looks just like it did in the other spot except the handles are gone on the left, right, and top. You can’t move it or resize it. Now if I go in, flip this back in, and create a new deck down here, let’s just say it’s a completely different query table. Select Star From Olympics, and we’ll put this right next to the other one, zoom out a little bit so it makes more sense for anyone watching. I run the query, when I put it in a Show Table, and so now you can see we’ve got two separate decks. They’re not even dependent on each other, showing. Now if we look at it in Publish mode, you’ll see that we have two separate decks so it looks like exactly like I created it in two separate decks.

If you wanted to have maybe a selector up here, a chart here, a row of tables over here, then you wouldn’t necessarily want it to be in separate things like this, right? You may want to have a title against the top of this query down here that sets something about that data set. Well to do that, that’s when you use the draftboard card. Now we’re back to this deck in edit mode, I’ll go over here, create a new deck by clicking, and now I do a Set Up draftboard. What that does is basically create a draftboard inside of a draftboard. To move this stuff around, I’m going to make these smaller just so it’s easier to move them around, I’ll resize this guy so they can all be pulled in. I accidentally created a new deck inside of there by doing such. Now I’m going to grab both of these tables and slide them into here. You still have all the freedom that you had before in terms of jumping between the cards inside of the deck and resizing. I’ll put this right next to the other one. Finally I’m going to slide this guy up into the left.

News, Analysis and Blogs

What Our Customers Are Saying

v

We use SlamData to build custom reports and have found the tool is exceptionally easy to use and very powerful. We recently needed to engage the support team and we were very pleased with the turn-around time and the quality of support that we received.

Troy Thompson
Director of Software Engineering
Intermap Technologies, Inc.

v

When our company migrated from SQL database to MongoDB, all our query tools became obsolete. SlamData saved the day! I was able to easily write SQL2 queries. Plus the sharing, charting, and interactive reports were a game changer.

Michael Melmed
VP, Ops and Strategy
US Mobile

v

Slamdata helped shine the light on how our new product was being used. The support staff was awesome and we saved engineering cycles in building all the analytics in-house. I am using it to change the mindset in the teams and shift the focus from product launches to product landings

Engineering Lead
Cisco Systems

WHITEPAPER

The Characteristics of NoSQL Analytics Systems

  • The Nature of NoSQL Data
    • APIs
    • NoSQL Databases
    • Big Data
    • A Generic Data Model for NoSQL
  • Approaches to NoSQL Analytics
    • Coding & ETL
    • Hadoop
    • Real-Time Analytics
    • Relational Model Virtualization
    • First-Class NoSQL Analytics
  • Characteristics of NoSQL Analytics Systems
    • Generic Data Model
    • Isomorphic Data Model
    • Multi-Dimensionality
    • Unified Schema/Data
    • Post-Relational
    • Polymorphic Queries
    • Dynamic Type Discovery & Conversion
    • Structural Patterns

© 2017 SlamData, Inc.

Do NOT follow this link or you will be banned from the site!

SlamData Provides Missing Platform for NoSQL Data Insight

“The ROI has been in saving my time building, refreshing and tweaking reports and saving the time of engineers, who would otherwise have to build custom reports for our analytics portal."

- Michael Melmed, US Mobile
Read the Case Study Now
The study was conducted by Constellation Research.
close-link
Click Me
Tweet
Share
Share
+1
Reddit
Buffer