munotes®
Sign in
Home / Syllabus / B.Sc. (Information Technology) / TY BSc IT / Semester 6 / Data Analytics and Business Intelligence and Computer Security

B.Sc. (Information Technology) Data Analytics and Business Intelligence and Computer Security Syllabus - Mumbai University 2026

This is the TY BSc IT syllabus under NEP 2020, in force from the academic year 2026-27. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.

Data Analytics and Business Intelligence and Computer Security Syllabus.pdf
Major · Semester 6 · TY BSc IT · 2 credits · 50 marks

Loading syllabus...

Syllabus for Data Analytics and Business Intelligence and Computer Security

Major · Semester 6 · TY BSc IT · 2 credits · 50 marks

Module I

  • 1. Perform the analysis for the following:
  • a Import the data warehouse data in Microsoft Excel and create the Pivot table and Pivot Chart.
  • b Import the cube in Microsoft Excel and create the Pivot table and Pivot Chart to perform data analysis. 2. Apply the what – if Analysis for data visualization. Design and generate necessary reports based on the data warehouse data. Use Excel. 3. Perform the data classification using classification algorithm using R/Python. 4. Perform the data clustering using clustering algorithm using R/Python. 5. Perform the Linear regression on the given data warehouse data using R/Python. 6. 6. Perform the logistic regression on the given data warehouse data using R/Python. 7. Perform lookups using Microsoft Excel
  • a Perform vlookup on any products data.
  • b Perform hlookup on any products data. 8. Create the cube with suitable dimension and fact tables based on ROLAP, MOLAP and HOLAP model. 9. Create dashboard in POWER BI of Sales data. Use scattered chart and cards. 10. Create the dashboard in POWER BI of Netflix dataset.

Module II

  • 21. Configure Routers for
  • a Syslog, NTP, and
  • b SSH Operations
  • c OSPF MD5 authentication. 22. Configure AAA Authentication
  • a Configure a local user account on Router and configure authenticate on the console and vty lines using local AAA
  • b Verify local AAA authentication from the Router console and the PC-A client 23. Configuring Extended ACLs
  • a Configure, Apply and Verify an Extended Numbered ACL 24. Configuring IPv6 ACLs 25. Configure IP ACLs to Mitigate Attacks
  • a Verify connectivity among devices before firewall configuration
  • b Use ACLs to ensure remote access to the routers is available only from management station PC-C.
  • c Configure ACLs on to mitigate attacks. 26. Configuring a Zone-Based Policy Firewall (ZPF)
  • a Verify connectivity among devices before firewall configuration.
  • b Configure a zone-based policy (ZPF) firewall on R3.
  • c Verify ZPF firewall functionality using ping, SSH, and a web browser 27. DHCP Snooping and ARP Inspection 28. Configure IOS Intrusion Prevention System (IPS)Using the CLI
  • a Enable IOS IPS.
  • b Configure logging.
  • c Modify an IPS signature.
  • d Verify IPS 29. Implementing Layer 2 security
  • a Assign the Central switch as the root bridge.
  • b Secure spanning-tree parameters to prevent STP manipulation attacks.
  • c Enable port security to prevent CAM table overflow attacks 30. Implementing Layer 2 VLAN Security
  • a Enable trunking and configure security on the new trunk link 31. Configure and Verify a Site-to-Site IPsec VPN Using CLI 32. Configuring ASA Basic Settings and Firewall Using CLI 33. Exploring Processes, Threads, Handles, and Windows Registry (SysInternals Suite) 34. Use a Port Scanner to Detect Open Ports
  • a Nmap, a port scanner and network mapping, tool to detect open ports 35. Using Wireshark
  • a to Observe the TCP 3-Way Handshake
  • b to Examine a UDP DNS Capture 36. to Examine FTP and TFTP Captures

Text Books

  • 5 Microsoft Excel 365 Bible – Michael Alexander & Richard Kusleika Publisher: Wiley (Covers Pivot Tables, What-If Analysis, Lookups, Data Analysis Tools.)
  • 6 Python for Data Analysis – Wes McKinney Publisher: O’Reilly (Hands-on implementation of regression and data analysis using Python.)
  • 7 R for Data Science – Hadley Wickham & Garrett Grolemund Publisher: O’Reilly( Practical guide for clustering, classification and visualization using R.)
  • 8 Practical Business Intelligence with Power BI – Brett Powell Publisher: Apress (Step-by-step dashboard development.)
  • 1 Business Intelligence Guidebook – Rick Sherman Practical BI implementation strategies.
  • 2 Applied Predictive Modeling – Max Kuhn & Kjell Johnson Regression and classification practical modeling.
  • 3 Power BI Cookbook – Brett Powell Advanced dashboard techniques and case studies.
  • 4 CCNA Security 2.0 Lab Manual

Reproduced from the University of Mumbai syllabus for B.Sc. (Information Technology) under NEP 2020, in force from the academic year 2026-27. Wording is as printed in that syllabus. Module numbering is as printed there too.

The complete syllabus

This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.

PDF BSc IT SEM I & II (2024 25) NEP NEP 2020 syllabus, in force from 2024-25 Read full PDF Read
PDF BSc IT V & VI 2024 25 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read
PDF SY BSc IT 23 24 Earlier Choice Based syllabus, still set for ATKT candidates Read full PDF Read
BSc IT Syllabus Study Path
Start with the year folder.
Use FYBSc IT, SYBSc IT, or TYBSc IT first so your syllabus check matches the semester you are preparing for.
Check units before opening notes.
Use the syllabus to confirm topics, then open BSc IT notes for the same semester.
Practice after the syllabus check.
Move to BSc IT question papers after reviewing the module scope.
FYBSc IT Syllabus SYBSc IT Syllabus TYBSc IT Syllabus BSc IT Notes BSc IT Papers
Report or request
Done!