.png&w=1920&q=75)
B-COM-HONS in Business Analytics at Sri Guru Nanak Dev Khalsa College
Delhi, Delhi
.png&w=1920&q=75)
About the Specialization
What is Business Analytics at Sri Guru Nanak Dev Khalsa College Delhi?
This Business Analytics focus within the B.Com (Hons.) program at Sri Guru Nanak Dev Khalsa College, while not a formal specialization, allows students to cultivate strong analytical skills. It leverages core quantitative and computer application subjects, preparing students for the burgeoning demand for data-savvy professionals in the Indian business landscape, especially in e-commerce, finance, and marketing sectors. The program''''s strength lies in integrating foundational commerce knowledge with tools for data-driven decision making.
Who Should Apply?
This program is ideal for fresh graduates seeking entry into data analysis roles in finance, marketing, or operations. It also suits individuals with a strong aptitude for numbers and logical reasoning, aspiring to understand business problems through data. Students with a background in mathematics or statistics in their 10+2 will find the quantitative aspects particularly engaging, providing a solid launchpad into an analytics career.
Why Choose This Course?
Graduates of this program can expect to pursue career paths such as Business Analyst, Data Analyst, Financial Analyst, or Marketing Analyst in India. Entry-level salaries typically range from INR 3.5-6 LPA, growing significantly with experience. Students will be well-equipped for roles in consulting firms, e-commerce giants, and financial institutions, aligning with industry demand for professionals who can interpret business data effectively.
Student Success Practices
Foundation Stage
Master Business Statistics Fundamentals- (Semester 1-3)
Dedicate extra effort to ''''Business Statistics'''' (Semester 3), understanding concepts like regression, hypothesis testing, and probability. Utilize online resources such as Khan Academy or NPTEL for supplemental learning to solidify statistical foundations.
Tools & Resources
Khan Academy, NPTEL, NCERT Statistics books
Career Connection
Strong statistical knowledge is the bedrock of business analytics, crucial for interpreting data and building models in any analytical role.
Develop Proficiency in Spreadsheet Tools- (Semester 2-4)
Beyond ''''Computer Applications in Business'''' (Semester 4), take initiative to master advanced Excel functions, pivot tables, and basic VBA for data manipulation and visualization. Attend workshops or complete online courses to build practical skills.
Tools & Resources
Microsoft Excel, Coursera/Udemy Excel courses, YouTube tutorials
Career Connection
Excel proficiency is a fundamental requirement for almost all entry-level business analyst positions in India, enabling efficient data handling and reporting.
Engage in Early Problem-Solving Challenges- (Semester 1-4)
Participate in college-level case study competitions or online platforms that offer business problem-solving challenges. Focus on identifying data requirements and outlining analytical approaches, even without advanced tools initially.
Tools & Resources
Case Study Competitions, Online puzzles/quizzes related to business problems
Career Connection
Early exposure to real-world business problems trains your mind to think analytically and prepares you for case interviews in placements.
Intermediate Stage
Learn a Programming Language for Data- (Semester 3-5)
Self-learn a programming language like Python (with libraries such as Pandas, NumPy) or R, focusing on data cleaning, analysis, and visualization. Complete a beginner-friendly online course or join a coding club.
Tools & Resources
Python (Pandas, NumPy, Matplotlib), R (dplyr, ggplot2), DataCamp, Codecademy
Career Connection
Programming skills are highly valued for automating tasks, handling large datasets, and performing advanced analytics, opening doors to diverse analyst roles.
Pursue Internships focused on Data- (Summer breaks after Sem 2 & 4)
Actively seek internships, even short-term or virtual ones, with startups, NGOs, or small businesses, specifically requesting data-related tasks. This could involve market research data entry, basic report generation, or social media analytics.
Tools & Resources
LinkedIn, Internshala, College placement cell
Career Connection
Practical experience is crucial for understanding real-world data challenges and demonstrates your commitment and capabilities to potential employers in India.
Build a Portfolio of Mini-Projects- (Semester 4-6)
Start building a portfolio by working on small data projects using publicly available datasets (e.g., from Kaggle). Focus on areas like sales forecasting, customer segmentation, or sentiment analysis using learned tools.
Tools & Resources
Kaggle datasets, Google Colab/Jupyter Notebook, Tableau Public
Career Connection
A portfolio showcasing your analytical projects is a powerful tool to differentiate yourself in the competitive Indian job market and illustrate your skills effectively.
Advanced Stage
Gain Proficiency in a Business Intelligence Tool- (Semester 5-6)
Learn a popular BI tool like Tableau or Power BI to create interactive dashboards and reports. Many online courses offer free student licenses or trials, allowing you to visualize data effectively.
Tools & Resources
Tableau Desktop (student license), Microsoft Power BI Desktop (free), YouTube tutorials
Career Connection
Data visualization and reporting skills are critical for communicating insights to stakeholders and are a key requirement for most Business Intelligence and Data Analyst roles.
Undertake a Comprehensive Analytics Project- (Semester 6)
For your final year project or a major assignment, choose a topic that involves extensive data collection, analysis, and visualization. Collaborate with a faculty mentor to ensure depth and rigor, possibly simulating a real-world business case.
Tools & Resources
Academic research papers, Industry reports, Advanced Python/R, SQL
Career Connection
A capstone project demonstrates your end-to-end analytical capabilities and provides a strong talking point during placement interviews, making you industry-ready.
Network and Prepare for Placements- (Semester 6)
Attend industry webinars, career fairs, and connect with alumni working in analytics roles on LinkedIn. Focus on refining your resume and practicing interview questions specifically for data/business analyst positions, including SQL and basic case studies.
Tools & Resources
LinkedIn, College placement cell workshops, Mock interviews, GeeksforGeeks for SQL
Career Connection
Networking opens doors to hidden opportunities, while tailored placement preparation significantly increases your chances of securing a desirable role in the Indian analytics sector.
Program Structure and Curriculum
Eligibility:
- Minimum 40% aggregate in 10+2. Merit calculated on Best Four Subjects including one language, Mathematics, and any two subjects from List B1 as per Delhi University Undergraduate Admissions Bulletin 2024-25.
Duration: 6 semesters / 3 years
Credits: 96 Credits
Assessment: Internal: 30%, External: 70%
Semester-wise Curriculum Table
Semester 1
| Subject Code | Subject Name | Subject Type | Credits | Key Topics |
|---|---|---|---|---|
| BHCC01 | Financial Accounting | Core | 4 | Theoretical Framework of Accounting, Accounting Process, Business Income, Introduction to Indian Accounting Standards, Cash Flow Statement |
| BHCC02 | Business Law | Core | 4 | Indian Contract Act 1872, Special Contracts, Sale of Goods Act 1930, Limited Liability Partnership Act 2008, Information Technology Act 2000 |
| BHCC03 | Microeconomics | Core | 4 | Demand and Supply, Consumer Behaviour, Production and Cost Analysis, Market Structures (Perfect Competition, Monopoly), Factor Pricing |
| AECC-1 | Environmental Studies / MIL Communication | Ability Enhancement Compulsory Course | 4 | Environmental Concepts, Natural Resources, Ecosystems, Biodiversity, Environmental Pollution |
| VAC-1 | Constitutional Values & Fundamental Duties / Ethics & Culture | Value Added Course | 2 | Indian Constitution, Fundamental Rights, Fundamental Duties, Ethical Frameworks, Cultural Diversity |
Semester 2
| Subject Code | Subject Name | Subject Type | Credits | Key Topics |
|---|---|---|---|---|
| BHCC04 | Corporate Law | Core | 4 | Company Formation, Memorandum and Articles of Association, Share Capital and Debentures, Meetings and Resolutions, Winding Up |
| BHCC05 | Human Resource Management | Core | 4 | HR Planning, Job Analysis and Design, Recruitment and Selection, Training and Development, Performance Appraisal |
| BHCC06 | Macroeconomics | Core | 4 | National Income Accounting, Theories of Output and Employment, Inflation, Fiscal Policy, Monetary Policy |
| AECC-2 | English Communication / MIL Communication | Ability Enhancement Compulsory Course | 4 | Grammar and Usage, Reading Comprehension, Written Communication, Oral Communication, Presentation Skills |
| VAC-2 | Yoga and Well-being / Digital Empowerment | Value Added Course | 2 | Introduction to Yoga, Asanas and Pranayama, Meditation Techniques, Digital Literacy, Cyber Security Awareness |
Semester 3
| Subject Code | Subject Name | Subject Type | Credits | Key Topics |
|---|---|---|---|---|
| BHCC07 | Principles of Marketing | Core | 4 | Marketing Concepts, Market Segmentation, Product Life Cycle, Pricing Strategies, Promotion and Distribution |
| BHCC08 | Income Tax Law & Practice | Core | 4 | Basic Concepts of Income Tax, Residential Status and Tax Liability, Heads of Income, Deductions from Gross Total Income, Computation of Taxable Income |
| BHCC09 | Business Statistics | Core | 4 | Descriptive Statistics, Probability Theory, Sampling Methods, Hypothesis Testing, Correlation and Regression Analysis |
| SEC-1 | E-Commerce / Computerized Accounting System / Cyber Security / etc. (Student Choice) | Skill Enhancement Course | 2 | E-commerce Business Models, Payment Systems, Digital Marketing, Tally ERP/SAP Basics, Data Entry and Reporting |
| GE-1 | Generic Elective 1 (Interdisciplinary - Student Choice) | Generic Elective | 4 | Topics vary based on chosen discipline (e.g., Psychology, History, Languages), Analytical Skills, Critical Thinking, Communication, Research Methods |
Semester 4
| Subject Code | Subject Name | Subject Type | Credits | Key Topics |
|---|---|---|---|---|
| BHCC10 | Financial Management | Core | 4 | Financial Goals, Capital Budgeting, Cost of Capital, Working Capital Management, Dividend Policy |
| BHCC11 | Cost Accounting | Core | 4 | Cost Concepts and Classification, Cost Sheet Preparation, Marginal Costing, Budgetary Control, Variance Analysis |
| BHCC12 | Computer Applications in Business | Core | 4 | Database Management Systems (MS Access), Spreadsheet for Business (MS Excel), Word Processing (MS Word), Presentation Software (MS PowerPoint), Introduction to Business Software |
| SEC-2 | Financial Modeling and Derivatives / Business Research Methods / etc. (Student Choice) | Skill Enhancement Course | 2 | Financial Statement Analysis, Forecasting Models, Derivative Instruments (Futures, Options), Data Collection Methods, Statistical Tools for Research |
| GE-2 | Generic Elective 2 (Interdisciplinary - Student Choice) | Generic Elective | 4 | Topics vary based on chosen discipline, Problem-solving, Interdisciplinary analysis, Critical evaluation, Communication skills |
Semester 5
| Subject Code | Subject Name | Subject Type | Credits | Key Topics |
|---|---|---|---|---|
| BHCC13 | Auditing & Corporate Governance | Core | 4 | Auditing Concepts, Internal Control System, Audit Planning and Procedures, Corporate Governance Principles, Role of Independent Directors |
| BHCC14 | Goods & Services Tax (GST) & Customs Law | Core | 4 | GST Introduction and Mechanism, Input Tax Credit, Time and Value of Supply, Customs Act 1962, Valuation and Types of Duties |
| BHCC DSE-1 | Discipline Specific Elective 1 (Student Choice from list) | Discipline Specific Elective | 4 | Options may include: Investment Analysis & Portfolio Management, Financial Reporting and Analysis, International Business, Management Accounting, etc., Data interpretation, Strategic decision-making, Advanced analytical techniques, Industry specific data analysis |
| BHCC DSE-2 | Discipline Specific Elective 2 (Student Choice from list) | Discipline Specific Elective | 4 | Options may include: Auditing & Corporate Governance, Marketing Management, Fundamentals of Corporate Tax Planning, Industrial Laws, etc., Financial data interpretation, Market trend analysis, Legal data analysis, Operational efficiency metrics |
Semester 6
| Subject Code | Subject Name | Subject Type | Credits | Key Topics |
|---|---|---|---|---|
| BHCC DSE-3 | Discipline Specific Elective 3 (Student Choice from list) | Discipline Specific Elective | 4 | Options may include: Banking and Insurance, Advertising, Consumer Affairs, etc., Market research, Customer behavior analysis, Risk assessment, Regulatory compliance data |
| BHCC DSE-4 | Discipline Specific Elective 4 (Student Choice from list) | Discipline Specific Elective | 4 | Options may include: Rural Marketing, E-business, Organisational Behavior, etc., Digital business analytics, Consumer engagement metrics, Supply chain analytics, HR data analysis |
