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.
-
Files from your computer
Drag and drop from the desktop or browse your computer to upload files. We crank our engines to understand data types and structure of your files so that you are ready from the word go.
-
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
-
Data from Third-party providers
Our ever increasing list of third party integrations helps to make sure that you don't need to hop trampolines or write code to access your data, your way
-
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.
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
Clean 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
Apply simple Filters to your data or complicated nested ones, all with a couple of clicks.
-
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
Do conditional annotations by inserting custom values
Extract sub-text
Extract JSON
Split columns
Combine columns
Change case or remove whitespace
-
Numeric Functions
Regular Mathematics function
Rank
Running total
SQL Windows Functions
Find Large/Small values
-
Date Functions
Increment / Decrement date values
Extract part of date
Calculate date difference between two date columns
-
Summarising and Reshaping your data
Pivot
Group
Re-shape
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. Some call them scripts/macros. Mammoth makes this programming free experience
-
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 visual representation of each column in your table for a more accessible and quicker examination.
-
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 different resolutions, 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
Views are containers for analysis you do on a dataset in Mammoth. Your metric, explorations and pipelines are contained within separate views. This gives you the flexibility to do multiple analysis on the same dataset; each analysis leading to different perspectives.
-
Create as many Views as you want
Create multiple views of the same data and run different transformations on them.
-
Assign different Views to different 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 (SQL 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!