Wednesday, July 15, 2020

The Data Warehouse laboratory consist of 15 meetings.

  1. As part of the course, students prepare reports for lists and develop an individual data warehouse project.
  2. The report containing the solved tasks should be uploaded to the teacher before the classes on which it will be defended.
  3. Attendance is mandatory.
  4. Absence shall not release from the obligation to send the report.
    The grade for the course consists of:
  1. Ratings from reports:
    • Lists 1-6 rated on a scale of 0-1
    • Subsequent lists constituting elements of project preparation, rated on a scale of 0-5
  2. Evaluation of the project.

Lists

  1. Data Warehouses - list 1.pdf - due 8.03.2020
  2. Data Warehouses - list 2.pdf - due 15.03.2020
  3. Data Warehouses - list 3.pdf - due 22.03.2020

AviationData.zip Dane01.txt

  1. Data Warehouses - list 4.pdf - due 5.04.2020
  2. Data Warehouses - list 5.pdf - due 19.04.2020
  3. Data Warehouses - list 6.pdf - due 26.04.2020

(Data Warehouses - report.pdf)

Reports upload

Online meetings

ZOOM meeting

Mondays - from 11:15 until 12:15

Tuesdays - from 17:05 until 18:05

In all other times I'm available for consultations on zoom chat or email.

Project

Project requirements

Project topic submission

Already submitted projects

Dates:

  • I part - due 10.05.2020
  • II part - due 17.05.2020
  • III part - due 24.05.2020
  • presentation - https://appoint.ly/s/prezentacjePWR/introduction (projects` documentation should be sent before the actual presentation)

Dates of project presentation

Grades

Preliminary grades

Software used for the course

  • MS SQL Server 2016 Enterprise:
    • Integration Services, Analysis Services, Reporting Services, Data Quality Services
    • SQL Server Data Tools (Integration, Analysis oraz Reporting)
    • Data Quality Client, Master Data Services
  • MS SQL Server Management Studio
  • Visual Studio
  • Power BI Desktop
  • Bazy danych: AdventureWorks OLTP, AdventureWorksDW

Bibliography

@book{doi:10.2200/S00299ED1V01Y201009DTM009,
author = {Jensen, Christian S. and Pedersen, Torben Bach and Thomsen, Christian},
title = {Multidimensional Databases and Data Warehousing},
series = {Synthesis Lectures on Data Management},
volume = {2},
number = {1},
pages = {1-111},
year = {2010},
doi = {10.2200/S00299ED1V01Y201009DTM009},
URL = {https://doi.org/10.2200/S00299ED1V01Y201009DTM009},
eprint = {https://doi.org/10.2200/S00299ED1V01Y201009DTM009}
} 


@book{book,
author = {Rainardi, V},
year = {2008},
month = {01},
pages = {1-523},
title = {Building a data warehouse: With examples in SQL server},
doi = {10.1007/978-1-4302-0528-9}
}
@book{harinath2012professional,
title={Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX},
author={Harinath, S. and Pihlgren, R. and Lee, D.G.Y. and Sirmon, J. and Bruckner, R.M.},
isbn={9781118237083},
lccn={2012933620},
series={ITPro collection},
url={https://books.google.pl/books?id=_YUkhcSCrtcC},
year={2012},
publisher={Wiley}
}
@Book{193909,
author = "Russo, Marco and Ferrari, Alberto",
editor = "",
title = "Microsoft SQL Server 2016 Analysis Services: Modelowanie tabelaryczne",
publisher = "Promise",
year = 2018,
address = "Warszawa",
url="http://libra.acceptance.ibuk.pl/book/193909"
}
@book{Inmon:2002:BDW:560407,
author = {Inmon, W. H.},
title = {Building the Data Warehouse,3rd Edition},
year = {2002},
isbn = {0471081302},
edition = {3rd},
publisher = {John Wiley \& Sons, Inc.},
address = {New York, NY, USA},
url="https://dl.acm.org/citation.cfm?id=560407"
}
@book{Kimball:2004:DWE:1201627,
author = {Kimball, Ralph and Caserta, Joe},
title = {The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming and Delivering Data},
year = {2004},
isbn = {0764567578},
publisher = {John Wiley \& Sons, Inc.},
address = {USA},
url="https://dl.acm.org/citation.cfm?id=1201627"
}

Supplementory bibliography

@book{Aspin:2012:SSD:2480926,
author = {Aspin, Adam},
title = {SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools},
year = {2012},
isbn = {1430247916, 9781430247913},
edition = {1st},
publisher = {Apress},
address = {Berkely, CA, USA},
}
@book{Leonard:2014:SSI:2728723,
author = {Leonard, Andy and Masson, Matt and Mitchell, Tim and Moss, Jessica and Ufford, Michelle},
title = {SQL Server Integration Services Design Patterns},
year = {2014},
isbn = {1484200837, 9781484200834},
edition = {2nd},
publisher = {Apress},
address = {Berkely, CA, USA},
}
@book{imhoff2003mastering,
title={Mastering data warehouse design: relational and dimensional techniques},
author={Imhoff, C. and Galemmo, N. and Geiger, J.G.},
isbn={9780471324218},
lccn={2003010879},
series={Timely, practical, reliable},
url={https://books.google.pl/books?id=ut5QAAAAMAAJ},
year={2003},
publisher={Wiley Pub.}
}
@book{maclennan2011data,
title={Data Mining with Microsoft SQL Server 2008},
author={MacLennan, J. and Tang, Z.H. and Crivat, B.},
isbn={9781118080009},
url={https://books.google.pl/books?id=_EmNz6z66vIC},
year={2011},
publisher={Wiley}
}

Do końca semestru pozostało