This month’s Feature Focus comes at the request of you, the people! We’ve had a tidal wave of (three) emails asking for a piece on our data mining functionality, so that’s what you’re getting.
Analysts use our ‘Data Mining’ tool to quickly extract valuable insights from massive datasets – without having to get tangled up in databases and spreadsheets.
What is data mining?
Data mining = the process of interrogating data to discern patterns therein.
‘Data Mining’ in deltaDNA = a section of the deltaDNA platform within ‘Analyze.’ Analysts/developers can create, run, and save SQL queries to pull specific data from the larger dataset, then visualize that data in a number of ways.
Writing a query in Data Mining [Demo Game]
How does it work?
The query window is your gateway to insights and understanding. First, you’ll need to enter and run an SQL query. This can be a brand new one written on the fly, an old favorite saved previously, or a query imported from our expert-approved templates. Template queries are themselves locked from editing, but you can create a copy for your own account that is then customizable.
Once your query has returned a table of results, you can visualize that data in one of eight ways:
Beyond queries and visualizations, Data Mining also allows for the creation of player segments (for importing to event-based segments) and custom dashboards that group several charts together.
Query results returned [Demo Game]
Why is it useful?
In a nutshell – data mining with deltaDNA lets you pull and visualize data in one place, which cuts out a lot of the headaches endured by analysts querying their databases directly and exporting to a separate visualization or spreadsheeting tool. On top of all the points above, here are some more reasons to love the tool:
The query window uses autocomplete and syntax-highlighting to save time and prevent typos when writing SQL.
Dashboards aid analysis by facilitating the grouping of relevant charts together. You can also automate their distribution to mail groups on a regular basis. Learn more about our template dashboards here.
All dashboards refresh upon opening (as well as regularly auto-refreshing) to show results according to the latest data available.
Results, charts and visualizations are easily exportable so that insights can be shared with people without platform access.
Our SQL cookbook contains LOADS of great examples to help you write efficient queries that return useful results.
Query Results Visualized [Demo Game]
It’s there, you just have to find it
Everything that you can reasonably expect to learn about your players lives right there in the data. That said, it’s very much a game of needles and haystacks. Used in combination with your own knowledge and the guidance that we’ve embedded in template queries/dashboards, our Data Mining tool makes it quick and easy to find those needles. Get to know your players!