Data Warehousing Community Forum
February 09, 2012, 12:20:15 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Data Analyzing help  (Read 735 times)
ludasky
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: May 11, 2010, 03:25:08 pm »
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
Logged
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: May 14, 2010, 10:26:53 am »
Quote from: ludasky on May 11, 2010, 03:25:08 pm
Im stuck on what to actually analyse? What would be a complex question to ask in this data for a census?
What you seem to be interested in is called Data Mining.

Looking at the list of dimensions you have, there seems to be a lot of scope for interesting data trends to be found.

This should point you in the right direction - http://www.microsoft.com/sqlserver/2008/en/us/data-mining.aspx
Logged
If most people said what’s on their minds, they’d be speechless.
kgc1183
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« Reply #2 on: June 03, 2010, 06:38:21 pm »
I think since you are very new to BI lets start with Excel its the most famous tool.

Get the data in Excel and start creating different chart. First get the requirement from end user.
Logged
Kuldeep

Data Warehousing and Bi are the next in thing in IT
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: