Sample Analytics Dataset¶
On this page
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.
Collections¶
The sample_analytics database contains the following collections:
Collection Name | Description |
|---|---|
Contains details on customer accounts. | |
Contains details on customers. | |
Contains customer transactions. |
sample_analytics.accounts¶
This collection contains account details for users. Each document contains an account id, a limit and the products that a customer has purchased.
Indexes¶
The sample_analytics.accounts collection contains the following indexes:
Name | Index | Description |
|---|---|---|
_id_ | { "_id": 1 } | Primary key index on the _id field. |
Sample Document¶
{ "account_id": 470650, "limit": 10000, "products": [ "CurrencyService", "Commodity", "InvestmentStock" ] }
sample_analytics.customers¶
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.
Indexes¶
The sample_analytics.customers collection contains the following
indexes:
Name | Index | Description |
|---|---|---|
_id_ | { "_id": 1 } | Primary key index on the _id field. |
Sample Document¶
{ "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" } } }
sample_analytics.transactions¶
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.
Indexes¶
The sample_analytics.transactions collection contains the following
indexes:
Name | Index | Description |
|---|---|---|
_id_ | { "_id": 1 } | Primary key index on the _id field. |
Sample Document¶
{ "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" } ] }