Analyzing and Visualizing Sales & Marketing Data – Part 1: Intro

Through a series of posts, I will be using the data of a fictitious company called VanArsdel Ltd. to illustrate how you can use the different Microsoft BI tools with business-oriented data, reports and dashboards.

Throughout the series, I will be using Excel to collect and organize the data from different sources (will be Access DB in this case), use PowerPivot to build the data model and finally use Power BI to visualize and further explore the data.

This is real data from obviEnce (www.obvience.com) that has been anonymized and it is being used by Microsoft for learning purposes. You can download the data from this link.  

From this data, the insights we will capture includes (but not limited to):

1. Sales volume of this year and past year
2. Market share and fluctuations over time
3. Sentiment and sentiment gap
4. Total units sold per segment and per region
5. Biggest competitors
6. Business per region

 
Not excited yet? Ok, so let me give you a sneak peek of what the final dashboard would look like: ​

​Interesting, right? Now buckle up because you are about to get your head blown. Stay tuned for the next part.