Mumbai University Solved Question Papers
October 2025
Previous Year Question Paper with Solution
BSc IT · Sem VI
October 2025 - Business Intelligence and Data Analysis Examination
munotes.in
Mumbai
BSc IT Sem VI October 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 October 2025 - Business Intelligence and Data Analysis examination.
Contents
The questions below are the paper as the University of Mumbai set it at the October 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 October 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 term Business Intelligence and list its advantages.[5]
Answer
For full marks, cover: a definition, how BI turns data into decisions (sources, warehouse, analysis, presentation), the questions BI answers, the advantages listed and explained, and an example.
What Business Intelligence is
Business Intelligence (BI) is a set of mathematical models and analysis methods. They use the data an organisation holds to produce information and knowledge for decision making. In practice, BI is the set of processes and tools that collect data from many sources into an analytical store such as a data warehouse. BI then presents it as reports, dashboards and analyses.
The aim is simple: effective and timely decisions, based on facts rather than on intuition alone.
How BI works
- Data sources: sales, accounts, customer records, web logs and outside data.
- ETL: data is extracted, transformed (cleaned and made consistent) and loaded into a data warehouse or data marts.
- Analysis: queries, OLAP, data mining and optimisation models find patterns.
- Presentation: reports, dashboards and visualisations reach the decision maker.
BI first answers what happened and what is happening. Combined with analytics, it also explains why and predicts what will happen.
Advantages of Business Intelligence
- Faster decisions: managers get the information they need without waiting for manual reports.
- Better decisions: choices rest on data and tested models, not only on experience.
- One version of the truth: all departments read the same integrated data, so figures do not conflict.
- Finds trends and opportunities: for example, which products sell together or which regions are growing.
- Detects problems early: falling sales, rising costs or unusual transactions are flagged quickly.
- Better customer understanding: segmentation and purchase history support targeted offers.
- Cost savings: waste in stock, logistics and marketing spending is seen and cut.
- Performance tracking: key performance indicators on dashboards show progress against targets.
- Competitive advantage: a company that learns faster from its data responds faster to the market.
Example
A retail chain's BI dashboard shows that a product sells out in Pune every weekend but sits unsold in Nashik. Stock is moved between stores, so sales rise and waste falls.
Conclusion. Business Intelligence turns an organisation's data into information and knowledge for effective and timely decisions, through data sources, a warehouse, analysis and presentation. Its main advantages are faster and better-founded decisions, a single version of the truth, early detection of problems and opportunities, and lower costs.
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.