Technology Tools in Business Management-II

Syllabus

GE 09: Technology Tools in Business Management-II

Unit 1: Advanced Excel (Part 1): Using Text to Columns, the Paste Special Function, Data Validation, Subtotals and Grouping, Consolidating Data, Scenario Analysis, Data Tables in Scenario Analysis, What-if Analysis, Math and Trig Functions, Text Functions in Excel, Lookup Functions (Vlookups, HLookups, Match), Statistical Functions, Database Functions, Financial Functions, Formula Auditing and Error Tracing, Hyperlinks in Excel, Linking Data, Understanding Pivot Tables, Using Pivot Charts, Workbook Properties, Protecting and Sharing Worksheets, Data Encrypting and Finalizing Workbooks.                  (12)

Unit 2: Advanced Excel (Part 2): Custom Number Formats in Excel, Using Custom Lists, Working with Templates, Tracking Changes in Excel, Merging and Comparing Excel Workbooks, Using Pivot Tables and Slicers, Report Filters for Basic Analytics, Contact Management and Marketing with Excel, Managing Customers, Vendors, and Employees, Gaining Product and Service Insights, Sales Reports Using Excel, Supervising Sales with Excel, Preparing Invoices, Assessing Account Aging, Analyzing Demographics, Creating Scheduling and Marketing Calendars, Creating Standard Excel Templates for Routine Business Data Management and Analysis Activities.   (12)

Unit 3: Power BI and Tableau: Power BI: Interface and Navigation, Connecting to Data Sources, Basic Data Modeling, Creating Interactive Dashboards, Using DAX for Calculations, Sharing and Publishing Reports, Advanced Data Transformations, Custom Visuals, Integration with Other Microsoft Tools. Tableau: Interface and Navigation, Connecting to Data Sources, Basic Data Visualization, Creating Interactive Dashboards, Using Calculations and Parameters, Sharing and Publishing Dashboards, Advanced Data Manipulation, Custom Geocoding, Integration with Other Tools.                                              (12)

Unit 4: Google Analytics & Financial Tools: Google Analytics: Setting up Google Analytics Accounts, Tracking Website Traffic, Understanding Key Metrics and Reports, Audience, Acquisition, and Behavior Analysis, Conversion Tracking, Using Google Analytics Academy for Hands-on Learning, QuickBooks: Introduction to QuickBooks, Managing Financial Transactions, Creating and Sending Invoices, Tracking Expenses and Income, Generating Financial Reports, Understanding QuickBooks Online vs Desktop, QuickBooks Support Resources.                                                                                                    (12)

Unit 5: SAP and Cloud Computing Tools: SAP: Overview of SAP ERP, Modules and Functionalities, Managing Business Operations, Integrating SAP with Other Business Systems, Hands-on Practice with SAP Training Modules, Using SAP Learning Hub for Skill Enhancement., Amazon Web Services (AWS): Cloud Computing Fundamentals, Key AWS Services (EC2, S3, RDS), Setting up AWS Accounts, Managing Cloud Resources, Understanding AWS Pricing Models, AWS Security Best Practices, AWS Training and Certification Resources., Google Cloud Platform (GCP): Introduction to GCP, Key Services and Tools (Compute Engine, Cloud Storage, Big Query), Managing GCP Resources, Setting Up Projects and Billing, GCP Security Features, Learning Resources for GCP, Microsoft Azure: Overview of Microsoft Azure, Key Services (Virtual Machines, Azure Storage, Azure SQL Database), Creating and Managing Azure Resources, Understanding Azure Pricing, Azure Security Best Practices, Azure Training and Certification Resources.      (12)