Renault Group Data Analysis: A System Proposal Report

This report presents a data analytics system proposal for the Renault Group, a French automobile manufacturer, addressing its challenges and focusing on improving decision-making through effective data management. It covers a comprehensive analysis of the company's background, including both quantitative and qualitative research, to identify key issues such as declining market share, reduced consumer spending, and production downtime. The report outlines various roles within a business intelligence system, emphasizing the importance of data analysts and IT departments, and discusses relevant metrics aligned with the company's corporate strategy, utilizing a balanced scorecard approach. Furthermore, it explores different types of data analysis, including descriptive, diagnostic, and predictive analytics, supported by mathematical derivations and visualizations to enhance user experience. The ultimate goal of the proposed system is to provide actionable insights that align with Renault Group's mission and vision, ensuring its long-term stability and success in a competitive market. Desklib provides access to this and other solved assignments for students.

Data Analytics –
System Proposal Report

Table of Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY...................................................................................................................................4
Analysis of the information along with Quantity and quality of background research..........4
Provide the list of roles which are covered under specification.............................................5
Discuss about the metrics and its explanation in context to the corporate strategy...............6
Span of the types of analysis being used................................................................................8
Mathematical derivation correctness and aggregation...........................................................9
Specialisation in Visualisation and user experience.............................................................10
CONCLUSION..............................................................................................................................11
REFERENCES..............................................................................................................................12

INTRODUCTION
Data can be defined as an aspect that plays a very important role in increasing the
trustworthiness and time management of decision-making process of company. At present, the
level of competition has leveraged to very high extent and this requires proper management of
data in order to accomplish goals of organisation (Dey, Hassanien, and et.al., 2018). The report
is based on Renault group. It is a France based auto mobile manufacturing company which has
faced depression. The system proposal technique is used for providing the information to the
management so that they can have significant data for taking efficient decisions .
Mission:
Company is focusing on bringing people together and closer to one another by moving
whole furniture together with the help of its innovative spirit. They believe in such type of
strategy for success that gives respect to everyone and along with this, it is also sensitive and
responsible.
Vision:
The most important vision of Renault group is to re-explore the upcoming mobility and
transportation system. They are focussing on new vehicles, conducting experiments and
enhancing partnerships so that it can generate mobility. It is looking forward to electronic ZOE
cab vehicles as a part of its project. The firm is looking forward to sketch out easy to live
mobility should be available to all (Dartmann, Song, and Schmeink, 2019).
The target of system is to generate an output that holds power to provide value to firm so
that the mission and vision of organisation can be achieved properly and with efficiency. It can
be done by looking at information and its structure for making futuristic and present decision in
a strategic format. Its scope in this high competition situation is big and allows company to keep
its focus on preparation and follow an appropriate strategy for all its sections of firm. This helps
in smooth functioning of these departments. This report will consist of background of research,
list of roles, analysis of information, visualization, metrics in relationship to corporate strategy
and user experience specification.
MAIN BODY
Analysis of the information along with Quantity and quality of background research
Methodology

It deals with evaluation of project in context of examination of sources of data received
and the methods of derivation. The current project will design and create a methodology to
achieve key information for achieving target of report. It is based on both a qualitative and a
quantitative nature so that deep insights can be obtained to meet specific needs. The dashboard is
created with reference to quantitative research with reference to annual reports and other sources.
Quantitative research uses numerical data so that it can be properly interpreted to evaluate
financial data. Qualitative research is linked with acquisition of theoretical information so that a
significant skill for knowledge development can be enabled. This can be useful in developing an
appropriate approach to system dashboard to, in turn, have accurate information for making
decisions by a particular organization. A number of articles, magazines, etc. are referred to for
this purpose (Novak, Bennett, and Kliestik, 2021).
Background of research
The company's background on quality research can be stated that Renault group is a
multinational organizations that has a market share of around 30% in the industry. The business
has faced a decline in market share due to a number of factors. In order to be successful with a
number of actions that are considered by particular firm to improve performance. The main
reason identified in evaluation is reduced consumer spending and production downtime due to
coronavirus pandemic. There are a various competitors who are also influencing the processing
of Renault group such as Renault group, Royal Enfield brands and many more (Liu, and et.al.,
2020).
In qualitative assessment, it could be it can be analysed that there are various
components with which performance of Renault group can be assessed. The operational profits
of organization has decreased in 2020 when compared to year 2018 & 2019. The net profitability
trend according to annual report is also decreasing, which is a negative sign of development.
Earnings per share are also experiencing a declining pattern, which can adversely affect investor
decision-making. The company's financial position in current year is not very effective compared
to previous year. On this basis, it can be determined that liquidity increases as liabilities increase.
On this basis, it can be determined that there is a lack of effectiveness in overall governance of
organization that needs to be improved in order to achieve significant processing. Through the
qualitative and qualitative performance of company it can be ascertained that business must
improve its overall performance in order to have stability in market (Zhao, and Hu, 2019).

Renault group is following the functional organisational structure. It is used by firm in
order to manage work properly by dividing it among various organisations and functions.
Provide the list of roles which are covered under specification.
Business insight is connected with method and specialized foundation that is liable for
gathering, putting away, assessment of information so appropriate choice can be made. There are
a few destinations which can be refined by suing business insight in authoritative exercises. BIS
is an urgent framework that is profoundly utilized by number of clients so that suitable degree of
data to meet capacity to arrive at authoritative beneficial position can become conceivable
(Leung, and et.al., 2021). The jobs include information expert, progressed business clients, IT
division, and so forth. In the flow period, statistical surveying with assistance of BIS is applied
viably so higher productivity can be determined.

The jobs contain information obtaining, examining, situational mindfulness, hazard
evaluation, choice help, and so on A successful execution of business insight process allows
clients to get experiences in regards to information on clients, driving execution and income,
recognizable proof of leads, deals patterns, advantages of offering deals patterns, working on
functional productivity, and so on Likewise, it tends to be deciphered that hierarchical target with
assistance of satisfying these jobs help in getting upper hands. It upholds dynamic course of
referenced venture so profundity capacity to meet hierarchical goals by making method
expedient and proficient. Information investigator, IT division, and so on impacts BIS which
sway the working of association (Hammou, Lahcen, and Mouline, 2020).
Discuss about the metrics and its explanation in context to corporate strategy.
For the organization to get fruitful, it is vital that legitimate business methodology is
being followed. The explanation relating to truth of matter is that on off chance that systems of
business won't be followed then this will be influencing general working of organization. In this
way, for Renault group it is extremely significant that legitimate technique is being set and is
continued in a similar way. This is important in light of fact that on off chance that procedures
are not being continued in same way then this will be influencing functioning effectiveness and
achievement of business generally. There are various techniques through which procedures can
be set in legitimate way. For this, Renault group embraces utilization of adjusted scorecard to set
systems for all division. The utilization of adjusted scorecard will help organization in setting
destinations for every component of this model. Henceforth, this will bring about better and
successful checking and working of organization and accomplishing destinations of business
(Galetsi, and Katsaliaki, 2020).
The reasonable scorecard of Renault group incorporates four unique components. These
component includes monetary, client, inward cycle and learning. For Renault group, to get
fruitful, it is essential that this multitude of components are being set to keep up with working in
better and compelling way. As for financials significant objective of Renault group is to endure
effectively that is to procure normal pay to work in better and compelling way. This is essential
for explanation that in event that Renault group won't have consistent income then they won't be
ready to work in better and viable way.
Further as for customer's point of view, objective of Renault group is to attempt to build
quantity of purchaser habitually. The explanation relating to truth of matter is that on off chance

that customer number won't be expanding then this will be influencing benefit of business. Thus,
it is vital that all the working of organization should be coordinated towards expanding quantity
of purchaser and their advantage towards organization and its items (Zeng, Tim, Yu, and Liu,
2020).
Moreover, for the point of view of interior business, organization should lay out
objectives based on the inner workplace. This includes dealing with every one of inside divisions
to guarantee that appropriate working is being guaranteed. Consequently, for this, Renault group
has set targets for every single office that is creation, activity, finance, promoting, deals and
numerous different divisions fundamental for effective running of business.
At the end come the advancement and learning point of view of adjusted scorecard. This
is important to be taken into account in light of fact that business exist in outside climate and
various changes are being occurring. Consequently, it is extremely significant for Renault group
that this large number of most recent changes and development are being educated in better and
successful way. The explanation hidden this reality is that in event that preparation connecting
with new components and changes won't be done then this will be influencing functioning
proficiency and level of information on representatives. Hence, for this, Renault group has set
goal of exploring market consistently so any of change can be investigated and legitimate
preparing can be given to representatives working (Kushwaha, Kumar, and Kar, 2021).
Alongside the balanced scorecard, it is additionally important for organization to likewise
embrace the utilization of various key instruments too. This is fundamental to work on the
functioning effectiveness of business. henceforth, for this, Renault group likewise embraces the
utilization of KPI which is Key Performance Indicator. This method is being utilized to
investigate and assess exhibition based on some marker. This may include diverse component
like benefit, deals, return on value, value income proportion and numerous other various
markers. The utilization of KPI is assistive to Renault group as this aides organization in working
and keeping up with work in course of meeting the marker.
Span of the types of analysis being used.
Descriptive analytics
This is a strategy for examination which helps organization in investigating the current
business working by breaking down the past information and execution. This strategy is simpler
for the firm to use to assess the exhibition of the company. Renault group likewise embraces the

utilization of elucidating insights to assess the previous presentation of the organization to
examine the current and future working (Nicolaescu, and et.al., 2020).
Year Operating income Net income
2018 2987 3451
2019 2105 19
2020 -1999 -8046
Mean 1031 -1525.34
Median 2105 19
Standard deviation 2172.58 4818.99
Diagnostic analytics
This techniques helps the firm examining the way that what occurred by reviewing the
results of descriptive measurements. This is helpful to business in assessing the way in which
this measurement is laying out and the manner it tends to be utilized by Renault group (Leung,
Jiang, Poon, and Crevier, 2018).
Predictive analytics
With the help of this method, Renault group involves all the results of the three analysis
and then take its decision. So, there are various kinds of techniques that could be used with a
perspective of analysing and examining the complete performance (Alshaikh, and et.al., 2019).

Mathematical derivation correctness and aggregation
Looking at the position of the organization numerically is vital for the organization. This
is essential for the explanation that when the issue and issues of the organization will be clarified
in quantitative terms then it will be a lot more straightforward for the organization to take choice.
The explanation fundamental this reality is that on the off chance that the organization will have
low benefit then this issue can't be settled in appropriate way as there isn't a particular viewpoint.
Then again, in the event that it is informed that the organization is experiencing 30 % misfortune
in contrast with past year then it will be more straightforward for organization to foster a portion
of the methodologies through which the asset can be overseen in appropriate and powerful way
(Verma, Malhotra, and Singh, 2020).
Accordingly, for the compelling investigation of the presentation of the organization it is
extremely fundamental that Renault group attempts the diverse numerical activity and
accumulation to assess the working in better and powerful way. These computations will help the
organization in reviewing the way that how the organization is performing and what procedures
can be applied to work on the working. Along these lines, there are various techniques with the
help of which the organization can examine and work out its exhibition.
Particular Formula 2018 2019 2020
Operating income 2987 2105 -1999
Net income 3451 19 -8046
Sales 57419 55537 43474
Operating profit margin
OP/ sales *
100 5.20% 3.79% -4.60%
Net profit margin
NP/ sales *
100 6.01% 0.03% -1850.76%
Thus, from the above calculations, it can be said that the income of the company has
reduced with a great speed. In year 2020, the firm is not earning any profits and is showing the
downfall of the company. So, this collection of data can help the firm in taking decision for
improving the profits if the business. Thus, it is very much clear from the data that the sales of
the firm is decreasing continuously. But looking at the operating and net income the revenue of
the business has reduced to the great extent. So, the business should try to manage its costs. The
income of the business has reduced because of increase in the expenses and shortening of the
sales due to pandemic (Kang, and et.al, 2018).

Specialisation in Visualisation and user experience
With the examination of the dashboard obviously the exhibition of the organization is
lessening. This isn't really great for the organization as the benefits of the organization is
diminishing and this isn't good for the company. Consequently, with the assistance of the
dashboard it is obvious that the complete deals are diminishing later each year. This is plainly
clear from the business part of dashboard that the income is coming from one unique sources that
is sales of automobiles. The all out income in the year 2018 was 57419 and it is decreasing step
by step and in 2020 it was 43474. this essentially infers that deals of automobiles are decreasing.
So, it is prudent that the business should focus on increasing its sales.
Further with assistance of the monetary perspective plainly benefit of the organization is
diminishing exceptionally quick. As obvious from the dashboard plainly the working pay and net
gain of the organization is consistently diminishing. In any case, in the year, 2020 there was an
intense decrease inside the benefit of the organization. this may be a direct result of the
explanation that the deals of organization are decreased. Be that as it may, then again, the
decrease in the benefits of the organization was exceptionally colossal. In 2020 the operating loss
was 1999 which was before 2987 in year 2018. along these lines, for this it is prudent to Renault
group that they should attempt to diminish their costs so the benefits of the organization might
increment. Besides, it is likewise clear to the organization that they should investigate the
methodologies of their rivals so they can successfully make their own techniques (Pramanik and
et.al., 2017).
Further, when the region shrewd deals examination was done than it was apparent that in
the year 2020 the deals in each area has declined. This isn't by any means great for the
organization as the benefit of the organization is diminishing. Thus, it is fitting to the
organization that they should attempt to put some sum in advertising of the item and
administrations. The explanation fundamental this reality is that on the off chance that the
promoting won't be great then purchaser won't be drawn in towards the organization. thus, it is
important for Renault group that they should zero in on viable advertising systems like utilization
of web-based media and other computerized stages.
Dashboard design
1. Sales Dashboard

The report demanded by the director of sales is mostly based on taking a deep look at the profits
and revenue along with the performance of the department for acquiring new customers. This is
done by distributing the complete sales into areas and as per the salesperson. With the help of
these measures, the sales Director of the company would be able to generate following
information.
 Ascertains if the section is able to meet the target set by the organisation in relation to
the revenue and profits.
 Monitor the performance of the sales person against the preset goals.
 Determine the sign-up rate of new clients.
 Make sure that the profit margin is properly regulated.
 Make use of data related to the productivity of the sales man for designing new
rewards in the form of incentives.
The attribute is not providing accurate results and are weak thus, would not be used in the
sales dashboard.
Metric Dimensions
Metric Group by options Data source options Chart element
options
Revenue -Time
-Salesperson
-Region
-Revenue
-Profit
-Revenue Target
-Profit Target
Profit -Time
-Salesperson
-Region
-Revenue
-Profit
-Revenue Target
-Profit Target
-Profit Margin
Salesperson
Performance
-Salesperson -Salesperson Revenue
-Salesperson Profit
-Salesperson Revenue
Target
-Salesperson Profit
Target
Customer Acquisition -Time -Customer acquisition -Customer acquisition

-Salesperson
-Region
count target
Deviation of Metrics
Description Derivation
Revenue Sum of sales value
Cost of Sales Sum of purchases directly attributed to sales
e.g. purchased stock
Profit Sum of Revenue less Cost of Sales
Profit Margin Sum of Profit divided by Sum of Revenue,
expressed as a percentage
Customer Acquisition Count Count of customers placing their first order in
the Sales database
Salesperson Revenue Sum of Revenue attributed to each Salesperson
Salesperson Profit Sum of Profit attributed to each Salesperson
Revenue Target
Entered manually
Profit Target
Salesperson Revenue Target
Salesperson Profit Target
Customer Acquisition Target
2. Finance Dashboard
It shows the position of present financial position of the organisation. Here the ficus is in
the accounts receivable so that the company can make minimize the number of invoices
outstanding. The company demands a snapshot of all the resources for getting information about
the company. It has viewed an increase in the cost incurred on employees. This dashboard will
assist in the ascertaining the place where the cost of company is increasing.