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

Complete Introduction to Excel Interactive Dashboards

9/12/2019

0 Comments

 
Excel is an amazing tool for analyzing data, but the challenge is understanding what your data is telling you.  A problem I find people regularly battle with is that when you start exploring different aspects it’s easy to end up with Analysis Paralysis and getting overwhelmed by how much information is available.  In this video I will show you to create powerful interactive dashboards using nothing complex, just simple drag and drop techniques, which will give you the big picture as well as the ability to filter and sort as needed.
Picture
Dashboards are the ideal tool for providing a high level overview of what is happening in the business, department, team or project and are traditionally made up of tables of data and graphs that can quickly and easily convey important information.
Before starting to set up a dashboard, you need to decide on your key metrics.  These are normally important totals that you want to share, for example, total sales, total profit or average profit per customer.  I suggest that the Key Metrics are bold and placed in the top right area of the dashboard as this is where most people will start viewing your dashboard. 
Picture
Visual elements are another important element of a dashboard as graphs convey a lot of information very simply.  A trend graph easily communicates the general trend of data, is the data moving up, down, stable or volatile? Line or area graphs are normally used to communicate trends.
Picture
Column and bar charts are used to communicate which items are highest or lowest.  These types of graphs provide an understanding of magnitude differences between items and are used to communicate comparisons.
Picture
Pie charts can be used to communicate percentage contribution to the whole.  It is easy to overcrowd a pie chart by using too many items - so the general rule of thumb is to keep the number of items down to no more than 5 to 7 items. 
Colour also plays an important role because they convey subconscious messages.  When designing dashboards, I suggest not using too many colours and to keep in mind the impact of the colours you choose (ie. green is associated with good and red is associated with bad).  My advise is to use use soft grays, browns or blues for backgrounds and bold colours for the key things you’d like to highlight.
Picture
A key point I’d like to bring your attention to, is that while I’m going through the processes of how to create an interactive dashboard in Excel using only Pivot Tables, Pivot Charts and Slicers, I never use complex formulas, VBA or macros.  Microsoft have really moved away from these complicated methods and made things simple for all Excel business users.

I hope you enjoy this video and if you are interested in learning more about creating interactive dashboards with Excel, please have a look at our on-site classroom courses and online or virtual courses.
0 Comments

    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