Navigation

Sample Analytics Dataset

The sample_analytics database contains three collections for a typical finanacial services application. It has customers, accounts, and transactions. These are used as part of the exercises for the MongoDB Training on Data Analysis.

To learn how to load the sample data provided by Atlas into your cluster, see Load Sample Data.

The sample_analytics database contains the following collections:

Collection Name
Description
Contains details on customer accounts.
Contains details on customers.
Contains customer transactions.

This collection contains account details for users. Each document contains an account id, a limit and the products that a customer has purchased.

The sample_analytics.accounts collection contains the following indexes:

Name
Index
Description
_id_
{ "_id": 1 }
Primary key index on the _id field.
{
"account_id": 470650,
"limit": 10000,
"products": [
"CurrencyService",
"Commodity",
"InvestmentStock"
]
}

This collection contains customers details including what accounts they hold users. Each document contains username, name, address, birth date, email address, a list of the accounts held, and details on the tier(s) and related benefits they are entitled to.

The sample_analytics.customers collection contains the following indexes:

Name
Index
Description
_id_
{ "_id": 1 }
Primary key index on the _id field.
{
"username": "lejoshua",
"name": "Michael Johnson",
"address": "15989 Edward Inlet\nLake Maryton, NC 39545",
"birthdate": {"$date": 54439275000},
"email": "courtneypaul@gmail.com",
"accounts": [
470650,
443178
],
"tier_and_details": {
"b5f19cb532fa436a9be2cf1d7d1cac8a": {
"tier": "Silver",
"benefits": [
"dedicated account representative"
],
"active": true,
"id": "b5f19cb532fa436a9be2cf1d7d1cac8a"
}
}
}

This collection contains transactions details for users. Each document contains an account id, a count of how many transactions are in this set, the start and end dates for transactions covered by this document, and a list of sub documents. Each sub document represents a single transaction and the related information for that transaction.

The sample_analytics.transactions collection contains the following indexes:

Name
Index
Description
_id_
{ "_id": 1 }
Primary key index on the _id field.
{
"account_id": 794875,
"transaction_count": 6,
"bucket_start_date": {"$date": 693792000000},
"bucket_end_date": {"$date": 1473120000000},
"transactions": [
{
"date": {"$date": 1325030400000},
"amount": 1197,
"transaction_code": "buy",
"symbol": "nvda",
"price": "12.7330024299341033611199236474931240081787109375",
"total": "15241.40390863112172326054861"
},
{
"date": {"$date": 1465776000000},
"amount": 8797,
"transaction_code": "buy",
"symbol": "nvda",
"price": "46.53873172406391489630550495348870754241943359375",
"total": "409401.2229765902593427995271"
},
{
"date": {"$date": 1472601600000},
"amount": 6146,
"transaction_code": "sell",
"symbol": "ebay",
"price": "32.11600884852845894101847079582512378692626953125",
"total": "197384.9903830559086514995215"
},
{
"date": {"$date": 1101081600000},
"amount": 253,
"transaction_code": "buy",
"symbol": "amzn",
"price": "37.77441226157566944721111212857067584991455078125",
"total": "9556.926302178644370144411369"
},
{
"date": {"$date": 1022112000000},
"amount": 4521,
"transaction_code": "buy",
"symbol": "nvda",
"price": "10.763069758141103449133879621513187885284423828125",
"total": "48659.83837655592869353426977"
},
{
"date": {"$date": 936144000000},
"amount": 955,
"transaction_code": "buy",
"symbol": "csco",
"price": "27.992136535152877030441231909207999706268310546875",
"total": "26732.49039107099756407137647"
}
]
}
Give Feedback