SUMMER TRAINING REPORT Jitender
SUMMER TRAINING REPORT Jitender
SUMMER TRAINING REPORT Jitender
Undertaken at
Page | 1
DECLARATION
I, Jitender, a student of BBA (Full Time) Programmed at the Centre for DPG Institute of Technology And
Management, Gurugram, Haryana, hereby declare that I have undergone the
Summer Training at YBI Foundation under the supervision of Ms. Akriti badra on and from 20th June to
21th July.
I also declare that the present project report is based on the above summer training and is my original
work. The content of this project report has not been submitted to any other university or institute
either in part or in full for the award of any degree, diploma or fellowship.
Further, I assign the right to the university, subject to the permission from the organization concerned,
use the information and contents of this project to develop cases, case leads, and papers for publication
and/or for use in teaching.
Date: 07/10/2024
ACKNOWLEDGEMENT
Page | 2
It is moral to offer my thanks to my teachers who have provided me with the required guidance to
complete the project. I am thankful to Ms. Akriti badra, who has been a constant source of guidance in
I am very thankful to all the interns and the other employees in the company for always lending a
helping hand and making valuable contribution towards the successful completion of this Summer
Training Report.
Jitender
Page | 3
CERTIFICATE OF THE SUMMER INTERNSHIP
Page | 4
TABLE OF CONTENTS
1. Declaration 2
Acknowledgement 3
Internship Certificate 4
Executive Summary 6
EXECUTUVE SUMMARY
Page | 5
This study revolves around the future of business analytics in the corporative world. To utilize
the full potential of the employees and the organization, business analytics is really important.
The study analyses the future of business analytics in the upcoming future from the perspective
of other interns of YBI Foundation and some employees at a banking organization. Various
attributes like skills and knowledge needed for business analytics, opinions on business analytics
future, learning environment of the organization are also discussed in the study. Sample for the
study was collected from 8 interns at YBI Foundation.
The findings throw light on the importance of business analytics for an organization and suggest
various reasons to use business analytics in an organization. The data collection was done
through questionnaires. Secondary data has been collected from various published books for the
study.
Page | 6
CHAPTER 1
INTRODUCTION
Introduction:
Business Analytics is the process of collecting, organizing, analyzing, and interpreting data to
gain insights that can be used to make informed business decisions. It involves using statistical
and quantitative analysis techniques to extract meaningful insights from data and using these
insights to improve business performance.
Business analytics can be applied to various areas of business, including sales, marketing,
finance, operations, and customer service. By analyzing data from these areas, organizations can
identify trends, patterns, and correlations that can help them make informed decisions and
optimize their business processes.
Some of the techniques used in business analytics include data mining, predictive analytics, data
visualization, and statistical analysis. These techniques can be used to generate reports,
dashboards, and visualizations that provide actionable insights for business decision-makers.
As businesses increasingly shift towards data-driven approaches, the field's importance is ever
greater. Understanding this field ensures that professionals can leverage data effectively to guide
their organizations to success. Hence, it is important to study business analytics and to know its
place in the future.
Page | 8
Origin of the Report:
This report is an internship report prepared as a requirement for the conclusion of the BBA
program. As per requirement of BBA program of DPG Institute of Technology and Management
Department of Business Administration. The Guideline and preparation of the report was
supervised and directed by Ms. XYZ and I am thankful to her for assigning this project.
The main objective of this report is to find the scope of business analytics in the future for an
organization. To find the main objective other supportive objectives are as follows:
Methodology of Report:
The study is performed based on the information extracted from different sources collected by
using a specific methodology. This report is analytical-theoretical in nature. To prepare the
report on finding the future of business analytics the information has been collected from
primary and secondary sources.
After studying the whole report anyone can learn and understand the importance of business
analytics in the organization and how helpful it is to survive in this competitive world of today’s
era.
Questionnaire Design:
Questionnaire was prepared with close-ended questions. The size of the questionnaire is two A4
sizes pages and the average time of questioning is 20 minutes.
Sampling Plan:
Population
The target population were the Interns who were learning about business analytics in YBI
Foundation.
Sample Unit
Sample Size
Sampling Method:
The non- probability convenience sampling method was used for collecting the information
about this report.
Page | 10
Data Collection Procedure:
1. Primary data:
I have collected raw data through questionnaires and interviews with other interns at the
organization.
2. Secondary data:
In order to collect the secondary data YBI foundation’s website has been used.
Moreover Library sources also have been used as secondary source of collecting
early mentioned data and information.
Page | 11
CHAPTER 2
COMPANY PROFILE
Page | 12
Overview of YBI Foundation:
YBI Foundation is a Delhi-based not-for-profit edutech company that aims to enable the youth to
grow in the world of emerging technologies. They offer a mix of online and offline approaches
to bring new skills, education, technologies for students, academicians and practitioners. They
believe in the learning anywhere and anytime approach to reach out to learners. The platform
provides free online instructor-led classes for students to excel in data science, business
analytics, machine learning, cloud computing and big data. They aim to focus on innovation,
creativity, technology approach and keep themselves in sync with the present industry
requirements. They endeavor to support learners to achieve the highest possible goals in their
academics and professions.
Vision
The YBI Foundation envisions a future where the Sustainable Development Goals (SDGs) are
not merely aspirations but tangible realities. Committed to the pursuit of global well-being, we
strive to play a pivotal role in actualizing the SDGs by championing innovative solutions,
fostering partnerships, and empowering communities. Our vision is to contribute significantly to
eradicating poverty, ensuring quality education, promoting gender equality, and addressing
environmental challenges. Through collective action and impactful initiatives, we aim to be a
catalyst for positive change, leaving a lasting legacy of sustainable development for
generations to come.
Values
Page | 13
Mission of YBI Foundation:
The YBI Foundation is dedicated to catalyzing positive change and fostering sustainable
development. Committed to empowering communities, we strive to provide educational
opportunities, support environmental initiatives, and promote social equality. Through
collaborative efforts and innovative solutions, we aim to create a lasting impact, shaping a world
where every individual has the resources and opportunities to thrive.
The YBI Foundation extends its expertise to businesses in their initial stages by offering business
management services. This includes assistance in developing business plans, providing strategic
direction, and offering counseling to help these businesses establish a strong foundation for
success
Page | 14
YBIF actively engages in identifying and promoting innovative solutions to address global
challenges outlined in the Sustainable Development Goals (SDGs) such as implementation of
creative and effective approaches to poverty eradication, quality education, gender equality, and
environmental sustainability.
3. Fostering Partnerships:
YBI foundation works towards building strong and meaningful partnerships with various
stakeholders, including governmental bodies, non-profit organizations, businesses, and local
communities. Collaborative efforts are essential in maximizing impact and creating a united front
to tackle complex issues related to well-being, education, and social equality.
4. Empowering Communities:
YBI Foundation is dedicated to empowering communities by providing them with the necessary
tools, resources, and educational opportunities. This could involve initiatives aimed at skill
development, capacity building, and creating a supportive environment that enables individuals
to take charge of their own development and contribute to the well-being of their communities.
YBI Foundation is committed to promoting social equality by advocating for and supporting
initiatives that address issues related to gender equality, inclusivity, and social justice. This
involves projects that focus on creating equal opportunities for all individuals, regardless of
gender, race, or background, fostering a society where everyone can thrive and contribute to
positive change.
Social Welfare:
The YBI Foundation envisions a future where the Sustainable Development Goals (SDGs) are
not merely aspirations but tangible realities. Committed to the pursuit of global well-being, we
strive to play a pivotal role in actualizing the SDGs by championing innovative solutions,
fostering partnerships, and empowering communities.
Page | 15
Policies and Procedures:
• Maintain cordial relations with all stakeholders, namely- customers or buyers, suppliers
and employees
Qualified & Experienced Manpower: The employees are highly educated and
experienced.
Quality of service(s): There is no hesitation about the quality of the services of this
company.
Demand & Supply: Besides the quality of the services, marketing circumstances is
also in the preeminent situation.
Sophisticated Technologies: System of Technology is extremely upgraded than the
others company.
Dealing with IT: Company complete their activities by using software and hardware.
Also used internet for exchanging their information from one business office to
another.
Page | 16
Courses provided by YBI Foundation:
STRENGTHS:
Capable management.
Qualified and experienced manpower.
Extremely rapid growth, high quality services and production level also high.
Adequate capitalization.
Good profitability.
Powerful marketing plan.
It provides quick and prompt services to its customers.
WEAKNESS:
Page | 17
New business models and changing market trends.
Markets crowded with advertising messaging.
Lack of capital.
OPPORTUNITY:
As many developing countries see a rise in entrepreneurship, YBI has the opportunity to
expand its services.
The foundation can adopt AI driven mentorship platforms and mobile finance solutions to
reach a wider audience more efficiently.
Partnering with tech companies can help YBI offer digital solutions, such as blockchain
for microfinance, and boost its program offerings.
There is a growing trend towards social entrepreneurship among youth, YBI can tap into
this by offering specialized support for socially impactful.
THREATS:
Page | 18
CHAPTER 3
BUSINESS ANALYTICS
Page | 19
Business Analytics:
Business analytics is the process of transforming data into insights to improve business
decisions. Data management, data visualization, predictive modeling, data mining, forecasting
simulation, and optimization are some of the tools used to create insights from data. Yet, while
business analytics leans heavily on statistical, quantitative, and operational analysis, developing
data visualizations to present your findings and shape business decisions is the end result. For
this reason, balancing your technical background with strong communication skills is imperative
to do well in this field.
Every business today produces a considerable amount of data in a specific way. Business
Analytics now are leveraging the benefits of statistical methods and technologies to analyze their
past data. This is used to uncover new insights to help them make a strategic decision for the
future.
Thus, Business Analytics brings together fields of business management, and computing to get
actionable insights. These values and inputs are then used to remodel business procedures to
generate more efficiency and build a productive system.
Page | 20
Evolution of Business Analytics:
Technologies have been used as a measure to improve business efficiency since the beginning.
Automation has played a considerable role in managing and performing multiple tasks for large
organizations. The unprecedented rise of the internet and information technology has further
boosted the performance of businesses.
2. Diagnostic Analytics: This focuses on the past performance to ascertain why something
has happened.
Page | 21
3. Predictive Analytics: Using all the past gathered data tells what is likely to happen on a
granular level. The prediction of the possible outcome is made using statistical models
and machine learning techniques.
1. Augmented Analytics:
Augmented analytics tools use AI and natural language processing to automate data preparation,
insight discovery, and reporting. They make data analysis more accessible to non-technical users
by providing automated suggestions and recommendations.
2. Real-time Analytics:
Businesses are increasingly focusing on real-time data analysis to make faster decisions. This is
especially important in sectors like e-commerce, finance, and healthcare, where real-time
insights can lead to competitive advantages.
With the increasing importance of data in decision-making, data governance and privacy have
become crucial. Emerging trends include stricter regulations (e.g., GDPR), enhanced data
security measures, and ethical considerations in data analytics.
Page | 22
4. Data Democratization:
Businesses are making efforts to empower more employees with self-service analytics tools,
enabling them to access and analyze data without needing a deep understanding of data science
or programming.
Data visualization tools are evolving to provide more interactive and informative visual
representations of data. Augmented reality (AR) and virtual reality (VR) are also being explored
to enhance data exploration.
6. Cloud-Based Analytics:
The shift to cloud-based analytics platforms continues, allowing organizations to scale their
analytics infrastructure more easily, reduce costs, and benefit from enhanced collaboration and
accessibility.
As the Internet of Things (IoT) generates massive volumes of data, businesses are integrating
this data with traditional datasets to gain deeper insights. This trend is particularly relevant in
industries like manufacturing, logistics, and smart cities.
8. Explainable AI:
As AI and ML become more integrated into analytics, there's a growing need for models to be
explainable and interpretable. Understanding why a model makes a particular prediction or
recommendation is essential, especially in regulated industries.
Page | 23
9. Natural Language Processing (NLP):
NLP is being used in analytics to analyze unstructured text data, such as customer reviews, social
media comments, and emails. It enables sentiment analysis, topic modeling, and trend
identification.
Organizations are adopting hybrid and multi-cloud strategies to balance performance, cost, and
security. This approach allows them to leverage different cloud providers and on-premises
infrastructure.
With the high volume of data available for businesses, collecting meaningful data is a big
challenge. Ideally, employees spend much time sifting through the data to gain insights, which
can be overwhelming. Besides, it’s impossible to sort and analyze all the data in real-time, which
might fail to provide accurate and relevant reports.
You can easily overcome this problem using an appropriate data analytics tool. The tool can help
you collect, analyze, and provide real-time reports for better decision-making. On the same note,
it reduces the time employees spend collecting and analyzing data, thereby boosting productivity.
The use of data analytics tools should also go hand in hand with employee training on effective
data utilization, either through online training programs or coaching workshops.
Without the perfect tool for your business data analytics needs, you may be unable to conduct the
data analysis efficiently and accurately.
Different analytics tools (Power BI, Tableau, RapidMiner, etc.) are available and offer varying
capabilities. Besides finding software that fits your budget, you should consider other factors
such as your business objectives and the solution’s scalability, integration capabilities, ability to
analyze data from multiple sources, etc.
Page | 24
If you have a data analyst, they should be well-versed in how to select the right tool. But since
the analytics landscape is changing quickly, those not conversant with modern data analytics
could enroll in a refresher course such as the Tableau Data Analytics Certificate to hone their
skills. Alternatively, you could consult an expert to guide you on the best tool based on your
business needs.
3. Data visualization:
Data requires to be presented in a format that fosters understandability. Usually, this is in the
form of graphs, charts, infographics, and other visuals. Unfortunately, doing this manually,
especially with extensive data, is tedious and impractical. For instance, analysts must first sift
through the data to collect meaningful insights, then plug the data into formulas and represent it
in charts and graphs.
The process can be time-consuming, not forgetting that the data collected might not be all-
inclusive or real-time. But with appropriate visualization tools, this becomes much easier, more
accurate, and relevant for prompt decision-making.
Usually, data comes from multiple sources. For instance, your website, social media, email, etc.,
all collect data you need to consolidate when doing the analysis. However, doing this manually
can be time-consuming. You might not be able to get comprehensive insights if the data size is
too large to be analyzed accurately.
Software built to collect data from multiple sources is pretty reliable. It gathers all the relevant
data for analysis, providing complete reports with minimal risk of errors.
5. Low-Quality Data:
Inaccurate data is a major challenge in data analysis. Generally, manual data entry is prone to
errors, which distort reports and influence bad decisions. Also, manual system updates threaten
errors, e.g., if you update one system and forget to make corresponding changes on the other.
Fortunately, having the tools to automate the data collection process eliminates the risk of errors,
guaranteeing data integrity. More so, software that supports integrations with different solutions
helps enhance data quality by removing asymmetric data.
Another major challenge facing businesses is a shortage of professionals with the necessary
analytical skills. Without in-depth knowledge of interpreting different data sets, you may be
limited in the number of insights you can derive from your data.
Page | 25
In addition to hiring talent with data analysis skills, you should consider acquiring easy-to-use
and understand software. Alternatively, you could conduct training programs to equip employees
with the most up-to-date data analysis skills, especially those handling data.
7. Scaling challenges:
With the rapidly increasing data volume, businesses face the challenge of scaling data analysis.
Analyzing and creating meaningful reports becomes increasingly difficult as the data pile up.
This can be challenging even with analytics software, especially if the solution is not scalable.
That’s why it’s important to consult before acquiring a tool to ensure it’s scalable and supports
efficient data analysis as your business grows.
Businesses collect customer data from many different channels, including physical retail, e-
commerce, and social media. By using data analytics to create comprehensive customer profiles
from this data, businesses can gain insights into customer behavior to provide a more
personalized experience.
Take a retail clothing business that has an online and physical presence. The company could
analyze its sales data together with data from its social media pages and then create targeted
social media campaigns to promote their e-commerce sales for product categories that the
customers are already interested in.
Organizations can run behavioral analytics models on customer data to optimize the customer
experience further. For example, a business could run a predictive model on e-commerce
transaction data to determine products to recommend at checkout to increase sales.
Enterprises can use data analytics to guide business decisions and minimize financial losses.
Predictive analytics can suggest what could happen in response to changes to the business, and
prescriptive analytics can indicate how the business should react to these changes.
Page | 26
For instance, a business can model changes to pricing or product offerings to determine how
those changes would affect customer demand. Changes to product offerings can be A/B tested to
validate the hypotheses produced by such models. After collecting sales data on the changed
products, enterprises can use data analytics tools to determine the success of the changes and
visualize the results to help decision-makers choose whether to roll the changes out across the
business.
3. Streamline operations:
Organizations can improve operational efficiency through data analytics. Gathering and
analyzing data about the supply chain can show where production delays or bottlenecks originate
and help predict where future problems may arise. If a demand forecast shows that a specific
vendor won't be able to handle the volume required for the holiday season, an enterprise could
supplement or replace this vendor to avoid production delays.
Risks are everywhere in business. They include customer or employee theft, uncollected
receivables, employee safety, and legal liability. Data analytics can help an organization
understand risks and take preventive measures. For instance, a retail chain could run a propensity
model — a statistical model that can predict future actions or events — to determine which
stores are at the highest risk for theft. The business could then use this data to determine the
amount of security necessary at the stores, or even whether it should divest from any locations.
Businesses can also use data analytics to limit losses after a setback occurs. If a business
overestimates demand for a product, it can use data analytics to determine the optimal price for a
clearance sale to reduce inventory. An enterprise can even create statistical models to
automatically make recommendations on how to resolve recurrent problems.
5. Enhance security:
All businesses face data security threats. Organizations can use data analytics to diagnose the
causes of past data breaches by processing and visualizing relevant data. For instance, the IT
department can use data analytics applications to parse, process, and visualize their audit logs to
Page | 27
determine the course and origins of an attack. This information can help IT locate vulnerabilities
and patch them.
IT departments can also use statistical models to prevent future attacks. Attacks often involve
abnormal access behavior, particularly for load-based assaults such as a distributed denial-of-
service (DDoS) attack. Organizations can set up these models to run continuously, with
monitoring and alerting systems layered on top to detect and flag anomalies so that security pros
can take action immediately.
Businesses can now update the value of their product offerings, maximize reach, find business
opportunities, and generate new revenue streams with the use of business analytics. Additionally,
it has assisted companies in offering consumers solutions that are optimized, improving customer
experience. The following are some of the essential scopes of Business Analytics –
1. Customer Experience:
2. Inventory management:
Companies can streamline their supply chains and cut costs. Understanding the
frequency and timing of orders, the products that are in demand, and how well-positioned
a firm is to meet those demands through strategically planning its supply chain operations
are all made possible by business analytics. Additionally, it allows companies to scale
their offerings sustainably.
Organizations may design focused campaigns and find the best cross-sell and up-sell
opportunities by researching how customers respond to their product offers and
marketing initiatives. To predict patterns and trends in consumers’ purchasing behavior,
it is necessary to look into the consumer’s age demography, average income, and reasons
Page | 28
for purchasing. This aids firms in concentrating their product messages and timing of
launches to meet the needs of their customers.
Those clunky on-premise data storage solutions are a thing of the past. Cloud platforms like
Microsoft Azure Synapse Analytics and Amazon Redshift offer scalable and cost-effective
solutions for data storage, processing and analysis.
Businesses of all sizes can now leverage powerful analytics without the hassle of expensive
hardware infrastructure, ultimately leading to the future of business analytics.
Data is powerful, but it can also be overwhelming. Communicating insights is key to data-driven
decision-making. Data visualisation tools like Tableau, Power BI, and Qlik are industry leaders
in creating interactive dashboards and data visualisations that bring complex information to life.
These tools help you to convert raw data into clear and compelling stories that can be told to
anyone, technical or non-technical.
3. Programming Languages:
While some business analytics tasks can be done through user-friendly interfaces, a deeper
understanding of programming languages opens up a whole new world of possibilities
Python, R and SQL are the fundamental tools for data analysis, manipulation and modelling.
Python is a favourite among many due to its versatility and libraries specifically designed for
data science tasks.
Don't be scared of the coding part —many courses are designed for beginners and focus on
building practical data analysis skills.
Page | 29
4. Splunk:
Splunk is one of the most widely used business analytics tools in small and medium-scale
industries.
Initially launched to process machine log file data, Splunk has added many sophisticated
features, including a user-friendly web interface and visualization options.
In the age of data analytics, where information is a valuable currency, privacy and ethics are
paramount. As organizations harness data to make informed decisions, it is essential to navigate
the ethical and privacy considerations thoughtfully. Here are several steps that organizations
should take to safeguard their data:
1. Organizations must obtain informed consent when collecting and using personal data.
Individuals should be aware of how their data will be used and have the option to opt out.
3. Organizations should be transparent about their data collection and processing practices.
Clear privacy policies and easy-to-understand explanations of data usage are essential.
4. Collect only the data that is necessary for the intended purpose. Avoid collecting
excessive or irrelevant information that could pose privacy risks.
6. Policies should be in place against using the data by Employees for personal gain or
leaking sensitive information out. Due care should be taken regarding timely access
revocation when employees leave the organization.
7. Address bias in data and algorithms to ensure fairness and prevent discrimination.
Analyse data for potential bias and take corrective actions.
Page | 30
8. Organizations should be accountable for their data practices. Establish clear
responsibilities for data governance and compliance with privacy regulations.
10. Develop and deploy AI and machine learning models ethically. Avoid harmful
consequences and unintended biases in algorithmic decision-making.
11. Stay updated with data protection laws and regulations such as GDPR, CCPA, and
HIPAA. Ensure full compliance in data handling.
CHAPTER 4
FINDINGS and ANALYSIS
Page | 31
Business Analytics and its Importance:
Business Analytics is the process of collecting, organizing, analyzing, and interpreting data to
gain insights that can be used to make informed business decisions. It involves using statistical
and quantitative analysis techniques to extract meaningful insights from data and using these
insights to improve business performance.
Business analytics can be applied to various areas of business, including sales, marketing,
finance, operations, and customer service. By analyzing data from these areas, organizations can
identify trends, patterns, and correlations that can help them make informed decisions and
optimize their business processes.
IMPORTANCE:
1. Data-driven decision-making:
Business analytics provides organizations with the tools and insights needed to make
data-driven decisions. By using data to inform decision-making, organizations can
optimize their operations, improve efficiency, and achieve their goals more
effectively.
2. Competitive advantage:
3. Improved performance:
5. Risk management: Business analytics can help organizations identify and mitigate
risks by analyzing data and predicting potential outcomes. This can help businesses
make more informed decisions and reduce the likelihood of negative consequences.
1. Understanding Business Needs: Identify and comprehend the needs, challenges, and
goals of the business.
4. Data Analysis: Interpret and analyze data to provide insights for informed decision-
making.
5. Risk Assessment: Identify and assess potential risks to the success of projects or
business initiatives.
Page | 33
6. Solution Evaluation: Evaluate proposed solutions to ensure they align with business
requirements and objectives.
8. Change Management: Assess the impact of changes and develop strategies for
smooth implementation.
Page | 34
Step 1. Defining the business needs
The first stage in the business analytics process involves understanding what the business would
like to improve on or the problem it wants solved. Sometimes, the goal is broken down into
smaller goals. Relevant data needed to solve these business goals are decided upon by the
business stakeholders, business users with the domain knowledge and the business analyst. At
this stage, key questions such as, “what data is available”, “how can we use it”, “do we have
sufficient data” must be answered.
This stage involves cleaning the data, making computations for missing data, removing outliers,
and transforming combinations of variables to form new variables. Time series graphs are plotted
as they are able to indicate any patterns or outliers. The removal of outliers from the dataset is a
very important task as outliers often affect the accuracy of the model if they are allowed to
remain in the data set. As the saying goes: Garbage in, garbage out (GIGO)!
Once the data has been cleaned, the analyst will try to make better sense of the data. The analyst
will plot the data using scatter plots (to identify possible correlation or non-linearity). He will
visually check all possible slices of data and summarise the data using appropriate visualisation
and descriptive statistics (such as mean, standard deviation, range, mode, median) that will help
provide a basic understanding of the data. At this stage, the analyst is already looking for general
patterns and actionable insights that can be derived to achieve the business goal.
Page | 35
Step 3. Analyse the data
At this stage, using statistical analysis methods such as correlation analysis and hypothesis
testing, the analyst will find all factors that are related to the target variable. The analyst will also
perform simple regression analysis to see whether simple predictions can be made. In addition,
different groups are compared using different assumptions andthese are tested using hypothesis
testing. Often, it is at this stage that the data is cut, sliced and diced and different comparisons
are made while trying to derive actionable insights from the data.
Business analytics is about being proactive in decision making. At this stage, the analyst will
model the data using predictive techniques that include decision trees, neural networks and
logistic regression. These techniques will uncover insights and patterns that highlight
relationships and ‘hidden evidences’ of the most influential variables. The analyst will then
compare the predictive values with the actual values and compute the predictive errors. Usually,
several predictive models are ran and the best performing model selected based on model
accuracy and outcomes.
At this stage the analyst will apply the predictive model coefficients and outcomes to run ‘what-
if’ scenarios, using targets set by managers to determine the best solution, with the given
constraints and limitations. The analyst will select the optimal solution and model based on the
lowest error, management targets and his intuitive recognition of the model coefficients that are
most aligned to the organisation’s strategic goal.
The analyst will then make decisions and take action based on the derived insights from the
model and the organisational goals. An appropriate period of time after this action has been
taken, the outcome of the action is then measured.
Finally the results of the decision and action and the new insights derived from the model are
recorded and updated into the database. Information such as, ‘was the decision and action
effective?’, ‘how did the treatment group compare with the control group?’ and ‘what was the
return on investment?’ are uploaded into the database. The result is an evolving database that is
continuously updated as soon as new insights and knowledge are derived.
Page | 36
Business Analytics at YBI Foundation:
The organization uses analytics to optimize the allocation of resources such as funding,
mentorship, and staff time. By analyzing data from previous projects, YBI can identify
areas where resources have had the greatest impact and redirect efforts to areas where
more support is needed.
YBI provides tailored support to entrepreneurs based on their unique needs and
challenges. By analyzing data on business performance, financial health, and market
trends, YBI can create customized programs that offer relevant guidance and resources,
thereby improving the likelihood of long-term success for young business owners.
Page | 37
Current Business Analytics Practices:
YBI Foundation has started to incorporate data analytics into various aspects of its operations,
using it to make informed decisions that align with its mission. Below is an overview of the key
areas where business analytics is currently being implemented.
One of the foundation's primary uses of business analytics is in evaluating the effectiveness of its
entrepreneurship programs. Key metrics include:
Entrepreneurial success rates: This involves tracking the percentage of businesses that
remain operational after participating in YBI's programs. Data is collected on the survival
rate of businesses over specific time periods (e.g., 1 year, 3 years).
Revenue and profit growth: YBI assesses the financial performance of businesses post-
program, looking at both revenue generation and profitability.
Job creation and community impact: The organization tracks the number of new jobs
created by supported businesses, which helps demonstrate the broader social and
economic impact of the foundation’s work.
Analytics tools such as Power BI and Excel are used to visualize data trends, which inform
program adjustments and help communicate results to external stakeholders such as donors and
government bodies.
Donor engagement and fundraising are vital to YBI Foundation’s ability to support young
entrepreneurs. Business analytics is used to analyze donor behavior, retention rates, and patterns
of giving. Predictive models help forecast future funding opportunities by identifying trends and
profiling donors most likely to contribute based on past behavior.
By leveraging analytics, YBI can target fundraising campaigns more effectively, ensuring that
outreach efforts are directed toward high-value opportunities and improving donor satisfaction
through personalized communication.
Using financial analytics, YBI optimizes its budgetary allocations and resource deployment
across programs. By analyzing historical financial data, the foundation ensures that funds are
allocated to programs with the highest impact while maintaining operational efficiency.
Page | 38
Advanced forecasting models enable YBI to predict cash flow needs, anticipate potential
financial challenges, and adjust its strategies in real time.
1. Microsoft Excel:
A widely used tool for data collection, initial analysis, and basic financial modeling.
Excel helps the foundation in handling smaller datasets and running simple analytics on
program outcomes, donor data, and financial information.
2. Power BI:
YBI uses Power BI to create interactive dashboards and visualizations that allow
decision-makers to quickly analyze large amounts of data. This tool is particularly useful
in presenting program outcomes and financial data to stakeholders in an easy-to-
understand format.
3. Google Analytics:
YBI tracks website traffic and digital engagement metrics through Google Analytics.
This helps monitor the effectiveness of digital outreach campaigns and engagement
efforts, informing decisions related to marketing and program recruitment.
4. CRM Systems:
YBI leverages customer relationship management (CRM) tools to store and analyze data
on donors, mentors, and entrepreneurs. CRM analytics are used to track interactions,
measure engagement, and predict future behavior based on historical patterns.
Feedback from participants and stakeholders is gathered through surveys. This data is
analyzed to assess satisfaction levels, program effectiveness, and areas for improvement.
Page | 39
While YBI Foundation has made significant progress in adopting business analytics, several
challenges impede the organization’s ability to fully leverage data-driven decision-making:
1. Data Integration:
YBI collects data from multiple sources (e.g., surveys, CRM systems, financial records).
However, integrating these diverse data streams into a unified platform for analysis remains a
challenge. Currently, manual data processing is time-consuming and can lead to inconsistencies
in reporting. The lack of a comprehensive data integration system limits the depth of analysis and
hinders real-time decision-making.
While YBI’s staff has a solid foundation in basic data analysis, the organization lacks sufficient
expertise in advanced analytics, such as predictive modeling, machine learning, and artificial
intelligence (AI). Without these capabilities, YBI cannot fully unlock the potential of its data or
extract deeper insights from large datasets.
As a non-profit organization, YBI operates on limited budgets, which affects its ability to invest
in advanced analytics tools. While tools like Excel and Power BI are useful, more sophisticated
platforms (such as Tableau or cloud-based analytics solutions) could provide more powerful
insights. However, these platforms are often costly, making them difficult to access within
current budget constraints.
YBI handles sensitive data related to entrepreneurs, donors, and financial records. Ensuring the
privacy and security of this data is critical, particularly as the foundation expands its digital and
data-driven operations. Compliance with global data protection regulations (e.g., GDPR) is
essential to maintaining stakeholder trust and preventing data breaches.
Page | 40
1. Adoption of Advanced Analytics and AI:
By integrating AI and machine learning models into its analytics processes, YBI can move
beyond descriptive analytics to predictive and prescriptive analytics. Predictive models can help
the foundation forecast trends, donor behaviors, and the future needs of entrepreneurs.
Prescriptive analytics will enable YBI to develop actionable recommendations based on data
insights, improving decision-making processes across all levels of the organization.
The adoption of real-time analytics platforms will allow YBI to monitor the performance of its
programs in real-time. Access to live data will enable faster response times, allowing the
organization to make necessary adjustments to program delivery or resource allocation as
needed. This will improve program effectiveness and create more timely interventions for
entrepreneurs.
Cloud-based analytics platforms provide scalable and cost-effective solutions for data
management and processing. By moving to cloud-based platforms, YBI can streamline its
operations, improve data accessibility, and reduce infrastructure costs. Cloud platforms also
facilitate collaboration, allowing staff and stakeholders across different regions to access and
analyze data seamlessly.
Investing in advanced data visualization tools such as Tableau will allow YBI to communicate
complex data insights in an engaging and easy-to-understand manner. This will help the
foundation better demonstrate its impact to donors, government agencies, and other stakeholders,
ultimately increasing its ability to secure funding and support.
Questionnaire is important for any types of research. Questions are designed and asked to
respondents to extract specific information. It serves two basic purposes: to (1) collect the
appropriate data (2) make data comparable and amenable to analysis.
For preparing this report a questionnaire was prepared and 8 interns were interviewed. The
questionnaires are analyzed below:
Yes 8 100%
No 0 0%
Graphical Representation:
Page | 42
Chart Title
yes
no
100%
Interpretation:
From the graph, it is identified that all the respondents think that business analytics is
important for an organization.
Disagree 0 0%
Agree 3 37.5%
Strongly disagree 0 0%
Graphical Representation:
Page | 43
Chart Title
MARKETING FINANCE
PRODUCTION ALL OF THESE
Interpretation:
From the grapgh, it is identified that 5 respondents strongly think that business analytics should
be practiced in an organisation and 3 think also agree to this and noone denies that business
analytics
No 0 0%
Yes 8 100%
Graphical Representation:
Page | 44
Chart Title
yes no
Interpretation:
From the graph, it can be noticed that all the respondents think that business analytics
have a profound effect on a business whether it is sales or production or any activity of
the firm.
Marketing 1 12.5%
Finance 1 12.5%
Production 0 0%
Page | 45
All of these 6 75%
Graphical Representation:
Chart Title
13% MARKETING
13% FINANCE
PRODUCTION
ALL OF THESE
75%
Interpretation:
From the graph, it can be identified that most of the respondents think business analytics
can be used in all kinds of departments of a firm.
It shows the capability of business analytics to influence any department and that it is
very important for any department of a firm.
5. A company should have an entire department for business analytics.
Agree 3 37.5%
Page | 46
Disagree 0 0%
Strongly disagree 0 0%
Graphical Representation:
Chart Title
13%
13%
75%
Interpretation:
According to the graph, it can be understood that all the respondents think that their shall
be a department for the business analytics.
It shows the futuristic scope of business analytics.
No 0 0%
Page | 47
Yes 8 100%
Chart Title
120
100
80
60
40
20
0
yes no
Interpretation:
From the graph it can be understood that according to the respondents growth of an
organization is heavily affected by business analytics in a positive way.
Growth of a firm is not dependent on business analytics but it does help in making it
better.
Yes 8 100%
No 0 0%
Graphical Representation:
Page | 48
Chart Title
100%
50%
0%
yes no
Interpretation:
From the graph, it can be identified that with the help of business analytics a business can
tremendously increase the efficiency of the business firm.
It shows the importance of business analytics.
Disagree 0 0%
Agree 8 100%
Chart Title
disagree
agree
Interpretation:
According to the graph, it can be obtained that business should invest a normal amount
on the development and use of business analytics.
It will definitely show in the efficiency of management in making better decisions.
9. How does business analysis help a firm?
Page | 49
Particulars Respondent Percentage
Interpretation:
After studying the table it is clear that business analytics helps a business in many ways and
some of them are; helping the business to get to know their customers and satisfy them with their
requirements, by increasing efficiency of the firm, to find new ideas for
marketing/sales/production, etc.
Agree 4 50%
Disagree 2 25%
Page | 50
Graphical Representation:
Char t Title
50
40
30
20
10
0
disagree agree strongly agree strongly
disagree
Interpretation:
From the graph, it can be noticed that there are different views of people on AI affecting
business analytics. Some think it will become hindrance some doesn’t think that.
So, it can be concluded that if people use it to make their analysis better it will help them
but if it becomes too automated it will harm the people but the role of business analytics
will still be their if not the analyst.
11.Business analytics have a wide range of scope to be used in an organization.
Disagree 0 0%
Agree 8 100%
Graphical Representation:
Page | 51
Chart Title
disagree agree
Interpretation:
From the graph it can be identified that business analytics have a very wide range of
scope in the future or now such as, marketing, production, sales, finance, etc.
12. Do you think business analytics will have a great importance for a company
in the future?
Yes 8 100%
No 0 0%
Graphical Representation:
Page | 52
Chart Title
no
yes
0 10 20 30 40 50 60 70 80 90 100
Interpretation:
From the graph, it can be identified that all the respondents think and have a very positive
outlook on the future of business analytics.
Page | 53
CHAPTER 5
CONCLUSION
Focus on clean, accurate, and integrated data sources for better analysis.
Utilize tools like Power BI, Tableau, or Looker for dynamic reports and dashboards.
Use tools for real-time data processing to make quicker business decisions.
Reduce manual inputs errors and improve efficiency by automating data gathering
processes.
Page | 54
Promote data literacy across the organization through continuous training and education.
Tailor the cadence of reporting to match the decision-making needs of the business.
CONCLUSION:
The future of business analytics is set to undergo a remarkable evolution, fueled by rapid
advancements in technology and an ever-increasing emphasis on data-driven decision-making.
As organizations continue to generate vast amounts of data from various sources, the ability to
analyze and interpret this information effectively will be crucial for maintaining a competitive
edge.
Emerging technologies such as artificial intelligence (AI) and machine learning (ML) are
transforming the landscape of analytics, enabling businesses to uncover deeper insights and
trends that were previously inaccessible. These technologies facilitate predictive and prescriptive
analytics, allowing organizations to not only understand what has happened but also anticipate
future scenarios and make proactive decisions. Additionally, the rise of advanced visualization
Page | 55
tools enhances data interpretation, making complex datasets more comprehensible and actionable
for stakeholders at all levels.
To fully capitalize on the potential of business analytics, organizations must also invest in robust
data infrastructure. This includes implementing centralized data repositories that facilitate
seamless access to information across the enterprise, as well as ensuring data quality and
governance standards are upheld. By prioritizing these foundational elements, companies can
create an environment where data is not only abundant but also reliable and relevant.
Moreover, organizations must remain agile and responsive to emerging trends and technologies.
The analytics landscape is continually evolving, and companies that are proactive in adopting
innovative methods and frameworks will be better positioned to navigate the complexities of the
market. This adaptability will enable businesses to harness real-time insights, optimize their
operations, and enhance customer experiences.
Ultimately, the organizations that embrace the full potential of business analytics will not only
drive innovation and competitive advantage but also create sustainable growth in an increasingly
dynamic business environment. By aligning analytics strategies with overarching business goals
and fostering a culture of data-driven decision-making, companies can unlock new opportunities
for success in the years to come. As we move forward, the integration of advanced analytics into
core business practices will be essential for thriving in a world where data reigns supreme.
References:
Text Book
A text book on Business Research Methods, Author Dr. F.C. Sharma.
Class notes and Documents from DPGITM Library.
Bibliography:
https://www.google.com
www.wikepedia.com
http://www.geeksforgeeks.org
http://www.simplilearn.com
Appendix:
Survey Questionnaire
Name:
Sex:
Page | 57
Q: 1 Do you think business analytics is important for any company?
a) Yes
b) No
a) Disagree
b) Agree
c) Strongly agree
d) Strongly disagree
a) Disagree
b) Agree
c) Strongly agree
d) Strongly disagree
a) Marketing
b) Finance
c) Production
d) All of these
a) Disagree
b) Agree
c) Strongly agree
d) Strongly disagree
a) No
b) Yes
a) Agree
b) Disagree
a) Disagree
b) Agree
c) Strongly agree
d) Strongly disagree
a) Disagree
b) Agree
Q: 12 Do you think business analytics will have a great importance for a company in the future?
a) No
b) Yes
Page | 59
Page | 60