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 Tuesday, April 29, 2014 8:11 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
Hello everyone,

i have a project for a datawarehousing class and could really use some help in this.

Heres what i am supposed to do?
I am asking each student to build a data warehouse and to do a presentation of your project to the class on the last day of class. You may work alone on this project or you may work as a group. Here is what needs to be done.



A. Select an application. It can be real or simulated.



B. Develop a data warehouse scheme.



C. Load the warehouse.



D. Mine the warehouse.

Does someone know of a good idea or dataset that would be easy for a project?

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.


  Post Attachments 
ULSTAT2000-2012.xlsx (6 views, 14.41 KB)
Post #1565943
Posted Tuesday, April 29, 2014 2:16 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
Does anyone at least know of a application that would have datasets somewhere?
Post #1566128
Posted Tuesday, April 29, 2014 2:26 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 13,302, Visits: 12,168
I would just Binoogle "sql server data warehouse example". You will find some examples of simple projects designed to help people learn how to build these. It is probably a good starting point to find a topic and get you moving. You should design your own though and not copy what you find.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1566130
Posted Tuesday, April 29, 2014 2:46 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 12:13 AM
Points: 745, Visits: 4,776
If you can get your hands on a copy, read a little of Ralph Kimball's Data Warehouse Toolkit
Post #1566145
Posted Tuesday, April 29, 2014 3:08 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
That's the problem. When I fanoogle Sql server data dataset example i really don't many results.
Post #1566150
Posted Tuesday, April 29, 2014 3:50 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 12:13 AM
Points: 745, Visits: 4,776
Do you understand the difference between an OLTP database structure and a DW database structure? Which part are you having trouble with? The star schema?
Post #1566161
Posted Wednesday, April 30, 2014 7:23 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:01 AM
Points: 914, Visits: 1,431
How about using the "work as a group" option, so your team can figure it out together? Part of becoming a DBA is being able to work with a team and feed off of each other's strengths.

Steve



Post #1566387
Posted Wednesday, April 30, 2014 10:43 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 wish i could work as a group but that is already out of the question.

Right now i am looking for ideas for a project. Ideas that may even already have been compiled in a database.

Example:

One student did his project early

He compared baseball statistics of Babe Ruth and tried to show if Babe Ruth was the best based out of statistics.

He used : How long their career was, batting average, etc...

He took had a database with all this information and drew a conclusion of who he thought was the best candidate.

My problem is finding an idea where i can get the data. Heck, just coming up with the idea is hard.
Post #1566503
Posted Wednesday, April 30, 2014 10:57 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 42,822, Visits: 35,952
This might stimulate some ideas:
https://www.google.com/?q=publicly+available+data



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1566508
Posted Wednesday, April 30, 2014 11:02 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
Thank you! exactly what i was needing.
Post #1566512
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse