Dashboard Link A Current Technology Usage tab containing: Top 10 Languages Top 10 Databases Platforms Top 10 WebFrames A Future Technology Trends tab containing: Top 10 Languages desired for the next year Top 10 Databases desired for the next year Desired platforms for the next year Top 10 WebFrames desired for the next year A … Read more
Dashboard is based on Customer Loyalty Program data. Following KPI’s as displayed Product Sales Total quantity sold Total revenue generated Product line performance by year Customer Response Revenue and quantity sold by location Marketing response by department Customer lifetime value and quantity sold by city Department sales by loyalty status Product & Location based analysis … Read more
Sample data Solution Step 1: Create user defined funtion CREATE FUNCTION [removeHTML] (@HTMLText VARCHAR(MAX))RETURNS VARCHAR(MAX)ASBEGINDECLARE @Start INTDECLARE @End INTDECLARE @Length INTSET @Start = CHARINDEX(‘<‘,@HTMLText) SET @End = CHARINDEX(‘>’,@HTMLText,CHARINDEX(‘<‘,@HTMLText)) SET @Length = (@End – @Start) + 1 WHILE @Start > 0AND @End > 0AND @Length > 0BEGINSET @HTMLText = STUFF(@HTMLText,@Start,@Length,”)SET @Start = CHARINDEX(‘<‘,@HTMLText) SET @End = … Read more
How to setup and configure a relatively simple dashboard in Excel, which will help you tell a story about the data.
This type of chart is the most common as they are easy to create and are great for comparing related data sets or parts of a whole.
This type of chart can show the breakdown of an entity into its sub-parts and the proportion of the subparts in relation to one another. Each portion of the pie represents a static value or category, and the sum of all categories is equal to a 100 percent.
A line chart is a great way to display the information. They are able to display trends and show how a data value is changing in relation to a continuous variable. For example, if time is a continuous variable, how has the sale of a product or multiple products changed?