Goal:
The aim of the course is to introduce students to the fundamentals and practical applications of data visualization and business intelligence. The course seeks to help students understand how data and analytical results can be transformed into business information and how this information can be communicated effectively. Special emphasis is placed on data visualization and the creation of dashboards. By the end of the course, students should understand how data visualization and business intelligence can be effectively applied in business decision-making and how organizational performance can be improved through data analysis and business intelligence.
Course description:
Within the framework of the course, students become familiar with the methods of loading and cleaning source data, the tasks of data modeling, and the fundamentals of data visualization, and they gain in-depth insight into the use of Microsoft Power BI.
The course covers loading data into Power BI from various data sources, data cleaning, and an introduction to the capabilities of Microsoft Fabric. Topics include data modeling, the star schema model, linking data tables, the use of fact and dimension tables, applying basic DAX functions, organizing measures, and understanding different types of visualizations. Students also learn dashboard development, the use of visual elements, different types of filters, theme settings, interactive report creation, and the design of user-friendly interfaces.
Advanced Power BI topics are also addressed, including Python visualizations, the use of the Selection Pane, design modernization, and creating an application-like look and feel.