How do you find relationships in data to make business decisions?

CRM software is right for this application?

[kieranmullen]

This is from a friend of mine. I take photos, he installs windows. Different business. I was looking at different CRM applications that were out there sugar etc just started so go easy on me. But from his request he wants to FIND relationships in his data to make better business decisions. Any ideas?

---him
Do you know of a good map program where i can add things like jobs that we've done, and then categorize them by date, type, amount, etc. and then search through it and give me results based on the attributes that i input. i've looked at google maps, but it doesn't have any search features by attributes that i know of. it would be a good tool for us, so we can figure out where to market and view any type of "trends" that may come up. I'm still looking myself, but i was just wondering if you knew of a program that does the things that i previously mentioned (off the top of your head).
---

[bill]

How do you have the data now?
It sounds like you just need to sort the data in different ways. You lost me a bit there talking about CRM and Google Maps. Some people can sort this type of data in an Excel spreadsheet. I guess it would be dependent on what sort of data was currently available.

[explorador]

I can only think on the windows business -> geographical tendencies, having a record of the installed windows, plus the date, and weather, and also the conditions of the place (forest, garden, and such) you might have a hotspot on a map.

Don't know about the full capabilities of Google Earth, I had a subscription and was ok. I found Ozi and GPS TrackMaker more powerful (but lacking the nice pictures feature) Those programs allow you to add comments and diff data plus having a search function.

I would even record the coordinates via GPS to add the altitude to the profiles.

Remember, weather can make you change, add or remodel windows and weather changes with time and altitude. Usually, the weather can wear out more quickly a window in a region so the neighbors are likely to become your clients (in that region).

On the photography thing I guess its an option to track the RELIGION of your clientes as some celebrations are related to dates.

Ok, enough for me, time to go to sleep... hard day today.