Act Now: Discover one new and useful thing from familiar data

We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost.

Act Now is a new idea I am trying. It asks you to do some activity and post the results.

image

Photo credit: Machine Project / Foter / CC BY-NC-SA

The first activity is to find at least one really useful information from data which you have been using routinely. How to do it? You can use one or more of the following ideas to discover more about your own data. For each activity relevant references are given.

  1. Try all options in Show Values As on items in data area
  2. Group text data in various ways in Pivot Table
  3. If there is any type of locational information in the data (city, country, lat / long) use Power Map (or Power View) to create a map based upon your data
  4. Use Quick Analysis feature of Excel to view the data in different ways
  5. Use Recommended Charts option to view different representations of the data
  6. Try using the same data but across a much longer period of time.
    For example, if you regularly deal with monthly data, combine two years of data and analyze it. Usually we could not do this due to the 1 million row limitation of Excel sheets. Now, with Power Pivot Data Model, there is no such limit.
  7. Use Sparklines to check the pattern of fluctuations
  8. Use Distinct Count instead of Count in Data Model based Pivot Tables (Power Pivot)
  9. Data contains many columns. Some of these columns have never been added to Pivot Tables. Add them and explore.
  10. Use Average or Standard Deviation instead of Sum

Post your result as comments. Let everyone learn from your experience. Enjoy!

2 thoughts on “Act Now: Discover one new and useful thing from familiar data

  1. Pingback: Knowledge Pack: Data Analytics | Efficiency 365

  2. Pingback: Quality Management 3: Run Charts | Efficiency 365

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s