We are looking at some BI Platform, but probably won't have anything usable for the purpose until late 2008. So I hope to get some tips on using some more common software or websites for the immediate need.
Basically, I need to find a way for my team to effectively and efficiently create and analyze monthly progress reports for their products.
In addition to the data they have direct access to, each product manager will have to collect these data from marketing managers of 6-8 brands that sell their products. Data include quantitative like sales, profits, year-over-year growth; as well as qualitative like what promotion campaigns were carried out.
On top of that, once we have all these info for each product, I will have to compile/slice/dice the data to prepare for the director/VP level meeting with each of the brand.
We have about 20 key products and 13 brands. So it can be a lot of work. Ideally, I'd like each product manager & brand manager to enter their data into a web (internet or intranet) tool, and then have access to only the data that are relevant to them. (Some brands are direct competitors.)
As we are investing in a major BI tool, we don't want to spend money on a temporary solution. I am thinking about looking into what Survey Monkey and Microsoft Sharepoint can do.