Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in November, I have asked you to visualize sales data using sample data. The visualization challenge #2, sponsored by Zoho Reports generated a huge buzz around the community and fetched 32 incredible entries. The response was so overwhelming that it took me almost 24 hours to write this post. Thanks everyone for participating and making this a huge learning experience for everyone. Personally I have learned several useful dashboard and charting tricks. I will be sharing some of these lessons with all of you in the coming weeks.
Grouping Dates in Pivot Tables
Do you know you can group dates in pivot tables to show the report by week, month or quarter? I have learned this trick while doing analysis on a pivot table today. In this online lesson on pivot tables, I will teach you how to group dates in pivot tables to analyze the data by month, week, quarter or hour of day.
Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]
Here is a challenge many people face. How to make a chart visualizing sales data with several dimensions like product, brand, region, sales person name, year (or month or quarter) and one or two values like sales, # of units sold, profits, # of new customers.
In visualization challenge #2, all you have to do is a make a chart or dashboard to visualize this sales data effectively.
Product Recommendation – Excel Lookup Toolbox
Anyone working on the data using excel will know the importance of lookup formulas. They are vital for making almost any spreadsheet or dashboard. That is why when my friend John Franco, who maintains Excel-Spreadsheet-Authors.com, wrote to me about his new book Excel lookup toolbox I was truly excited. In this post I am going to share my review of this product.
Another Reason why Tables are so awesome [quick tip]
Ever since I have learned the tables feature in Excel 2007, I have fallen in love with that. They are so awesome and so user friendly.
Here is a simple, yet very effective feature of Excel Tables that will show table header row even when you scroll down. The header row is shown in the place of column headings (the place where you see A,B,C,D etc.).
One more method to find unique values in excel and you can call me a dork
Use Excel Pivot tables to find and extract unique items in your data. This method is very fast and easily scalable.
The New Poor – Internet Penetration Rates by Country
Yesterday is Blog Action day and tons of bloggers posted about single topic – poverty. It is a topic very close to my heart for various reasons. It is a very sad thing not to have food or shelter or healthy living conditions. But man has thrived in all those situations just because he learned […]