Mumbai University Solved Question Papers
October 2025
Previous Year Question Paper with Solution
BSc IT · Sem VI
October 2025 - Business Intelligence Examination
munotes.in
Mumbai
BSc IT Sem VI October 2025 Business Intelligence 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 5 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 October 2025 - Business Intelligence examination.
Contents
The questions below are the paper as the University of Mumbai set it at the October 2025 - Business Intelligence examination, in the order it was set.
MarksPage
MarksPage
MarksPage
The Paper as Set
The questions in this volume are the questions asked at the October 2025 - Business Intelligence 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.What is business intelligence? Describe its architecture.[5]
Answer
For full marks, cover: a definition of business intelligence and its purpose, the architecture layer by layer (data sources, extraction and loading, data warehouse and marts, analysis tools, presentation, decision makers), a diagram, a worked data-loading figure, and the benefits.
What business intelligence is
Business intelligence (BI) is a set of mathematical models and analysis methods that use an organisation's data. They produce information and knowledge useful for decision making. It turns scattered records of sales, customers and operations into reports, forecasts and recommendations. The aim is faster, better-founded decisions in place of guesswork.
The architecture
A BI system is built in layers, each feeding the next.
1. Data sources. Operational systems such as sales, billing, payroll and inventory, plus external data such as market surveys, competitors' prices and web data.
2. Extraction, transformation and loading (ETL). Data is extracted from the sources, transformed (cleaned, checked, converted to common codes and units, combined) and loaded into the warehouse, usually on a schedule.
3. Data warehouse and data marts. The data warehouse is a single, integrated store of historical data, organised by subject for analysis. Data marts are smaller stores for one department, such as marketing or finance. Metadata describes where each item came from and what it means.
4. Analysis tools.
- Query and reporting, for standard and ad hoc reports.
- OLAP (online analytical processing), to slice and drill through data by dimensions such as time, region and product.
- Data mining, to find patterns and build predictive models.
- Optimisation models, to choose the best decision under constraints.
5. Presentation. Dashboards, scorecards, charts and alerts that show the results clearly.
6. Decision makers. Managers and analysts who act on the results, with feedback into new questions.
Draw: a pyramid. From the base up: "Data sources" (operational and external), "ETL", "Data warehouse and data marts", "Data exploration (queries, OLAP)", "Data mining", "Optimisation", and at the top "Decisions". Beside it, an arrow running up labelled "more value for decisions".
Worked figure: a nightly load
A nightly ETL run reads 1,000,000 sales rows. 2,500 fail the checks (missing product code or negative quantity) and are set aside for correction.
- Rows loaded = 1,000,000 - 2,500 = 997,500.
- Rejection rate = 2,500 / 1,000,000 = 0.25 per cent.
A rising rejection rate warns that a source system has a fault, before wrong figures reach the dashboards.
Benefits
- One consistent version of the figures for the whole organisation.
- Faster answers to managers' questions.
- Patterns and forecasts that raw records cannot show.
- Decisions based on evidence, which can be checked later.
Conclusion. Business intelligence uses an organisation's data, through models and analysis, to support decisions. Its architecture runs from data sources through ETL into a data warehouse and marts. Query, OLAP, data mining and optimisation tools work on that store, and dashboards present the results to decision makers. In the worked load, 2,500 of 1,000,000 rows (0.25 per cent) were rejected.
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.