Associate Business Analyst - Rathinam College



DEPARTMENT OF COMPUTER SCIENCERATHINAM COLLEGE OF ARTS AND SCIENCE (AUTONOMOUS)RathinamTechzone, Pollachi Road, Eachanari, Coimbatore – 641021Program forM.Sc. Data Science and Business Analysis(M.Sc. DSBA) (I, II, III and IV Semester) 2019 – 2021 Batch onwardsRATHINAM COLLEGE OF ARTS AND SCIENCE (AUTONOMOUS)Scheme of curriculum for M.Sc. Data Science and Business AnalysisBatch admitted during 2019 - 2021Board of Studies – Computer Science (PG)Vision and Mission of the Institution:VISIONA world renowned INDUSTRY-INTEGRATED INSTITUTION that imparts knowledge, skill, and research culture in young men and women to suit emerging young India. MISSIONTo provide quality education at affordable cost, and to maintain academic and research excellence with a keen focus on INDUSTRY-INTEGRATED RESEARCH AND EDUCATION. MOTTOMeaningful INDUSTRY-READY education and research by all meansVision and Mission of the Department:VISIONTo inculcate candidates with technical competency and skill professionalism to make them competent to undertake the current challenges in industrial sector with a focus on societal transformation.MISSIONTo import quality based education by enhancing the talent, innovative idea, and problem solving skill and to promote the research project by establishing industrial linkage and entrepreneurial setup.IntroductionBattle for high-quality jobs is getting tougher in this competitive world, so it’s more important than ever to have the best qualifications possible for better career opportunities. Studying for an MSc for sake, won’t be enough by itself to get into the commendable level, but it could be extremely rewarding in other ways if one plans better. Masters in cross level programme from under graduation would widen the scope of career opportunity in this competitive world with higher quotient in selection for both the fields.Upgrading one’s qualifications and getting an MSc is a brilliant way to prove the potential and sustainable employers that one have what it takes to work in a high-profile position. Not only does it demonstrate the potential candidate can handle additional responsibility, it also suggests that added value and asset to the organization. That is the reason, why many of the senior managers at leading companies tend to have a master’s degree. Master in Business Analytics will prove the quality of a candidate in this “Data Era”.Career? Or Job? Both the terms are actionably seeming to be related but not for sustainable development and goal achievement. Career meant for long term, futuristic and sustainable. Job doesn’t. Choosing career after university education is a deciding factor for one’s living standards. At this current situation, heavily populated country like India, getting employment is a bigger challenge. Making better decision about career plan is the primary achievement, as career plan enhance the one’s future value. After globalization, career evangelist come up with new era called “Data Era”, as from last two years of data generation is approximately equal to the data generated in past all years. Hence, every industry dumped with 4V’s of data – Volume, Velocity, Variety and Veracity, and they are need to be analysed for the better nurturement of business with meaning insights.Irrespective of any business domain, industries are in dire need of analysing their huge volume of data in a proper way to come up with new insights which will help them in revenue generation and business development. There is a huge dearth of resource person on analysing the data and bringing with new ideas in parallel and vertical development of their business.Business Analytics refers to the skills, technologies, practices that are applied on past data and/or processes to derive insights that can be used for future business planning. It is a field that is now applied across all domains and industries. The comprehensive Business Analytics curriculum provides a framework through which participants learn to enhance their management skills, expand their knowledge of Business Analytics, and gain a strategic perspective of the industry. Business analytics refers to the ways in which enterprises such as businesses, non-profits, and governments can use data to gain insights and make better decisions. Business analytics is applied in operations, marketing, finance, and strategic planning among other functions. The ability to use data effectively to drive rapid, precise and profitable decisions has been a critical strategic advantage for companies as diverse as Walmart, Google, Capital One, and Disney. For example, Capital One uses sophisticated analytic capabilities to match credit card offerings to customers more accurately than their competition. Walmart uses analytics to monitor and update its inventory in a way that allows it to serve its customers at an exceptionally low cost.The programme’s courses and the final project are designed around the real-world integration of business disciplines. Apart from these courses, there are preparatory courses which will have to be completed before the programme begins.Business AnalystAssociate Business AnalystStatisticianData ArchitectJunior StatisticianMarket Research AnalystData Analytics ManagerHealth Care AnalystSome of the important positions of Business Analyst Professionals in an organization are as follows:How Two Year M.Sc (BA) Beneficial?2-year Master of Science in Business Analyst helps a student to gain employment in the following job areas:IndustryEntry level (0-2 years exp.)Mid-Level (3-5 years exp.)Advanced level (5 years plus exp.)Average SalaryRs. 5,00,000 – 7,00,000Rs. 7,00,000 – 10,00,000Rs. 10,00,000 +2-year Master of Science in Business Analyst is also highly beneficial to start one’s own business as an analytics outsourcing or an independent Business Analyst consultant.Salient features:This program offers Business Analytics specialization focused on pre-processing, Storing and analytics of data for business environment.The Program is designed to impart strong knowledge of R programming and Python fundamentals, Business Management Concepts followed by conceptual and practical knowledge of Data Science Techniques and Big Data Analytics.The Program offers a unique value proposition by combining the important subject areas in each of these new age fields of study for Analyst industry.The program offers a wide range of technical and programming skill sets that complement the specialization subjects on Business Analytics.This program is primarily aimed at offering student’s flexibility in making their career choices in Business Management, Project Management , Data Management, Data Analytics and Data Visualisation.The program ignite the spark of interest in widening their knowledge on business analytics techniques in different business domains.Program Educational Objectives (PEO)PEO1:Graduates of this programme will establish as effective professionals by learning technical skills in Business Analytics field and can pursue higher education by accruing knowledge and research.PEO2:To impart sound theoretical foundation and In-depth practical knowledge to analyse the key business processes that drive the value chain of an organization throughout the entire product life cycle.PEO3:Implement a classroom + practical oriented curriculum that helps students understand the Business Analytics Techniques and associated advanced techniques. To understand and analyse models, tools and techniques for enforcement of business analyst to different business industries.PEO4:Provide solutions, assessments and validation to a broad range of situations by eliciting, planning, monitoring and analysing enterprise requirements.PEO5:Provide a platform for students to understand various Business Analytics techniques of data preprocessing, storing, descriptive and predictive analytics.PEO6:Prepare data for statistical analysis, perform basic exploratory and descriptive analysis, and apply statistical techniques to analyze dataPEO7:To learn and explore how visualization makes decision makers to understand the business in quick and taking rightful decisions.Mapping of Institute Mission to PEOInstitute Mission PEO’sTo provide quality education at affordable cost, and to maintain academic standards and research excellence with a keen focus on INDUSTRY-INTEGRATED RESEARCH AND EDUCATION.PEO1, PEO5, PEO7Mapping of Department Mission to PEODepartment Mission PEO’sTo provide better understanding of Business Analytics at top level standards and provide hands on experience in major industry demanded business analytics techniques with a keen focus on INDUSTRY-INTEGRATED RESEARCH AND EDUCATION.PEO2, PEO3,PEO4, PEO6Program Outcomes (PO):PO1:To a given scenario, students will be able to analyze the problem, design strategies and technical requirement to solve them with the meaningful insights for business development.PO2:Student will be able to understand the suitable statistical technique for algorithmic design of the given problem statementPO3:Students will be able to apply clean the data and pre-process them to get ready for the model building and implement the model in the system for required decision making process.PO4:Students will be able to apply their knowledge of machine learning for the better built model with bringing up of meaningful insights to the decision makers.PO5:Students will be able to develop new or improved innovative business processes from gap analysis through process design in support of a company's strategic objectives in a socially responsible manner.PO6:Students will be able to Learn and identify business opportunities and designsolutions and they will be able to discover how to optimize project investmentsPO7:Students will be able to apply descriptive, predictive and prescriptive analytics to business modelling and decision-makingCorrelation between the POs and the PEOsProgram OutcomesPEO1PEO2PEO3PEO4PEO5PEO6PEO7PO1:√√√√PO2:√√√√PO3:√√√√√PO4:√√√√√PO5:√√√√√PO6:√√√√√PO7:√√√√√Components considered for Course Delivery is listed below:1. Class room Lecture2. Laboratory class and demo3. Assignments4. Mini Project5. Project6. Online Course7. External Participation8. Seminar9. Internshipapping of POs with Course Delivery:Program OutcomesCourse Delivery123456789PO1√√√√√√√PO2√√√√√√√PO3√√√√√PO4√√√√√PO5√√√√√PO6√√√√√√√√PO7√√√√√√√√√Course MatrixS.NoSemPartTypeSubjectCreditHourIntExtTotal11IIITheoryBusiness Fundamentals - 133406010021IIITheoryBusiness Statistics and Probability33406010031IIITheoryOperating System33406010041IIITheoryR Programming Language34406010051IIITheoryBusiness Economics33406010061IIITheoryDatabase Management System34406010071IIIPracticalR Programming Language Lab45406010081IIIPracticalDatabase Management System Lab454060100??????????12IIITheoryBig Data Analytics33406010022IIITheoryMachine Learning33406010032IIITheoryAnalytics using Excel33406010042IIITheoryPython Programming33406010052IIITheoryData Mining Techniques33406010062IIITheoryBusiness Fundamentals - II33406010072IIIPracticalBig Data Analytics Lab44406010082IIIPracticalPython Programming Lab44406010092IIIPracticalAnalytics using Excel Lab444060100??????????13IIITheoryMarket Research and Analytics33406010023IIITheoryExploratory Data Analysis34406010033IIITheoryElective I33406010043IIITheoryElective II33406010053IIITheoryFinancial Econometrics33406010063IIITheoryOperations Research34406010073IIIPracticalMarket Research and Analytics Seminar45406010083IIIPracticalFinancial Econometrics Lab454060100??????????14IIITheoryProject Management34406010024IIITheoryElective III34406010034IIITheoryBusiness Intelligence33406010044IIITheoryMajor Project / Internship1015406050054IIIPracticalBusiness Intelligence Lab444060100?????1051201200??18003400List of Electives:ElectiveSubject NameElective – IArtificial Neural NetworksPredictive AnalyticsElective – IICloud ComputingCloud Infrastructure ServicesElective – IIIText AnalyticsSocial and Web Media AnalyticsDistribution of Credits Semester-wiseSemesterCredits126230326423Total105 Syllabus:SEMESTER -1Syllabus TitleBusiness Fundamental - ITotal Hours45Credits03Course Objectives: To understand the basic managerial functions of planning, organizing, staffing, directing, and controlling resources to accomplish organizational goals. To understand the concept of management and the role of the manager at each level of the organization To understand the skills that are necessary for a manager to be effective.Course Outcomes: On successful completion of the module students will be able to:Developed working knowledge of fundamental terminology and frameworks in the four functions of management: Planning, Organizing, Leading and Controlling; Analyze organizational case situations in each of the four functions of managementIdentify and apply appropriate management techniques for managing contemporary organizations; and Understand the skills, abilities, and tools needed to obtain a job on a management track in an organization of their choice.Module -1 9 Hrs.Introduction to Management: Defining Management, Concept of Management, Nature, Importance, Management Skills, Levels of Management, Role of managers, Characteristics and Quality Managers, Evolution of Management thought, Organization and the environmental factors.Business ethics and Social Responsibility: Concept, Shift to Ethics, Tools for Ethics.Module -2 9 Hrs.Planning : Nature and purpose of planning, Planning process, Types of plans, Process of planning, Barriers to Effective Planning, Objectives, Managing by objective (MBO) Strategies, Types of strategies, Policies, Decision Making, Types of decision, Decision Making Process, Rational Decision Making Module - 3 9 anizing: Nature and purpose of organizing, Organization structure, Formal and informal groups / organization, Line and Staff authority, Departmentation, Span of control, Centralization and Decentralization, Delegation of authority, Staffing, Selection and Recruitment, Orientation, Career Development, Career stages, Training, Performance Appraisal. Module-4 9 Hrs.Directing: Creativity and Innovation, Motivation and Satisfaction, Motivation Theories, Leadership Styles, Leadership theories, Communication, Barriers to effective communication, Organization Culture, Elements and types of culture, Managing cultural diversity.Module-5 9 Hrs.Controlling: Process of controlling, Types of control, Methods: Pre-control, Concurrent Control, Post-control, Budgetary and non-budgetary control Q techniques, Managing Productivity, Cost Control, Purchase Control, Maintenance Control, Quality Control, Planning operations.Text Books:Stephen P. Robbins and Mary Coulter, 'Management', Prentice Hall of India, 8th edition. Charles W L Hill, Steven L McShane, 'Principles of Management', Mcgraw Hill Education, Special Indian Edition, 2007. Reference Books:Hellriegel, Slocum & Jackson, ' Management ,A Competency Based Approach’, Thomson South Western, 10th edition, 2007. Harold Koontz, Heinz Weihrich and Mark V Cannice, 'Management ,A globalTitleBusiness Statistics and ProbabilityTotal Hours45Credits03Course Objectives: To understand the basic concepts of statistics and probability.To understand the description of data using statistical techniquesTo understand the summary of data using statistical measuresTo understand the statistical methods involved in hypothesis testingTo understand the ANOVA and its importance in business performance.Course Outcomes: On successful completion of the module students will be able to:Able to know the importance of statistics in different research areas.Able to know the basic concepts of Statistics and its evolution.Able to apply suitable statistical measures to describe and summarize the dataAble to apply t and f test for testing the statistical measures to know the significance.Able to apply ANOVA for testing significance of arithmetic mean and regression coefficients.Module -1 9 Hrs.Descriptive Statistics: Data and Data Sources, Types of Data, Measures of Central Tendency – Mean, median mode for raw and grouped data, measures of dispersion – Range, standard deviation, variance, coefficient of variation, mean deviation, mean absolute deviation, measures of symmetry: Skewness and Kurtosis.Module -2 9 Hrs.Elements of Probability and Sampling Distributions: Experiments and events, Basic Relations of Probability, Conditional Probability, Joint Probability, conditional probability on discrete case and continuous case, computing expectations by conditioning, introduction to Bayes theorem, problems related to Bayes Theorem, Discrete Probability Distribution (Binomial and Poisson), Continuous Probability Distribution (Normal). Various types of Probability and Non-probability Sampling, Sampling distribution of important statistic. Module – 3 9 Hrs.Hypothesis Testing : Introduction to testing of hypothesis, Statistical assumptions for parametric test, Level of significance, confidence level, Type I Error, Type II error, Critical value, power of the test, sampling distribution, small sample test – t test for one sample and two sample mean, F test to test the equality of two sample variance, Large Sample test – Z test for equality of single mean with population mean, equality of two sample mean, equality of single proportion with population proportion and equality of two sample proportions.Module-4 9 Hrs.Correlation and Regression Analysis: Correlation analysis, properties of correlation coefficients, significance of single correlation coefficient, significance of multiple correlation coefficients, concepts of multiple correlation and partial correlation, Introduction to linear model, concepts of factor, effect, residuals, dependency, independency, assumptions of linear model, difference between linear and nonlinear model, estimation of parameters of regression coefficients for simple and multiple linear regression model, properties of regression coefficients, significance of regression coefficients, diagnostic testing: auto correlation, multi collinearity, heteroscedasticity, normality, significance of estimated parameters in multiple linear regression,.Module-5 9 Hrs.Linear Model:Introduction to general linear model, assumptions of ANOVA, factors and levels in ANOVA, layout of one way ANOVA, skeleton of one way ANOVA, multiple comparison of sample means, one way analysis of variance with unequal sample sizes, two factor analysis of variance – introduction and parameter estimation, two way analysis of variance with interaction, Post ANOVA: testing of hypothesis for significance of mean using Fishers Least Significance Difference test (lsd), Tukeys test, Dunnet test, Duncan Multiple Range test.Text Books:Fundamentals of mathematical statistics – SC Gupta and VK Kapoor, Sultan Chand & Sons Publication, New DelhiReference Books:Introduction to probability Models, Ninth Edition – Sheldon M. Ross, Elsevier Publication, Academic Press, UKIntroduction to Probability and Statistics for Engineers and Scientists, Third Edition - Sheldon M. Ross, Elsevier Publication, Academic Press, UKTitleOperating SystemTotal Hours45Credits03Course Objectives: In this course students will be able to:Computer System ArchitectureOperating System OperationsProcess management and SynchronizationDeadlocks System ModelMemory Management StrategiesDistributed SystemsCourse Outcomes: On successful completion of the module students will be able to:Understand Operating System Structure and OperationsUnderstand Process concept and multithreaded programming Process Synchronization in Operating System Memory Management Strategies and File SystemDistributed System ArchitectureModule -1 9 Hrs.Introduction to Operating Systems: Computer System organization, Computer System architecture, Operating System structure, Operating System operations, Process management, Memory management, Storage management, Protection and security, Special-purpose systems, Computing environments, Operating System Services, User interface, System calls, System programs, Operating System design and implementation, Operating System structure, Operating System generation, System boot- Case Study. Module -2 9 Hrs.Process Management: Process concept, Process scheduling, Operations on processes, Inter-process communication, Multi-Threaded Programming Overview, Multithreading models, Thread Libraries, Threading issues, Process Scheduling Basic concepts, Scheduling criteria, Scheduling algorithms, Multiple-Processor scheduling, Thread scheduling- Case Study.Module – 3 9 Hrs.Process Synchronization and Deadlocks: Process Synchronization, The Critical section problem, Peterson’s solution, Synchronization hardware, Semaphores, Classical problems of synchronization, Monitors, Deadlocks System model, Deadlock characterization, Methods for handling deadlocks, Deadlock prevention, Deadlock avoidance, Deadlock detection and recovery from deadlock- Case StudyModule-4 9 Hrs.Memory Management and File System: Memory Management Strategies, Background, Swapping, Contiguous memory allocation, Paging, Structure of page table, Segmentation, Virtual Memory Management Background, Demand paging, Copy-on-write, Page replacement, Allocation of frames, Thrashing, File System: File concept, Access methods, Directory structure, File system mounting, File sharing, Protection. Implementing File System: File system structure, File system implementation, Directory implementation, Allocation methods, Free space management- Case Study.Module-5 11 Hrs.Introduction to Distributed Systems: Perimeter, Firewall and Internal Routers, Introduction to Access Lists, Standard Access Lists, Extended Access Lists, Turning Off and Configuring Network Services, Monitoring Access Lists,Introduction to NAT, Types of Network Address Translation, How NAT Works, Testing and Troubleshooting NAT, Configure and verify PPP and MLPPP on WAN interfaces using local authentication, Configure PPPoE client-side interfaces using local authentication, Configure GRE tunnel connectivity, Describe WAN topology options,Describe WAN access connectivity options.Case Study: Remote Procedure call in DCE.Text Books:Abraham Silberschatz, Peter Baer Galvin , Greg Gagne: Operating System Principles, 7th edition, Wiley-India, 2006. Distributed Operating Systems: Concepts and Design by Pradeep K. Sinha, 1st edition, PHI LearningReference Books:D.M Dhamdhere: Operating systems - A concept based Approach, 2nd Edition, Tata McGraw- Hill, 2002.P.C.P. Bhatt: Operating Systems, 2nd Edition, PHI, 2006.Harvey M Deital: Operating systems, 3rd Edition, Addison Wesley, 1990TitleR Programming LanguageTotal Hours60Credits03Course Objectives: To understand the basic concepts of R programming language.To understand the data structures in R programming language.To understand the important packages and functions in R programming language.To understand the procedure for summary statistics and parametric testing of hypothesis using R programming Language.To understand the functions for graphs and non-parametric testing of hypothesis in R programming Language.Course Outcomes: On successful completion of the module students will be able to:Know the procedure to read and write different format of data set into R environment.Understand the uniqueness in R programming with the help of apply function in R programming language.Apply different options in I/O operations in R programming Language.Know the interpretation of summary statistics and testing of hypothesis.Know the built-in functions for graphs and non-parametric testing of hypothesis in R.Module -1 9 Hrs.Introduction to R Environment: History and development of R Statistical computing programming language, installing R and R studio, getting started with R, creating new working directory, changing existing working directory, understanding the different data types, installing the available packages, calling the installed packages, arithmetic operations, variable definition in R, simple functions, vector definition and logical expressions, matrix calculation and manipulation using matrix data types, workspace management, help function in R environment.Module -2 12 Hrs.Data Structures and Control StatementsIntroduction to different data types, vectors, atomic vectors, types and tests, coercion, lists, list indexing, function applying on the lists, adding and deleting the elements of lists, attributes, name and factors, matrices and arrays, matrix indexing, filtering on matrix, generating a covariance matrix, applying function to row and column of the matrix, data frame – creating, coercion, combining data frames, special types in data frames, operations in data frame, applying functions: lapply( ) and sapply( ) on data frames, control statements, loops, looping over non vector sets, arithmetic and Boolean operators and values, branching with if, looping with for, if-else control structure, looping with while, vector based programming.Module – 3 12 Hrs.I/O operations and String ManipulationsIntroduction to I/O functions in R, accessing I/O devices, using of scan( ), readline ( ) function, comparison and usage of scan and readline function, reading different format files into R: text file, CSV file, Statistical package files, xls and xlsx files, reading data frame files, converting from one format to another using in built function, writing different file format in to the local machine directory, getting file directory information, accessing the internet : overview of TCP/IP, sockets in R, basics of string manipulations – grep ( ), nchar ( ), paste( ), sprintf( ), substr( ), regexpr( ), strsplit( ), testing of file name with given suffix.Module-4 12Hrs.R for Summary Statistics and Parametric TestsDescriptive statistics – summary statistics for vectors, making contingency tables, creating contingency tables from vectors, converting objects in to tables, complex flat tables, making ‘Flat’ contingency tables, testing tables and flat table objects, cross tables, testing cross tabulation, recreating original data from contingency tables, switching class, mean (arithmetic, geometric and harmonic), median, mode for raw and grouped data, measure of dispersion – range, standard deviation, variance, coefficient of variation, testing of hypothesis – small sample test, large sample test – for comparing mean, proportion, variance (dependent and independent samples), correlation and regression – significance of correlation and regression coefficientsModule-5 15 Hrs.R for Graphs, Nonparametric Tests and ANOVAIntroduction to graphs, Box-Whisker Plot, Scatter plots, pairs plots, line chart, Pie Chart, Cleveland Dot Charts, Bar Charts, Customization of charts, non-parametric test: The Wilcoxon U-Test (Mann-Whitney): One and Two-Sample U-Test, Tests for association: Chi Square Tests, Monte Carlo simulation, Yates Correction for 2X2 Tables, single category goodness of fit tests, Analysis of Variance for one-way variation and two variation – with and without interaction, Text Books:The art of R programming – Norman Matloff, no starch Press, San Francisco.R in Action – Robert I. Kabacoff, Second Edition, Dreamtech Press.Reference Books:Introduction to Scientific Programming and Simulation using R – Owen Jones, Robert Maillardet and Andrew Robinson, CRC PressAdvanced R – Hadley Wickham, CRC Press.TitleBusiness EconomicsTotal Hours45Credits03Course Objectives: To equip the students of management with time tested tools and techniques of business economics to enable them to appreciate its relevance in decision-making.To explore the economics of information and network industries and to equip students with an understanding of how economics affect the business strategy of companies in these industries.Course Outcomes: On successful completion of the module students will be able to:It equip the students to Design competition strategies, including costing, pricing, product differentiation, and market environment according to the natures of products and the structures of the markets.It develop economic way of thinking in dealing with practical business problems and challenges.Module -1 9 Hrs.Basic Concepts of Economics: Introduction to Economics , Basic Economic Problem, Circular Flow of Economic Activity , Nature of the firm - rationale, objective of maximizing firm value as present value of all future profits, maximizing, satisficing, optimizing, principal agent problem, Accounting Profit and Economic Profit , Role of profit in Market System , Adam Smith and Invisible Hand.Module -2 9 Hrs.Demand Analysis and Forecasting: Determinants of Market Demand at Firm and Industry level – Elasticity of Demand - Market Demand Equation – Use of Multiple Regression for estimating demand – Case study on estimating industry demand (formulating equation and solving with the aid of software expected)Demand and Supply: Market Equilibrium – Pricing under perfect competition, monopolistic competition, Case study on pricing under monopolistic competition, Oligopoly - product differentiation and price discrimination; price- output decision in multi-plant and multi-product firms.Module – 3 9 Hrs.Cost Concepts: Cost Concept, Opportunity Cost, Marginal, Incremental and Sunk Costs, Cost Volume Profit Analysis, Breakeven Point, Case Study on marginal costs.Module-4 9 Hrs.Risk Analysis and Decision Making: Concept of risk, Expected value computation, Risk management through Insurance, diversification, Hedging, Decision Tree Analysis, CaseStudy on Decision tree technique.Module-5 9 Hrs.Monetary and Fiscal Policy: Monetary and fiscal policy, Role of Fiscal and Monetary Policy, Money? Markets, Concept of savings and investment, Business cycles , National income accounting concepts, Commercial banks and the central bank money and credit, Financial markets and asset pricesText Books:Managerial Economics, by Peterson, Lewis, Sudhir Jain, Pearson, Prentice Hall Indian Economy by Datt&Sundaram 61st Edition, S ChandManagerial Economics by D. Salvatore, McGraw Hill, New Delhi.Thomas Sowell, “Economics – A Common Sense Guide to the Economy”, Basic Books Publishers, ISBN 978-0-465-05684-2.Reference Books:Managerial Economics by Varshney and Maheshwari, Sultan Chand and Sons, New Delhi.Managerial Economics by Dr. D. M. Mithani, Himalaya Publishing HouseManagerial Economics by Joel DeanPrentice Hall, USA.Managerial Economics by H L Ahuja S Chand & Co. New DelhiTitleDatabase Management SystemTotal Hours60Credits03Course Objectives: In this course students will be able to understand:Database designFile systemsVarious database management systemsDatabase design models and relational modelER DiagramSQL and SQL statementsDatabase physical and logical designTransactions managementCourse Outcomes: On successful completion of the module students will be able to:Explain database and database management systemExplain physical and logical view of a database management systemList various types of database management systemsDesign database using different database design modelsCreate ER Diagram for a databaseWrite SQL queries to manipulate databaseDescribe ACID properties of transactionsImplement transactions in a database.Module -1 9 Hrs.Overview of Database Systems: Introduction - Overview of Database Management - What is Database System - History of DBMS - Managing Structured Data - File Systems vs. DBMS - Basics of DBMS – DBMS Architecture -Overview of Relational Model - Database languages – Queries - Transaction Management - Structure & Design of a DBMS - Object Relational and semi-structured DB - Users & Administrators- Client/Server Architecture - Case Study.Module -2 12 Hrs.Database Design Models: The Relational Model - Relational Calculus - Introduction to Database Design - ER Diagrams – Entities, Attributes and Relationships. Design with ER Model - Conceptual Design for Large Enterprises - UML - Case Study.Relational Model: The Relational Model Integrity Constraints - Key Constraints – Primary Key Constraints - Foreign Key Constraints - General Constraints - Relational Algebra- Selection and Projection- Set Operation - Relational Calculus - Tuple Relational Calculus- Domain Relational Calculus - Case Study.Module – 3 12 Hrs.Schema Refinement and Normal Forms : DB Design - Normal forms and Atomic Domain- Functional Dependencies and Decomposition - Database Design Process SQL: SQL queries – Union – Intersect - and Except - Nested Queries – Aggregate Queries- Null values- Joins – Views - Stored Procedures - User defined Functions – Triggers – Transactions - Case StudyModule-4 15 Hrs.DB Application Development: DB Access from applications – embedded SQL, Cursors, and Dynamic SQL. Introduction to JDBC & SQL/J - Stored Procedures.Overview of Storage and Indexing: Data on external storage - File Organizations and Indexing - Index Data Structures - Comparison of File Organizations - Indexes and Performance Tuning.Overview of Query Evaluation: System Catalog - Operator Evaluation - Algorithms for relational operations. Introduction to Query Optimization – Alternative Plans - Case Study.Module-5 12 Hrs.Transaction Management: Introduction to Transaction - ACID Properties Serializability- Transactions and Schedules - Concurrent Execution of Transactions - Lock-based concurrency control - Transaction support in SQL commit - rollback – save point - Introduction to Crash Recovery.Physical Database Design and Tuning: Introduction to Physical Database design - Index Selection - Clustering. Overview of Database Tuning - Choices in tuning queries and Views - Case StudyText Books:Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke 3rd Edition, McGraw Hill 2003.Database System Concepts, AbrahamSilberschatz, Henry F.Korth and S.Sudarshan, 5th Edition, McGraw Hill 2006.Reference Books:Fundamentals of Database Systems, Elmasri and Navathe, 5thEdition, Addison- Wesley, 2007.An Introduction to Database Systems, C.J. Date, A. Kannan, S. Swamynatham, 8th Edition, Pearson education, 2006.TitleR Programming Language LabCredits04Programs:Exercise -1Install and configure R, set working directory.Install Packages and calling installed packagesR studio environment and functionalities of R studioImplement basic R operations (data input, missing values, importing data into R using different formats : xlsx, CSV, Text files)Use R as a calculatorExplore various functionalities of dataframes.Create data set using data frames, list and tables.Calculate the remainder after dividing 31079 into 170166719Calculate the interest earned after 5 years on an investment of $2000,Assuming an interest rate of 3% compounded annually.Use R to calculate the area of a circle with radius 7 cm.Do you think there is a difference between 48:14?2and 48:(14?2)?Usingrep()and seq()as needed, create the vectors?0000011111222223333344444 and 1234512345123451234512345Create the vector## [1]000111100011110001111000111100011## [34] 1 1and convert it to a factor. Identify the levels of the result, and thenchange the level labels to obtain the factor:## [1] Male MaleMale Female FemaleFemaleFemale Male Male## [10] Male Female FemaleFemaleFemale Male MaleMale Female## [19] Female FemaleFemale Male MaleMale Female FemaleFemale## [28] Female Male MaleMale Female FemaleFemaleFemale## Levels: Male FemaleExplore various functionalities of plotsExercise -2Create the contingency table for the given raw data.Create the interactive user input code line in r using readline ( ) function.Create the contingency table for the given vector format data.Convert the contingency table to original format of the given data.Analyse and give interpretation of summary statistics for the given data.Calculate mean, median and mode for the grouped data and compare the results for the given data.Analyse the given data for non-parametric tests and give the interpretations.Use R for test the given dataIn order to compare the effectiveness of two sources of nitrogen, namely ammonium chloride (NH4Cl) and urea, on grain yield of Coarse cereal, an experiment was conducted. The results on the grain yield of Coarse Cereal (kg/plot) under the two treatments are given below.NH4Cl : 13.4, 10.9, 11.2, 11.8, 14.0, 15.3, 14.2, 12.6, 17.0, 16.2, 16.5, 15.7.Urea : 12.0, 11.7, 10.7, 11.2, 14.8, 14.4, 13.9, 13.7, 16.9, 16.0, 15.6, 16.0. Assess which source of nitrogen is better for Coarse Cereal.Use R to test the given data and interpret the results.In a health survey of school children, it is found that the mean hemoglobin level of 55 boys is10.2 per 100ml with a SD of 2.1. Can we consider this group as taken from a population with a mean of 11.0 g/100ml?In a hearing survey among 246 town school children, 36 were found with conductive hearing loss and among 349 village school children 61 were found with conductive hearing loss. Does this present any evidence that conductive hearing loss is as common among town children as among village children?In an experiment to compare two types of Goat foods A and B, the following results of increase in weight were observed in Goats.Pig No.12345678Increase in weight due to A4953515247505253Increase in weight due to B5255525350545453Assuming the two samples are independent can we conclude food B is better than food A?Before an increasing in exercise duty on tea, 800 persons out of a sample of 1000 persons were found to be tea drinkers. After an increasing in duty, 800 people were tea drinkers in a sample of 1200 people. Using SE of a proportion, state whether there is a significant decrease in consumption of tea after the increase in the exercise duty.Use R for test the given dataA health status survey in a few villages revealed that the normal serum protein value of children in that locality is 7.0 g/100ml. A group of 16 children who received high protein food for a period of six months had serum protein values shown below. Can we consider that the mean serum protein level of those who were fed on high protein diet is different from that of the general population?S.No.(Child No.)12345678Protein level (g%)7.107.708.207.567.057.087.217.25S.No.(Child No.)910111213141516Protein level (g%)7.366.596.857.907.276.567.938.56Students were selected to training. Their performance was noted by giving a test and the marks recorded out of 50. They were given effective 6 months training and again they were given a test and marks were recorded out of 50.Farmers12345678910Before training25203515422826443548After training26203413434029413646By applying the t-test can it be concluded that the students have benefited by the training?100 individuals of a particular race were tested with an intelligence test and classified into two classes. Another group of 120 individuals belong to another race were administered the same intelligence test and classified into the same two classes. The following are the observed frequencies of the two races:RaceIntelligenceIntelligentNon-intelligentTotalRace I4258100Race II5565120Total97123220 Test whether the intelligence is anything to do with the race.Obtain the correlation coefficient between the heights of father(X) and of the son (Y) from the following dataX6566676869707172Y6768656872726971And also test its significance. Using R functions.Analyse the given data for analysis of variance and interpret the same for all the possible values.Consider the inbuilt data set cars.Find Correlation between possible variables and pairwise correlationFind regression line between appropriate variablesDisplay the summary statistics and comment on the resultsTitleDatabase Management System LabCredits04List of Experiments:Tables to be used in the exercise: Student (Student_id, Sname, DepNo, email)CollDept (DeptNo, Dname,HOD)Faculty(Faculty_id,fname,dept,designation,salary)Employee (EmpID, name, job, hiredate, sal, deptno,MgrID,age)Department (deptno, dname, loc)Create :Above given tables with appropriate data types and constrainsA query to display the name and age of students, whose age is more than 30 years.Display the employee number, name, salary, and salary increased by15%.A query that displays the names and indicates the amounts of their annual salaries with asterisks. Sort the data in descending order of salary.Retrieve data from multiple tables by using all types of below specified joins:Inner Join:a) Retrieve only the information about departments to which at least one employee is assigned.b) Retrieve only the information about those employees who are assigned to a department.?c) ?Retrieve the information of all the employees along with their Department Name if they are assigned to any department.d) Retrieve the information of all the departments along with the detail of EmployeeName belonging to each Department, if any is available.?e) Retrieve the ID of the employees and the IDs of their respective managers from the employee table.Using group functions, retrieve suitable results by using HAVING, GROUP BY and ORDER BY clausesFind the age of highest paid employee who is at least 30 years old for each department with at least two such employees.Find those departments for which the average age of employee is the minimum over all departments.Find the sum of salary of all the employees in a each department having department number greater than 10. Write a query that displays the names with the first letter capitalized and all other letters lowercase, and the length of the names, for all names whose name starts with J, A, or M. Give each column an appropriate label. Sort the results by the names.Perform below specified DDL operations:Create another table by name NEWDEPT from DEPT table’s deptno, dnameColumns and another column by name dept_head.Apply all the given constraints properly. Perform below specified operations with these tables.Rename the table.Add one column (sex) to that table which contains either M or F.Drop column from the table. Drop the table.Create one simple view on students which contains all students records belong to department MCA.Try to insert one row data through the view and verify it in the base table.Create a sequence and insert data to students using that sequence for providing new students number. Create a PL/SQL block that selects the maximum department number in the DEPARTMENTS table and stores it in a variable. Print the results to the screen.Create a PL/SQL block to insert a new department number into the Departments table. Use maximum dept number fetched from above and adds 10 to it. Create a PL/SQL block to delete the department created in exercise 16. Print to the screen the number of rows affected.Write a PL/SQL block which accepts employee name, basic and should displayEmployee name, PF and net salary.HRA=30% of basic salaryDA=75% of basic salaryNet salary=basic+HRA+DA-PFIf the basic is less than 8000 PF is 5% of basic salary.If the basic is between 8000 and 15000 PF is 7% of basic salary.If the basic is between 15000 and above PF is 8% of basic salary.Write a PL/SQL block to award an employee with the bonus. Bonus is 15% of commission drawn by the employee. If the employee does not earn any commission then display a message that ‘employee does not earn any commission’. Otherwise add bonus to the salary of the employee. The block should accept an input for the employee number.Write a PL/SQL block which accepts employee number and finds the average salary of the employees working in the department where that employee works. If his salary is more than the average salary of his department, then display messaging that ‘employee’s salary is more than average salary’ else display ‘employee’s salary is less than average salary’.Using Cursors Write a program that gives all employees in department MCA and 15% pay increase. Display a message displaying how many Employees were awarded the increase.Display the names of employees who are working for Department MCA.Create a procedure that deletes rows from the employee table. It should accept 1 parameter, job; only delete the employee’s with that job. Display how many employees were deleted. Write a PL/SQL block to invoke the procedure. Write a simple before statement-level trigger that displays a message prior to an insert operation on the?EMP?table.Write an after statement-level trigger. Whenever an insert, update, or delete operation occurs on the?EMP?table, a row is added to the?empauditlog?table recording the date, user, and action.Write a row-level trigger that calculates the commission of every new employee belonging to department 30 that is inserted into the?EMP?table.Design mini database project using procedures and triggers. Front-end can be done using Java or or any other similar languages.SEMESTER -2Syllabus TitleBig Data AnalyticsTotal Hours45Credits03Course Objectives: To understand different types and concept of Big DataTo understand different sources of Big Data generationTo understand architecture of data storage and data processing layerTo understand high level architecture of MapReduce To understand data cleansing and transformation techniques using Apache Hive and Apache PigTo understand data movement techniques in and out of Hadoop clusterCourse Outcomes: On successful completion of the module students will be able to:Apply data processing techniques and analyze the Importance of Big DataAnalyze Hadoop tools to process big data on Hadoop clusterApply the HDFS Design while processing very huge volume of dataApply the YARN Concepts and Resource Manager to optimize heavy jobsAnalyze the various techniques/types of Execution Types in Apache PigUnderstand the concept of different types of tables in Apache HiveModule -1 7 Hrs.Introduction to Big Data:What is Big Data - Why Big Data – Facts about Big Data - Importance of Big Data - Evaluation of Big Data – Sources of Data Explosion – Types of Data – Different V’s of Big Data – Characteristics of Big Data – Need of Big Data – Capabilities of Big Data – Handling Limitations of Big Data – Technologies Supporting Big Data – Difference between Traditional IT Approach and Big Data Technology – Big Data Use Cases –Case Study for Netflix and the house of card – Big Data in Banking Domain – Big Data in Ecommerce Domain – Big Data in Government Sectors – Big Data in Hospitals.Module -2 9 Hrs.Apache Hadoop:Why Hadoop –History and Milestone of Hadoop – Batch Processing – Features of Hadoop – Hadoop Framework – Core Components of Hadoop – Design HDFS – HDFS Core Concept – Difference between Regular File System and HDFS – Common Hadoop Shell Commands – Hadoop Distribution – Name Node – Data Node – Job Tracker – Task Tracker – Secondary Name Node – Job Submission on Hadoop Cluster – AdvantagesModule – 3 9 Hrs.Map Reduce:YARN Concepts – Resource Manager – Application Master – Node Manager –Container Concepts – Difference between Hadoop 1.x & 2.x – MapReduce –History – Mapper – Reducer – Record Reader – Input Split – Input File Formats – Output File Formats – Shuffle phase – Sort phase – Partitioner – Combiner – Fault Tolerant – Map Side Join – Reduce Side Join Module-4 9 Hrs.Apache Pig :Apache Pig – Execution Types – Local Mode – Distributed Mode – Data Types – Complex Data Types – Schema – Data Transformation Techniques – Load Data – FILTER – SORT – ALIAS – STORE – Substring – Strsplit– Group – Cogroup – Union – Joins – UDF – Features Module-5 11 Hrs.Apache Hive & Apache Pig:Apache Hive – Metastore – Warehouse – Comparison Traditional Databases – Hive Query Language – Data Types – Tables – Internal Table – External Table – Partitioned Table – Bucketing – Views – Indexing – Importing Data – Altering Tables – Joins – User Defined Functions – Applications – Apache Sqoop – Data Importing – Data Exporting – Architecture of Sqoop Text Books:Big Data for Dummies – Judith Hurwitz, Alan Nugent, Dr. Fern Halper and Marcia Kaufman, Published by John Wiley & Sons, Inc, ISBN: 978-1-118-50422-2 Harness the Power of Big Data - Paul C. Zikopoulos, Dirk deRoos, Krishnan Parasuraman, Thomas Deutsch, David Corrigan, James Giles by The McGraw-Hill Companies, ISBN: 978-0-07180818-7Hadoop: The Definitive Guide - by Tom White , ISBN: 978-1-491-90163-2Hadoop in Practice – Alex Holmes, MANNING SHELTER ISLAND, ISBN 9781617290237Website: LearningTotal Hours45Credits03Course Objectives: To understand the basic concepts of statistical learning methods and models.To understand the importance of supervised learning in multivariate data sets.To understand the estimation procedure for multiple regression coefficientsTo understand the assumptions in estimating regression coefficients using OLS method.To understand the importance of supervised learning in classifying class labels for prediction.Course Outcomes: On successful completion of the module students will be able to:Understand the difference between continuous class label and discrete class label classification methods.Predict the continuous class variable using linear regression analysis.Predict the binary class variable using decision tree and random forest.Understand the importance of Logistic regression and its application in business.Apply the assessment method to find the better fit model for classification techniques.Module -1 9 Hrs.Introduction to Machine Learning: Introduction to Machine learning – Statistical Learning – types of Machine Learning –learning models: geometric, probabilistic and logistic models, introduction to supervised, unsupervised and reinforcement learning, Generalized Linear Model, difference between Generalized and General Linear Model, Link Functions and Linear Predictors, Parameter Estimation and Inference in the GLM, Prediction and Estimation with the GLM, Residual Analysis in the GLM : Raw and deviance residual, introduction to over dispersion, concepts on Poisson Regression.Module -2 9 Hrs.Supervised Learning –Regression Analysis: Introduction to parametric machine learning method, assumptions of parametric machine learning methods, linear model and its assumptions, simple linear regression, parameter estimation, properties of regression parameters, testing the significance of regression parameters, estimation of σ2, Interval Estimation of the Mean Response, prediction of new observations, Confidence interval for β0, β1 and σ2, Multiple linear Regression analysis, parameter estimation, and significance of coefficients, assumptions of multiple linear regression parameters.Module – 3 9 Hrs.Classification Techniques – Logistic Regression: Introduction to logistic regression, assumptions involved in logistic regression, concepts on odds and odds ratio, maximum likelihood estimation, binomial logistic regression, parameter estimation, properties of logistic regression coefficients, logistic regression for correlated data, model accuracy testing, confusion matrix, Receiver Operating Characteristic Curve, area under curve, likelihood ratio test, concepts and interpretation of Pseudo R square tests, Hosmer-Lemeshow Test, Wald Test, prediction using better fit model and interpretation.Module-4 9 Hrs.Classification Techniques – Decision Tree: Introduction to decision tree algorithms, classification tree, characteristics of classification tree – size and hierarchical nature of tree, training and testing data set, induction algorithms, probability estimation in decision tree – Laplace correction and no match method, stopping criteria for tree development, pruning techniques and pruned tree, evaluation of decision tree classifiers, generalization error, F measure, Confusion matrix, ROC curve, Hit Rate Curve, Lift curve, McNemar’s Test, Resample paired t test, K-fold cross validated paired t test, prediction using better model, Decision tree ensembles methods.Module-5 9 Hrs.Kernel Models and Unsupervised Learning: Introduction to kernel methods, basics of Support Vector Machine (SVM) and Support Vector Regression (SVR), SVM : classification margin, Maximum margin hyper plane, primal form, dual form, soft margin, SVR : regression tube, primal form, dual form, kernel trick, kernel functions, linear, polynomial, radial and sigmoidal kernel functions, kernel prediction and kernel based algorithm for SVM and SVR, unsupervised Learning – Clustering, principle component analysis.Text Books:Introduction to Linear Regression Analysis, Fifth Edition - DOUGLAS C. MONTGOMERY, ELIZABETH A. PECK, G. GEOFFREY VINING, A JOHN WILEY & SONS, INC., PUBLICATIONIntroduction to Machine Learning - EthemAlpaydm, The MIT PressUsing Multivariate Statistics - Barbara G. Tabachnick, Linda S. Fidell, PearsonReference Books:Applied Multivariate Statistical Concepts - Debbie L. Hahs-Vaughn, Routledge, 2016TitleAnalytics using ExcelTotal Hours45Credits03Course Objectives: Students will be able to work with Data Entry and various Functions and Formulae of Excel Workbook.This Module enables students to do Filtering and Conditional Formatting of data, work on various analysis techniques.Students will also be able to do Statistical Analysis techniques on data using Excel.Various Simulation techniques, Analysis and Forecasting methods will be taught. Course Outcomes: On successful completion of the module students will be able to:On successful completion of all modules students get the knowledge of create flexible data aggregations?using?pivot tables. Students get the knowledge how to represent? the data visually?using?pivot charts. Module -1 9 Hrs.Functions and Formulas: Understanding Screen Layout - Creating Auto List & Custom List - Entering, Selecting and Editing Data - Understanding References (Relative, Absolute & Mixed) - Working on Various Functions & Formulas - Common Basic Functions - Logical Functions - Text Functions - Date & Time Functions - Lookup & Reference Functions - Mathematical Functions - Conditional Functions - Referring Data from Different Worksheet & Workbook Formula–Auditing -Various Calculation Techniques - Working on Ranges.Module -2 9 Hrs.Presentation of Data: Sorting Techniques - Various Data Filtering Techniques - Formatting Techniques - Conditional Formatting - Number Formatting - Table Formatting - Protecting Sheets & Files - Understanding Various Excel Window Techniques - Viewing Excel Spreadsheet in various Layouts - Advanced Printing Techniques - Templates - Themes.Module – 3 9 Hrs.Data Analysis Tools: Data Consolidation - Text to Columns - Flash Fill - Remove Duplicates - Advanced Data Validation Techniques - What-if Analysis - Goal Seek - Data Table - Solver – Scenarios; Working with Tables - Creating Charts - Understanding Sparklines (Line, Column, Win/Loss) - Pivot Tables & Pivot Charts.Module-4 9 Hrs.Data Analysis: Data Analysis ToolPak – Loading and Activating, ANOVA, correlation, covariance, Descriptive Statistics, Exponential Smoothing, F-Test 2-sample for variances, Fourier Analysis, Histogram, Moving Average, Random Number Generation, Rank and Percentile, Regression, Sampling, t-test, z-test. Module-5 9 Hrs.Simulations?:Simulations, Decision Trees and Forecasting, when should we use simulation, simulation modeling cycle, Introduction to Monte Carlo Simulation, generating random values, discrete and continuous functions, Excel for simple simulation, Managerial applications of risk analysis, performing a simulation using @Risk, analyzing the simulation output, generating various plots. Simulation in forecasting, Advanced simulation techniques.Text Books:Excel 2016 Bible, John Walkenbach, Wiley, 1st Edition, 2015.Excel Data Analysis - Modeling and Simulation, Hector Guerrero, Springer, 2010 Edition, 2014.Excel Functions and Formulas, Bernd Held, Theodor Richardson, BPB Publications, 3rd Edition, 2017.Reference Books:Microsoft Excel 2013, Data Analysis and Business Modeling: Winston, PHI, 2014 Edition, 2014. Excel Data Analysis for Dummies, Stephen L Nelson, E C Nelson, Wiley, 2nd Edition, 2014.TitlePython ProgrammingTotal Hours45Credits03Course Objectives: To understand the history and development of Python Programming Language.To understand the data structures and looping concepts in Python Programming Language.To understand the important packages and functions in Python Programming Language.To understand the importance of Python Programming Language in data wrangling or munging.To understand the impact of Python Programming Language in statistical analysis.Course Outcomes: On successful completion of the module students will be able to:Understand the core programming concepts of Python Programming Language.Know the Looping and condition statements in Python Programming LanguageUnderstand the different options in Data Management in Python Programming Language.Understand the importance of data transformation and its need in Python Programming LanguageKnow elementary to advanced statistical methods in Python Programming environment.Module -1 9 Hrs.Introduction to Python Environment :History and development of Python, Why Python? Grasping Python’s core philosophy, Discovering present and future development goals, Working with Python : Getting a taste of the language, Understanding the need for indentation, Working at the command line or in the IDE, Visualizing Power, Using the Python Ecosystem for Data Science, Accessing scientific tools using SciPy, Performing fundamental scientific computing using NumPy, Performing data analysis using pandas, Implementing machine learning using Scikit‐learn, Plotting the data using matplotlib, Parsing HTML documents using Beautiful Soup, Setting Up Python for Data Science, Getting Continuum Analytics Anaconda, Getting Enthought Canopy Express, Getting pythonxy, Getting WinPython, Installing Anaconda on Windows, Linux and MACModule -2 9 Hrs.Data Structures, Looping and Branching: Working with Numbers and Logic, Performing variable assignments, Doing arithmetic, Comparing data using Boolean expressions, Creating and Using Strings, Interacting with Dates, Creating and Using Functions, Calling functions in a variety of ways, Using Conditional and Loop Statements, Making decisions using the if statement, Choosing between multiple options using nested decisions, Performing repetitive tasks using for, Using the while statement, Storing Data Using Sets, Lists, and Tuples : Performing operations on sets, Working with lists, Creating and using Tuples, Defining Useful Iterators, Indexing Data Using Dictionaries.Module – 3 9 Hrs.Data Management : Working with Real Data, Uploading small amounts of data into memory, Streaming large amounts of data into memory, Sampling data, Accessing Data in Structured Flat‐File Form, Sending Data in Unstructured File Form, Managing Data from Relational Databases, Interacting with Data from NoSQL?Databases, Accessing Data from the Web, Juggling between NumPy and pandas, Validating Your Data, Removing duplicates, Manipulating Categorical Variables, Dealing with Dates in Your Data, Dealing with Missing Data, Slicing and Dicing: Filtering and Selecting Data, Concatenating and Transforming Working with HTML Pages, Working with Raw Text, Working with Graph Data.Module-4 9 Hrs.Data Transformation: Understanding classes in Scikit‐learn, Playing with Scikit‐learn, Defining applications for data science, Performing the Hashing Trick, Using hash functions, Demonstrating the hashing trick, Working with deterministic selection, Considering Timing and Performance, Benchmarking with timeit, Working with the memory profiler, Performing multicore parallelism, Demonstrating multiprocessing.Module-5 11 Hrs.Unit V: Python for Statistics: Exploring Data Analysis, The EDA Approach, Defining Descriptive Statistics for Numeric Data, Measuring central tendency, Measuring variance and range, Working with percentiles, Defining measures of normality, Counting for Categorical Data, Understanding frequencies, Creating contingency tables, Creating Applied Visualization for EDA, Inspecting boxplots, Performing t‐tests after boxplots, Observing parallel coordinates, Graphing distributions, Plotting scatterplots, Using covariance and correlation, Using nonparametric correlation, Considering chi‐square for tables, Using the normal distribution, Creating a Z‐score standardization, Transforming other notable distributions, Detecting Outliers in Data, Clustering, Reducing dimensionality.Text Books:Python for Data Science for Dummies - Luca Massaron and John Paul Mueller, John Wiley & Sons, Inc.Reference Books:Python for Data Analysis - Wes McKinney, O’Reilly Media, Inc.Data Science from Scratch - Joel Grus, O’Reilly Media, Inc.Python Scripting for Computational Science - Hans PetterLangtangenTitleData Mining TechniquesTotal Hours45Credits03Course Objectives: To understand the basic concepts of data mining techniques.To understand the procedure for CRISP – DM and KDD processTo understand the importance of association rule mining and its application in data mining project.To understand the concepts of classification techniques used in data mining projects. To understand the summary of text mining and its text clustering techniquesCourse Outcomes: On successful completion of the module students will be able to:Understand the important difference between CRISP –DM and KDD process of data mining.Understand the data pre-processing technique for the data mining projects and its importance in reduction of time in completing the project.Apply association rule mining for the appropriate data set and conclude the results for decision making process.Learn the different data classification techniques and its practical use in data mining project.Understand the basic concepts of text mining and able to cluster the text using statistical programming language.Module -1 9 Hrs.Introduction to Data Mining :Data mining, evolution of data mining, definition and concepts, introduction to data mining process, data mining methodology, over view of CRISP-DM and KDD process, over view of data mining algorithms, organization of data, Univariate and multivariate data distributions, distance measures and similarity measures, attribute selection, data cleaning and integrity, data split, test data, training data, validation data, mistakes in data mining, myths about data mining.Module -2 9 Hrs.Data Preparation:Introduction, feature extraction and portability, data type portability, discretization and binarization, text to numeric data, Time Series to Discrete Sequence Data, Time Series to Numeric Data, Discrete Sequence to Numeric Data, Data Cleaning: Handling Missing Entries, Handling Incorrect and Inconsistent Entries, Scaling and Normalization, Data Reduction and Transformation, Dimensionality Reduction with Axis Rotation, Dimensionality Reduction with Type Transformation.Module – 3 9 Hrs.Association Pattern Mining : Introduction, The Frequent Pattern Mining Model, Association Rule Generation Framework, Frequent Itemset Mining Algorithms: Brute Force Algorithms, Apriori Algorithms, Enumeration-Tree Algorithms, Enumeration-Tree-Based Interpretation of Apriori, Tree Projection and Depth Project, Vertical Counting Methods, Recursive Suffix-Based Pattern Growth Methods, Alternative Models: Interesting Patterns, Statistical Coefficient of Correlation, Chi Square Measure, Interest Ratio, Symmetric Confidence Measures, Cosine Coefficient on Columns, Jaccard Coefficient and the Min-hash Trick, Collective Strength, Relationship to Negative Pattern Mining, Useful Meta-algorithms.Module-4 9 Hrs.Data Classification : Introduction, feature selection for classification, Filter models: Gini Index, Entropy, Fisher Score, Fisher Linear Discriminant, Wrapper models and embedded models, Decision Trees: Stopping criteria, Pruning of tree, Rule-Based Classifiers: Rule Generation from Decision Trees, Sequential Covering Algorithms, Rule Pruning, Probabilistic Classifiers: Na?ve Bayes Classification and logistic regression, Support vector Machine and Neural Networks.Module-5 9 Hrs.Text Mining: Definition of text mining, general architecture of text mining, text mining operations, Text mining query languages, application of text categorization, document representation, machine learning and classifier evaluation, clustering task in text mining and its interpretation, word cloud, customization of word cloud.Text Books:Data Mining The Text Book – Charu C Aggarwal, Springer.Reference Books:Applied Data Mining Statistical Methods for Business and Industry - PAOLO GIUDICI, John Wiley & Sons Ltd. Data Mining, Third Edition– Ian H. Witten, Eibe Frank, Mark A. Hall, ELSEVIER.TitleBusiness Fundamental – IITotal Hours45Credits03Course Objectives: To provide students with an understanding of the principles of human behavior in organizations with relevance to the Indian business context. To provide students with an understanding of different organizational behavior concepts like motivation, communication, culture, human resource and conflictCourse Outcomes: On successful completion of the module students will be able to:Equip the students to understand and implement different cultures, ethics and motivation required in organization management.Develop leadership, group behavior, reaction and handling situations during conflict in a professional wayModule -1 9 Hrs.Introduction to OB: Introduction Concept of OB; Management roles, skills and activities; Disciplines that contribute to OB; Opportunities for OB – Globalization - Indian workforce diversity - customer service - innovation and change - networked organizations - work-life balance - people skill - positive work environment – ethics, Challenges for OB Manager, Learning: Individual Behavior Learning, attitude and job satisfaction: Concept of learning, conditioning, shaping and reinforcement Concept of attitude, components, behavior and attitude Job satisfaction: causation; impact of satisfied employees on workplace Comparison of job satisfaction amongst Indian employees with other culturesModule -2 9 Hrs.Motivation: Concept, Theories (Hierarchy of needs, X and Y, Two factor, McClelland, Goal setting, Self-efficacy, Equity theory), Job characteristics model, Redesigning job and work arrangements, Employee involvement, Flexible benefits, Intrinsic rewards Personality and Values: Concept of personality, MBTI, Big Five model. Relevance of values, Indian values, Linking personality and values to the workplace (person-job fit, person-organization fit) Perception, Decision Making and Emotions: Perception and judgments, Factors, Linking perception to individual decision making, Decision making in organizations, Ethics in decision making, Emotional labour, Emotional IntelligenceModule – 3 9 munication: Importance, Types, Barriers to communication, Communication as a tool for improving Interpersonal EffectivenessGroup Behavior : Groups and Work Teams, Concept, Five stage model of group development, Group think and shift, Indian perspective on group norms Groups and teams, Types of teams, Creating team players from individuals, Team building and team based work (TBW). Leadership: Concept, Trait theories, Behavioral theories (Ohio and Michigan studies), Contingency theories ( Fiedler, Hersey and Blanchard, Path-Goal), Authentic leadership, Mentoring, self-leadership, online leadership, Inspirational Approaches (transformational, charismatic), Comparison of Indian leadership styles with other countries. Exercises, games and role plays may be conducted to develop team and leadership skills.Module-4 9 anizational Culture: Organizational Culture and Structure Concept of culture, Impact (functions and liability), Creating and sustaining culture, Employees and culture, Creating positive and ethical cultures. Concept of structure: Prevalent organizational designs, New design options.Human Resource Management: Introduction to HRM, Selection, Orientation, Training & Development, Performance Appraisal, IncentivesModule-5 9 Hrs.Decision Making: Decision Making, Process of Decision Making, Using data to make better decisions, data driven decision making, Shut down Decision, Make or Buy Decision, Joint Product Decisions, Product Mix Decisions, Replacement Decisions.Text Books:Organisational Behaviour by Stephen P. Robbins, Timothy A. Judge and Seema Sanghi, 13th Ed, Pearson Education ltd. Reference Books:Luthans Fred., “Organizational Behaviour”, McGraw Hill. Hellriegel, Slocum and Woodman, Organisational Behavior, South-Western, Thomson Learning, 9th edition, 2001. BehaviorIn Organizations, Jerald Greenberg, 8th ed, Pearson Education. Arnold, John, Robertson, Ivan t. and Cooper, Cary, l., “Work psychology: understanding human behavior in the workplace”, Macmillan India Ltd., Delhi. Dwivedi, R. S., “Human relations and organizational behaviour: a global perspective”, Macmillan India Ltd., Delhi. Jan Williams, "Financial and Managerial Accounting" – The basis for business decisions, Tata McGraw Hill Publishers Data Analytics LabCredits04Below are the list of Experiments to be executed on Hadoop Cluster:Experiment 1:Prepare list of software, infrastructure for setting up single node Hadoop cluster.Experiment 2:?You need to perform 20 basics Linux commands on single node Hadoop cluster. Experiment 3:?You need to perform 20 basics Hadoop commands on single node Hadoop cluster. Experiment 4:You need to program Mapper Class, Reducer Class and Driver Class for map reduce word count Job.Experiment 5:You need execute word count job based on 0 reducer, 2 reducer, Default reducer & 4 reducer and observe different outputs for word count job.Experiment 6: (Below experiment should be implemented on Apache Pig Environment)In this task you have 2 files named as Student and Results. You need to use PIG commands for this task. Step1: Upload this file to Lab through winSCP. Student: Contains names and roll number of students. Results: Contains roll number and results of students whether they passed or failed. Problem Statement: You need to print the name of all the students who failed or passed in the exam based on the given data.(Faculty will share data with students)Experiment 7:You need to execute word count job and write code in Pig Latin Script.Experiment 8:Description: Georgia Salary/Travel data provided as CSV file with this assignment for the Fiscal Year 2010 and Organization Type of Local Boards of Education, produce a distinct list of all Job Titles along with the total number of employees aligned with each Job Title & the minimum/maximum/average salaries for each of the identified Job Titles Expected Steps: -Store the given input file salaryTravelReport.csv into the HDFS Location - Load the salary file and declare its structure- Loop through the input data to clean up the number fields. Take out the commas from the salary and travel fields and cast to a float - Trim down to just Local Boards of Education - Further trim it down to just be for the year in question - Bucket them up by the job title- Loop through the titles and check how many are there under each title- Determine the minimum, maximum and average salaries for every title - Guarantee the order on the way out - Dump the results on the console- Save results back to HDFS.Experiment 9: (Below experiment should be implemented on Apache Hive Environment)The dataset provided - MovieLens data sets are collected by the GroupLens Research Project at the University of Minnesota. It represents users' reviews of movies. This data set consists of: * 100,000 ratings (1-5) from 943 users on 1682 movies. * Each user has rated at least 20 movies. * Simple demographic info for the users (age, gender, occupation, zip) u.data-- The full u data set, 100000 ratings by 943 users on 1682 items. Each user has rated at least 20 movies. Users and items are numbered consecutively from 1. The data is randomly ordered. This is a tab separated list:user id | item id | rating | timestamp The time stamps are Unix seconds since 1/1/1970 UTC u.user -- Demographic information about the users; This is a tab separated list:user id | age | gender | occupation | zip code The user ids are the ones used in the u.data data set.Find the below problemstatement:Create au_data table. See the field descriptions of u_data table. Load data into u_data table from a local text file. Show all the data in the newly created u_data table. Show the numbers of item reviewed by each user in the newly created u_data table. Show the numbers of users reviewed each item in the newly created u_data table. Experiment 10You need to follow Experiment Number 09 and find out solution for below sets of problem:Create au_user table. See the field descriptions of u_user table. Load data into u_user table from a local text file. Show all the data in the newly created user table. Count the number of data in the u_user table.Count the number of user in the u_user table genderwise. joinu_data table and u_user tables based on userid and show the top 10 results.Experiment 11: (Below experiment should be implemented on MySQL and Apache Sqoop Environment)You need to Export data from MYSQL and load into HDFS based on different properties.You need to Export data directly to Apache Hive.You need to Import data to MYSQL from HDFS based on different properties.TitlePython Programming LabCredits04List of Experiments:Write a python program to find biggest number among four numbers using if-elseWrite a python program to find given number is prime or notWrite a python program to find given number is palindrome or notWrite a python program to print multiplication table of given numberWrite a python program to find mean of a n numbers using listWrite a python program to find given number is exist or not in the list, if exists print all its placesWrite a python program to return sum of n numbers from a function using listWrite a python program to manipulate student details using dictionary and listsWrite a python program to return student details from a function using list and sno as parameterWrite a python program to manipulate employee details using classes and objectsWrite a python program to read and write student details from and to a file using IOWrite a python program to read content from student.csv file and find total number of students, maximum and minimum marksTitleAnalytics using Excel LabCredits04List of Experiments:Understanding Excel’s Files, Ribbon and Shortcut: Create a workbook , Enter data in a worksheet , Format a worksheet ,Format numbers in a worksheet , Create an Excel table , Filter data by using an AutoFilter , Sort data by using an AutoFilter Essential Worksheet Operations: Using Help (F1), Key Board Shortcuts Working with Cells and a: Formatting Cells, Name ManagerVisualizing Data a Conditional Formatting: Apply conditional formattingPrinting Your Work: Print a worksheet , Using Print Preview & Other Utilities Working with Dates and Times & Text: Working with Dates & Time, Creating Formulas that Manipulate Text – Upper, Proper, Lower, Concatenate, Text to column Creating Formulas That Count, Sum, Subtotal: Create a formula, Use a function in a formula Creating Formulas That Look Up Values: VLookup, HLookup, Match & Index Creating Formulas for Financial Applications: Introduction to formulas e.g. PV, PMT, NPER, RATE, Creating Balance Sheet, Investment Calculations, Depreciation calculations Creating Charts and Graphics: Chart your data, Creating Sparkline Graphics, Using Insert Tab UtilitiesUsing Custom Number Formats: Right click, Format Cells window Using Data Tab and Data Validation: Getting external Data, Remove Duplicates, Apply data validation & using utilities from Data Tab Protecting Your Work: Using Review Tab Utilities Performing Spreadsheet What-lf Analysis: Create a macro, Activate and use an add-in Analyzing Data with the Analysis Tool Pak: Anova, Correlation, Covariance, Descriptive Statistics, Histogram, Random Number Generation, Rank and Percentile, Regression, t-Test, Z Test Using Pivot Tables for Data Analysis: Create Data Base for Pivot, Analyzing Data with Pivot Tables, Producing Report with a Pivot TableSEMESTER -3Syllabus TitleMarket Research and AnalyticsTotal Hours45Credits03Course Objectives: To provide students with an understanding of the principles of marketing, market research, sampling processTo provide students with an understanding of different concept of Market MeasurementTo introduce the basic concepts and techniques of Digital Marketing analyticsCourse Outcomes: On successful completion of the module students will be able to:Understand what marketing research is and how it is used by management.Define research problems.Understand different digital marketing platformUnderstand and analyze global market Module -1 9 Hrs.Introduction to Market Research (MR): The Marketing concept, Need for marketing research to solve marketing problems, Converting a business problem into a research problem. The Marketing Research System, Definition of MR, Basic and Applied Research, The Marketing Research Process, Types of Research, Steps in Marketing Research Process, Research Design, Data Sources, Marketing Information System, International Market Research, Sampling Process in Marketing Research, Sampling Design and Procedure, Sampling Methods, Non probabilistic sampling Techniques, ProbabiliticSampling Techniques.Module -2 9 Hrs.Marketing Research and Analytics Measurement: Measurement concept, Sources of variation in Measurement, Validity & reliability of Measurement, Attitude measurement, Data Collection, Online data collection, Primary and Secondary Data Collection, Errors and Difficulties in Data Processing, Coding and Editing, Data Analysis, Hypothesis Testing, Report Writing, Presentation of Data.Module – 3 9 Hrs.Marketing Research Techniques: Market development research: Cool hunting – socio cultural trends, Demand Estimation research, Test marketing, Segmentation Research, Cluster analysis, Discriminant analysis, Sales forecasting, Concept testing, Brand Equity Research, Brand name testing, Conjoint analysis, Multidimensional scaling, positioning research, Pricing Research, Shop and retail audits, Marketing effectiveness and analytics researchModule-4 9 Hrs.Data Analysis & Reporting: Data analysis, Analytical Techniques, Univariate analysis, Bivariate analysis, Multivariate analysis, Cluster analysis, Multi - dimensional scaling, Factor analysis, Conjoint analysis, Simple and cross tabulation, simple and multiple regression, Factor analysis. Module-5 9 Hrs.Digital Marketing: The Evolution of Digital Ecosystem, Data Growth Trends, Digital Media Types, Web Analytics, Conversion Analytics, Custom Segmentation, Social Media Reporting, Real Time Site Analytics, Measurement Framework, Owned and Earned Social Media Metrics, Digital Advertising Concepts, Aligning Digital and Traditional Analytics, Social Media Landscape AnalysisText Books:Philip Kotler,(2010), Marketing Management- The South Aisan Perspective, Pearson Digital Marketing Analytics by Chuck Hemann& Ken Burbary, Pearson Education, ISBN:13:978-0-7897-5960-3Naresh K. Malhotra, MARKETING RESEARCH: AN APPLIED ORIENTATION, Pearson Education, AsiaReference Books:Ramasamy, Namakumari (2010) Marketing Management, McMillan PublishersKeiefer Lee & Steve Carter, GLOBAL MARKETING MANAGEMENT, Oxford University Press, 2009MichealR.Czinkota and IIkkaA.Ronkainen,GLOBAL MARKETING, CENGAGE Learning, 2007 International Business Environment – Sundaram and Black International Business Environment – Bhalla and RajuWarren J. Keegan(2010): Global Marketing Management’ Pearson EducationSvendHollensen (2010): Global Marketing: A Decision-Oriented Approach- 3 rd Edition, Pearson Education.F.Adhikary, Manab, Global Business Management, Macmillan, New DelhiTitleExploratory Data AnalysisTotal Hours60Credits03Course Objectives: To understand importance of data and its types in Exploratory Data Analysis.To understand difference between EDA and summary statistics in context of interpretation.To understand the importance of data pre-processing for Exploratory Data Analysis.To understand the significance of missing value imputations in better EDA interpretations.To understand the importance measure of central tendency in describing the quick view of data set.To understand the importance of measure of dispersion and its interpretation in spread ness of dataCourse Outcomes: On successful completion of the module students will be able to:Understand the data and its types for the appropriate exploratory data analysis.Understand the importance of Exploratory Data Analysis over summary statistics.Understand the importance Univariate statistics in EDAPlot Univariate statistical graphs for the better representation and interpretation.Plot bivariate statistical graphs for the better representation and interpretation.Module -1 12 Hrs.Introduction to Data and its types: Definition and importance of data, classification of data : based on observation – Cross Sectional, times series and panel data, based on measurement – ratio, interval, ordinal and nominal, based on availability – primary, secondary, tertiary, based on structural form – structured, semi structured and unstructured, based on inherent nature – quantitative and qualitative, concepts on sample data and population, small sample and large sample, statistic and parameter, types of statistics and its application in different business scenarios, frequency distribution of data. Module -2 12 Hrs.Introduction to Exploratory Data Analysis (EDA): Definition of EDA, difference between EDA with classical and Bayesian Analysis, comparison of EDA with Classical data summary measures, goals of EDA, Underlying assumptions in EDA, importance of EDA in data exploration techniques, introduction to different techniques to test the assumptions involved in EDA, role of graphics in data exploration, introduction to unidimensional, bidimensional and multidimensional graphical representation of data.Module – 3 12 Hrs.Data Preparation: Introduction to data exploration process for data preparation, data discovery, issues related with data access, characterization of data, consistency and pollution of data, duplicate or redundant variables, outliers and leverage data, noisy data, missing values, imputation of missing and empty places, with different techniques, missing pattern and its importance, handling non numerical data in missing places.Module-4 12 Hrs.Univariate Data Analysis: Description and summary of data set, measure of central tendency – mean: Arithmetic, geometric and harmonic mean – Raw and grouped data, confidence limit of mean, median, mode, quartile and percentile, interpretation of quartile and percentile values, measure of dispersion, concepts on error, range, variance, standard deviation, confidence limit of variance and standard deviation, coefficient of variation, mean absolute deviation, mean deviation, quartile deviation, interquartile range, concepts on symmetry of data, skewness and kurtosis, robustness of parameters, measures of concentration.Module-5 12 Hrs.Bivariate Data Analysis: Introduction to bivariate distributions, association between two nominal variables, contingency tables, Chi-Square calculations, Phi Coefficient, scatter plot and its causal interpretations, correlation coefficient, regression coefficient, relationship between two ordinal variables – Spearman Rank correlation, Kendall’s Tau Coefficients, measuring association between mixed combination of numerical, ordinal and nominal variables.Text Books:Exploratory Data Analysis – John W Tukey, Addison Wesley Publishing Company Exploratory Data Analysis in Business and Economics - An Introduction Using SPSS, Stata and Excel – Thomas Cleff, Springer PublicationReference Books:Graphical Exploratory Data Analysis - S.H.C. du Toit A.G.W. Steyn R.H. Stumpf, Springer PublicationHand book of Data Visualization – Chun-houh Chen, Wolfgang H?rdle, Antony Unwin, Springer Publication.TitleArtificial Neural NetworkTotal Hours45Credits03Course Objectives: To understand the importance of neural network system and its componentsTo understand the neural network learning and adaptation in data scienceTo understand the mechanism of single layer perceptron in neural network modelsTo understand the advantage of multilayer perceptron over single layer perceptronTo understand broad application of neural networks in different field of businessesCourse Outcomes: On successful completion of the module students will be able to:Know the basic concepts of neural networks and its componentsKnow neural network learning and adaption techniquesKnow the detailed concepts of single layer perceptron neural networksKnow the detailed concepts of multilayer perceptron neural networksExplain the different field of application on neural network modelsModule -1 9 Hrs.Introduction to Neural Network System : Introduction to biological neurons and their artificial models, history of artificial neural systems development, Simple Memory and Restoration of Patterns, basic concepts related to neural networks : three layers of neural network systems, units, connections, site, mode, perceptron, single layer and multiple layer perceptron, McCulloch-Pitts Neuron Model, Neuron Modelling for Artificial Neural System, Models of neural networks : feedforward and feedback networks, neural processing.Module -2 9 Hrs.Neural Network Learning and Adaptation: Introduction to neural network learning and adaptation, Learning as approximation or Equilibria Encoding, concepts of supervised and unsupervised learning, neural network learning rules : Hebbian learning rule, perceptron learning rule, delta learning rule, Widrow-Hoff Learning Rule, correlation learning rule, Winner- Take-All learning rule, Outstar learning rule, summary and comparison of artificial neural network learning rules.Module – 3 9 Hrs.Single Layer Perceptron Classifiers: Introduction to single layer perceptron, classification model, features and decision tree, discriminant functions, linear machine and minimum distance classification, non-parametric training concepts, training and classification using the discrete perceptron, single layer continuous perceptron neural networks for linearly separable classification, multi category single layer perceptron neural networks.Module-4 9 Hrs.Multilayer feed forward Neural Networks: Introduction to multilayer perceptron neural networks, linearly non separable pattern classification, delta learning rule for multilayer perceptron networks, generalized delta learning rule, Feedforward recall and error Back-Propagation training, training errors, Multilayer Feedforward Networks as Universal Approximators, Learning Factors: Initial Weights, cumulative weight adjustments vs incremental updating, learning constant and momentum method, classifying and expert layered networks, Character Recognition Application, expert systems applications, learning time sequences.Module-5 9 Hrs.Single-Layer Feedback Neural Networks : Introduction to single layer feedback neural networks, basic concepts of dynamic systems, Mathematical Foundations of Discrete-Time and gradient type Hopfield Networks, Transient Response of Continuous-Time Networks, Relaxation Modelling in Single-Layer Feedback Networks, Summing Network with Digital Outputs, Minimization of the Traveling Salesman Tour Length.Text Books:Introduction to Artificial Neural Systems – Jacek M Zurada, West Publishing Company.Reference Books:An introduction to neural networks - Kevin Gurney, UCL Press.PRINCIPLES OF ARTIFICIAL NEURAL NETWORKS, 2nd Edition - Daniel Graupe, World Scientific Publishing Co. Pte. Ltd.TitlePredictive AnalyticsTotal Hours45Credits03Course Objectives: To understand the basic concepts and importance of predictive analytics in businessTo understand the procedure for data pre-processing techniques to get ready for further analysisTo understand the importance and working procedure for data wrangling techniquesTo understand and work with linear regression analysis with python and its model validation techniquesTo understand and work with logistic regression analysis, decision tree and random forest with python and its model validation techniquesCourse Outcomes: On successful completion of the module students will be able to:Understand the important terminologies and need for predictive analytics for business organizationApply data pre-processing techniques for predictive analyticsApply data wrangling techniques for predictive analyticsBuild linear regression analysis and fine tune the model for higher accuracyBuild classification techniques and fine tune the model for higher accuracyModule -1 8 Hrs.Introduction to predictive modelling: History and Evolution, Scope of predictive modelling: Ensemble of statistical algorithms, Statistical tools, Historical data, Mathematical function, Business context, Data Mining, Data Analytics, Data science, Statistics, Statistics vs Data Mining vs Data Analytics vs Data Science, machine learning python packages: Anaconda, Standalone Python, Data Analysis Packages – Numpy, Pandas, Matplotlib, Machine Learning Core Libraries, Installing Python packages with pip, Python and its packages for predictive modelling.Module -2 10 Hrs.Data Pre-processing for Predictive Analytics: Reading the data – variations and examples, Various methods of importing data in Python: reading a dataset using the read_csv method, reading a dataset using the open method of Python, reading data from a URL, miscellaneous cases - Reading from an .xls or .xlsxfle, summary, dimensions, and structure Handling missing values: Checking for missing values, Treating missing values: deletion and imputation, Creating dummy variables, Visualizing a dataset by basic plotting: scatter plots, histograms, boxplots. Module – 3 9 Hrs.Data Wrangling: Introduction, need for data wrangling, Sub setting a dataset: Selecting columns, selecting rows, Selecting a combination of rows and columns, Creating new columns, Generating random numbers and their usage: Various methods for generating random numbers, Seeding a random number, Generating random numbers following probability distributions, Probability density function, Cumulative density function, Uniform distribution, Normal distribution, Using the Monte-Carlo simulation to find the value of pi, Generating a dummy data frame, Grouping the data – aggregation, filtering, and transformation, Random sampling – splitting a dataset in training and testing datasets, Concatenating and appending data, Merging/joining datasets.Module-4 9 Hrs.Linear Regression with Python: Definition and overview of linear regression analysis, Linear regression using simulated data, Fitting a linear regression model and checking its efficacy, Finding the optimum value of variable coefficients, Making sense of result parameters, p-values, F-statistics, Residual Standard Error, Implementing linear regression with Python, Linear regression using the statsmodel library, Multiple linear regression, Multi-collinearity: Variance In?ation Factor, Model validation, Training and testing data split, Summary of models, Linear regression with scikit-learn, Feature selection with scikit-learn, Handling other issues in linear regression: Handling categorical variables, Transforming a variable to fit non-linear relations, Handling outliers. Module-5 9 Hrs.Classification Techniques with Python: Introduction and definition to classification techniques, Contingency tables, conditional probability, odds ratio, Moving on to logistic regression from linear regression, Estimation using the Maximum Likelihood Method, Making sense of logistic regression parameters, Wald test, Likelihood Ratio Test statistic, Chi-square test, Implementing logistic regression with Python: Model validation and evaluation, Model validation, ROC Curve, Confusion Matrix, Introduction to decision trees, Understanding the mathematics behind decision trees and ensemble tree methods: Homogeneity, Entropy, Information gain, ID3 algorithm to create a decision tree, Gini index, Reduction in Variance, Pruning a tree, handling a continuous numerical variable and missing values, Regression tree algorithm, implementing a regression tree using Python, Understanding and implementing random forests using python.Text Books:Learning Predictive Analytics with Python– Ashish Kumar, PACKT PublishingReference Books:Mastering Machine Learning with Python in Six Steps- Manohar Swamynathan, ApressMastering Predictive Analytics with Python - Joseph Babcock, PACKT Publishing.TitleCloud ComputingTotal Hours45Credits03Course Objectives: To provide students with the fundamentals and essentials of Cloud Computing.?To provide students a sound foundation of the Cloud computing so that they are able to start using and adopting Cloud Computing services and tools in their real life scenarios.?To enable students exploring some important cloud computing driven commercial systems such as GoogleApps, Microsoft Azure and Amazon Web Services and other businesses cloud applications.Course Outcomes: On successful completion of the module students will be able to:Analyze the Cloud computing setup with its vulnerabilities and applications using different architectures.Design different workflows according to requirements and apply map reduce programming model. Apply and design suitable Virtualization concept, Cloud Resource Management and design scheduling algorithmsCreate combinatorial auctions for cloud resources and design scheduling algorithms for computing clouds Assess cloud Storage systems and Cloud security, the risks involved, its impact and develop cloud application Broadly educate to know the impact of engineering on legal and societal issues involved in addressing the security issues of cloud computingModule -1 9 Hrs.Fundamentals of Cloud Computing:Cloud Computing Basics – History of Cloud Computing, Characteristics of Cloud Computing, Need for Cloud computing, Advantages and Possible Disadvantages of cloud computing, Cloud Deployment Models – Public, Private, Hybrid, Community, Other deployment Models. Evolving Data Center into Private Cloud, Datacentre Components, Extracting Business value in Cloud Computing – Cloud Security, Cloud Scalability, Time to Market, Distribution over the Internet, Cloud Computing Case Studies.Module -2 9 Hrs.Cloud Delivery Models : Introduction to Cloud Services, Infrastructure as a Service (IaaS) – Overview, Virtualization, Container, Pricing Models, Service Level Agreements, Migrating to the Cloud, IaaS Networking options, Virtual Private Cloud(VPC), IaaS Storage – File and Object storage, Data Protection, IaaS security, Benefits, Risks and Examples of IaaS. Platform as a Service (PaaS) – Overview, IaaS vs PaaS, PaaS Examples, benefits and risks. Software as a Service (SaaS) – Introducing SaaS, SaaS Examples – Office 365, Google G Suite, , Evaluating SaaS – user and vendor perspective, Impact of SaaS, Benefits and risks of SaaS. Other Services on Cloud, Cloud Delivery Models ConsiderationsModule – 3 9 Hrs.Cloud Platforms:Introducing Cloud Platforms, Evaluating cloud platforms, Cloud Platform technologies – Amazon Web Services, Microsoft Azure, Google Cloud Platform, , Impact of Cloud platforms. Private Cloud Platforms – Introducing Private clouds – Microsoft Azure stack, Open stack, AWS Greengrass, Impact of Private cloudsCloud Migration : Delivering Business Processes from the Cloud: Business process examples, Broad Approaches to Migrating into the Cloud, The Seven-Step Model of Migration into a Cloud, Efficient Steps for migrating to cloud., Risks: Measuring and assessment of risks, Company concerns Risk Mitigation methodology for Cloud computing, Case StudiesModule-4 9 Hrs.Cloud Computing - Challenges, Risk and Mitigation:Cloud Storage, Application performance, Data Integration, Security. Ensuring Successful Cloud Adoption: Designing a Cloud Proof of Concept, Vendor roles and capabilities, moving to the Cloud. Impact of Cloud on IT Service Management. Risks and Consequences of Cloud Computing: Legal Issues, Compliance Issues, Privacy and Security.Module-5 9 Hrs.Managing the Cloud: Managing and Securing Cloud Services, Virtualization and the Cloud, Managing Desktops and devices on the cloud, SOA and Cloud computing, Managing the Cloud environment, Planning for the Cloud – Economic Cost Model and Leveraging the Cloud, Cloud computing resources, Cloud Dos and Don’ts.Text Books:Kirk Hausman, Susan L. Cook, TelmoSampaio, “ CLOUD ESSENTIALS CompTIA? Authorized Courseware for Exam CLO-001”, John Wiley & Sons Inc.,? 2013Judith Hurwitz? ,? Robin Bloor? ,? Marcia Kaufman ,? Fern Halper, “Cloud Computing for Dummies”, Wiley Publishing Inc.,? 2010Reference Books:Erl,” Cloud Computing: Concepts, Technology & Architecture”, Pearson Education, 2014Srinivasan, “Cloud Computing: A Practical Approach for Learning and Implementation “Pearson Education, 2014TitleCloud Infrastructure ServicesTotal Hours45Credits03Course Objectives: To provide students with the fundamentals and essentials of Cloud Computing.To provide students a sound foundation of the Cloud computing so that they are able to start using and adopting Cloud Computing services and tools in their real life scenarios.To enable students exploring different services offered on Amazon Platform like Storage, Management tools, Analytical Services and Business Intelligence.Course Outcomes: On successful completion of the module students will be able to:Understand the Cloud Service Models and Cloud Deployment ModelsCreate and configure the compute, storage and database services in the cloud which help them to work with analytic services.Monitor and get the logs related to various services.Deploy and configure the data analytics projects.Select Cloud services to analyse big data and create statistical models.Module -1 9 Hrs.Introduction to Cloud Computing :Introduction to Cloud Computing, Cloud Service Models, Cloud Deployment Models, Cloud Computing Security, Introduction to Amazon Web Services, AWS Compute Options, AWS Virtual Private Cloud, AWS Identity and Access Management, AWS Lambda, Pricing ConceptsModule -2 9 Hrs.AWS Storage : Amazon Storage, S3 Storage Basics, Buckets and Objects, Creating A Web Server Using S3 Endpoints, Managing Voluminous Information with EBS, Glacier Storage Service , Describe Amazon DynamoDB, Understand key aspects of Amazon RDS,RDS Database engines, benefits of RDS, Launch an Amazon RDS instance, Amazon ElastiCache.Module – 3 9 Hrs.AWS Management Tools: Amazon CloudWatch, Accessing a CloudWatch using different method, CloudWatch Metrics, CloudWatch Alarms, Monitoring Amazon RDS, Collect Metrics and Logs with CloudWatch Agent, Benefits and features of AWS CloudTrail, CloudTrail Concepts, Creating and updating Trail, Working with log files. AWS Command Line Interface (CLI), AWS Personal Health Dashboard, Simple Notification Service(SNS).Module-4 9 Hrs.AWS Analytic Services:Introduction to AWS Analytic Services, Features and benefits of Amazon Athena, Creating Database, creating table and running a query in Athena, Querying AWS CloudTrail Logs, Benefits and features of Amazon EMR, EMR Architecture, Launch cluster and run a hive Script to process data, Plan and configure clusters, features of Amazon Elasticsearch(ES) Service, Creating and configuring Amazon ES Domains, Overview of Amazon kinesis, Configuring input and output stream for Kinesis Data Analytics, features of AWS GlueModule-5 9 Hrs.Cloud Business Intelligence: Features of Amazon RedShift, Launch an Amazon Redshift Cluster, Connect to the Sample Cluster and Run Queries, Load sample data from S3, AWS Data Pipeline, Pipeline Components, Instances, and Attempts, DataNode, Database and Activities, Overview of Quicksight, Editions of Amazon Quicksight, Data Sources, Data Sets, Functions and Operators, Working with Analysis, Working with Visuals, Working with Stories, Working with Dashboards, Overview of Amazon SageMaker, Features of SageMaker, Create and configure notebook instances, create and configure training jobs, creating and configuring models and end points.Text Books:AWS Certified Solutions Architect Official Study Guide.by John Stamper, Sean Senior, Kevin E. Kelly, Biff Gaut, Tim Bixler, Hisham Baz, Joe BaronCloud Analytics with Google Cloud Platform: An end-to-end guide to processing and analyzing big data using Google Cloud Platform by?SanketThodge?Rajaraman, Anand and Ullman, Jeff. (2008). Mining of Massive Datasets. New York: Cambridge Press.Reference Books:Isson, Jean-Paul and Harriott, Jesse. (2012). Win with Advanced Business Analytics: Creating Business Value from Your Data, 1st edition. New York: Wiley.Shmueli, Galit, Patel, Nitin and Bruce, Peter. (2010). Data Mining for Business Intelligence. New York: Wiley.Rajaraman, Anand. (2011). Mining of Massive Datasets. New York: Cambridge University Press.TitleFinancial EconometricsTotal Hours45Credits03Course Objectives: To understand the basic concepts of time series analysisTo understand the elementary time series models and model evaluation techniquesTo understand the integration process of non-stationary data setTo understand the importance of ARMA and ARIMA models for forecastingTo understand the basic concepts and estimation procedure for VAR modelsTo understand the method to select the appropriate number of order of variablesTo understand the VECM model for Cointegrated series of variablesTo understand the ARCH and GARCH modelsTo understand the basics of multivariate time series analysis techniquesCourse Outcomes: On successful completion of the module students will be able to:Understand the different elementary models related to time series analysis.Apply different model evaluation technique to identify better model to forecast.Understand the importance of stationarity in building time series models.Understand the use of Granger Causality and JohensenCointegration method.Apply VAR model to the dynamic behaviour of financial time series conditions.Select the order of Vector Auto Regression model for better forecast of time series data.Apply VECM in the appropriate place to overcome the Cointegration problem.Build the model using ARCH and GARCH technique for non-constant variance data.Module -1 9 Hrs.Time Series in Financial Econometrics:Introduction to time series plot in history, time series data and cross sectional data, difference between time series and cross sectional data, time series and stochastic process, means, variances, covariance, stationarity, importance of stationarity in time series analysis, components of time series analysis: trend, seasonal, cyclical and irregular, white noise process, random walk, elementary time series models with zero mean, model evaluation techniques: Bias, MAD, MSE, MAPE.Module -2 9 Hrs.Univariate time series analysis – I:Models related to stationary data, Auto Regressive model, Moving Average model, Stationarity of data, concepts on unit root, impacts of unit root in estimating the model parameters, tests related to unit root: Dickey Fuller test, Augmented Dickey Fuller test, KPSS Test, The Phillips Peron Test, seasonal unit roots, periodic integration and unit root testing.Module – 3 9 Hrs.Univariate time series analysis – II: ARMA (p,q) process, ACF (Auto Correlation Function) and PACF (Partial Auto Correlation Function) of an ARMA (p,q) process, forecasting ARMA process, integration of non-stationary data, first order integration and second order integration, ARIMA (p,i,q), estimation of parameters of ARIMA model, Wald Test Statistic for significance of coefficients.Module-4 9 Hrs.Spectral Analysis: Spectral densities, periodogram, he Spectral Representation and Spectral Distribution, Sampling Properties of the Sample Spectral Density, time invariant linear filters, the spectral density of ARMA (Auto Regressive Moving Average), smoothing the Spectral Density, Bias and variance, bandwidth, Confidence Intervals for the Spectrum, Leakage and Tapering, auto regressive spectrum estimation.Module-5 9 Hrs.Multivariate Time Series Analysis - VAREstimation : Introduction to multivariate time series analysis, Concepts of Vector Auto Regression, multivariate least square estimation, asymptotic properties of Lease square estimation, Introduction to Vector Error Correction Models, Cointegrated Processes (Johensen Co-integration technique), Common Stochastic Trends, Deterministic Terms in Cointegrated Processes, Forecasting Integrated and Cointegrated Variables, Introduction to Univariate GARCH models, multivariate GARCH, estimation of GARCH models.Text Books:Introductory Econometrics A modern Approach - Jeffrey M. Wooldridge, South-Western Cengage Learning.Basic Econometrics, Fifth Edition - Damodar N. Gujarati, Dawn C. Porter, McGraw-Hill/Irwin Publication.Reference Books:Introduction to Time Series and Forecasting– Peter J. Brockwell Richard A. Davis, Springer Time Series Analysis with applications in R - Jonathan D. Cryer ? Kung-Sik Chan, Second Edition, SpringerNew Introduction to Multiple Time Series Analysis, Helmut Lütkepohl, SpringerTitleOperations ResearchTotal Hours60Credits03Course Objectives: Understand modelling techniques and linear equationsUnderstand the need of using operations researchSimplification of LPP by graphical methodIdentify situations in which linear programming techniques can be appliedUnderstand fundamental concepts and general mathematical structure of a linear programming modelTo understand and solve various transportation problems.Course Outcomes: On successful completion of the module students will be able to:Solve Linear EquationsWork with Linear ProgrammingWork with Network Models and Solving ProblemsWork with gaming and queuing theory Solve and examine situations that generate queuing problemsModule -1 9 Hrs.Introduction To Operations Research (OR): Operations Research Definition and Scope, History of Operation Research, Features of Operations Research, OR approach to problem solving, Modelling in Operation Research, Principles of Modelling, Methodology of Operations Research, Management applications of Operations Research, Characteristics of Operations Research, Role of Operations Research in decision making.Module -2 12 Hrs.Linear Programming Problem(LPP): Introduction, Structure of LPP, Advantages and Limitations of LPP, Applications of LPP, Mathematical Model of LPP, Guidelines of Model Formulation, Examples of LP Model Foundation – Production – Marketing - Finance- Agricultural - Transportation - Personnel, Graphical Solution Methods of LPP, Simplex Algorithm – Minimization and Maximization Case for Linear ProgrammingModule – 3 12 Hrs.Transportation Problems: Introduction of Transportation Problems, Transportation Algorithm, Test for Optimality, Maximization Transportation Problem, Trans-shipment ProblemAssignment Problems: Introduction to Assignment problem, Solution Methods, Hungarian Method, Travelling Salesman Problem Module-4 12 Hrs.Game Theory: Introduction, Two-Person Zero-Sum Game, Maximin-Minimax Principle, Games without saddle points–Mixed Strategies, Graphical Solution of 2×n and m×2 games, Dominance Property. Replacement Theory: Introduction, Replacement of items that deteriorate, Replacement of items that fails.Module-5 15 Hrs.Queuing Theory: Queuing problem, characteristics, general structure of queuing system, probabilistic queuing models (Poisson-exponential single server model with infinite population), applications of queuing theory. Markov Chains: Introduction, characteristics, Applications of Markov Chain, State and Transition Probabilities, Multi-Period Transition Properties, Steady-State ConditionsText Books:N.D. Vohra, “Quantitative Techniques in Management”,6 thEd.,2004 , BPB. Operations Research Theory and Applications – J K Sharma , Macmillan Publication, ISBN: 978-9350-59336-3Reference Books:V.K.Kapoor, “Operations Research Techniques for Management”,1st Ed., 2001. Sultan ChandK. Swarup, P.K.Gupta and M. Mohan, “Operations Research”, 12th Ed.,2006, Sultan Chand Hamady A. Taha, “Operations Research”, 7 th Ed., 2005, Wesley.TitleMarket Research and Analytics SeminarCredits04Course Objectives: To familiarize students with a variety of popular techniques used in the collection and analysis of marketing research information and, within the constraints of the course, to develop their proficiency in their use and interpretation. Provide students with an understanding of what marketing research can and cannot realistically achieve for management decisions.Course Outcomes:On successful completion of the module students will be able to:Gain perspective and practice in applying techniques and interpreting findings. Develop, design and execute marketing research projects. Study emerging trends in marketing research Implement the process of research design through collection of data.This class will consist of a lecture, discussion and hands on work. Students will also be responsible for a major research project. As such, a high degree of commitment, involvement and energy is critical to the successful completion of this course. Due to the nature of the marketing research process, the course may consist of a high degree of outside field work, computer analysis and group work. Students are required to read all assigned materials before coming to class. The instructor will typically give an overview of the assigned topic in the first portion of the class session. This part of the class seeks to stimulate discussion of key concepts as well as to provide a forum for the exchange of ideas among class members. Any topic can be selected for Case Study not restricted to:Trade AnalyticsFMCG MarketingIndustrial Products – B2B MarketingSuggested Readings:An Introduction to Marketing Research, Smith and Albaum (2010), Qualtrics Survey UniversityTitleFinancial Econometrics LabCredits04List of Experiments:Exercise -1For the given data find out the time series component present in it.Install Packages and calling installed packages related with time series in RUnderstanding the function of ts packages in RPlotting of time series data and conclude the possible analysis for the same.Exercise -2Create the moving average model for the given data – Simple Average.Create the moving average model for the given data – Moving Average.Create the moving average model for the given data – Weighted Moving Average.Fit na?ves forecasting model for the given data.Fit Smoothing forecasting model for the given data – Exponential Smoothing (Holts Method).Exercise -3Model Evaluation Techniques using – Error or Bias, MAD, MAPE, MSE.Exercise -4Testing the stationarity of the given dataTesting the autocorrelationExercise -5ACF and PACFCorrelogramExercise -6Auto Regressive Model Moving Average ModelExercise -7Fit ARMA for the given data and forecast the same for the next time periodFit ARIMA for the given data and forecast the same for the next time periodExercise – 8Testing of Spurious (Non Sense) RegressionUnit Root TestHeteroscedasticityGranger CausalityExercise – 9VARExercise – 10ARCH model fitGARCH model fitSEMESTER -4 SyllabusTitleProject ManagementTotal Hours60Credits03Course Objectives: To teach the students the basics of project planning, budgeting, execution & course correction.To acquaint the students with the planning process in business and familiarize them with the function and techniques of project management.To gain the ability to work on the Strategic Business planning process.To understand the strategic impact of all decisions and actions.Course Outcomes: On successful completion of the module students will be able to:Students will know the importance of flawless execution of project which requires intense & detailed planning & resourcing; also the principles of project management. Understand how short term and long term goals fit within the broader strategic plan.Able to deal with and manage any type of project.To proceed with a project with a clear and efficient step-by-step methodology.Module -1 9 Hrs.Introduction to Project Management: Understanding Project, Project Management, Portfolio Management, Program Management, Organizational Project Management, Projects and Strategic Planning, Project Management Office, Operations and Project Management, Operational Stakeholders in Project Management, Organizations and Project Management, Business Value Role of Project Management, Responsibilities and Competencies, Interpersonal Skills.Module -2 12 Hrs.Project Environment: The Project Environment, Project Lifecycle, Project Managers are Leaders, Organization Structure - The Basic Model, Modifications to the Basic Model, The Organizational Culture and Change, Organization as a System, Surviving the Organizational Structure, Project Stakeholders, Stakeholders – Who are they? Roles of the Stakeholders, How the Project Manager should lead the stakeholders. Public Private Partnership (PPP).Module – 3 15 Hrs.Project Planning: Initiation and Planning, Initiation, Project Kick-off and Communication, The kick-off meeting, the Project Charter creation, Assigning roles to the team, developing responsibility matrix, Developing the Communication Plan, Project Scope and Priorities, Defining the Scope, Vision Document, Statement of Work, Establishing Project Priorities, The Documents that need to be created, Project Scope and its Management - Work Breakdown Structure and Verification of the Scope. Verifying the Project Scope and Protecting the Scope from Change, Planning, The Project Planning Process, The Planning Stage: Introduction to Planning, The Process and the Activities, Creating a Schedule and Time Management Plan, Creating a Resource Plan, Creating a Financial Plan, Creating a Quality Plan, Creating a Risk Plan, Creating a Acceptance Plan, Creating a Communication Plan, Creating a Procurement Plan, Phase Review.Module-4 12 Hrs.Project Execution: Executing the Project, Project Work – Execution, Introduction to the process of execution, Directing the project work, Assuring Quality, Completing Procurements, Building a High Performance Project Team, Project Team is developed, not acquired – The Project Team Dynamics, Motivation and Leadership, Collaborative Problem Solving, Knowing the Stakes and Managing them, Stakeholder Management.Module-5 12 Hrs.Scheduling the Project in a Global Business Environment: Monitoring and Closing the Project in a global business environment, Monitoring and Controlling the Project Work, Monitoring and Controlling the Project Work, Schedule and Cost , Monitoring and Controlling Scope, Schedule and Cost – Overview, Controlling Scope, Controlling Schedule and Controlling Cost, Closing the Project – An Overview, Verifying the Scope of the Project Deliverables. Managing a project across geographical borders. Case Studies.Text Books:Robert L Kimmons, James H Loweree. Project Management: A Reference For Professionals: Cost Engineering, CRC Press, 2000.A Guide to the Project Management Body of Knowledge (PMBOK? Guide), Fifth Edition, Project Management Institute, 2013. Reference Books:Sanford I. Heisler. The Wiley Project Engineer's Desk Reference: Project Engineering, Operations, and Management, Wiley-interscience, 1994.James P Lewis. Fundamentals of Project Management, Heritage Publishers, 2003Harvard Business Press, Managing Projects Large and Small: The Fundamental Skills to deliver on budget and on Time, 2003.TitleText AnalyticsTotal Hours60Credits03Course Objectives: To understand the pre-processing of text for text analytics.To understand the importance of considering syntactic parsing.To understand the mechanism of text analytics generation in processing of natural language.To understand the importance of corpus creation in text analytics To understand the different statistical techniques used in text analyticsCourse Outcomes: On successful completion of the module students will be able to:Know the basic concepts of text analytics and its important terminologiesKnow the key role of syntactic parsing and semantic analysis in text analyticsKnow the importance of corpus creation in text analyticsKnow the important statistical techniques used in text analyticsModule -1 12 Hrs.Introduction to Text Analytics :Introduction to text pre-processing, terminologies related with text processing, challenges of text pre-processing, tokenization, sentence segmentation, introduction to lexical analysis, finite state morphonology, finite state morphology, morphology vs lexcal analysis, paradigm based lexical analysis.Module -2 12 Hrs.Syntactic Parsing and Semantic Analysis: Introduction to syntactic parsing, The Cocke–Kasami–Younger Algorithm, parsing as deduction, Implementing Deductive Parsing, LR Parsing, Constraint-based Grammars, Issues in Parsing, Basic Concepts and Issues in Natural Language Semantics, Theories and Approaches to Semantic Representation, Relational Issues in Lexical Semantics, Fine-Grained Lexical-Semantic Analysis.Module – 3 12 Hrs.Natural Language Generation :Introduction to natural language generation, simple Examples of Generated Texts, The Components of a Generator: Components and level of representation, Approaches to Text Planning: The Function of the Speaker, Desiderata for Text Planning, Pushing vs. Pulling, Planning by Progressive Refinement of the Speaker’s Message, Planning Using Rhetorical Operators, Text Schemas, The Linguistic Component: Surface Realization Components, Relationship to Linguistic Theory, Chunk Size, Assembling vs. Navigating, Systemic Grammars, Functional Unification GrammarsModule-4 12 Hrs.Corpus Creation: Introduction and definition of corpus in natural language processing, corpus size, Balance, Representativeness, and Sampling, Data Capture and Copyright, Corpus Markup and Annotation, Multilingual Corpora, Multimodal Corpora, Corpus Annotation Types, Morphosyntactic Annotation, Treebanks: Syntactic, Semantic, and Discourse Annotation, The Process of Building Treebanks, application of Treebanks.Module-5 12 Hrs.Statistical Techniques in Text Analytics: Introduction to statistics and its importance in text analytics, general linear model, binary linear classification, one versus all method for multi-category classification, maximum likelihood estimation in parameter estimation in linear classification techniques, concepts of generative and discriminative models, introduction to sequence prediction model and its application in text analytics.Text Books:Hand Book of Natural Language Processing, Second Edition – NITIN INDURKHYA FRED J. DAMERAU, CRC Press.Reference Books:Mining Text Data - Charu C. Aggarwal, ChengXiangZhai, SpringerText Mining Classification, Clustering, and Applications - Ashok N. Srivastava, Mehran Sahami, CRC PressTitleSocial and Web AnalyticsTotal Hours60Credits03Course Objectives: To understand the basic concepts and importance social media analytics.To understand the procedure for analysing twitter data and access the same through R platform.To understand the procedure for analysing Facebook data and access the same through R platform.To understand the procedure for analysing Instagram and access the same through R platform.To understand the procedure for analysing GitHub data and access the same through R platformCourse Outcomes: On successful completion of the module students will be able to:Understand the important terminologies and analytics techniques in social media analytics.Analyse the twitter data and conclude the important finding and insights of the society thought on particular issues.Analyse the facebook data and conclude the important finding and insights of the society thought on particular issues.Analyse the Instagram profile and find out the interesting insights. Analyse the GitHub profile and find out the latest trending article in GitHubModule -1 12 Hrs.Introduction to Social Media Analytics : History and Evolution of social media, impact of social media in growth of business, Social media and its importance, Various social media platforms, Social media mining, Challenges for social media mining, Social media mining techniques: Graph mining and text mining, The generic process of social media mining: Getting authentication from the social website, Data visualization R packages, The simple word cloud, Sentiment analysis Word cloud, Pre-processing and cleaning in R.Module -2 12 Hrs.Analytics on Twitter: Introduction, Twitter and its importance, Understanding Twitter's APIs: Twitter vocabulary, Creating a Twitter API connection: Creating a new app, Finding trending topics, Searching tweets, Twitter sentiment analysis: Collecting tweets as a corpus, Cleaning the corpus, Estimating sentiment.Module – 3 12 Hrs.Analytics on Facebook : Introduction, importance of Facebook, Creating an app on the Facebook platform, Rfacebook package installation and authentication, Installation, A closer look at how the package works, A basic analysis of your network, Network analysis and visualization: Social network analysis, Degree, Betweenness, Closeness, Cluster, Communities, Getting Facebook page data, Trending topics analysis, In?uencers: based on single post and multiple post, Measuring CTR performance for a page, Spam detection, Recommendations to friends.Module-4 12 Hrs.Analytics on Instagram: Definition and overview Instagram and its role in social awareness, Creating an app on the Instagram platform, Installation and authentication of the instaR package, Accessing data from R: Searching public media for a specific hashtag, Searching public media from a specific location, Extracting public media of a user, Extracting user profile, Getting followers, Getting comments, Number of times hashtag is used, Building a dataset: User profile, User media, Travel-related media, Popular personalities: Who has the most followers? Who follows more people? Who shared most media? Overall top users, Most viral media, Finding the most popular destination, Locations with most likes, Locations most talked about, Clustering the pictures, Recommendations to the users.Module-5 12 Hrs.Analytics on GitHub : Introduction to GitHub, creating an app on GitHub, GitHub package installation and authentication, Accessing GitHub data from R, Building a heterogeneous dataset using the most active users, Building additional metrics, Exploratory data analysis, EDA – graphical analysis: Which language is most popular among the active GitHub users? What is the distribution of watchers, forks, and issues in GitHub? How many repositories had issues? What is the trend on updating repositories? Compare users through heat map, EDA – correlation analysis: How Watchers is related to Forks, Correlation with regression line, Correlation with local regression curve, Correlation on segmented data, Correlation between the languages that user's use to code, how to get the trend of correlation?Text Books:Mastering Social Media Mining with R– Sharan Kumar Ravindran, Vikram Garg, PACKT Publishing.Reference Books:Social Media Mining with R - Nathan Danneman, Richard Heimann, PACKT Publishing.SOCIAL MEDIA MINING An Introduction - REZA ZAFARANI, MOHAMMAD ALI ABBASI, HUAN LIU, CAMBRIDGE University Press.TitleBusiness IntelligenceTotal Hours45Credits03Course Objectives: To understand the basic concepts of Business Intelligence and its architecture.To understand the procedure for Business Performance management and business intelligence.To understand the importance of OLAP and Business Intelligence Data stages.To understand the different types of business intelligence, reporting and dash board design. To understand how the Business Intelligence system is implementedCourse Outcomes: On successful completion of the module students will be able to:Understand the important terminologies and architecture of Business Intelligence system. Understand the important difference between business performance management and business intelligence.Understand the different OLAP systems used in Business Intelligence Report creations and analytics.Learn the different business intelligence types, and importance of report creation and dashboard design.Understand implementation procedure for business intelligence systemsModule -1 9 Hrs.Introduction to Business Intelligence: Introduction to Business Intelligence, A Framework for Business Intelligence (BI), Definitions of BI, A Brief History of BI The Architecture of BI, Styles of BI, The Benefits of BI, Event-Driven Alerts, Intelligence Creation and Use and BI Governance, A Cyclical Process of Intelligence Creation and Use, Intelligence and Espionage, Transaction Processing versus Analytic Processing, Successful BI Implementation, The Typical BI user Community, Appropriate Planning and Alignment with the Business Strategy, Real-Time, On-Demand BI Is Attainable, Developing or Acquiring BI Systems, Justification and Cost-Benefit Analysis, Security and Protection of Privacy, Integration of Systems and Applications , Major Tools and Techniques of Business Intelligence.Module -2 9 Hrs.Business Performance Management: Business Performance Management (BPM) Overview, BPM Defined, Comparison of BPM and BI, Operational Planning, Financial Planning and Budgeting, Pitfalls of Variance Analysis, Act and Adjust: What Do We Need to Do Differently?, Performance Measurement, Key Performance Indicators (KPI) and Operational Metrics, Problems with Existing Performance Measurement Systems, Effective Performance Measurement, BPM Methodologies, Balanced Scorecard (BSC) , Six Sigma, BPM Technologies and Applications, BPM Architecture, Commercial BPM Suites, BPM Market versus the BI Platform Market, Performance Dashboards and Scorecards, Dashboards versus Scorecards, Dashboard Design, important properties of design of dash board.Module – 3 9 Hrs.Business Intelligence - Stages : Introduction, Extract, Transform, and Load (ETL), Data Warehouse, Data Warehouse Architecture, Design of Data Warehouses, Dimensions and Measures, Data Warehouse Implementation Methods: Top-Down Approach, The Bottom-Up Approach, The Federated Approach, The Need for Staged Data, Integrating Data from Multiple Operating Systems, OLAP, Types of OLAP, Multidimensional OLAP (MOLAP), Relational OLAP (ROLAP), Hybrid OLAP (HOLAP), Data Mining, Data Mining and Statistical Analysis, Data-Mining Operations, Data Mining—Data Sources, Data Dredging, Data Management, Data Usage, Enterprise Portal (EP).Module-4 9 Hrs.Types of Business Intelligence: Multiplicity of BI Tools, The Problem with Multiple BI Tools, Types of BI, Enterprise Reporting, Cube Analysis, Ad Hoc Query and Analysis, Statistical Analysis and Data Mining, Alerting and Report Delivery, Modern BI, Enterprise Reporting, Support for Different Forms and Types, Support for Personalization and Customization, Support for Wide Reach, High Throughput and Access across All Touch Points, The Enterprise BI, Single Unified User Interface, Single Unified Backplane, Vision of a Critical BI System, Centralized Business Logic, Flexible Data Structures, Advanced Analytics, Reporting, Rich Report Design, Flexible Information Delivery, Self-Service Reporting, Critical BI for the Enterprise.Module-5 9 Hrs.Business Intelligence Implementation: Introduction, Implementation of BI System: An Overview, BI Implementations Factors, Managerial Issues Related to BI Implementation , BI and Integration Implementation, Types of Integration, Levels of BI Integration, Embedded Intelligent Systems, Connecting BI Systems to Databases and Other Enterprise Systems, Connecting to Databases, Integrating BI Applications and Back-End Systems, Middleware, On-Demand BI, The Limitations of Traditional BI, The On-demand Alternative, Key Characteristics and Benefits, Issues of Legality, Privacy, and Ethics, Legal Issues, Privacy, Ethics in Decision Making and Support. Text Books:Business Intelligence: A Managerial Approach, 2nd Edition - Turban, Sharda Efraim; Ramesh, DursunDelen and King, David. (2011), Prentice Hall.Business Intelligence for Telecommunications – Deepak Pareek, Auerbach Publications.Reference Books:Applied Data Mining Statistical Methods for Business and Industry - PAOLO GIUDICI, John Wiley & Sons Ltd.Data Mining: Concepts and Techniques, Second Edition - Han, Jiawei and Kamber, Micheline. (2009). San Francisco: Morgan Kaufmann Publishers.Business Analysis for Business Intelligence - Bert Brijs, CRC Press.TitleBusiness Intelligence LabCredits04List of Experiments:Exercise – 1Create the given data in databaseExercise – 2Define fact table and dimension table for the logical designExercise – 3Create the logical design for the given data to create Data warehouse.Exercise – 4Create a physical design in data warehouse platform to implement logical design created in the previous exercise.Exercise – 5Integrate the logical and physical design to create Data warehouse.Exercise – 6Design and create data martExercise – 7Extract data in to ETL platformExercise – 8Apply Aggregate functions in ETLExercise – 9Types of transformations in ETL operationsExercise – 10Graphical representation of dataExercise – 11Dashboard and Report Preparation ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download