Syllabus

Title
1799 From Database to Dashboard - SQL and Power BI
Instructors
Serhat Ada, M.Sc.
Contact details
Type
PI
Weekly hours
2
Language of instruction
Englisch
Registration
10/04/24 to 10/08/24
Registration via LPIS
Notes to the course
This class is only offered in winter semesters.
Subject(s) Master Programs
Dates
Day Date Time Room
Tuesday 12/03/24 04:00 PM - 07:00 PM LC.2.064 PC Raum
Thursday 12/05/24 04:00 PM - 07:00 PM LC.-1.038
Thursday 12/12/24 04:00 PM - 07:00 PM LC.-1.038
Tuesday 12/17/24 04:00 PM - 07:00 PM LC.-1.038
Tuesday 01/14/25 04:00 PM - 07:00 PM LC.2.064 PC Raum
Thursday 01/16/25 04:00 PM - 07:00 PM LC.-1.038
Thursday 01/23/25 04:00 PM - 07:00 PM LC.2.064 PC Raum
Contents

Business Analysts started to play an increasingly important role as the competition between businesses gets fiercer in the marketplace. How the market trends shift, how customers react to the new developments, what the forecasted sales would be, are a couple of questions to be answered by means of data. This course hence is designed to help students to get a comprehensive understanding relational databases to query data and shape results.

Throughout the course, students will use SSMS (SQL Server Management Studio), which allows them to handle the information using tables and to query these tables and other objects related (views, functions, procedures, etc.). In addition to SSMS, to visualize and analyze data, students will learn how to use Power BI, which is a powerful as well as a flexible tool for connecting with and analyzing a wide variety of data. Apart from the various visualization advantages that Power BI offers, it has amazing connection capabilities easily integrating with Databases. This offers increased advantages regarding functionalities and comes in handy for Business Analysts who are used to work in SQL.

Learning outcomes

After taking the course students will be able to 

  • Learn about basic database concepts
  • Learn about complete SQL concepts like joins, subqueries, constraints
  • Identify and work with business-oriented data sets
  • Understand the importance, concepts and power of data visualization
  • Create and share fully functional Power BI reports and dashboards
Attendance requirements

80 % is required

Teaching/learning method(s)
  • Theoretical and practical input by the instructor
  • In-class exercises with a strong emphasis on student participation (individual and in groups)
  • Self-directed learning
  • Group projects including presentations by students
Assessment
  • 20 % Peer grading
  • 30 % Weekly exercises
  • 50 % Final presentation of group project
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.

Availability of lecturer(s)

In-class and via email

Last edited: 2024-05-23



Back