| Course Unit Code | 155-0357/03 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Choice-compulsory type B |
|---|
| Level of Course Unit * | Second Cycle |
|---|
| Year of Study * | |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| NOV21 | Ing. Vítězslav Novák, Ph.D. |
| Summary |
|---|
| The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI. |
| Learning Outcomes of the Course Unit |
|---|
| The aim of the course is to acquaint students with the basics of business intelligence and information support of teamwork using the Microsoft Office 365 office suite. At the end of the course students should be able to obtain information from more data using tools such as Microsoft Excel, Power Query, Power Pivot or Power BI. |
| Course Contents |
|---|
1. History of the Internet - milestones, famous persons.
2. How Internet / Intranet works - main services, applications, protocols, network topology - comparison and modern trends.
3. Cloud Computing I. - history, concepts, characteristics, service models.
4. Cloud Computing II. - architecture, deployment models, security and privacy.
5. Social intranet - techniques and systems in team work.
6. Visualizing Data and Information - Communicating Information Clearly and Efficiently.
7. Web design - main rules, typography, graphics, accessibility rules. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
WINSTON, Wayne. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). San Francisco, Microsoft Press, 2021. ISBN 978-0137613663.
ALEXANDER, Michael and KUSLEIKA, Dick. Microsoft Excel 365 Bible. Indianapolis, John Wiley & Sons, 2022. ISBN 978-1119835103.
DECKLER, Greg and POWELL, Brett. Mastering Microsoft Power BI - Second Edition: Expert techniques to create interactive insights for effective data analytics and business intelligence. Birmingham, Packt Publishing, 2022. ISBN 978-1801811484. |
NOVÁK, Vítězslav. Analýza dat v Microsoft Excelu. Ostrava: VŠB - Technická univerzita Ostrava, 2023. ISBN 978-80-248-4695-8.
LASÁK, Pavel. Praktické použití funkcí v Excelu. Praha: Grada Publishing, 2021. ISBN 978-80-271-1303-3.
LAURENČÍK, Marek. Excel 2019: práce s databázemi a kontingenčními tabulkami. Průvodce (Grada). Praha: Grada, 2020. ISBN 978-80-271-1391-0. |
| Recommended Reading: |
|---|
FERRARI, Alberto and Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond, Washington: Microsoft Press, 2017. ISBN 978-1-5093-0276-5.
RUSSO, Marco and Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition. Redmond, Washington: Microsoft Press, 2019. ISBN 978-1509306978.
DECKLER, Greg. Learn Power BI - Second Edition: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence. Birmingham, Packt Publishing, 2022. ISBN 978-1801811958. |
KLATOVSKÝ, Karel. Microsoft Excel 2021/365 nejen pro školy. Prostějov: Computer Media, 2023. ISBN 978-80-7402-451-1.
FERRARI, Alberto and Marco RUSSO. Analyzing Data with Microsoft Power BI and Power Pivot for Excel. Redmond, Washington: Microsoft Press, 2017. ISBN 978-1-5093-0276-5.
RUSSO, Marco and Alberto FERRARI. The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition. Redmond, Washington: Microsoft Press, 2019. ISBN 978-1509306978. |
| Planned learning activities and teaching methods |
|---|
| Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 45 | 25 |
| Examination | Examination | 55 | 15 |