Syllabus

Title
1205 Data Storytelling with Excel, Power Query and Power BI
Instructors
Mag. Rainer Baier
Contact details
rainer.baier@wu.ac.at
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
10/02/26 to 10/06/26
Registration via LPIS
Notes to the course
This class is only offered in winter semesters.
Subject(s) Master Programs
Business Software Skills
Dates
Day Date Time Room
Wednesday 11/04/26 01:30 PM - 07:00 PM LC.2.064 (P&S)
Monday 11/16/26 08:15 AM - 12:00 PM TC.3.02 (P&S)
Tuesday 11/17/26 01:30 PM - 06:00 PM TC.-1.61 (P&S)
Monday 11/23/26 08:15 AM - 12:00 PM TC.3.02 (P&S)
Monday 12/14/26 01:30 PM - 06:30 PM Online-Einheit

On this page:

to top
Contents

It is a fact that Excel is essential for any business professional. Thus, when applied effectively, Excel is a very powerful tool that allows you to process huge amounts of data and present complex information etc. 
Business Intelligence is in high demand. Companies are constantly searching for ways to make better and faster marketing decisions. Therefore, they rely heavily on data. Data-driven decision-making is the key to success for any business in the world of tomorrow. MS Power BI is an advanced yet easy to get started self-service business intelligence solution provided by Microsoft which is currently in very hot demand. 
The 1st part of this course is designed to help you learn how to solve business problems with Excel (more) efficiently and promote you to be an advanced user.
The 2nd part of the course is for everybody who wants to learn about self-service business intelligence with Power BI, to create professional visualizations, interactive reports and dashboards and to make data-driven decisions.
During our use cases we work with data from different industries (tourism, aircraft, telecommunication, the World Bank …).


In this course you will learn ...
… all about functions, data transfer and reporting by using
•    TEXT functions (CONCATENATE, LEFT, RIGHT, MID, LOWER, ...)
•    IF and VLOOKUP Functions 
•    (Power) PivotTables
•    Advanced Data Analysis with Dashboards (Excel Powerview)
•    Dynamic Data Exchange with external sources (databases, SAP, Internet) by using Power Query Editor
•    AI Tools in Data preparation and adjustments with Power Query Editor
… the basics about Power BI Desktop the Business Intelligence App from Microsoft
•    Import Data
•    Creating interactive Dashboards and Reports
•    Visualizations from the Market Store
•    Modelling of different data sets
•    Adjust Datasets with Power Query Editor
•    Calculation with Measures and DAX Functions with AI support
•    Distribute the reports via HTML
•    Using PowerBI with Mobile Devices
•    Power BI Cloud Resources
•    AI in Data Modelling and Vizualisation
… with practical business examples such as
•    BCG Matrix
•    ABC Analysis
•    Break Even Point
•    Form Controls (Scroll Bar; Check Box …)
•    Goal Seek
•    Solver
•    Integrated AI Tools and Agents in Office 365 Copilot

 

to top
Learning outcomes

After this course you should be able to

  • work with logical functions in Excel
  • use a variety of data validation techniques
  • use a range of lookup and reference functions
  • understand and create PivotTables and Graphs
  • use the Data Consolidation feature to combine data from several workbooks into one
  • use Solver to solve more complex and intricate problems
  • import data into Excel, Power BI and export data from Excel
  • create and use a range of controls in a worksheet
  • create and use a range of Excel Business Tools
  • solve business tasks by using Excel more efficiently.
  • create interactive Reports and Dashboards with Power BI Desktop
  • use Vizaulisations from the Market Store
  • create data models of different data sets
  • adjust Datasets with Power Query Editor
  • calculate with Measures and DAX Functions
  • distribute the reports via HTML, Powerpoint...
  • Using PowerBI with Mobile Devices
  • Power BI Cloud Resources
  • KI in Data Modelling and Vizualisation
to top
Attendance requirements

80 % is required

to top
Teaching/learning method(s)
  • Theoretical input by the trainer
  • Hands on Excel/Power BI workshop with a strong emphasis on student participation
  • Learning in peer groups
  • Self-directed learning with the e-learning platform
  • Student presentations
 
to top
Assessment
  • 55 % Class Participation and Peer Group Learning Participation
  • 20 % Group Presentation (Distance Learning Upload your Presentation)
  • 20 % Power BI Screencast
  • 05% Pre Course Assignments
to top
Readings

Please log in with your WU account to use all functionalities of read!t. For off-campus access to our licensed electronic resources, remember to activate your VPN connection connection. In case you encounter any technical problems or have questions regarding read!t, please feel free to contact the library at readinglists@wu.ac.at.

to top
Availability of lecturer(s)

rainer.baier@wu.ac.at

Last edited: 2026-06-08



Back