hi,

Im new to datawarehouse so bear with me please

I have done a data preparation for an Adult census in Access then imported into SQL 08. Now i need to do a Data analysis of it.

I have 10 dimension tables of the following: Age, CapitalGain, CapitalLoss, Education, Gender, HoursPerWeek, Inome, MaritalStatus, NativeCountry, Occupation, Race, Relationship, Workclass.

Fact Table: CensusFt and it has a measure call FinalWeight in it. Which is Sum(FinalWeight).

Im stuck on what to actually analyse? What would be a complex question to ask in this data for a census?

 i have to use one of the following tools to make a chart and graph out of it: SQL server reporting services, excel 2007, PowerPivot or Tableau. Which one its the most friendly use or really good to use?? power pivot i dont have office10 yet.

Thank you for trying to help