MPM_DPBI Data processing with powerBI

Faculty of Economics and Administration
Autumn 2023
Extent and Intensity
0/2/0. 5 credit(s). Type of Completion: zk (examination).
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 18. 9., except Mon 6. 11., P. Lasák
Course Enrolment Limitations
The course is offered to students of any study field.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 15/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
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 2024.
  • Enrolment Statistics (Autumn 2023, recent)
  • Permalink: https://is.muni.cz/course/econ/autumn2023/MPM_DPBI