- Home
- Participant Homepage
- Course Offers
- Current Course Programme
- Operating Systems & Programming
- Digitale Selbstverteidigung: Einführung in die IT-Sicherheit für Anwender:innen
- Linux: Bash Workshop (TheAlternative.ch)
- Linux: Introduction to Open Source Software (TheAlternative.ch)
- Python: Basics
- Python: Automatisierung, Web-Scraping, Bildbearbeitung
- Python: Intermediate
- Microsoft Power Automate: Digitalisierung erster Prozesse
- Science IT: Linux Command Line
- Image Editing, Illustration and Presentation
- Collaboration, Social Media and Webpublishing
- Accessibility@UZH in the CMS
- Images for your Website
- CMS Introduction Magnolia
- Creating and Publishing Web Pages
- Basic Introduction to JavaScript
- UZH365: Task management with Microsoft Planner
- UZH365: Create an Intranet with SharePoint
- UZH365: Basics of collaboration in the cloud
- UZH365: Effective communication with teams Telephony
- UZH365: Microsoft Outlook (im Web) Grundlagen
- UZH365: Outlook Desktop Productivity Training
- UZH365: SharePoint Basics
- TOPdesk: Hands-on Essentials
- Data Science
- QGIS Desktop Basics
- Python: Introduction to Natural Language Processing (NLP)
- Python: For the Digital Humanities
- Einführungskurs in das Statistikpaket SPSS
- Introduction to Programming with MATLAB
- Qualitative Datenanalyse mit MAXQDA
- Python: Data Analysis Essentials
- R: Basic Introduction
- R: Crash Course in Statistics using R
- R: Reporting using Quarto & R Markdown
- R: tidyverse for Data Science
- UZH 365: Data Analysis and Visualisation with PowerBI
- Databases, Spreadsheet
- E-Learning
- Scientific Computing
- Text Processing & Publishing
- Knowledge Management
- UZH365: Digital Communication and Collaboration
- IT Courses from other Organisational Units of the UZH
UZH 365: Data Analysis and Visualisation with PowerBI
Power BI is one of the most used software for data-driven decision making in industry. Power BI allows to easily integrate different data sources, to create data models and to realize effective data representations that facilitate the data analysis and the information sharing within an organization. This course targets participants with little to no experience in Power BI and data analysis and illustrates the basic software functionalities and capabilities. The course content is disseminated through slides, Power BI guide-trough with the instructor and in-class exercises.
General information
| Duration | 12 hours |
|---|
- Introduction to Power Bi desktop and software layout
- Data gathering and transformations via Power Query
- DAX: measures, calculated columns and tables
- Visuals, filters and slicers
- Data relationships and hierarchy
- Time analytics: date tables, calendar and time-intelligent functions
Power BI desktop (free) must be installed on the participant’s computer. Power BI Desktop runs only on a Windows computer.
Students and employees of the University of Zurich.
By taking this course, participants will be able to clean and integrate several different data sources in Power BI. Participants will be able to create simple data models, composed by multiple relationships across different data sources. Furthermore, participants will gain experience in creating reports and employing analytics with several data types. Participants will acquire some best practices for data analysis in Power BI and will learn how to deliver visually effective data representations via Power BI reports.
The course material comprises slides as well as exercise data files and will be provided in class.
Dates