Business applications and analytical dashboards in MS Excel, VBA, SQL, BI 2400-PL3SL311A

The goal of the class is for students to prepare an bachelor thesis. The seminar allows practical application of the knowledge learned in classes on MS Excel, VBA, Power BI, Tableau, as the main part of the work will be the design, creation and implementation of a business application written in these programs. Natural candidates are students pursuing one of the educational paths: "Business applications in Microsoft Excel using the VBA programming language" or "Analytical dashboards using Business Intelligence tools."

The topics of the works can also be related to data analysis for business cases. In particular, the works may refer to microeconomic theories, applications of theorogical models and their verification by experimental methods.

The seminar allows practical use of the knowledge learned in classes in Excel, VBA, Power BI, Tabelau, econometrics, microeconomics, game theory, market organization, or experimental economics, extending it and taking a critical look at the models discussed there.

Credit for the first semester is based on progress in writing the paper, including a draft of the paper, and presentation of the results obtained. Credit for the final semester, in accordance with current UW regulations, is based on the submission of the thesis to the dean's office.

Notes:

Note 1: students who are considering enrolling in the seminar are obliged to meet in advance with the instructor. At the meeting, the rules of thesis writing will be explained, the possible topics of the thesis, and the students' preliminary area of interest in order to determine the choice of credited subjects useful for writing the thesis.

Note 2: students themselves choose the topic of the thesis, which they consult with the seminar leader. Each student works individually on his topic - there are no collective meetings in the seminar.