Mumbai University Solved Question Papers
March 2025
Previous Year Question Paper with Solution
BSc IT · Sem VI
March 2025 - Business Intelligence and Data Analysis Examination
munotes.in
Mumbai
BSc IT Sem VI March 2025 Business Intelligence and Data Analysis Question Paper with Solutions
Get access to whole semester resourcesSemester Pass
MU B.Sc. (Information Technology) student group
Free to join
First published on munotes.in on 4 November 2026.
Published by munotes.in, Mumbai.
Model answers written and edited by the munotes.in editorial desk.
Passages from this volume may be quoted, in print, online or by an AI system, with credit: name munotes.in and link to this volume's page. The volume may not be reproduced as a whole. Full terms at munotes.in/content-license.
munotes.in is an independent study resource for students of the University of Mumbai. It is not affiliated with the University of Mumbai, and is not endorsed by it.
The University does not publish an official answer key for this paper. The answers in this volume are model answers, written to show how a full-mark answer is built. They are a study aid, not an authority on what an examiner marked.
The question paper reproduced here is the paper as set by the University of Mumbai at the March 2025 - Business Intelligence and Data Analysis examination.
Contents
The questions below are the paper as the University of Mumbai set it at the March 2025 - Business Intelligence and Data Analysis examination, in the order it was set.
MarksPage
MarksPage
The Paper as Set
The questions in this volume are the questions asked at the March 2025 - Business Intelligence and Data Analysis examination, reproduced as the University of Mumbai set them, in the order it set them. Nothing has been reworded, added or left out. Only the answers are ours. See the original question paper.
Duration 2½ hours · Total marks 75 · 30 questions answered
How to use this volume
Solve the paper first, under exam conditions and against the clock. Then read the answers here and mark your own. Reading a solution before attempting the question feels productive and teaches very little, because recognising an answer is not the same as being able to write one.
SECTION I
1.
Attempt any three of the following · 15 Marks
a.Explain the three main components of Business Intelligence?[5]
Answer
For full marks, cover: what business intelligence is, the three main components (data sources, data warehouses and data marts, BI methodologies) with what each holds or does, how data flows through them, and an example.
Business intelligence
Business intelligence (BI) is the set of mathematical models and analysis methods that turn an organisation's data into information and knowledge for better decisions. A BI system rests on three main components.
Component 1: Data sources
BI first gathers data from many places.
- Operational systems: the databases of sales, purchasing, accounts, payroll and inventory, often ERP and CRM systems.
- Unstructured internal data: e-mails, documents and logs.
- External data: market research, government statistics, social media and data bought from agencies.
These sources differ in format, quality and timing. The challenge is to bring them together consistently.
Component 2: Data warehouses and data marts
The data is extracted from the sources, cleaned, transformed and loaded (ETL) into a central store.
- A data warehouse is an integrated, subject-oriented, time-stamped and non-volatile collection of data for the whole organisation. Unlike operational databases, it keeps history and is designed for analysis, not for daily transactions.
- Data marts are smaller stores for one department or subject, such as marketing or finance, drawn from the warehouse.
This component makes data reliable, consistent and quick to query.
Component 3: BI methodologies
The third component is the set of methods that analyse the stored data and support decisions.
- Reporting and OLAP: multidimensional analysis, slicing sales by region, product and month.
- Exploratory analysis and visualisation: charts and dashboards that reveal patterns.
- Data mining: classification, clustering and association rules to find hidden patterns and predict.
- Optimisation and mathematical models: choosing the best plan, such as production quantities or prices.
- Time series and forecasting: predicting demand.
The results reach decision makers through reports, dashboards and alerts.
How they connect
Draw: three boxes left to right. "Data sources" (operational, external, documents) with an arrow labelled "ETL" to "Data warehouse and data marts", then an arrow to "BI methodologies" (OLAP, data mining, optimisation, forecasting), and finally an arrow to "Decision makers".
Example
A retail chain collects till data from 200 stores and weather data from an outside agency (sources). Each night the data is loaded into its warehouse, with a marketing data mart (warehouse). Analysts use OLAP and a forecasting model to plan stock before the monsoon (methodologies).
Conclusion. The three main components of business intelligence are the data sources, the data warehouses and data marts, and the BI methodologies. The warehouses integrate and store the data, and the methodologies analyse it. Together they carry raw data from scattered systems to the decision maker as useful knowledge.
The rest of the answers
The first answer is free. The rest come with the B.Sc. (Information Technology) Semester 6 solved papers.
You have read the question paper and its first answer in full. Buy the solved papers once and you can read every answer of every solved paper in this semester.
Notes + practical solutions + solved papers: ₹798 Already bought it? Sign in
Or solved papers only: ₹499
Or notes + practical solutions: ₹499
The question paper itself stays free, and so does the syllabus.
Found an error in this volume? Report it and we will check it against the paper.