Total: 50 Hours
Objectives:
* Understand the role of business analytics within an organization
* Analyze data using excel and SPSS and understand relationships between the underlying business processes of an organization.
Unit 1: (12 hrs)
Basics of Excel
Getting Acquainted with Excel, Creating Basic Spreadsheets, Using Ranges, Creating Formulas. Copying & Pasting Formulas, Columns & Rows, Formatting Spreadsheets, Setting Spreadsheet Layout, Consolidating Spreadsheets. Spreadsheet Charts, Editing and Formatting Charts, Sorting Data, Auto Filtering Data.
Unit 2: (12 hrs)
Data Handling and Decision making
Data Handling - Controlling User Input, Working with Dates & Times, Working with Text, Lookup and Reference, Logical Functions, what-if analyses. Business decision using spread sheet - Working with Numbers, Summarizing Data, PivotTables 1, Simple Summaries, Manipulating Data, Interpreting Data, Power Pivot, Advanced Macros and VBA.
Unit 3: (13 hrs)
Analytics using SPSS
Different types of data; Data Visualization; Data visualization methods; Tables, Graphs, Charts, Histograms, Frequency distributions, Regression models Simple linear regression, multiple linear regressions: Non- linear regression; Logistic regression
Unit 4: (13 hrs)
Advanced Analytics and Decision making
Cluster Analysis and classification, Principal component analysis, Factor analysis, Discriminant Analysis.
References:
Albright Winston Zappe, (2006).Data Analysis and Decision Making with Microsoft Excel Hobson Publications, 3rd Edition.
Conrad Carlberg,(2008). Business Analysis with Microsoft Excel, Pearson Education, 3rd Ed.
Naresh K. Malhotra,(2003) Marketing Research an Applied Orientation, Pearson Education.