Sustainable Entrepreneurship Through Improved Corporate Governance in India
working
Sustainable entrepreneurship and effective corporate governance are integral to achieving Sustainable Development Goal (SDG) 12, which focuses on ensuring sustainable consumption and production patterns. The Indian logistics sector is a key driver of economic development, encompassing transportation, warehousing, and supply chain management services. As the sector expands, there is a growing emphasis on integrating sustainability into business practices. This involves not only managing environmental impact but also ensuring ethical governance, employee welfare, and responsible resource use. Despite the growing focus on sustainability, there is often a lack of integrated analysis that evaluates corporate governance and sustainable practices holistically. This case study aims to fill this gap by assessing how logistics companies in India adhere to principles of ethical governance, sustainability, employee well-being, human rights, and environmental protection.
The primary objective of this module, "Sustainable Entrepreneurship Through Improved Corporate Governance in India," is to utilize Power BI and DAX-based modeling to evaluate the logistics sector's performance against key principles of corporate governance related to SDG 12. By analyzing various indicators and visualizing the results, the study aims to identify areas for improvement and provide recommendations for better alignment with sustainable entrepreneurship goals. This case study uses data from Business Sustainability and Responsibility (BSBR) reports of logistics companies in India. The dataset includes detailed information on governance practices, sustainability investments, employee well-being, human rights practices, and environmental impact metrics.
To assess adherence to ethical governance, transparency, and accountability principles
Purpose
In the context of growing concerns about corporate ethics and transparency, this goal aims to evaluate the extent to which logistics companies in India adhere to ethical governance standards. Ethical governance and transparency are critical in ensuring that businesses operate with integrity, maintain accountability, and foster trust among stakeholders. With increasing scrutiny on corporate behavior and a demand for higher standards of business conduct, assessing these principles helps identify gaps and areas for improvement.
Methodology
To assess the adherence of logistics companies in India to ethical governance and transparency principles, the methodology will involve a comprehensive analysis of the available data on disciplinary actions, CSR expenditure, and procurement and sales practices. The process will be as follows:
- Data transformation and organization to structure the data
- DAX modelling for computing main measures
- Data visualization for presenting the data
- Analyzing the trends in ethical governance and transparency
- Reporting the findings and including actionable recommendations for enhancing corporate governance practices based on the analysis.
To contribute and publish select a pending milestone.
Completed
Introduction to the ethical governance and transparency
Aim: The milestone will focus on providing the theoretical background for the goal by assessing the critical components of corporate responsibility. Understanding these concepts provides a foundation for assessing how well logistics companies adhere to ethical standards.
Method: An in-depth literature review of 10-15 journal articles to be undertaken from secondary data. The articles that include the discussion of ethical governance and transparency for the logistic companies in India need to be included. The emphasis should be laid on identifying the core concepts related to ethical governance and transparency. Furthermore, only those articles to be included which are dated 2018 and post that. You can refer Business Sustainability and Responsibility (BSBR) report details.
Structure: To achieve this milestone, write a 1000 words article. Use at least 10 references dated post 2018. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Introduction
- Conduct a comprehensive literature review on concept of ethical governance and transparency and its significance for achieving SDG 12
- Define core concepts related to ethical governance and transparency. Here you need to define what these measure means and why they are relevant for measuring ethical governance and transparency
- percentage of disciplinary actions relative to total employees,
- average percentage of females in the Board and Key Management Personnel,
- percentage of differently abled employees relative to total employees, and total employment.
- Ratio of Female Representation in Board vs Key Management Personnel
- Capex vs R&D Investment Ratio
- CSR expenditure percentage
- Purchases from Top 10 Trading Houses Percentage
- Sales to Top 10 Dealers Percentage
- Discuss specific challenges and issues faced by logistics companies regarding ethics and transparency.
- Explain why ethical governance is crucial in the logistics sector of India
- Conclusion
- References
Determination of key indicators for measuring ethical governance and transparency.
Aim: This milestone involves creating DAX measures to calculate key indicators related to ethical governance and transparency. Accurate DAX measures are essential for meaningful analysis.
Method: The milestone is divided into 3 parts. The 1st part of the module is focused on the computation of the stated indicators using DAX modelling. Once its done, then the 2nd part will be computing the weighted score based on different indicators. Finally you will discuss your work in the form of an article. The structure of the article is given in tasks.
Tasks:
- Introduction
- Compute Indicators
- percentage of disciplinary actions relative to total employees,
- average percentage of females in the Board and Key Management Personnel,
- percentage of differently abled employees relative to total employees,
- total employment.
- Ratio of Female Representation in Board vs Key Management Personnel
- Capex vs R&D Investment Ratio
- Computation of ethical governance and transparency score with followed assigned weights
- Disciplinary Actions Percentage: 20%
- CSR Expenditure Percentage: 20%
- Percentage of Females in Board and Management: 20%
- Purchases from Top 10 Trading Houses Percentage: 15%
- Sales to Top 10 Dealers Percentage: 15%
- Differently Abled Employees Percentage: 10%
- Scoring criteria
- Excellent (80-100 points)
- Good (60-79 points)
- Average (40-59 points)
- Below Average (20-39 points)
- Poor (0-19 points)
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Pending
Process of data transformation
Aim: The milestone will focus on discussing the process implemented for preparing and cleaning the data to ensure accuracy and consistency before analysis.
Method: The milestone is divided into 2 parts. 1st part is for the analysis of the main data. You need to extract the data relevant to you and then use the collected data for analysis. This will include all basic information and principle 1 data. Create a separate table for storing this data. Once this is done then perform the relevant data transformations for making the data suitable for analysis like changing data types, checking for the headers of table and so on. After all the issues are resolved then comes the 2nd part of the milestone which is discussing this working in the form of article. You will need to clearly discuss what you have done under this milestone by adding relevant snips.
Tasks:
- Introduction
- Existing issues with the data
- Steps taken for cleaning data and transforming it
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Visualization of logistic companies ethical governance and transparency level
Aim: This milestone will focus on visualizing the ethical governance and transparency level of the selected companies to have the identification of the overall picture of different companies' status.
Method: The milestone is divided into 2 parts. The 1st part is about creation of dashboard using relevant graphs for presenting the indicators. Also, the overall scoring computed using the weighted score method will be presented. Even a slicer need to be added to have the access of each indicator information year wise and company wise. Once this dynamic dashboard is created, the 2nd part will be about discussing what all you have done in the form of an article.
Task:
- Introduction
- Visualization along with interpretation
- Adding relevant visualization tools
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Reporting of the insights
Aim: The milestone will focus on providing recommendations for the logistic companies to improve their ethical governance and transparency level based on the insights derived from analysis
Method – The article will focus on the information derived from milestone 1 and the findings derived from your analysis in milestone 2 to 4. This milestone will be completely insights based wherein initially you will link your analysis findings with the theoretical information derived in milestone 1. Once this is done then comes the section wherein your learnings will be discussed. In the recommendation section you will have to state the possible recommendation for each company to improve their scoring of the concerned area. The recommendation will be overall for the logistic industry firstly and then company wise by understanding their status. These recommendations should be completely theoretical but practical which seems to be relevant within next few years. Apart from writing this article you will also prepare a PPT to discuss your insights within 5 slides.
Structure: To achieve this milestone, write a 1500 words article. Use information derived from milestone 1 to 4. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Introduction – brief introduction to the goal
- Report creation based on main insight
- Recommendation – practical recommendation company wise
Also, submit a PPT of upto 5 slides to discuss your findings and recommendations.
To assess sustainability and safety incorporation into product offerings
Purpose
The purpose of this goal is to evaluate how well sustainability and safety have been integrated into the product offerings of logistics companies in India. This includes analyzing the extent to which companies have invested in sustainable technologies and processes and how these investments have influenced the safety and environmental outcomes related to their products. The evaluation will provide insights into whether these investments are effectively reducing the environmental footprint and improving safety standards in their product life cycle
Methodology
To evaluate the sustainability and safety practices of logistics companies, the methodology will include the following steps:
- Data preparation to ensure all relevant data is cleaned, and prepared for analysis.
- DAX Modelling to compute specific indicators that measure the integration of sustainability and safety into product offerings.
- Creation of visual tools to interpret and present the data in a clear and impactful manner.
- Conducting a detailed analysis to identify patterns, trends, and correlations.
- Summarizing the findings with actionable recommendations for enhancing sustainability and safety in product offerings.
To contribute and publish select a pending milestone.
Completed
Understanding Sustainability and Safety in Product Offerings
Aim: This milestone will focus on providing a comprehensive understanding of what sustainability and safety mean in the context of product offerings. The purpose is to establish a foundation for assessing how well these factors are being incorporated into products by logistics companies.
Method: An in-depth literature review of 10-15 journal articles to be undertaken from secondary data. The articles that include the discussion of sustainability and safety offerings for the logistic companies in India need to be included. The emphasis should be laid on identifying the core concepts related to sustainability and safety in product offerings. Furthermore, only those articles to be included which are dated 2018 and post that. You can refer Business Sustainability and Responsibility (BSBR) report details.
Structure: To achieve this milestone, write a 1000 words article. Use at least 10 references dated post 2018. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Introduction to sustainability in products - Overview of how sustainability is integrated into product design, development, and lifecycle management.
- Safety in products- Discussion on the importance of safety considerations in product offerings, including compliance with safety regulations. Also mention its its significance for achieving SDG 12
- Literature review on best practices for integrating sustainability and safety into product offerings.
- Define key concepts and create a framework for assessing sustainability and safety in product offerings. Here you need to define what these measure means and why they are relevant for measuring sustainability and safety offerings
- Capex vs R&D Investment Ratio,
- Waste management practices
- Percentage of products and packaging recycled, reused, and safely disposed for plastics,
- Percentage of products and packaging recycled, reused, and safely disposed for e-waste,
- Percentage of products and packaging recycled, reused, and safely disposed for hazardous waste,
- Percentage of differently abled employees and workers,
- Percentage of female representation in the Board of Directors and key management personnel.
- CSR expenditure
- Explain why sustainability and safety in products is crucial in the logistics sector of India
- Conclusion
Data Preparation and Transformation
Aim: This milestone focuses on preparing and transforming the provided data for a robust analysis. The purpose is to ensure that the data is ready for accurate computation of indicators that will measure sustainability and safety incorporation.
Method: The milestone is divided into 2 parts. 1st part is for the analysis of the main data. You need to extract the data relevant to you and then use the collected data for analysis. This will include all basic information and principle 2 data. Create a separate table for storing this data. Once this is done then perform the relevant data transformations for making the data suitable for analysis like changing data types, checking for the headers of table and so on. After all the issues are resolved then comes the 2nd part of the milestone which is discussing this working in the form of article. You will need to clearly discuss what you have done under this milestone by adding relevant snips.
Tasks:
- Introduction
- Existing issues with the data
- Steps taken for cleaning data and transforming it
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
DAX Modelling and Indicator Computation
Aim: This milestone focuses on the creation of key indicators using DAX to quantify the integration of sustainability and safety into product offerings. The purpose is to generate measurable insights that can guide the evaluation process.
Method: The milestone is divided into 3 parts. The 1st part of the module is focused on the computation of the stated indicators using DAX modelling. Once its done, then the 2nd part will be computing the weighted score based on different indicators. Finally you will discuss your work in the form of an article. The structure of the article is given in tasks.
Tasks:
- Introduction
- Compute Indicators
- Capex vs R&D Investment Ratio,
- Ratio of Female Representation in Board vs Key Management Personnel
- Percentage of products and packaging recycled, reused, and safely disposed for plastics,
- Percentage of products and packaging recycled, reused, and safely disposed for e-waste,
- Percentage of products and packaging recycled, reused, and safely disposed for hazardous waste,
- Percentage of differently abled employees and workers,
- average Percentage of female representation in the Board of Directors and key management personnel. Note: - Measures the percentage of plastics reused out of the total reclaimed plastics from product life cycles.
- Assign weights to each indicator and calculate an overall sustainability score for each company based on the following weights
- R&D Investments in Sustainability: 15%
- Capex Investments in Sustainability: 15%
- Waste Management Practices (Recycled, Reused, Safely Disposed): 25%
- CSR Expense: 15%
- Differently Abled Employees and Workers: 10%
- Female Representation: 20%
- Scoring criteria
- Excellent (80-100 points)
- Good (60-79 points)
- Average (40-59 points)
- Below Average (20-39 points)
- Poor (0-19 points)
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Visualization of Sustainability and Safety Incorporation
Aim: This milestone focuses on visualizing the degree of sustainability and safety incorporation into product offerings. The purpose is to identify trends, correlations, and gaps through visual tools that make the data more interpretable and actionable.
Method: The milestone is divided into 2 parts. The 1st part is about creation of dashboard using relevant graphs for presenting the indicators. Also, the overall scoring computed using the weighted score method will be presented. Even a slicer need to be added to have the access of each indicator information year wise and company wise. Once this dynamic dashboard is created, the 2nd part will be about discussing what all you have done in the form of an article.
Tasks:
- Introduction
- Visualization along with interpretation
- Adding relevant visualization tools
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Reporting and Strategic Recommendations on enhancing the sustainability and safety of product offerings
Aim: Compile findings and articulate a report with actionable recommendations on enhancing the sustainability and safety of their product offerings.
Method – Discuss your suggestions in alignment with the literature from milestone 1 and the findings derived from the analysis of milestones 2, 3 & 4. Start by linking your statistical analysis findings with the theoretical information derived in milestone 1. Highlight key challenges. Explain why enhancing sustainability and safety in product offerings is essential, linking it to brand reputation, regulatory requirements, and long-term business viability.
The recommendation will be overall for the logistics industry first and then company-wise with a discussion about their overall status. Provide a strong rationale for the recommendation, supported by evidence from your research or case studies. Outline the anticipated benefits of implementing the recommendations. Define a recommended action or strategy.
Structure:
- Introduction: Contextual background, overview of the problems and challenges and importance
- Report creation based on main insight. Make use of figures and tables wherever appropriate (do not source from outside).
- Recommendation – practical recommendation company-wise
Goal 3: To define how companies support and promote the well-being of their employees
Purpose
The purpose of this goal is to evaluate how well companies in India support and promote the well-being of their employees. This includes assessing training programs, safety measures, diversity and inclusion practices, and overall well-being expenditures. By examining these factors, the goal is to understand the extent to which companies are investing in their employees' health, safety, and development, and to identify areas for improvement.
Methodology
To assess employee well-being, the methodology will include:
- Data preparation to ensure the data related to employee well-being is cleaned and formatted for analysis.
- Creating specific DAX measures to quantify various aspects of employee well-being.
- Using visual tools to present and interpret the data.
- Identifying patterns and trends related to employee well-being.
- Summarizing findings and providing actionable recommendations for enhancing employee well-being.
To contribute and publish select a pending milestone.
Completed
Understanding Employee Well-being
Aim: To establish a foundation for assessing employee well-being by understanding key concepts and best practices.
Method: An in-depth literature review of 10-15 journal articles to be undertaken from secondary data. The articles that include the discussion of employee well being for the logistic companies in India need to be included. The emphasis should be laid on identifying the core concepts related to employee well being. Furthermore, only those articles to be included which are dated 2018 and post that. You can refer Business Sustainability and Responsibility (BSBR) report details.
Structure: To achieve this milestone, write a 1000 words article. Use at least 10 references dated post 2018. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Introduction
- Importance of employee well being – overview of relevance of health and safety training programs for employees and workers, Role of skill upgradation in employee development, and Understanding the impact of diversity and inclusion on employee well-being. Also mention the significance of employee well being for achieving SDG 12.
- Review of best practices for supporting employee well-being.
- Definition of key concepts related to employee well-being. Here you need to define what these measure means and why they are relevant for measuring employee well being
- Well being expenditure
- Percentage of employees/workers having Training Coverage for Health and Safety and Skill
- Percentage of employees/wolers having Recordable Work-Related Injuries
- Share of LTFR for employees and workers
- Share of complaints on total working conditions and health and safety
- Percentage of differently abled employees and workers
- Percentage of female representation in the Board of Directors and key management personnel.
- CSR expenditure share
- Explain why employee well being is crucial in the logistics sector of India
- Conclusion
Data Preparation and Transformation
Aim: To prepare and transform data for accurate computation of employee well-being indicators.
Method: The milestone is divided into 2 parts. 1st part is for the analysis of the main data. You need to extract the data relevant to you and then use the collected data for analysis. This will include all basic information and principle 3 data. Create a separate table for storing this data. Once this is done then perform the relevant data transformations for making the data suitable for analysis like changing data types, checking for the headers of table and so on. After all the issues are resolved then comes the 2nd part of the milestone which is discussing this working in the form of article. You will need to clearly discuss what you have done under this milestone by adding relevant snips.
Tasks:
- Introduction
- Address existing issues with the data.
- Steps taken to format and transform data for analysis.
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Employee well being indicator computation using DAX modelling
Aim: To compute key indicators that measure the support and promotion of employee well-being.
Method: The milestone is divided into 3 parts. The 1st part of the module is focused on the computation of the stated indicators using DAX modelling. Once its done, then the 2nd part will be computing the weighted score based on different indicators. Finally you will discuss your work in the form of an article. The structure of the article is given in tasks.
Tasks:
- Introduction
- Compute Indicators
- Training coverage - Percentage of employees having Training Coverage for Health and Safety, percentage of employees having Training Coverage for Skill, Percentage of workers having Training Coverage for Health and Safety, Percentage of workers having Training Coverage for Skill Upgradation, the share of total employees receiving training, share of total workers receiving training,
- Safety metrics - Percentage of employees having Recordable Work-Related Injuries, percentage of workers having Recordable Work-Related Injuries, share of LTFR for employees and workers by assuming total working hours = [(no. of lost time injuries *1000000)/LTIFR] and number of lost time injuries being 10% of total recordable work-related injuries.
- Complaints analysis - share of complaints on total working conditions, share of complaints on health and safety
- Diversity metrics - Percentage of differently abled employees and workers, and average Percentage of female representation in the Board of Directors and key management personnel.
- Scoring – Assign weight to each indicator and calculate overall wellbeing score
- Training Coverage - 20% (divide as per the share of employees and workers in total employment)
- Safety Metrics - 40%
- Diversity Metrics - 20%
- Well-being Expenditure: 10%
- Complaints Analysis - 10%
- Scoring criteria
- Excellent (80-100 points)
- Good (60-79 points)
- Average (40-59 points)
- Below Average (20-39 points)
- Poor (0-19 points)
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Visualization of Employee Well-being Indicators
Aim: To visualize the computed indicators and overall well-being score, making the data more interpretable and actionable.
Method: The milestone is divided into 2 parts. The 1st part is about creation of dashboard using relevant graphs for presenting the indicators. Also, the overall scoring computed using the weighted score method will be presented. Even a slicer need to be added to have the access of each indicator information year wise and company wise. Once this dynamic dashboard is created, the 2nd part will be about discussing what all you have done in the form of an article.
Tasks:
- Introduction
- Visualization along with interpretation
- Adding relevant visualization tools
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Pending
Reporting and Strategic Recommendations for improving employee well-being
Aim: Compile findings and articulate a report with actionable recommendations for improving employee well-being.
Method – Discuss your suggestions in alignment with the literature from milestone 1 and the findings derived from the analysis of milestones 2, 3 & 4. Start by linking your statistical analysis findings with the theoretical information derived in milestone 1. Highlight key challenges. Explain why improving employee well-being is critical, linking it to productivity, employee engagement, retention, and overall organizational success. Structure your arguments in a way that highlights the relevance, practical application, and potential impact of your suggestions.
The recommendation will be overall for the logistics industry first and then company-wise with a discussion about their overall status. Provide a strong rationale for the recommendation, supported by evidence from your research or case studies. Outline the anticipated benefits of implementing the recommendations. Define a recommended action or strategy.
Structure:
- Introduction: Contextual background, overview of the problems and challenges and importance
- Report creation based on main insight. Make use of figures and tables wherever appropriate (do not source from outside).
- Recommendation – practical recommendation company-wise
Goal 4: To determine how companies respect and promote human rights within their operations and value chains.
Purpose
The purpose of this goal is to assess how effectively companies respect and promote human rights within their operations and across their value chains. This includes evaluating human rights training, wage policies, and addressing complaints related to human rights issues. The evaluation will provide insights into the company's commitment to human rights standards and highlight areas for improvement.
Methodology
To evaluate the respect and promotion of human rights by companies, the methodology will include:
- Clean and prepare the provided data for accurate analysis.
- Compute specific indicators that reflect human rights practices and policies.
- Develop a scoring system to quantify the overall performance in human rights.
- Create visual tools to interpret and present data clearly and impactfully.
- Conduct a detailed analysis to identify patterns and trends in human rights practices.
- Summarize findings with actionable recommendations for enhancing human rights practices.
To contribute and publish select a pending milestone.
Completed
Understanding Human Rights in Corporate Operations
Aim: Establish a foundation for assessing how companies incorporate human rights into their operations and value chains.
Method: An in-depth literature review of 10-15 journal articles to be undertaken from secondary data. The articles that include the discussion of incorporation of human rights in corporate operations for logistic companies in India need to be included. The emphasis should be laid on identifying the core concepts related to of incorporation of human rights in corporate operations. Furthermore, only those articles to be included which are dated 2018 and post that. You can refer Business Sustainability and Responsibility (BSBR) report details.
Structure: To achieve this milestone, write a 1000 words article. Use at least 10 references dated post 2018. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Overview of human rights principles applicable to corporate operations.
- Discussion on the importance of clear human rights policies and standards. Also mention the significance for achieving SDG 12.
- Examine best practices and standards for respecting and promoting human rights in businesses.
- Define key concepts and create a framework for assessing human rights practices within companies. Here you need to define what these measure means and why they are relevant for incorporation of human rights in corporate operations
- percentage of total employment having human rights training coverage,
- Minimum wage compliance
- Complaints related to sexual harassment, discrimination, child labor, forced labor, wages, and other human rights issues.
- Percentage of differently abled employees and workers
- Percentage of female representation in the Board of Directors and key management personnel.
- Explain why incorporation of human rights in corporate operations is crucial in the logistics sector of India
- Conclusion
Data Preparation and Transformation
Aim: Ensure that all relevant data is cleaned and transformed for accurate analysis.
Method: The milestone is divided into 2 parts. 1st part is for the analysis of the main data. You need to extract the data relevant to you and then use the collected data for analysis. This will include all basic information and principle 5 data. Create a separate table for storing this data. Once this is done then perform the relevant data transformations for making the data suitable for analysis like changing data types, checking for the headers of table and so on. After all the issues are resolved then comes the 2nd part of the milestone which is discussing this working in the form of article. You will need to clearly discuss what you have done under this milestone by adding relevant snips.
Tasks:
- Introduction
- Address existing issues with the data.
- Steps taken to format and transform data for analysis.
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Pending
DAX Modelling for indicator derivation
Aim: Compute indicators to quantify human rights practices and respect within the company. Develop a scoring system to evaluate overall performance.
Method: The milestone is divided into 3 parts. The 1st part of the module is focused on the computation of the stated indicators using DAX modelling. Once its done, then the 2nd part will be computing the weighted score based on different indicators. Finally you will discuss your work in the form of an article. The structure of the article is given in tasks.
Tasks:
- Introduction
- Compute Indicator
- Human Rights Training Coverage: percentage of total employment training coverage, percentage of employees training coverage, percentage of workers training coverage
- Minimum wage compliance: [employees paid more than minimum wage/total employees]*100. Apply this formula for total employment, employees and workers
- Complaints analysis – total rate of complaints, and then individual rate of complaints related to sexual harassment, discrimination, child labor, forced labor, wages, and other human rights issues.
- Differently abled percentage - Percentage of differently abled employees and workers
- Female representation - average Percentage of female representation in the Board of Directors and key management personnel.
- Scoring – Assign weight to each indicator and calculate overall human rights practice
- Human Rights Training Coverage: 20%
- Minimum wage compliance: 15%
- Differently Abled Percentage: 15%
- Female Representation : 15%
- Complaint Rates (combined): 35% (distributed among individual complaint rates)
- Scoring criteria
- Excellent (80-100 points)
- Good (60-79 points)
- Average (40-59 points)
- Below Average (20-39 points)
- Poor (0-19 points)
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Visualization of Human Rights Practices
Aim: Visualize the data to identify trends, gaps, and areas for improvement.
Method: The milestone is divided into 2 parts. The 1st part is about creation of dashboard using relevant graphs for presenting the indicators. Also, the overall scoring computed using the weighted score method will be presented. Even a slicer need to be added to have the access of each indicator information year wise and company wise. Once this dynamic dashboard is created, the 2nd part will be about discussing what all you have done in the form of an article.
Tasks:
- Introduction
- Visualization along with interpretation
- Adding relevant visualization tools
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Reporting and Strategic Recommendations for promoting human rights in operations and value chains
Aim: Compile findings and articulate a detailed report with actionable recommendations for improving human rights practices in operations and value chains.
Method – Discuss your suggestions in alignment with the literature from milestone 1 and the findings derived from the analysis of milestones 2, 3 & 4. Start by linking your statistical analysis findings with the theoretical information derived in milestone 1. Highlight key challenges. Discuss the significance of human rights in business operations, linking it to corporate social responsibility. State possible recommendations for each company to improve their scoring of the concerned area. Explain why this recommendation is important.
The recommendation will be overall for the logistics industry first and then company-wise with a discussion about their overall status. Provide a strong rationale for the recommendation, supported by evidence from your research or case studies. Discuss how this action will address specific human rights challenges. Define a recommended action or strategy.
Structure:
- Introduction: Contextual background, overview of the problems and challenges and importance
- Report creation based on main insight. Make use of figures and tables wherever appropriate (do not source from outside).
- Recommendation – practical recommendation company-wise
Goal 5: To evaluate how companies manage their environmental impact and contribute to environmental sustainability.
Purpose
The purpose of this goal is to assess how companies manage their environmental impact and their contributions to environmental sustainability. This includes evaluating energy consumption, water use, waste management, and greenhouse gas emissions. The evaluation aims to provide insights into the company's environmental practices and their effectiveness in reducing environmental impact and promoting sustainability.
Methodology
To evaluate environmental impact management and sustainability contributions, the methodology will include:
- Data clearing for accurate analysis.
- Determination of indicators to measure environmental impact and sustainability efforts.
- Visualization of information for presenting data clearly and impactfully.
- Summarize findings with actionable recommendations for enhancing environmental sustainability.
To contribute and publish select a pending milestone.
Completed
Understanding Environmental Impact and Sustainability
Aim: Establish a foundation for assessing how companies manage their environmental impact and contribute to sustainability.
Method: An in-depth literature review of 10-15 journal articles to be undertaken from secondary data. The articles that include the discussion of managing environmental impact and contribution to sustainability for logistic companies in India need to be included. The emphasis should be laid on identifying the core concepts related to environmental impact and sustainability efforts. Furthermore, only those articles to be included which are dated 2018 and post that. You can refer Business Sustainability and Responsibility (BSBR) report details.
Structure: To achieve this milestone, write a 1000 words article. Use at least 10 references dated post 2018. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Overview of environmental impact categories including energy use, water consumption, waste management, and emissions.
- Significance of assessing environmental impact and promoting sustainability. Also mention the significance for achieving SDG 12.
- Discussion on best practices for managing environmental impact and promoting sustainability.
- Define key concepts and create a framework for assessing environmental impact and sustainability efforts. Here you need to define what these measure means and why they are relevant for managing environmental impact and contribution to sustainability
- Share of renewable energy consumption,
- Water usage intensity,
- Waste generation intensity,
- Scope 1 emission intensity,
- Scope 2 emission intensity,
- Scope 3 emission intensity.
- Explain why managing environmental impact and contribution to sustainability is crucial in the logistics sector of India
- Conclusion
Visualization of Environmental Impact and Sustainability
Aim: Visualize the data to identify trends, gaps, and areas for improvement in environmental management and sustainability.
Method: The milestone is divided into 2 parts. The 1st part is about creation of dashboard using relevant graphs for presenting the indicators. Also, the overall scoring computed using the weighted score method will be presented. Even a slicer need to be added to have the access of each indicator information year wise and company wise. Once this dynamic dashboard is created, the 2nd part will be about discussing what all you have done in the form of an article.
Tasks:
- Introduction
- Visualization along with interpretation
- Adding relevant visualization tools
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Pending
Data Preparation and Transformation
Aim: Ensure that all relevant data is cleaned and transformed for accurate analysis.
Method: The milestone is divided into 2 parts. 1st part is for the analysis of the main data. You need to extract the data relevant to you and then use the collected data for analysis. This will include all basic information and principle 6 data. Create a separate table for storing this data. Once this is done then perform the relevant data transformations for making the data suitable for analysis like changing data types, checking for the headers of table and so on. After all the issues are resolved then comes the 2nd part of the milestone which is discussing this working in the form of article. You will need to clearly discuss what you have done under this milestone by adding relevant snips.
Tasks:
- Introduction
- Address existing issues with the data.
- Steps taken to format and transform data for analysis.
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Determining sustainability indicators using DAX modelling
Aim: Compute indicators to measure environmental impact and sustainability efforts. Develop a scoring system to evaluate overall environmental performance.
Method: The milestone is divided into 3 parts. The 1st part of the module is focused on the computation of the stated indicators using DAX modelling. Once its done, then the 2nd part will be computing the weighted score based on different indicators. Finally you will discuss your work in the form of an article. The structure of the article is given in tasks.
Tasks:
- Introduction
- Compute Indicators-
- share of renewable energy consumption,
- Water usage intensity,
- Waste generation intensity,
- Scope 1 emission intensity,
- scope 2 emission intensity, and
- scope 3 emission intensity. Note: Intensity is computed by dividing the total amount by total employment
- Scoring: Compute an overall sustainability score based on weighted indicators.
- Energy Consumption from Renewable Sources: 20%
- Water Usage Intensity: 15%
- Waste Generation Intensity: 15%
- Scope 1 Emissions Intensity: 20%
- Scope 2 Emissions Intensity: 15%
- Scope 3 Emissions Intensity: 15%
- Scoring criteria
- Excellent (80-100 points)
- Good (60-79 points)
- Average (40-59 points)
- Below Average (20-39 points)
- Poor (0-19 points)
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Reporting and Strategic Recommendations for environmental sustainability
Aim: Compile findings into a detailed report with actionable recommendations for improving environmental sustainability.
Method – Discuss your suggestions in alignment with the literature from milestone 1 and the findings derived from the analysis of milestones 2, 3 & 4. Start by linking your statistical analysis findings with the theoretical information derived in milestone 1. Discuss your overall learning from the analysis. State possible recommendations for each company to improve their scoring of the concerned area. Explain why this recommendation is important.
The recommendation will be overall for the logistics industry first and then company-wise with a discussion about their overall status. These recommendations should be relevant in a practical scenario. Overall, use information derived from milestones 1 to 4. Discuss the anticipated benefits of implementing this recommendation. Consider environmental, economic, and social impacts.
Structure:
- Introduction: Contextual background, overview of the problems and challenges and importance
- Report creation based on main insight. Make use of figures and tables wherever appropriate (do not source from outside).
- Recommendation – practical recommendation company-wise
Goal 6: To identify how companies contribute to inclusive growth and equitable development within their operational regions.
Purpose
The purpose of this goal is to evaluate how companies contribute to inclusive growth and equitable development within their operational regions. This includes analyzing job creation across different areas and the impact of CSR spending. The evaluation aims to provide insights into how effectively companies promote economic growth and equitable opportunities in the regions where they operate.
Methodology
To assess contributions to inclusive growth and equitable development, the methodology will include:
- Data transformation for accurate analysis.
- Determining indicators for assessing contributions to local economic development and inclusive growth.
- Visualization of the data
- Summarize findings with actionable recommendations for enhancing contributions to inclusive growth and equitable development.
To contribute and publish select a pending milestone.
Completed
Understanding Inclusive Growth and Equitable Development
Aim: Establish a foundation for assessing how companies contribute to inclusive growth and equitable development.
Method: An in-depth literature review of 10-15 journal articles to be undertaken from secondary data. The articles that include the discussion of inclusive growth and equitable development role for logistic companies in India need to be included. The emphasis should be laid on identifying the core concepts related to assessing contributions to inclusive growth and equitable development. Furthermore, only those articles to be included which are dated 2018 and post that. You can refer Business Sustainability and Responsibility (BSBR) report details.
Structure: To achieve this milestone, write a 1000 words article. Use at least 10 references dated post 2018. Make use of figures and tables wherever appropriate (but do not copy paste them from any source). Structure of the article should be as follows:
- Overview of inclusive growth concepts, including equitable access to opportunities and resources.
- Significance of inclusive growth and equitable development. Also mention the significance for achieving SDG 12.
- Examine best practices and standards for promoting inclusive growth and equitable development.
- Define key concepts and create a framework for assessing contributions to inclusive growth and equitable development. Here you need to define what these measure means and why they are relevant for promoting inclusive growth and equitable development
- Job creation in rural, semi-urban, urban, and metropolitan areas
- CSR expense
- percentage of total employment having human rights training coverage,
- Complaints related to sexual harassment, discrimination, child labor, forced labor, wages, and other human rights issues.
- Explain why assessment of contributions to inclusive growth and equitable development is crucial in the logistics sector of India
- Conclusion
Visualization of Contributions to Inclusive Growth
Aim: Visualize the data to identify trends, gaps, and areas for improvement in contributions to inclusive growth and equitable development.
Method: The milestone is divided into 2 parts. The 1st part is about creation of dashboard using relevant graphs for presenting the indicators. Also, the overall scoring computed using the weighted score method will be presented. Even a slicer need to be added to have the access of each indicator information year wise and company wise. Once this dynamic dashboard is created, the 2nd part will be about discussing what all you have done in the form of an article.
Tasks:
- Introduction
- Visualization along with interpretation
- Adding relevant visualization tools
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Pending
Data Preparation and Transformation
Aim: Ensure that all relevant data is cleaned and transformed for accurate analysis.
Method: The milestone is divided into 2 parts. 1st part is for the analysis of the main data. You need to extract the data relevant to you and then use the collected data for analysis. This will include all basic information and principle 5 and 8 data. Create a separate table for storing this data. Once this is done then perform the relevant data transformations for making the data suitable for analysis like changing data types, checking for the headers of table and so on. After all the issues are resolved then comes the 2nd part of the milestone which is discussing this working in the form of article. You will need to clearly discuss what you have done under this milestone by adding relevant snips.
Tasks
- Introduction
- Address existing issues with the data.
- Steps taken to format and transform data for analysis.
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
DAX Modelling and Indicator Computation
Aim: Compute indicators to measure contributions to inclusive growth and equitable development. Develop a scoring system to evaluate overall impact.
Method: The milestone is divided into 3 parts. The 1st part of the module is focused on the computation of the stated indicators using DAX modelling. Once its done, then the 2nd part will be computing the weighted score based on different indicators. Finally you will discuss your work in the form of an article. The structure of the article is given in tasks.
Tasks:
- Introduction
- Compute Indicators
- Human Rights Training Coverage: percentage of total employment training coverage, percentage of employees training coverage, percentage of workers training coverage
- Complaints analysis – the total rate of complaints, and then the individual rate of complaints related to sexual harassment, discrimination, child labour, forced labour, wages, and other human rights issues.
- Scoring- Compute an overall contribution score based on weighted indicators.
- Job Creation in Rural Areas: 20%
- Job Creation in Semi-Urban Areas: 20%
- Job Creation in Urban Areas: 15%
- Job Creation in Metropolitan Areas: 15%
- CSR Expense: 10%
- Training on Human Rights: 10%
- Complaints for Human Rights Violations: 10%
- Scoring criteria
- Excellent (80-100 points)
- Good (60-79 points)
- Average (40-59 points)
- Below Average (20-39 points)
- Poor (0-19 points)
- Summary
Submission: You need to submit along with your analysis file a word document stating how you have followed the above task. Add relevant screenshots of your analysis and if required any video snip of your analysis to make the word document more effective. The word document is for providing better understanding of what processes you have followed to fulfill the above task.
Reporting and Strategic Recommendations for inclusive growth and equitable development
Aim: Compile findings and articulate a detailed report with actionable recommendations for inclusive growth and equitable development
.
Method – Discuss your suggestions in alignment with the literature from milestone 1 and the findings derived from the analysis of milestones 2, 3 & 4. Start by linking your statistical analysis findings with the theoretical information derived in milestone 1. Address both economic inclusivity and social equity. Highlight key challenges. Discuss the importance of addressing these challenges in the context of sustainable development and social justice. State possible recommendations for each company to improve their scoring of the concerned area. Explain why this recommendation is important.
The recommendation will be overall for the logistics industry first and then company-wise with a discussion about their overall status. Provide a strong rationale for the recommendation, supported by evidence from your research or case studies. Discuss how this action will address specific human rights challenges. Define a recommended action or strategy.
Structure:
- Introduction: Contextual background, overview of the problems and challenges and importance
- Report creation based on main insight. Make use of figures and tables wherever appropriate (do not source from outside).
- Recommendation – practical recommendation company-wise