So what have you accomplished so far? Is there a particular place that you are stuck?
If you need help getting started, check out this link for great resources: Tableau Training and Tutorials
Once you give it the old college try, post areas where you are stuck and I'm sure that we will be happy to lend a hand in your understanding of the tool.
Thank you for your response. I've given you access to my project workbook on Google drive here: https://drive.google.com/file/d/0B-KJ2gPFm4zMbG9TQjk0UEFaQzQ/view?usp=sharing
The data can be accessed here and I've given you access as well here: LaptopSales.zip - Google Drive
You are an expert in this area and I truly appreciate you taking time to encourage me and offer help.
I am available if you have a few minutes to talk on (240) 888-7534.
Here are my current issues:
- Parsing the text date field so it can be recognized as MM-DD-YYYY and discard the time segment as I don’t believe it’s needed
- Map the European postal codes with the stores and customers in the geographic visualization to detect specific locations
- Correlation of stores and customers
- Travel distances between customer and stores
- Mapping between configurations present in which stores
1 of 1 people found this helpful
Ok, Let's tackle things one at a time.
#1 - You'll need to build 4 calculations. Substring out the date in to it's parts with a combination of Left() and Right() functions. For the month, you will need to create a Case Statement to convert the 3 Char month into an Integer. the other two will need to be converted to Integer as well, but it's a bit more straight-forward. The final calculation with use the MAKEDATE() function which references the first three calcs.
Give it a try and see how you end up.
for UK Postal Code, you'll need to convert the postal codes from "XXX XXX" to the UK OutCode, which is the first 4. So use Replace() to rid the space from the postal code, and then left() to get the Outcode. You'll also need to got to Map on the menu bar, the Locations and change it to the UK.
...as an aside, the post codes change in the UK a bit, so some of these may need to be manually mapped, which can be done in the same location (Map>Locations)
The homework piles up...
Thank you Mark,
I will try your guidance after my next meeting (I'm working full time also while taking full course MBA load).