Building Service Businesses: Economy, Techniques, and Data Reporting
Learn service business economics and use data reporting for effective operations and growth.

Track
Service Management
Level
Intermediate
Language
English
Duration
120 hours
Learning Mode
Learn at ALC or at Home
Introduction
- Describe the economic evolution, development, and growth of service sector in India.
- Identify the prospects of growth and employment in service sector in India.
- Discuss the theories and strategies of pre-industrial and post-industrial service society.
- Classify the roles, characteristics, and technological involvement in 21st century service sector.
- Diagnose the types of service experiences and careers in 21st century.
- Explain the characteristics and processes involved in service sector.
- Classify the difference between Service Industry Processes and Manufacturing/Product-based processes.
- Discuss the different types of industries in service sector of India.
- Diagnose the developing, maintaining and managing the different service process.
- Examine the importance of customer participation and interaction in managing service processes.
- Classify the different techniques used to improve the service processes.
- Examine the upcoming trends and career opportunities in service sector.
- Diagnose the differentiators and challenges faced in service sector.
- Examine the opportunities and strategies in Local and Global entrepreneurship.
- Classify the between International and Domestic Business and its trade aspects.
- Discuss the concepts of sustainable entrepreneurship and its characteristics.
- Describe the leadership characteristics, culture and decision making in corporate entrepreneurship.
- Discuss the process of opportunity evaluation and the competitive advantages of new entry in the market.
- Diagnose the stages of new business, trends, innovation, and methods of generating ideas.
- Examine the features of different support programs of Government to promote entrepreneurship.
- Identify the different strategies personal and business growth as an entrepreneur.
- Discuss the concepts, pros and cons of Franchising, joint ventures, merger, and acquisition.
- Explain the process of developing vision statement of a company and the process to be followed.
- Introduce the fundamental concepts and applications of mathematics in the business context.
- Familiarize with various types of data relevant to business operations and the sources from which such data can be collected.
- Equip with the skills to organize data through frequency distribution and represent it visually using charts and graphs.
- Interpret measures of central tendency (mean, median, mode) in the context of business, providing them with tools to summarize and analyze data distributions.
- Develop proficiency in using measures of dispersion, skewness, and standard deviation for analyzing variability and risk in business data.
- Articulate the importance of mathematics in business and apply mathematical concepts to real-world scenarios.
- Demonstrate the ability to identify and categorize different types of data relevant to business operations, and critically evaluate appropriate data sources.
- Create and interpret frequency distributions, charts, and graphs, providing meaningful insights into business data.
- Apply measures of central tendency to analyze and summarize business-related data sets, facilitating effective decision-making in various business contexts.
- Utilize measures of dispersion, skewness, and standard deviation to assess variability and risk in business data, contributing to more informed and strategic business decisions.
- Equip with advanced skills in creating various types of charts in Excel.
- Create comprehensive dashboards in Excel for data visualization and analysis.
- Provide a foundational understanding of Google Analytics and its key features.
- Familiarize with the fundamentals of Google Data Studio for creating compelling visualizations.
- Leverage Google Data Studio for advanced data analytics and visualization.
What you'll learn ?
- Paraphrase the complex and transformative economic evolution, leading to significant development and substantial growth in India.
- Report the intricately interwoven and complex multifaceted outlook of growth and employment in service sector.
- Compare the multifaceted, encompassing diverse socio-economic frameworks and approaches of pre-industrial and post-industrial service society.
- Interpret the complex roles, diverse characteristics, and extensive technological involvement 21st century service sector.
- Illustrate the diverse array of service experiences and careers encompassing a wide range of industries and fields in 21st century.
- Illustrate the various characteristics and diverse process involvement in service sector.
- Compare the nature of offerings and operational procedures of Service Industry Processes and Manufacturing/Product-based processes.
- Review the various industries present in India offering distinct services and contributing to the country’s economic growth.
- Interpret the complex task involved in developing, maintaining, and managing various service processes.
- Inspect the crucial role of customer participation and interaction in effectively managing service processes to enhance customer satisfaction, optimize service delivery, and foster long-term loyalty.
- Report the various advanced techniques employed to enhance service processes.
- Review the upcoming trends that present diverse career opportunities in service sector.
- Review the intricately interwoven, presenting a complex landscape of differentiators and challenges in service sector.
- Paraphrase the opportunities and implementing effective strategies in both local and global entrepreneurship for thoughtful consideration and adaptation in business.
- Compare the intricate relationship between International and Domestic Business, along with its trade aspects that adds complexity to the overall economic landscape.
- Report the application of environmentally and socially responsible practices and principles in business operations, emphasizing long-term viability and positive impact on both the entrepreneurial economy and society.
- Interpret the intricate interplay of leadership characteristics, corporate culture, and decision-making processes significantly shape the landscape of corporate entrepreneurship.
- Estimate the intricately evaluating potential prospects and distinctive strengths of assessing opportunities and competitive advantages for new market entry.
- Examine the stages of new business involve integrating emerging trends, fostering innovation, and utilizing diverse methods for generating creative ideas.
- Survey the Government support programs for promoting entrepreneurship encompassing various features aimed at fostering entrepreneurial growth and innovation.
- Interpret the diverse strategies for personal and business growth essential to foster success and advancement as an entrepreneur.
- Diagnose the distinct business strategies of Franchising, joint ventures, mergers, and acquisitions each with its own set of advantages and disadvantages.
- Build the systematic and comprehensive approach to articulate a clear and inspiring company’s vision statement.
- Assess appropriate solutions for the challenges presented, while practicing humanistic, ethical, and moral values in real-life situations.
- Be proficient in designing and customizing complex charts to effectively represent data.
- Design interactive and insightful dashboards that convey meaningful insights.
- Navigate Google Analytics, interpret data, and generate reports for informed decision-making.
- Use Google Data Studio to design and present data-driven reports and dashboards.
- Perform complex data analyses, create interactive reports, and extract valuable insights using Google Data Studio.
Syllabus
1. Role of Services in an Economy 1
- a. Role of Services in an Economy Introduction
- b. The service sector
- c. Facilitation role of services in an economy
- d. Economic evolution
- e. Development and structure of services sector GDP in India
- f. Sectoral growth rate
- g. Remarkable growth observation in India’s service sector –an international comparison
- h. Sectoral Composition of GDP Growth
- i. Contribution of services sub-sectors to India’s GDP
- j. Reasons for the growth of Services in India
- k. Employment in the services sector
- l. Indian service sector
- m. Service sector in India: some issues & challenges
- n. Prospects for Growth in the Services Sector
2. ole of Services in an Economy 2
- a. Role of Services in an Economy Introduction
- b. Hunting-and-Gathering Societies
- c. Horticultural and Pastoral Societies
- d. Agricultural Societies
- e. Preindustrial Society
- f. Features Of Pre-Industrial Society
- g. Transport Therefore Primitive
- h. Industrial Society
- i. Industrialisation in India
- j. Post-industrial Society
- k. Comparison of Societies
- l. Theories Explaining the Growth of Services
3. Nature of Service Sector 1
- a. Nature of Service Sector Introduction
- b. Nature of the Service Sector
- c. The Role of the Service Economy in Development
- d. The Defining Characteristics of a service
- e. Classification of Service
- f. Trivia Time
- g. White and Blue Collared Workers & The working class
- h. Technology Spawns Workplace Change
- i. The Twenty-first Century Career
4. Nature of Service Sector 2
- a. Nature of Service Sector Introduction
- b. The Twenty-first Century Career
- c. The Experience Economy
- d. The Business that sells an Experience
- e. Consumer Service Experience
- f. Business Service Experience
- g. Service Dominant Logic
- h. Foundation Premises of Service Dominant Logic
- i. Fundamental principles in detail
5 . Characteristics of Service Operations 1
- a. Distinctive Characteristics of Service Operations
- b. Customer Participation
- c. Simultaneity
- d. Perishability
- e. Intangibility
- f. Heterogeneity
- g. Non-transferrable Ownership
6 . Characteristics of Service Operations 2
- a. Service Package
- b. Supporting Facility
- c. Facilitating Goods
- d. Information and Data
- e. Explicit Service
- f. Implicit Services
- g. Grouping Services by Delivery Process
- h. Low Labour Intensity
- i. High Labour Intensity
- j. Low Interaction & Customization
- k. High Interaction & Customization
- l. Open System View of Service Operations Management
7. Roles in Service Sector 1
- a. Roles in Service Sector Introduction
- b. Ways of Identifying Service
- c. Consequences of Rapid Growth of Services
- d. How recession affects service
- e. Human resources in the age of Service
- f. Human resources in the age of Service continue
- g. Outsourcing
8.Roles in Service Sector 2
- a. Roles in Service Sector
- b. The Trade Sector
- c. The Tourism Sector
- d. The Shipping Sector
- e. The Port Services Sector
- f. The Storage Services Sector
- g. The Telecom Sector
- h. The Real Estate Sector
- i. The IT Sector
- j. The Accounting Sector
- k. The Research and Development Sector
- l. The Legal Sector
- m. The Consultancy Sector
- n. The Construction Sector
9. Functions in the Service Sector 1
- a. Service Functions
- b. IT Operation Management
- c. Service Desk - Internal and External
- d. Technical Management
- e. Applications Management
- f. Reporting
- g. Functions of the Service Desk
10. Functions in the Service Sector 2
- a. Functions in the Service Sector an Interaction
- b. Human Resources
- c. HRD and HRM as functions of Human Resources
- d. Competitive Advantage
- e. Competencies, Culture, and Composition
- f. Differences in HRD between manufacturing sector and service sector
- g. Human Resource Planning
- h. Selection and Recruitment
- i. Training and Development of Employees
- j. Performance Management
- k. Overall Welfare of Employees
- l. Information Sharing
- m. Survey Management
- n. Compliance Management
- o. HR Technology Management
- p. Change Management
11. Processes in Service Sector 1
- a. Processes in Service Sector Introduction
- b. What is a Service Process
- c. Characteristics of Service Processes
- d. Steps of Managing a Service Process
- e. Elements of a Service Delivery System
12. Processes in Service Sector 2
- a. Types of Service Processes
- b. Degree or Level of Contact
- c. Differences between Service Industry Processes vs
- d. Manufacturing/Product-based processes
13. New and Upcoming Sectors: Roles in Service Sector 1
- a. Service Sector in India
- b. The IT and Fintech Sector
- c. The Travel and Tourism Sector
14. New and Upcoming Sectors: Roles in Service Sector 2
- a. The Media and Entertainment Industry
- b. The Logistics Industry
- c. Upcoming Trends in the Service Sector
- d. Career Path in the Service Sector
15. New and Upcoming Sectors: Functions in the Service Sector 1
- a. Classification of Services
- b. The Service Sector in the Three-Part Economy
- c. Employment Scenario
- d. Service process
- e. Line operations
- f. Job Shop Operations
- g. Degree of Contact
16. New and Upcoming Sectors: Functions in the Service Sector 2
- a. Service Offering cred fintech
- b. Developing and Maintaining the Service Process 1
- c. Developing and Maintaining the Service Process 2
- d. Service Process
- e. The 7 Step Process for Managing Service Processes
- f. Delivering excellent service
- g. Service Operation Functions
17. New and Upcoming Sectors: Processes in Service Sector 1
- a. Service Process
- b. Characteristics of service processes
- c. Service Location
- d. Customer Participation and Interaction
- e. Steps for managing service processes
18. New and Upcoming Sectors: Processes in Service Sector 2
- a. New and Upcoming Sectors: Processes in Service Sector Introduction
- b. Challenges in designing a process
- c. Phases of service process
- d. Improvement techniques for service industries
- e. Cost of delay of service processes
- f. What is Service Design by Yosef Shuman
19. Case Study 1
- a. Village Volvo
- b. Xpresso Lube
- c. Walmart
20. Case Study 2
- a. Air Deccan
- b. OYO Hotels
- c. Cloud Kitchens
- d. Telecom industry
- e. MyGate Application
- f. New Age Applications
- g. New Age Applications- 2
- h. New Age Applications- 3
21. Service Sector: Opportunities and Challenges 1
- a. Types of service sectors in India
- b. Differentiators of the service sector in India
- c. Challenges faced by the service sector in India
22. Service Sector: Opportunities and Challenges 2
- a. Service Sector in India
- b. Opportunities for the Service Sector in India
- c. Advantages of the Service Sector in India
- d. What’s New in Services
23. Sensing Business Opportunity and Identifying Solution 1
- a. Opportunity Recognition & The Opportunity Assessment Plan
- b. Nature of International Entrepreneurship
- c. Importance of International Business to the Firm
- d. Motivations to Go Global
- e. Available Distribution System
- f. Strategic Effects of Going Global
- g. Foreign Market Selection
- h. Entrepreneurial Entry Strategies
- i. Entrepreneurial Partnering
- j. Implications for the Global Entrepreneur
24. Sensing Business Opportunity and Identifying Solution 2
- a. Information Sources
- b. International Vs Domestic Business (PESTEL Analysis)
- c. Culture
- d. Aspects of International Trade
25. Entrepreneurship Development 1
- a. The nature of entrepreneurship
- b. Entrepreneur background and characteristics
- c. Sustainable entrepreneurship
26. Entrepreneurship Development 2
- a. Reliance Story
- b. Corporate entrepreneurship
- c. Managerial versus entrepreneurial decision making
- d. Establishing a culture for corporate entrepreneurship
- e. Leadership characteristics of corporate entrepreneurs
- f. Learning from failure
27. From Opportunity to Business Plan 1
- a. From Opportunity to Business Plan
- b. How to Identify an Opportunity
- c. Business Opportunity Evaluation
- d. New Entry Generation
28. From Opportunity to Business Plan 2
- a. Competitive Advantages in New Entry Opportunity
- b. Assessing Attractiveness of Opportunity
- c. First Mover Advantages
- d. Risk Reduction Strategies
29. From Business Plan to Funding 1
- a. Stages of a New Business
- b. Concept Stage
- c. Product Development Stage
- d. Sources of New Ideas
- e. Methods of Generating Ideas
- f. Does R&D Spending Correlate to Being the Most innovative
- g. Trust in Business
30. From Business Plan to Funding 2
- a. Trend
- b. Important Elements of Business Development
- c. Creative Problem Solving
- d. Innovation
- e. Defining a New Innovation (Product or Service)
- f. Classification of New Products or Services
- g. Evaluation Criteria
- h. E-Commerce
31. Government Programmes for Entrepreneurship 1
- a. What is Skill India initiative?
- b. Micro Enterprises
- c. MUDRA
- d. Roles and Responsibilities of MUDRA
- e. Atal Innovation Mission (AIM)
- f. Start Up India Initiative
- g. Startup India Seed Fund Scheme
- h. Aspire - Small Business Ideas for Rural Areas in India
- i. Dairy Entrepreneurship Development Scheme (DEDS)
- j. Venture Capital Assistance Scheme
- k. The Software Technology Park (STP) scheme
32. Government Programmes for Entrepreneurship 2
- a. Micro, Small and Medium Enterprises Development
- b. Micro, Small and Medium Enterprises Development - Continue
- c. What Is Credit Guarantee?
- d. Showcasing
- e. Objectives of IREDA
- f. Information technology
- g. State Govt.mechanisms
- h. ESDM Under the scheme
33. Strategies for growth 1
- a. Introduction - Continue
- b. The 4 Types of Entrepreneurships
- c. Success Strategies for Entrepreneurs
34. Strategies for growth 2
- a. Strategies for Personal Growth as an Entrepreneur
- b. Strategies for Personal Growth as an Entrepreneur
- c. Six Entrepreneurial and business growth strategy examples
35. Growth from external sources 1
- a. Franchising
- b. Franchising
- c. Types of Franchisees
- d. Joint Ventures
- e. Economies of Scale
36. Growth from external sources 2
- a. Merger or Acquisition
- b. Pros of mergers
- c. Cons of mergers
- d. Reasons that Cause Failure of Mergers and Acquisitions
37. Developing a company vision 1
- a. What is a vision statement?
- b. Vision statement
- c. Why does a company have to have a vision?
- d. Dual Components of the Company Vision
- e. Envisioned Future
- f. Vision statement sound mystical
38. Developing a company vision 2
- a. Developing a company vision Introduction
- b. Know your Goals
- c. Consider your company’s values
- d. Build upon your mission statement
- e. Keep it simple and straightforward
- f. Keep it Definitive
- g. Be forward thinking
- h. Establish timeframes
- i. Just write your vision statement!
- j. How To Use & Communicate Your Vision
- k. Measure Progress Toward Your Vision
- l. Vision statement templates and resources
- m. Visions Don’t Need to Be Set in Stone
39. Interview- Marker Movement
- a. Interview- Marker Movement Introduction
- b. Tell me something about yourself?
- c. Tell me little more about your Business?
- d. What’s your enterprise called?
- e. Can you elaborate entire cycle?
- f. How you decide pricing?
- g. What is your entire routine?
- h. Can you tell me how try to optimize the pricing and time that you have?
- i. How the ideation Process?
- j. What is your experience from multiple vendors?
- k. Can you take me through the pros and pain points of your business
- l. What is your Special experience in Party?
- m. Can you give some advice entrepreneur?
40. Case Study
- a. Cases on New Service Development
- b. Cases on the Service Encounter Triad
- c. Cases on Supporting Facility & Process Flows
41. Business Statistics: Meaning, Scope and Importance 1
- a. Introduction to Probability
- b. Introduction to Statistics
- c. Monty Hall Problem
- d. History of Statistics
- e. Indian Contribution to Statistics
- f. Arab Contribution to Statistics
- g. European Contribution to Statistics
- h. Three Waves of Statistics
- i. Modern Day Statistics
- j. Data Collection
- k. Methods or Methodology for Collection of Data
- l. Types of Statistics
- m. Nature of Statistics
- n. Conclusion
42. Business Statistics: Meaning, Scope and Importance 2
- a. Applications of Statistics
- b. - Real Life Applications of Statistics
- c. Application of statistics across the world
- d. Limitations of Statistics
- e. Importance of Statistics
43. Type of Data and Data Sources 1
- a. Definition of Statistics
- b. What is Data?
- c. Attribute Data
- d. Variable Data
- e. Examples of Attribute and Variable Data
- f. Primary Data
- g. Secondary Data
- h. - Definition of Primary and Secondary Data
- i. Pros and Cons of Primary Data
- j. Pros and Cons of Secondary Data
44. Type of Data and Data Sources 2
- a. Primary Data Collection Methods
- b. Secondary Data Collection Methods
- c. Primary Data Collection Methods Continued
- d. Census and Sampling
- e. - Key Differences Between Census and Sampling
45. Frequency Distribution, Charts and Graphs 1
- a. Classification of Data
- b. Objectives and Types of Classification of Data
- c. Tabulation: Objectives and Types
- d. - Types of Tabulation
- e. The Library of Congress Classification
- f. Graphs and Charts
- g. Creating Charts and Graphs
- h. - Line Graph
- i. - Bar Graph
- j. - Pie Charts
- k. - Cartesian Graphs
- l. - Venn Diagrams
46. Frequency Distribution, Charts and Graphs 2
- a. Histogram and It’s Types
- b. - Parts of Histogram
- c. Common Shapes of Histogram
- d. How to Make an Histogram
- e. Frequency Distribution
- f. Data Analysis
- g. Grouped and Ungrouped Data
47. Measures of Central Tendency 1
- a. Measures of Central Tendency
- b. Mean / Arithmetic Mean
- c. Applications of Arithmetic Mean
- d. Advantages / disadvantage of Arithmetic Mean
- e. Geometric Mean
- f. - Examples of Geometric Mean
- g. Applications of Geometric Mean
- h. - Advantages / Disadvantages of Geometric Mean
- i. Harmonic Mean
- j. Applications of Harmonic Mean
- k. - Advantages / Disadvantages of Harmonic Mean
- l. Relation Between Arithmetic, Geometric and Harmonic Mean
48. Measures of Central Tendency 2
- a. Median
- b. - Calculating Median
- c. Applications of Median
- d. Applications of Median in Real Life
- e. Key Advantages of Median
- f. Key Disadvantages of Median
- g. Mode
- h. Calculating Mode - Individual Observations
- i. - Discrete Series
- j. - Continuous Series
- k. - Grouping Method
- l. Applications of Mode
- m. Case Study: Mode
- n. Key Advantages of Mode
- o. Key Disadvantages of Mode
- p. Relation Between Median and Mode
49. Measures of Dispersion, Skewness, Standard Deviation 1
- a. Meaning of Dispersion
- b. Dispersion Continued
- c. Calculating Dispersion
- d. Measures of Dispersion
- e. - Absolute Measures & Relative Measures
- f. Range
- g. Advantages and Disadvantages of Range
- h. Applications of Range
- i. Coefficient of Range
- j. Mean Deviation
- k. Calculating Mean Deviation
- l. Advantages and Disadvantages of Mean Deviation
- m. Applications of Mean Deviation
50. Measures of Dispersion, Skewness, Standard Deviation 2
- a. Coefficient of mean deviation
- b. - Calculating Coefficient of Mean Deviation
- c. Quartile deviation and the coefficient of quartile deviation
- d. - Calculating Quartile deviation and the coefficient of quartile deviation
- e. Standard deviation and Variance
- f. Standard deviation - What does it means.
- g. Coefficient of variation
- h. Skewness
- i. Measures of skewness
51. Probability 1
- a. Understanding Probabilities
- b. Origins of Probability
- c. History of Probability
- d. What is Probability?
- e. The Need of Probability
52. Probability 2
- a. Approaches to Probabilities
- b. - The Classical Approach
- c. - The Relative Frequencies Approach
- d. - The Simulation Approach
- e. Case Study
- f. Overview of Set Notations
- g. Equalities/ TRANSLATING INEQUALITIES
- h. Sample Spaces
- i. Sets
- j. Putting Sets Together: Unions/ Intersections/ Complements
53. Normal Distribution and Sampling Distribution 1
- a. About Normal Distribution
- b. Definition of Terms and Statistical Symbols Used
- c. Properties of Normal Distribution
- d. Normality Testing in Minitab Software
- e. About Standard Normal Distribution
- f. Standardization – How to Calculate Z Scores
- g. About Sampling Distribution
54. Normal Distribution and Sampling Distribution 2
- a. Understanding Normal Distribution
- b. Kurtosis and Skewness
- c. The Empirical Rule
- d. The Normal Distribution Explained
- e. The Normal Distribution Explained in Advance
- f. Examples of Normal Distribution
- g. The Central Limit Theorem(CLT)
- h. Problems and Solutions of Normal Distribution
- i. Understanding Standard Normal Distribution in detail
- j. Area of Standard Normal Distribution
- k. Understanding Standard Normal Distribution
- l. Def. of Sampling Distribution
- m. The Advantages Associated With Sampling
- n. Characteristics of Sampling Distribution
- o. Functions of Sampling Distribution
- p. Parameters of Sampling Distribution
- q. Sampling Methods
55. Mathematics for Business 1
- a. Introduction to Interest
- b. Simple interest
- c. Compound interest
- d. Difference between simple and compound interest
- e. Simple interest Applications
- f. Compound interest concepts
- g. Compound interest Applications
- h. Examples of simple interest
- i. Examples of compound interest
56. Mathematics for Business 2
- a. Introduction to Depreciation
- b. WHY DO ASSETS DEPRECIATE?
- c. What Can and Cannot Be Depreciated?
- d. Which asset does not depreciate?
- e. Features of Depreciation
- f. Causes of Depreciation
- g. Types of depreciation
- h. Straight Line Method vs Written Down Value Method
- i. How Depreciation is Calculated
- j. NPV
- k. What is NPV?
- l. Advantages of Net present value method
- m. Limitations of Net present value method
- n. Rule of 72
57. Mathematics for Business 3
- a. About Break-Even Analysis
- b. Formula to Calculate Break-Even Point
- c. Role of the Concept of Break-Even Analysis in Managerial Decision Making
- d. Benefits of Break-Even Analysis
- e. About Business Forecasting
- f. Elements of Forecasting
- g. Types of Forecasting: - Qualitative - Jury, Delphi method
- h. - Quantitative - Linear Relation Method
- i. - Forecasting Problems
- j. Meaning of Demand Forecasting
- k. Objectives of Demand Forecasting
- l. Methods of Demand Forecasting
- m. Limitations of Demand Forecasting
58. Mathematics for Business 4
- a. About Fixed Costs and Variable Costs
- b. About Break-Even Analysis and Involved Calculations
- c. Margin of Safety
- d. Role of the Concept of Break-Even Analysis in Managerial Decision Making
- e. Benefits of Break-Even Analysis
- f. About Business Forecasting
- g. Elements of Forecasting
- h. Types of Forecasting / Qualitative Forecasting
- i. Quantitative Forecasting
- j. Forecasting Problems
- k. Meaning of Demand Forecasting
- l. Objectives of Demand Forecasting / Methods of Demand Forecasting
- m. Limitations of Demand Forecasting
59. Probability: 3
- a. Probabilities Involving Multiple Events
- b. Probability Notation
- c. Marginal Probabilities
- d. Union Probabilities
- e. Intersectional or Joint Probabilities
- f. Complement Probabilities
- g. Conditional Probabilities
- h. The Rules of Probability
60. Probability: 4
- a. Odds vs Probability
- b. Picturing Probability
- c. Venn Diagrams
- d. History of Venn Diagrams
- e. Tree Diagrams
- f. Misconceptions about Probabilities
61. Basics of Excel
- a. Apply Custom Formats and Layouts
- b. Apply Custom Data Formats
- c. Use Advanced Fill Options
- d. Apply Advanced Conditional Formatting and Filtering
- e. Apply Custom Styles and Templates
- f. Use Form Controls
- g. Prepare Workbooks for Internationalization
- h. Use Outlines
- i. Use Custom Views
62. Create advanced formulas
- a. Create advanced formulas
- b. Functions
- c. Apply functions in formulas
- d. Mathematical Functions
- e. Financial functions
- f. Useful Data Functions
- g. Some Other Useful Functions
- h. Look up data by using functions
- i. Apply advanced date and time functions
- j. Functions for Manipulating Text
- k. Use Scenarios
- l. Use What-If Analysis Tools
- m. Create Scenarios
- n. Merge Scenarios
- o. Create Scenario Summaries
- p. Use Data Tables
- q. Create Advanced Charts
- r. Basic Excel Charts
- s. Use Area, Scatter & Stock Charts
- t. Use Surface, Radar & Combination Charts
- u. Create Custom Chart Templates
63. Create Dashboards using Excel: 1
- a. Details of using Macros
- b. Record a Macro
- c. Method of Using Macros
- d. Creating Program VBA
- e. Visual Basic Editor (VBA)
64. Session 04: Create Dashboards using Excel: 2
- a. Macros
- b. Visual Basic Editor
- c. Remove Formatting
- d. IF Statement
- e. For Loop Function
65. Session 05: Create Dashboards using Excel: 3
- a. Introduction
- b. Input Box
- c. DoWhile or DoUntil
- d. Do While
- e. Do Until
- f. Transpose Headers
- g. Transpose Customer Order
- h. Adding Loop 1
- i. Adding Loop 2
66. Create Dashboards using Excel: 4
- a. Introduction of Pivot Table
- b. Recommended Pivot Table
- c. Pivot Table 1
- d. Pivot Table 2
- e. Graphs and Charts
- f. Understand Pivot Table
67. Create Dashboards using Excel: 5
- a. SUMPRODUCT Function
- b. Steps to Compute Net Sales
- c. SUMIF Function
- d. COUNTIF Function
- e. COUNTIFS Function
- f. AVERAGEIF Function
- g. Data Validation
68. Create Dashboards using Excel: 6
- a. TRUE function
- b. LOOKUP function
- c. VLOOKUP function
- d. HLOOKUP function
- e. INDEX MATCH function
69. Google Analytics-1
- a. What is Google Analytics
- b. Benefits of Google Analytics
- c. How to Setup Google Analytics Account
- d. Hierarchy of the Google Analytic
- e. Basics of Google Analytic
- f. Pros and Cons of Google Analytic
70. Google Analytics-2
- a. Google Analytics
- b. Audience report
- c. Bounce Rate / Audience–Active Users
- d. Demographics
- e. Behaviour Overview
- f. 6 benefits of using Google analytics
71. Google Data Studio-1
- a. History of Data
- b. How to Tell A Story With Data & Analytics
- c. Introduction to Google Data Studio
- d. Google Data Studio-1
72. Google Data Studio-2
- a. Google Ads
- b. Google Analytics-1
- c. Google Analytics-2
- d. YouTube Analytics-1
- e. YouTube Analytics-2
73. Google Data Studio-3
- a. Creating Tables
- b. Formatting and Sorting Tables
- c. Multiple Measures
- d. Conditional Formatting
- e. Advantages of using Tables in Google Data Studio
- f. Practical Activity Completed Tables
74. Google Data Studio-4
- a. Average value - highest and lowest value
- b. Completed practical activity
- c. Comparison calculations
- d. Running total calculation
- e. Drill down
- f. Working with dates
75. Google Data Studio-5
- a. Create Pivot Table
- b. Scorecard Visualization
- c. Practical Activity
- d. Slicers and Visualisation-1
76. Google Data Studio-6
- a. Text filter visualization
- b. Numeric visualization filters
- c. Date visualization filters
- d. Custom calculations
- e. Year month and day
- f. Case Statement
- g. Comparisons
77. Google Data Studio-7
- a. Into to time series graphs
- b. Create time series graphs1
- c. Create time series graphs 2
- d. Create time series graphs 3
- e. Changing time perolods
- f. Style and formatting
- g. Time series chart options
- h. Area graph
78. Google Data Studio-8
- a. Introduction to Slicers and visualization filters
- b. Scorecard visualizations
- c. Text Slicers
- d. Numeric slicers
- e. Date slicers
- f. Text visualisation filters
- g. Numeric visualisation filters
- h. Date visualisation filters
- i. Column and bar graphs
- j. Pie graphs
- k. Custom visualisation
79. Google Data Studio-9
- a. Analysing Data
- b. Practical Activity
- c. Google Data Studio
- d. Add Visits
- e. Using Google Data 1
- f. Using Google Data 2
- g. Using Google Data 3
- h. Sharing Dashboards
- i. Sharing Dashboards 1
80. Google Data Studio-10
- a. Data studio function for calculated fields
- b. Concat formula
- c. “RegExp Extract”
- d. “RegExp Match”
- e. “Case” formula
Work-Centric Approach
The academic approach of the course focuses on ‘work-centric’ education. With this hands-on approach, derive knowledge from and while working to make it more wholesome, delightful and useful. The ultimate objective is to empower learners to also engage in socially useful and productive work. It aims at bringing learners closer to their rewarding careers as well as to the development of the community.
- Step 1: Learners are given an overview of the course and its connection to life and work
- Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
- Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
- Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
- Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
- Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
- Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
- Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
- Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
- Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
- Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
- Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!