Information Systems Management Lab

Course Objective: This course aims to equip students with practical skills in using business information systems tools such as Excel, databases, ERP, CRM, and DSS to support data-driven decision-making and process automation in business environments Course Outcomes: Upon completion of this course, the student will be able to CO1. Apply spreadsheet tools (MS Excel) for performing basic financial analysis including ROI, break-even, and profit/loss statements.

CO2. Analyze and visualize business data using Power BI to create interactive dashboards and data insights.

CO3. Design and implement relational databases using tools like MS Access or MySQL, including ER diagrams and basic SQL queries.

CO4. Evaluate the effectiveness of integrated business applications (ERP, CRM, DSS) in supporting various business functions and strategic decision-making.

Following the topics to be covered in laboratory with hands-on training not limited to below mentioned tools only.

S.No Topic Tools/Software Expected Outcome

1. Financial Analysis Using Excel MS Excel Profit/loss, ROI, break- even analysis

2. Data Visualization & Dashboard Creation Power BI Charts, PivotTables, dashboards

3. Introduction to Databases MS Access / MySQL Create, update, delete records

4. Querying Business Data MS Access / MySQL SQL basics: SELECT, WHERE, JOIN, etc.

5. Create Entity Relationship diagram for different cases in sync. with databases Draw.io/Creately or any other free tool available ER Diagram, relationship between entities, types of entities and keys

6. Introduction to ERP Systems ERPNext / Tally Business process flow through ERP

7. CRM Tools & Applications Zoho CRM / Salesforce (demo) Customer lifecycle and engagement

8. DSS and Business Simulation Excel-based Models / DSS Software Scenario analysis and decision making Note: Any other relevant open-source software may be used for above topics.