Lovely Professional University, Punjab

Course Code Course Title Course Planner Lectures Tutorials Practicals Credits

CSE424 BUSINESS ANALYTICS LABORATORY 14597::Robin Prakash Mathur 0.0 0.0 2.0 1.0

Course Category Courses with Placement focus

TextBooks

Sr No Title Author Edition Year Publisher Name

T-1 Microsoft Excel 2010, Data Analysis and Business Modeling

Wayne L. Winston 1st 2010 Prentice Hall

Reference Books

Sr No Title Author Edition Year Publisher Name

R-1 Fundamentals of Business Analytics R. N. Prasad,Semma Acharya

1st 2011 Wiley

Other Reading

Sr No Journals articles as Compulsary reading (specific articles, complete reference)

OR-1 homepages.wmich.edu/~balik/AFS06Balik.pdf ,

OR-2 www.ibm.com/software/data/cognos/services/ ,

OR-3 http://www.labanswer.com/laboratory_analytics.asp ,

Relevant Websites

Sr No (Web address) (only if relevant to the course) Salient Features

RW-1 http://www.exinfm.com/free_spreadsheets.html free excel spreadsheet

RW-2 www.techonthenet.com/excel/formulas/vlookup.php Vlookup function

RW-3 office.microsoft.com/en-in/.../hlookup-function-HP010062411.aspx hlookup function

RW-4 www.mrexcel.com/articles/excel-vlookup-index-match.php index function

RW-5 www.excel-examples.com/microsoft-excel-text-functions.htm text function

RW-6 www.excel-examples.com/microsoft-excel-text-functions.htm date function

RW-7 http://www.princeton.edu/~otorres/Excel/excelstata.htm descriptive statistics

RW-8 http://support.microsoft.com/search/?adv=1 Microsoft support

Detailed Plan For Practicals

Practical No Broad topic (Subtopic) Practical Description Learning Outcomes Equipment Used

Practical 1 Ranges and Look up function(Vlook up function)

vertical lookup function help to find specific information in large data tables

MS EXCEL 2010

Practical 2 Ranges and Look up function(Hlook up function)

horizontal lookup function help to find specific information in large data tables

MS EXCEL 2010

Practical 3 Index and Match function(Excel index function)

indexing in excel To find a value based on multiple criteria

MS EXCEL 2010

Practical 4 Index and Match function(Excel match function)

match function how to use match function in large spreadsheet

MS EXCEL 2010

Practical 5 Text and date function(Format text) operation on text in excel TRIM, REPT, CONCATENATE, MID and FIND.

MS EXCEL 2010

Practical 6 Text and date function(Today, Now and various date commands)

various date function day , date, networkdays, etc functions MS EXCEL 2010

Practical 7 Optimization and Summarizing data using excel(Histograms)

How to create a Histogram in Excel analyzing the data in histogram form MS EXCEL 2010

Practical 8 Optimization and Summarizing data using excel(Descriptive statistics)

Instructions for Calculating Descriptive Statistics in Excel

mean,mode,median, standard deviation MS EXCEL 2010

Practical 9 Optimization and Summarizing data using excel(Descriptive statistics)

Instructions for Calculating Descriptive Statistics in Excel

mean,mode,median, standard deviation MS EXCEL 2010

Practical 10 Data analysis operations(Pivot and slice operation)

Operations like slice, dice and pivot of OLAP

Can visualize the OLAP operations MS EXCEL 2010

Practical 11 Data analysis operations(Roll up and drill down operation)

Roll up and drill down operations of OLAP

how to make summarized and detailed data

MS EXCEL 2010

SPILL OVERPractical 12 Introduction to Multiple Regression Data prediction MS EXCEL 2010

Practical 13 Modeling Exponential Growth To model the growth of a company’s revenue over time

MS EXCEL 2010

*Each experiment of the lab will be evaluated using following relative scheme:

Component % of Marks

J/E 50

WR 20

VIVA 30