Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Help a complete noob with a project Expand / Collapse
Author
Message
Posted Friday, May 2, 2014 8:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
Points: 29, Visits: 89
EDIT: I found some data from NCES about Public University Libraries.

I am trying to define measures for building the warehouse? I like this data but i am trying to figure out how to use this with other libraries. Any ideas on the measures. I know its supposed to be quanitfiable and numberical generally.

I am also trying to determine what elements to use a predictable in analysis.
If someone could look at it and give me some advice i would appreciate it.



For measures i was thinking about using currency (dollars), and fiscal year.
Post #1567050
Posted Friday, May 2, 2014 9:31 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 339, Visits: 3,307
I'd start here to get a very good "In A Nutshell" overview.
http://www.kimballgroup.com/1997/08/02/a-dimensional-modeling-manifesto/


I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1567086
Posted Saturday, May 3, 2014 9:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
Points: 29, Visits: 89
I actually need more stuff like this. I have had a very hard time finding just basic information relating to DB/DW. My first assignment for a data warehousing class was to find all the basic information i could on the subject. MY results seemed like they differed.
Post #1567273
Posted Saturday, May 3, 2014 3:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
Points: 29, Visits: 89
If i'm building a databases how would i go about starting it?

I do the analysis part first correct?
Post #1567292
Posted Sunday, May 4, 2014 3:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 5, 2014 2:54 AM
Points: 29, Visits: 89
bump
Post #1567373
Posted Sunday, May 4, 2014 8:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:10 AM
Points: 36,995, Visits: 31,520
cook155 (5/4/2014)
bump


Speaking of "bumps" and as you said, this IS for a class. Not intending or meaning any disrespect whatsoever, the questions you're asking make it sound like you either didn't attend the classes or didn't pay attention at all. All of the questions that you're asking should have been covered by the instructor in the classes or will be covered by the instructor if this project was announced at the beginning of the class.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1567392
Posted Sunday, May 4, 2014 9:32 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 1:34 PM
Points: 23,327, Visits: 32,068
Just to add to what Jeff said. Since this is for a class we would like to see you doing the work and using this forum to show what you have done and where you stuck and need some help figuring out what you should do next to solve your problem.

It doesn't do you any good for us to do the work for you. You will learn more by doing the work and just asking us for help when you run into problems.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1567404
Posted Monday, May 5, 2014 3:42 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 339, Visits: 3,307
RobertC1 (5/3/2014)
I actually need more stuff like this. I have had a very hard time finding just basic information relating to DB/DW. My first assignment for a data warehousing class was to find all the basic information i could on the subject. MY results seemed like they differed.


That website is full of it, I can't think of a better resource for datawarehouse design - what are you missing here?


I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1567726
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse