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
2. Data Warehouses - list 2.pdf - due
3. Data Warehouses - list 3.pdf - due AviationData.zip Dane01.txt
4. Data Warehouses - list 4.pdf - due
5. Data Warehouses - list 5.pdf - due
6. Data Warehouses - list 6.pdf - due

(Data Warehouses - report.pdf)

Reports upload

Project

Project requirements

Dates:

• I part - due
• II part - due
• III part - due
• presentation - due

Dates of project presentation

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}
}