Business Intelligence 2600-MSMdz1BI
Lecture:
The lecture offers theoretical foundations that will be useful when using BI systems. Topics:
1. Introduction to BI - a framework for considerations (The times of the information society, Ubiquity of data and Big Data, Review of management information systems)
2. The concept and architecture of BI systems
3. Characteristics of well- and poorly structured problems,
4. Characteristics of the Microsoft Power BI tool
5. Data sources for Business Intelligence
6. Data warehouses
7. ETL operations
8. Power Query
9. Data modeling
10. OLAP
11. Data mining
12. Visualization of results (Reporting and data visualization tools, Dashboards)
13. Applications and development directions of BI systems (BI in management, Business Intelligence policy goals in the organization, Organizing data management processes for BI purposes, BI applications, Development directions of BI systems)
Exercises:
The exercises cover issues related to the use of the Microsoft Power BI tool and the use of BI methods in business analyses. Topics:
1. Introduction to Microsoft Power BI (built-in tools, program interface, overview of possibilities),
2. Data preparation (Power Query, basic data preparation operations, data from different sources, incompatible tables, table decomposition, queries, M language, text analysis)
3. Data modeling (basics of data modeling, Power Pivot, star models, snowflake models, fact constellations, models with staging tables)
4. ETL operations in practice
5. Data visualization (reporting tools, creating dashboards using Power View)
6. Elements of the DAX language
7. Review of semestral projects
Type of course
Mode
Course coordinators
Learning outcomes
Upon completion of the course, the student:
In terms of knowledge:
• correctly uses terminology in the field of BI technology and related technologies such as data mining and data warehouses (K_W01).
• identifies the needs of businesses related to the use of Business Intelligence technology (K_W02).
• explains the role of Business Intelligence (BI) technology in making operational and strategic decisions (K_W05).
• explains concepts such as the information society, data ubiquity, Big Data, data warehouses, ETL, OLAP, and data mining (K_W05).
• identifies key elements of BI (K_W05).
• describes the application of information systems and data ubiquity to model organizational functioning (K_W05).
• discusses the functions of Microsoft Power BI, including tools such as Power Query, Power Pivot, Power View, and the basics of the DAX language (K_W05).
• analyzes data processing workflows, including data extraction, transformation, and loading (ETL), and recognizes various data sources and their integration into data warehouses (K_W05).
In terms of skills:
• creates data models using Power Pivot (K_U06).
• visualizes results to create dashboards that support decision-making (K_U06).
• processes data using basic knowledge of information and communication tools such as ETL, Power Query, Power Pivot, Power View, OLAP, basic DAX language notation, and data mining to create dashboards (K_U06).
• collaborates in a team to prepare data models and a final project (K_U08).
• supports others in the process of preparing the final project (K_U09).
In terms of social competences:
• critically analyzes information using Business Intelligence technology, including Microsoft Power BI, to support operational and strategic decisions in organizations (K_K01).
Assessment criteria
Learning outcomes will be verified on an ongoing basis through tasks performed by participants during exercises, during a theoretical test and during semester-long project work.
There is no exam - uniform grade for lecture and exercises:
- Semester project (50% of the grade)
- Score from exercises (30% of the grade)
- Score obtained during the lecture (20% of the grade)
Bibliography
Literature:
- Microsoft Power BI. Jak modelować i wizualizować dane oraz budować narracje cyfrowe, praca zbiorowa, wyd. III. Wydawnictwo Helion Gliwice 2023.
- Jerzy Surma - Business Intelligence. Systemy wspierania decyzji biznesowych. Wydawnictwo Naukowe PWN, Warszawa 2009.
- Arkadiusz Januszewski – Funkcjonalność informatycznych systemów zarządzania. Tom 2. Systemy Business Intelligence. Wydawnictwo Naukowe PWN, Warszawa 2008.
Additional literature:
- Marco Russo, Alberto Ferrari - Kompletny przewodnik po DAX. Analiza biznesowa przy użyciu Microsoft Power BI, SQL Server Analysis Services i Excel, Wydawnictwo Helion Gliwice 2019.
- Gil Raviv - Power Query w Excelu i Power BI. Zbieranie i przekształcanie danych. Wydawnictwo Helion Gliwice 2020.
- Marco Russo, Alberto Ferrari – Power BI I Power Pivot dla Excela. Analiza danych. Wydawnictwo Helion Gliwice 2020.
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: