MPM_DPBI Data processing with powerBI

Faculty of Economics and Administration
Autumn 2024
Extent and Intensity
0/2/0. 5 credit(s). Type of Completion: zk (examination).
In-person direct teaching
Teacher(s)
Ing. Pavel Lasák (seminar tutor)
Guaranteed by
Ing. Pavel Lasák
Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Contact Person: Lenka Hráčková
Supplier department: Division of Applied Mathematics and Computer Science – Faculty of Economics and Administration
Timetable of Seminar Groups
MPM_DPBI/01: Mon 12:00–13:50 VT204, except Mon 16. 9., except Mon 4. 11., P. Lasák
Prerequisites
Basic knowledge of working on a PC.
Course Enrolment Limitations
The course is offered to students of any study field.
The capacity limit for the course is 45 student(s).
Current registration and enrolment status: enrolled: 44/45, only registered: 0/45, only registered with preference (fields directly associated with the programme): 0/45
Course objectives
The student is able data to download, edit, create relationship , visualize and then share.
Learning outcomes
load data process data visualize data create a function in DAX publish data
Syllabus
  • Basics - Introduction - Alternative tools - Power BI installation Loading data - From the web - From Excel - From csv - etc. Data editing - Introduction to PowerQuery Editor - Working with columns - Working with rows - Pivot and Unpivot - Calculations - ... Query creation - Data model Data visualization - Table - Matrix - Bar / Line / Pie Chart - Maps Creation of dasboards Data publication
Literature
    recommended literature
  • BRETT, Powell. Mastering Microsoft Power BI: Expert Techniques for Effective Data Analytics and Business Intelligence. Birmingham: Packt Publishing, 2018. ISBN 978-1-78829-723-3. info
    not specified
  • DAN, Clark. Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop. 2nd ed. Berkeley, CA: Apress, 2017. ISBN 978-1-4842-2577-6. info
  • ALLINGTON, Matt. Learn to write DAX : a practical guide to learning Power Pivot for Excel and Power BI. Merritt Island: Holy Macro! Books, 2016, viii, 184. ISBN 9781615470419. info
Teaching methods
Tasks in Power BI.
Assessment methods
Attendance Tasks Project Tests
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
Teacher's information
Power BI only works under Windows.
The course is also listed under the following terms Autumn 2022, Autumn 2023.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2024/MPM_DPBI