Scribd
Upload
14 views2 pages

NoSQL Lab Experiments

The document outlines two experiments focused on data analysis using NoSQL databases. Experiment 1 involves querying a data warehouse with MongoDB to generate sales reports, while Experiment 2 implements an Executive Information System using CouchDB to derive strategic insights from business data. Both experiments aim to enhance students' understanding of analytical queries and reporting in data-driven decision-making.

Uploaded by

PREM YADAV
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

NoSQL Lab Experiments

The document outlines two experiments focused on data analysis using NoSQL databases. Experiment 1 involves querying a data warehouse with MongoDB to generate sales reports, while Experiment 2 implements an Executive Information System using CouchDB to derive strategic insights from business data. Both experiments aim to enhance students' understanding of analytical queries and reporting in data-driven decision-making.

Uploaded by

PREM YADAV
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Topics Covered: Query & Reporting, Executive Information Systems (EIS), Data Warehouse

Strategy, Document-Oriented NoSQL Databases (MongoDB, CouchDB)

Experiment 1: Querying and Repor ng on a Data Warehouse using MongoDB


Objec ve
To understand how data warehouses support analytical queries and reporting and to
implement query-based reporting using the MongoDB aggregation framework.

Tools Required
• MongoDB

• MongoDB Compass or Mongo Shell

• Sample Sales Dataset

Dataset Descrip on
A sample sales dataset containing ields such as Order_ID, Product_Name, Category, Region,
Sales_Amount, Order_Date, and Customer_ID.

Tasks
1. Install MongoDB and create a database named salesDW.

2. Create a collection named sales and insert sample sales records.

3. Write a query to display all sales records.

4. Generate a report showing total sales by region using aggregation.

5. Generate a report showing total sales by product category.

6. Identify the top-selling products using aggregation queries.

Expected Outcome
Students will be able to perform analytical queries and generate reports from a MongoDB-
based data warehouse dataset.

Experiment 2: Implemen ng Execu ve Informa on System (EIS) using CouchDB


Objec ve
To implement a simple Executive Information System (EIS) using CouchDB and generate
strategic business insights from stored business data.

Tools Required
• CouchDB

• Fauxton Web Interface

• Sample Business Dataset


ti
ti
ti
ti
f
ti
ti
ti
Dataset Descrip on
A business performance dataset containing ields such as Product_ID, Product_Name,
Region, Revenue, Quarter, and Year.

Tasks
7. Install CouchDB and open the Fauxton web interface.

8. Create a database named businessDW.

9. Insert JSON documents representing product sales records.

10. Create a Map function to emit revenue by region.

11. Apply a Reduce function to compute total revenue by region.

12. Generate executive-level reports such as revenue by region, quarterly revenue trends,
and top performing products.

Expected Outcome
Students will understand how Executive Information Systems use NoSQL databases to
support strategic decision-making through summarized analytical reports.
ti
f

You might also like