Technology

How to aggregate data by referring to multiple sheets in Google Spreadsheet using multiple functions

  Problem Statement: Suppose you are running a small business or creating a timesheet based cost calculations in any organization as a Lead, then you may need to refer data from different sheets within a single google spreadsheet to get the desired output/result. Also, there might be a case where you want to see and manage the...

by Gaurav Bagla
Tag: Aggregation
23-Jun-2016

Technology

A use case and implementation of MongoDB Aggregation queries.

In any DBMS, aggregations are operations that process data records and return computed results. MongoDB provides a rich set of aggregation operations that examine and perform calculations on the data sets. Running data aggregation on the mongod instance simplifies application code and limits resource requirements. In my current...

by Manish Kapoor
Tag: Aggregation
08-Jun-2015