Post reply

Help a complete noob with a project

  • April 29, 2014 at 8:11 am

    #285009

    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

    #1709626

    Does anyone at least know of a application that would have datasets somewhere?

  • April 29, 2014 at 2:26 pm

    #1709628

    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

    #1709640

    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

    #1709645

    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

    #1709655

    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

    #1709825

    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

    #1709926

    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

    #1709929

    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

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

  • April 30, 2014 at 11:02 am

    #1709933

    Thank you! exactly what i was needing.

  • May 2, 2014 at 8:17 am

    #1710355

    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

    #1710385

    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

    #1710526

    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

    #1710542

    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

    #1710601

    bump

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply