Overview
A simple way to manage your entire data journey
The Mammoth Analytics platform has a whole suite of features designed to take care of all of your data needs. You don’t need any real-world analyst experience or programming skills to get started.
With powerful automation, customizable alerts, drill-down discovery and extensive data transformation capabilities, the Mammoth platform will increase your productivity, cut down your hours and empower you to achieve deeper and timely insights
Bring your Data Together
Your data from multiple sources, in one place
Information can come from anywhere. That’s why we have plenty of options for moving your data online. Below is a list of options that our platform supports:
-
Send Data to Mammoth via Webhooks
Webhooks are an increasingly popular way for applications to send data across to each
other. Mammoth generates its own webhooks which are used to bring data from third party
data providers or events from custom apps. -
Files from your computer
Drag and drop from the desktop or browse your computer to upload files.
-
Databases
Our database connector is designed for you to get started with just a couple of clicks. For
basic access, you donʼt need to know any SQL. Our visual interface does all the work for
you. However, the ability to write SQL queries for any complex operation is always available
as an option for our more technical users. To see a list of what we currently support, click
here. -
Data from third-party providers
While our webhooks feature is a powerful way to bring in data from third-party vendors, we
also have integrations that enable users to have greater control over their data.
Store Large or Small Data
A massive and centralized storage for all your data
Your data may sit in a variety of places, but with Mammoth, you can bring them all together and keep them there, forever. It’s a database but with an interface designed for everyone to use. Some of the features:
-
Massive Storage
There are no size constraints on Mammoth, have as many rows, columns, or datasets as you like because, with cloud storage, the sky is the limit.
-
Automated Refresh
When pulling data from a database or a third party service, users can set their schedule for refreshing the data
Transform and Prepare
All you need to get your data ready and in shape
At Mammoth, we provide you with a comprehensive suite of tools for you to clean and prepare your data. No coding needed. Here are some of the features:
-
Conditional Filters
Find your duplicate data and act on it. Whether it’s removing it, saving it elsewhere or sending alerts on it.
-
Combining Datasets
Weʼve made combining different datasets a cinch. Whether it is Lookup (aka VLookup in Excel) or Join (as itʼs done in SQL), you donʼt need to have any technical experience to perform this task.
-
Duplicate Rows
Find your duplicate data and act on it. Whether itʼs removing it, saving it elsewhere or sending alerts on it.
-
Find and Replace
With our regular Find and Replace, you can replace text across multiple columns. Our powerful Group Replace allows users to auto-detect all the similar spelled words to replace them in groups.
-
Text Functions
Insert text values based on conditions
Extract Sub-text
Extract JSON
Split Columns
Combine Columns
Change Case or Remove Whitespace -
Numeric Functions
Regular Mathematics function
Rank
Running Total
SQL WindowsFunctions
Find Large/Small Values between Columns -
Date Functions
Increment / Decrement date values
Extract part of Date
Calculate date difference between two date
columns -
Summarising and Reshaping your data
Group
Pivot
Transpose
Summarised Rows to Columns
Unify Different Data
Easily combine and standardize data from multiple sources
At Mammoth, we provide powerful tools to merge multiple datasets, no matter how complex they are.
Hereʼs a diagram of the data flow in a data join:
Manage and Automate Data Flow
A repeatable, editable and transparent data pipeline of all your actions
All the actions taken on data are recorded as sequential steps as part of a data pipeline. Something like
Excel macros, but far simpler.
-
Automation
All your data-related tasks, once set up, is set for automation. Any new data coming is automatically transformed. Users can adjust the various automation parameters, and the data pipeline can also be templatized.
-
Easy modification
Make as many mistakes as you want while you make sense of your data. Mammoth provides easy ways to roll back and edit all your data transformations.
-
Transparency with a high level of control
Have clear visibility into the flow of your data. View and manage all the steps taken to get to its final state. Users can write notes in every step, so everyone in the team is well aware of why and how any changes to the data happened. No more of a black-box solution.
Explore and Discover
Powerful segmentation and quick insights
To find the gold you have to wade through the mud. Discovering trends, patterns, and outliers might seem
like a big messy job, but Mammoth has the best tools for the job. Tidy up and dig a little deeper.
-
Visual Summary
Our powerful Exploration Cards provides a summarized representation of each column in your table for a more accessible and quicker examination. You can now view your data in different resolutions.
-
Powerful Drill-down
Filtering is a fundamental part of data analysis. In Mammoth, weʼve taken it to another level
with the ability to perform multi-level drill down and visualize the effect on your data. View your data from different perspectives and perform visual queries, all in a couple of clicks -
Metrics and Tables
Display the most relevant information at all times by creating charts and tables alongside
your source data. These can be highly customized.
Get Different Perspectives
Look at the same data in different ways
Data can be interpreted in many ways. The Mammoth platform allows for just that with the concept of Views. This allows users to create multiple views of the same data and run different transformations on them.
Some of the features include:
-
Create Multiple Views of your Data
Create multiple views of the same data and run different transformations on them.
-
Assign Different Views to Team Members
(Coming soon)
-
Templates
The concept of templates is precisely what it sounds like – a blueprint of all your work that
can be applied to different datasets. Create a View the way you like it, and then use the
template of that View to an entirely different set of data.
Send to Multiple Destinations
Use Mammoth as a powerful conduit to your final destination
At any point in your workflow, data can be exported in a variety of ways. There are a lot of use cases for this. For example, use Mammoth to bring data together, unify the datasets and then send it along to another destination (database, FTP server, desktop, etc.). You can automate this entire process or export as a one-time action. We support multiple ways to export your data:
Get Alerts & Notifications
Keep informed of changes in your data.
Whether youʼre paranoid about the health of your data or want updates once in a while, Mammothʼs alerting features are designed to meet all your needs. We have a complete alert and notification system, so you wonʼt miss a beat.
-
System Alerts
With automation as one of our core offerings, you can set up your data pipeline once and let
it run on a schedule. However, if something amiss affects the process, Mammoth keeps a
close watch and lets users know. -
Timed Reports and alerts
You can set alerts to notify you at any given time, or across any given period. Whether itʼs a
weekly sales report or a one-off notification, Mammoth gives you the flexibility. -
Conditional Reports and Alerts
You can set thresholds and custom conditions to trigger alerts. If something changes
beyond its limits, reaches or exceeds a value that you have set, you will be sent an alert so
you can either go in and prevent something terrible or go out and celebrate!
Reports and Dashboarding
Send your clean data to other visualization platforms
Native reports within Mammoth are coming soon. In the meantime, we provide a host of ways to send your data to other visualization platforms including PowerBI, Google Data Studio and Tableau.