Data Visualization using MS Excel

2 min read

The ability to analyze data is a powerful skill that helps you make better decisions. When it comes to choosing a tool there are several options; however, the first one you think of, is Microsoft Excel. Why? It is a tool that is deep-rooted in almost every business and our day-to-day life. The extent of our dependence on it is such that "Export to Excel" is the most used option amongst BI communities. In terms of usage, there are over 750M Excel users worldwide and literally, any function in any organization/industry can benefit through the use of Microsoft Excel. Additionally, the ability to learn and quickly put it into practice gives you another reason to adopt it.

"I never guess, it is a shocking habit - destructive to the logical faculty" - Sherlock Holmes

Today, we live in an information-rich and time-poor world. Businesses have transformed from being intuitive to data-driven engines. Leaders crave data because they are aware of its availability. However, what they are looking for is not data, it is information and knowledge extracted out of it. The big problem though isn't data or too much of it. It's the lack of time and there just isn't enough of it to to analyze tons of data you have at your disposal. So, if your organization isn't using BI tools like Tableau or PowerBI and plan to use Microsoft Excel as a tool for data analyses this might be of your interest. 


Above is a quick piece of analysis done on the recently concluded India vs England Cricket Test Series. A simple export of scorecards for all the test matches and use of basic excel functions like IF, SUM, RANK, VLOOKUP, and OFFSET have been used to transform the data in a structured format. There are no VBA macros used anywhere in the analysis and the visualizations have been created by basic chart options available as a part of the default excel package. 

If you are an organization looking for analyzing your data and are struggling with it, feel free to reach out to us at sumeet.shah@incentius.com

Authors

  • Sumeet Shah

    Associate Director, Incentius

Recent Blogs

{ "id": 6, "name": "Marketing", "linkedin": null, "title": null, "blurb": null, "created_at": "2021-02-11T10:51:54.000Z", "updated_at": "2021-02-11T10:51:54.000Z", "slug": "Marketing", "published_at": "2021-02-11T10:51:54.000Z", "image": { "id": 377, "name": "marketing.png", "alternativeText": null, "caption": null, "width": 800, "height": 800, "formats": { "thumbnail": { "name": "thumbnail_marketing.png", "hash": "thumbnail_marketing_0372c0012a", "ext": ".png", "mime": "image/png", "width": 156, "height": 156, "size": 9.36, "path": null, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/thumbnail_marketing_0372c0012a.png" }, "medium": { "name": "medium_marketing.png", "hash": "medium_marketing_0372c0012a", "ext": ".png", "mime": "image/png", "width": 750, "height": 750, "size": 65.87, "path": null, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/medium_marketing_0372c0012a.png" }, "small": { "name": "small_marketing.png", "hash": "small_marketing_0372c0012a", "ext": ".png", "mime": "image/png", "width": 500, "height": 500, "size": 41.36, "path": null, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/small_marketing_0372c0012a.png" } }, "hash": "marketing_0372c0012a", "ext": ".png", "mime": "image/png", "size": 26.85, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/marketing_0372c0012a.png", "previewUrl": null, "provider": "aws-s3-iam", "provider_metadata": null, "created_at": "2021-02-11T10:52:04.000Z", "updated_at": "2021-02-11T10:52:04.000Z" } }

Marketing

9 min read
{ "id": 6, "name": "Marketing", "linkedin": null, "title": null, "blurb": null, "created_at": "2021-02-11T10:51:54.000Z", "updated_at": "2021-02-11T10:51:54.000Z", "slug": "Marketing", "published_at": "2021-02-11T10:51:54.000Z", "image": { "id": 377, "name": "marketing.png", "alternativeText": null, "caption": null, "width": 800, "height": 800, "formats": { "thumbnail": { "name": "thumbnail_marketing.png", "hash": "thumbnail_marketing_0372c0012a", "ext": ".png", "mime": "image/png", "width": 156, "height": 156, "size": 9.36, "path": null, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/thumbnail_marketing_0372c0012a.png" }, "medium": { "name": "medium_marketing.png", "hash": "medium_marketing_0372c0012a", "ext": ".png", "mime": "image/png", "width": 750, "height": 750, "size": 65.87, "path": null, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/medium_marketing_0372c0012a.png" }, "small": { "name": "small_marketing.png", "hash": "small_marketing_0372c0012a", "ext": ".png", "mime": "image/png", "width": 500, "height": 500, "size": 41.36, "path": null, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/small_marketing_0372c0012a.png" } }, "hash": "marketing_0372c0012a", "ext": ".png", "mime": "image/png", "size": 26.85, "url": "https://incentius-website-v2021-images.s3.amazonaws.com/marketing_0372c0012a.png", "previewUrl": null, "provider": "aws-s3-iam", "provider_metadata": null, "created_at": "2021-02-11T10:52:04.000Z", "updated_at": "2021-02-11T10:52:04.000Z" } }

Marketing

7 min read