Data Visualization

2023/2024

Academic Year

ENG

Instruction in English

3

ECTS credits

Delivered at:

Department of Management

Course type:

Compulsory course

When:

2 year, 2 module

Instructor

Travin, Alexander

Course Syllabus

Abstract

The aim of this course is to equip students with advanced skills in using Microsoft Power BI for data visualization and analytics. The course will focus on enhancing their knowledge in creating interactive dashboards, analyzing data, performing calculations, and presenting information effectively. By the end of the course, students should be proficient in leveraging Power BI to make data-driven decisions and communicate insights to stakeholders.

Learning Objectives

• Develop a solid understanding of Microsoft Power BI and its features
• Learn how to connect to various data sources and perform data transformation and modeling
• Acquire skills in creating visually appealing and interactive reports and dashboards
• Explore advanced data visualization techniques to effectively communicate insights
• Gain proficiency in using DAX functions for advanced calculations and measures
• Understand and utilize advanced data analytics techniques such as forecasting and clustering
• Learn best practices in sharing and collaborating on Power BI reports and dashboards
• Enhance data security and governance by implementing appropriate access controls and data refresh schedules
• Apply learned concepts through practical assignments and real-world projects to reinforce understanding

Expected Learning Outcomes

• Able to utilize data modeling techniques to transform and shape data for analysis in Power BI.
• Knows how to design and develop interactive and visually appealing reports and dashboards using various Power BI tools and features.
• Able to apply advanced data visualization techniques, including custom visuals and hierarchies, to present complex data effectively.
• Knows how to perform calculations and create advanced measures using DAX (Data Analysis Expressions) functions in Power BI.

Course Contents

• Introduction to Power BI
• Getting and transforming of data with Power Query
• Calculations with DAX
• Data Visualization and Design
• Mid-term test and project defense

Assessment Elements

• Mid-term test
  The test includes 10 practical exercises. Each exercise weighs 1 point, incorrect exercise 0 points. Duration: 80 minutes.
• Final Project
  This is a group assignment. Students organize themselves into a small teams of 2-3. Each participant would be evaluated equally. Example of possible project design Project Description: As an undergraduate student in retail management, you will undertake a project to analyze and present the performance of a retail company using Power BI. The project will involve working with real-world retail data to gain insights and make data-driven decisions. Objectives: The main objectives of the project are as follows: 1. Analyze Sales Performance: Analyze the sales data of the retail company to identify key trends, patterns, and factors impacting sales. 2. Customer Segmentation: Conduct customer segmentation based on purchasing behavior and demographics to identify customer groups with different needs and preferences. 3. Inventory Management: Analyze inventory data to identify popular products, slow-moving items, and optimize stock levels based on customer demand. 4. Store Performance: Assess the performance of different store locations based on sales, customer footfall, and other relevant metrics. 5. Marketing Analysis: Analyze marketing campaign data and customer response to determine the effectiveness of different marketing initiatives. Note: The specific scope and requirements of the project can be adjusted based on the available data and the interests of the student.
• Final test
  Instructions: Please complete the following tasks using Microsoft Power BI based on the given scenario and dataset. You will be assessed on your ability to manipulate data, create visualizations, and derive meaningful insights. Scenario: You are a data analyst at a retail company. The company wants to analyze sales performance across different regions and product categories. They have provided you with a dataset containing sales data for the past year. Your task is to analyze the data and create a visual dashboard to present key insights. Dataset: The dataset consists of the following columns: Date: Date of the transaction Region: Region in which the sale occurred (e.g., North, South, East, West) Product Category: Category of the product sold (e.g., Electronics, Clothing, Home Appliances) Sales: Sale amount in USD

Interim Assessment

• 2023/2024 2nd module
  0.4 * Final Project + 0.4 * Final test + 0.2 * Mid-term test

Bibliography

Recommended Core Bibliography

• Greg Deckler. (2019). Learn Power BI : A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI. Birmingham: Packt Publishing. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=2252653
• Russo, M., & Ferrari, A. (2015). The Definitive Guide to DAX : Business Intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI. Redmond, Washington: Microsoft Press. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1601522

Recommended Additional Bibliography

• Adam Aspin. (2020). Pro Power BI Desktop : Self-Service Analytics and Data Visualization for the Power User: Vol. Third edition. Apress.

Authors

• TRAVIN ALEKSANDR SERGEEVICH
• BUDKO VIKTORIYA ALEKSANDROVNA