What is Descriptive Analytics?

What is Descriptive Analytics?

Descriptive Analytics

Descriptive analytics is one of the types of Business analytics also known as exploratory Analytics. Predictive and prescriptive are the other two types of analytics. In this article, I am going to explain descriptive analytics in-depth with a real-life use case.

Business Analytics is defined as the scientific process of transforming data into insights for making better decisions and predict the outcome for the business.

Any form of analytics starts with the collection of data and developing a model to summarize and create visual patterns for better understanding. However, the real magic of Business Analytics is its capability to predict and prescribe future course of actions by analyzing current and historical data patterns.

Types of Business Analytics

Business analytics can be categorized into four types, based on the depth of data analysis and the usage of that analysis.

  • Descriptive Analytics tells about “What is happening?” based on the available data. It provides real-time dashboards.
  • Diagnostics Analytics is used to discover or to determine “why something happened?”.
  • Predictive Analytics tells about “What is likely to happen?” based on the available data.
  • Prescriptive Analytics suggests decision options to handle “What is likely to happen?”

Business Intelligence (BI) was the earlier avatar of business analytics (data science) with limited capabilities to predict and to learn (machine learning).
BI used reporting tools like Hyperion, Business Objects to explore the historical data, analyze it and make sense of the same using slicing & dicing.
However, businesses today, are not looking at merely what’s been happening with my business or business initiatives but are also looking to know why, and other forward looking questions such as what if these trends continue, what will happen next, and what is the best/worst that can happen?

Descriptive Analytics

In this post, I am going to delve into descriptive analytics with examples. In my next posts (as time permits), I will talk about the other three types.
Descriptive analytics is the most basic form of analytics and lays the foundation for more advanced form of analytics. This type of analytics deals with “What has happened in the organization” and “what is happening now?”.
Every organization generates raw data in day-to-day transactions. For example, a car manufacturing company will generate data relating to inquiries made, actual sales, collections etc.
To make it even more staggering is the case of Facebook.
Facebook users generate content through posts, comments and picture uploads. This data is unstructured and is generated at a considerable rate.
Facebook statistics suggest that it processes 2.4 million posts per minute amounting to approx. 500 terabytes of data daily. These mind-boggling figures has given rise to the term “Big Data” and “Big Data Analytics”.  Some other post for “Big Data”!!
Making sense of the data in its raw format will be extremely difficult. This data has to be summarized, categorized and presented in a user-friendly manner to enable managers to understand and make sense of it.
Business Intelligence and data mining tools/techniques have been the de-facto mechanisms of doing so for larger organizations. But almost every organization does some form of summarization and MIS reporting using data base reporting tools or simply excel sheets.
Descriptive analytics is characterized by three key methods to summarize and describe the raw data:
Dashboards and MIS reporting: This method typically provide summarized data providing information on “What has happened”, “What’s been happening?” and “How does it compare with the plan?”
Ad-hoc reporting: This method supplements the previous method in helping the management in extracting information as required.
Drill-Down Reporting: This is the most complex part of descriptive analytics and provides the ability to dig deeper into any report to understand the data better. Typically summary data is drilled down to understand the transactional data. For example, Q4 All India sales figure for a product is a summary figure, which can be drilled down to look at the sales figures of each city or each region.

The case study description

Let’s take an example to understand it better. I will take the example of Google Analytics as I have been using it for my company to understand the flow of users, their demographics etc.
Let me first explain the use case.
Every company wants to have its online presence and so do we. Recently we have started online marketing using Google Paid Ads and Facebook. So, we would like to know the effectiveness of our campaigns on each channel as well as the effectiveness of our SEO campaign.

Deciphering the case study

Google provides a script based tracking mechanism, so you need to put that piece of code in every page you track.
So, every time a visitor comes to our website, Google script captures the page name, the referrer, demographics etc.
If the data is presented to me in the raw format, I would get overwhelmed with the large number of columns and rows. So Google analytics engine nicely summarizes this data for me.
In the image below, it shows me the number of visitor sessions on pages, I want to track.
What is descriptive Analytics?

When I drill down, it shows me the sources of traffic. Google Analytics categorizes the data into paid, non-paid, social etc categories, enabling me to understand the effect of each marketing effort/campaign.

What is descriptive Analytics?

If I now want to calculate the ROI of my campaigns, I further drill it down as shown in image below.

What is descriptive Analytics?

So, descriptive analytics enables an organization to make better sense of data, by providing summarization of data and the ability to drill down.

Data Analytics Courses Combo

About Techcanvass

Techcanvass offers IT certification courses for professionals. We are an IIBA endorsed education provider (EEP), iSQI Germany Authorized Training Partner.

We offer Business Analyst, Data Analytics and Domain Certification Courses in Banking, Payments, Trade Finance, Insurance and US Healthcare.

You can read many articles on Business Analysis and Data Analytics in this Business Analysis blog.


11 Comments. Leave new

  • There is certainly a great deal to learn about this issue. I like all the points you’ve made.

  • I simply wanted to develop a small comment in order to appreciate you for the amazing information you are placing here. My particularly long internet lookup has at the end of the day been compensated with reputable facts and techniques to talk about with my friends and family. I ‘d state that that most of us site visitors actually are undoubtedly fortunate to exist in a fabulous website with very many lovely professionals with insightful tricks. I feel very grateful to have discovered your web pages and look forward to many more fun times reading here. Thank you once again for a lot of things.

  • I have read several good stuff here. Definitely worth bookmarking for revisiting. I wonder how much effort you put to make such a great informative site.

  • Greetings from California! I’m bored at work so I decided to browse your website on my iphone during lunch break. I really like the knowledge you present here and can’t wait to take a look when I get home. I’m shocked at how fast your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyways, amazing site!

  • I just added this site to my feed reader, great stuff. Can not get enough!

  • I’m still learning from you, but I’m improving myself. I certainly enjoy reading all that is written on your website.Keep the information coming. I loved it!

  • I’m amazed, I must say. Rarely do I encounter a blog that’s both equally educative and engaging, and let me tell you, you’ve hit the nail on the head. The issue is something that too few people are speaking intelligently about. I am very happy I came across this in my hunt for something regarding this.

  • I think other web-site proprietors should take this site as an model, very clean and excellent user friendly style and design, let alone the content. You are an expert in this topic!

  • I’m extremely pleased to uncover this great site. I wanted to thank you for your time just for this fantastic read!! I definitely really liked every part of it and i also have you saved as a favorite to look at new information in your website.

  • You can definitely see your enthusiasm in the work you write. The world hopes for even more passionate writers like you who aren’t afraid to say how they believe. Always follow your heart.

  • Have you ever thought about including a little bit more than just your articles? I mean, what you say is valuable and everything. But think of if you added some great pictures or videos to give your posts more, “pop”! Your content is excellent but with images and clips, this site could undeniably be one of the best in its field. Superb blog!


Leave a Reply

Your email address will not be published.

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed