Hurtownie Danych i Analiza Danych dla Zastosowań Biznesowych

Data Warehouses and Data Analytics for Business Applications


dr hab. inż. Robert Wrembel, prof. nadzw.

·

Tabelau dla studentów

  • Indywidualne licencje studenckie są dostępne po wypełnieniu formularza na stronie
  • Program Tableau dla uczelni jest opisany na stronie

indyco: a tool for designing conceptual data warehouse models

indyco is the CASE tool for data warehouse design based on the Dimensional Fact Model (DFM).


The educational license of indyco lets you

  • create and maintain a conceptual schema of a data warehouse using the DFM, a graphical state-of-the-art notation built in over 20 years of experience in both the academic and industrial worlds;
  • design and deploy ROLAP star/snowflake schemata following the best practices in the literature and Kimball’s design patterns.
In the commercial license, one can also carry out reverse engineering of previously available data warehouse and create a comprehensive project documentation. Upon registration to the indyco web site, you will be enabled to download the software and the DFM slides for your lessons on DW design. The educational license has 1-year duration and can be used for both teaching and research purposes, not for commercial purposes.


Wykłady (Lectures)
Materiały dydaktyczne (Teaching materials)

  • Data Integration Architectures (slajdy>>)
  • Introduction to Business Intelligence (slajdy>>)
  • Data ingestion techniques - ETL (slajdy>>)
  • Traditional Data Warehouse Architectures (slajdy>>)
  • Conceputal and Logical Data Warehouse Models (slajdy>>)
  • Data Warehouse Physical Design (part 1) (slides>>)
  • Data Warehouse Physical Design (part 2) (slides>>)
  • Data Warehouse Physical Design (part 3) (slides>>)
  • Main Memory Data Warehouse Appliances (slides>>)
  • Data Warehouse Benchmarking (slides>>)
  • Architectures for Warehousing Big Data (slajdy>>)

Wykłady ekspertów zewnętrznych
(Lectures by external experts from industry and academia)

  • Architektura Hadoop w implementacji IBM - Łukasz Gaza, pracownik IBM Polska

    13.12.2014, godz. 9:00-15:45, 1.2.3 BT
  • The Inverted Data Warehouse based on TARGIT Xbone - How Big Data can be mined by "the little guy" - Dr. Morten Middelfart - Founder & Chairman of Social Quant, Inc., USA (Bio)


    13.03.2015, 16:30-20:00, lecture hall 13CW
    • BI to the Masses - End-User BI from a Project Management Perspective (slides lectures 1-3>>)
    • The Inverted Data Warehouse based on TARGIT Xbone – How Big Data can be mined by "the little guy"
    • Sentinel Mining
    14.03.2015, 9:00-12:10, lecture hall 1.2.3 BT
    • Meeting Big Data challenges in Leadership with Human-Computer Synergy (slides lectures 4-5>>)
    • Reality - Project management & Software development in the Real World
  • Mining Massive Datasets - Prof. Yannis Manolopoulos - Aristotle University of Thesaloniki, Grece

    20.03.2015, 16:30-20:00, lecture hall 13CW
    • Mining data streams
    • Link Analysis
    21.03.2015, 9:00-12:10, lecture hall 1.2.3 BT
    • Advertising on the Web
    • Recommendation systems

Laboratoria (Labs/hans-on)
Materiały dydaktyczne (Teaching materials)

  • Partycjonowanie danych (slajdy>>)
  • Modelowanie wymiarów (slajdy>>)
  • Perspektywy zmaterializowane i przepisywanie zapytań (slajdy>>)

Zadania

Skrypty do zadań