BUSINESS ANALYTICS End Sem Paper 25-26:Chandigarh University

📘 Chandigarh University – MCA/BCA/B.Tech

These Mid-Semester papers are part of the official examinations of Chandigarh University,
designed to test knowledge and practical understanding of core MCA, Computer Applications, and B.Tech subjects.

💡 Each paper encourages students to think critically, apply concepts, and showcase problem-solving skills — helping them prepare for real-world IT challenges.

Usage Condition:

• 📖 Papers are for reference and study purposes only.
• 🧑‍🎓 Students should use them responsibly and not for any malpractice.
• 📅 Availability depends on the course and year.

Instructions

1. This question paper consists of three sections. It is compulsory for students to attempt all questions of Section A and Section C.

2. Students need to attempt any one question from question no. 12 and question no. 13 of Section C.

3. Students have to attempt any one question from question no. 11 and question no. 10 of Section C.

BUSINESS ANALYTICS

Subject Code: 24CAH-703

Semester: 3 | Time: 3 Hours | Max Marks: 60

Section -A

• State the purpose of the LOOKUP function.
  CO1 | BT Level 2

• Define the purpose of using the CASCADE option with the DROP TABLE statement.
  CO1 | BT Level 2

• List the types of joins available in Tableau.
  CO2 | BT Level 1

• State the use of Tableau and its use in data visualization.
  CO3 | BT Level 2

• Define the functions of IF statement in Tableau calculations.
  CO2 | BT Level 1

Section B

6. Classify and evaluate the concept of data analytics and define its statistical significance.
   CO5 | BT Level 4

7. Differentiate the use of DELETE statement with TRUNCATE in SQL and explain the precautions should be taken when using DELETE.
   CO3 | BT Level 4

8. Support the process of connecting Tableau to Excel files. Give an example.
   CO4 | BT Level 3

Section C-(3*10)

• Evaluate the important merits and demerits of using table calculations versus calculation fields in Tableau.
  CO2 | BT Level 4

• Create a PIVOT chart based on the below data usually represented in the companies to transform data into pivot charts for presenting data compared to traditional charts like Excel. (Pivot Chart Example given in question)
  CO3 | BT Level 3

• Using Data Manipulation Language (DML) and functions categorize different data values of employees to use it to study data on an “Employees” table.
  CO4 | BT Level 3

Optional Questions of Section C (Attempt any 1)

12. Create a Story in Tableau that illustrates the sales performance of a company over the last five years. Describe the steps involved.
    CO3 | BT Level 5

OR

13. Design a dashboard in Tableau that includes the chart for sales by region and filter to select the year. Describe the steps involved.
    CO3 | BT Level 5

📄 Download PDF

If you want to download the PDF then click the link below

⬇ Download Now