April 29, 2014 at 8:11 am
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.
April 29, 2014 at 2:16 pm
Does anyone at least know of a application that would have datasets somewhere?
April 29, 2014 at 2:26 pm
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 Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 29, 2014 at 2:46 pm
If you can get your hands on a copy, read a little of Ralph Kimball's Data Warehouse Toolkit
April 29, 2014 at 3:08 pm
That's the problem. When I fanoogle Sql server data dataset example i really don't many results.
April 29, 2014 at 3:50 pm
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?
April 30, 2014 at 7:23 am
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
April 30, 2014 at 10:43 am
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.
April 30, 2014 at 10:57 am
This might stimulate some ideas:
https://www.google.com/?q=publicly+available+data
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 30, 2014 at 11:02 am
Thank you! exactly what i was needing.
May 2, 2014 at 8:17 am
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.
May 2, 2014 at 9:31 am
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.
May 3, 2014 at 9:32 am
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.
May 3, 2014 at 3:27 pm
If i'm building a databases how would i go about starting it?
I do the analysis part first correct?
May 4, 2014 at 3:49 pm
bump
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply