There Is No Point Talking About YOY / MOM If You Cannot Easily Create Them
Kyligence Zen supports self-service YOY/MOM analysis
May, a business team analyst, needs to run a month-on-month analysis of the company’s net profit. But if she turns to her data developer to develop new metrics, it will take about 1–2 weeks for approval and development. Since the basic metric of net profit has already been created, May decided to try the graphical interface of Kyligence Zen and create the MOM of net profit by herself.
Thanks to the low-code graphical metrics development and management environment of Kyligence Zen, data analysis is no longer the patent of a few data engineers, but a self-service data analysis activity that enables everyone to participate. In the following section, May will show you how to perform self-service creation of the ‘YOY/MOM of net profit’ metric by using Kyligence Zen without needing help from a data engineer.
The datasets and templates used in this article are now available on the Kyligence Zen Metrics template marketplace. Try it now.
Self-service creation of year-on-year metrics
Step 1: Tim, a Data Engineer, has created the core metrics including the basic metrics of net profit
May, a business analyst, entered Kyligence Zen’s metrics catalog to search and view the basic metric of “net profit”. Information about the metric is as follows:
Step 2: Business Analyst May performs self-service defining of year-on-year derived metrics
Based on the chart below, we know that net profit is a basic metric, and the year-on-year and month-on-month of net profit are both derived metrics based on this net profit. May, a business analyst, does not need to worry about the complicated technical details of year-on-year metrics when creating them. She can create derived metrics effortlessly by setting only a few relevant metric attributes (Derivation Type, Computation Interval, and Time Granularity).
Step 3: Business Analyst May performs business analytics with MOM and YOY Net Profit Metrics
Creating metrics is not the ultimate goal of May’s analytics. After the above second step, business analyst May has easily defined the metrics of MOM and YOY of net profit through self-service. May can finally use these metrics for her business analytics.
She wants to correlate metrics to the company’s business goals, so that they can actually drive the company’s business growth. Therefore, May created the goals for Net Profit, YOY of Net Profit and MOM of Net Profit with the Goal module of Kyligence Zen. Finally, the management team can clearly see the current revenue status of the enterprise by comparing the target value and the value of the Net Profit, YOY/MOM of Net Profit metrics, and adjust their business strategy accordingly.
Experience Kyligence Zen Now
The datasets and templates used in this article are now available on the Kyligence Zen Metrics template marketplace. Try it now.
Note 1: The dataset is from Kaggle, with Mohamed Harris as author. Some columns of the data used in this article are adjusted on the basis of the original dataset.