DATA INSIGHT TRAINING
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog

Key data analysis skills you should learn (Part 2)

1/7/2019

0 Comments

 
The next types of analysis I'm going to focus on are Key Metrics and Ranking Analysis.

Key Metrics
Key metrics displays one key piece of information prominently (examples include total sales, total profit or total number of customers) and by using ratios you can get deeper insight and more information from your key metrics.  For example we could create key metrics for displaying the profit ratio (which is the total profit divided by total sales) where the  profit ratio is displayed as a percentage, this makes it easier to see what portion of your sales is profit.

Another ratio that can be calculated is the average sale per customer or the average profit per customer.  In this case you would divide the total sales by the number of customers and the total profit by the number of customers, so by using three key metrics you have now created three new key metrics using ratios which gives further insight into your data.

Ranking Analysis
Ranking analysis is about understanding the top/bottom values within a range.  The simplest form of ranking is to do a sort from highest to lowest or lowest to highest but there are many more rankings that can be done.

Top 10 or bottom 10 is one of the common method of analysis to highlight the items that are contributing the highest or lowest within your data set.  Filtering your items to only show the top 5, 10 or 20 makes it easier for you or your audience to view the most important items in a table, rather than displaying a long list of items.  A top 10 or bottom 10 analysis can also be combined with your column or bar graphs to restrict the number of items that are displayed in the graph.
You can also use a top/bottom percentage filter, in other words limiting the list of items to the top 20% or bottom 20% and this again easily allows your audience to focus in on the key values within the data set.
0 Comments



Leave a Reply.

    Categories

    All
    Business Data Analysis
    Complete Introduction To
    Coronavirus
    Data Skills
    DAX
    Excel Dashboards
    Excel Formulas
    Gartner Report
    Inspiration & Motivation
    Pivot Tables
    Power BI
    Power BI Desktop
    Power BI Query Editor
    Power BI Services
    Power Map
    Power Pivot
    Power Query
    Power View
    Tables & Reports

    Archives

    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

Privacy Policy
Copyright datainsighttraining.com
info@datainsighttraining.com
+44 330 223 5910
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog