2024/2025
Лучшие практики бизнес-аналитики II
Статус:
Маго-лего
Когда читается:
2 модуль
Онлайн-часы:
20
Охват аудитории:
для своего кампуса
Преподаватели:
Стегний Елена Анатольевна
Язык:
английский
Кредиты:
3
Course Syllabus
Abstract
This course gives you access to the data visualization techniques. With the right techniques, data visualization can bring out insights that management personnel can use when making decisions to make them sound, data driven. Most of the data is stored in spreadsheets, where they are almost never used by anyone. To get more out of the data, it needs to be organized and well interpreted.
Learning Objectives
- After this course students should be able to use data carefully in order to make data-driven decisions. Students will know how to draw charts correctly and use data visualisation tools for solving business and academic tasks.
Expected Learning Outcomes
- - deep dive into the world of charts: their classification, the process of creation, tasks to be solved via different charts, and key rules to create a perfect graph - To get an overview of available online tools for charts creation.
- - to learn how to create an effective presentation - fundamentals of creating the presentation will be covered: types of presentations, key elements, and pillars to create a story - 5 main components of the presentation will be discussed: structure, composition, colors, illustrations, text. Af-ter finishing this week you will be able to create powerful presentations.
- - to learn how to build an effective business intelligence tool - to learn how to use different types of visualisations for building a dashboard - covering the foundations and key principles of building a dashboard
- - to learn the fundamental analytical scheme starting from data preparation and ending up with data visualisation in a form of a dashboard in Power BI
- - to get the skill of vivid and accurate graphic representation of such types of data (getting competitive advantage)
- - making the final project
- Differentiate the tasks solved via data visualisation
- Compare data-driven and conceptual graphs
- Be familiar with history of data visualisation
- Be able to apply dataviz classification for solving business tasks
- Apply the main rules of charts' creation
- Apply the guidelines for dataviz creation
- Reproduce the process of presentation creation
- Be familiar with main components of successful presentation
- Be able to develop a structured and logical story
- Use the basics of design thinking
- Apply rules of creating presentation for each of the components (structure, composition, colors, illustrations)
- Be familiar with definition of a dashboard
- Be able to apply key principles of building a dashboard to real-life problems
- Reproduce the Gestalt principles of data perception
- Build charts in Excel to create a dashboard
- Be able to apply business intelligence schema for solving business tasks
- Discuss the modern approach towards business intelligence
- Be familiar with key functions in Power BI for data visualisation
- Prepare and transform data with Power Query
- Build a dashboard in Power BI
- Use network visualisation in business
- Be familiar with main network visualisation steps
- Apply Eades' approach towards network analytics and visualisation
- Be familiar with network visualisation layouts and apply them for practical cases
- Be abble to apply network visualisation tools to HR analytics
Course Contents
- SESSION ONE: Visual Communications: Charts
- SESSION TWO: Making Presentations
- SESSION THREE: Dashabords and Visual Analytics
- SESSION FOUR: Data Analysis and Visualisation with Power BI
- SESSION FIVE: Network Visualisation for Better Decision-Making
Assessment Elements
- QuizzesThere will be 5 Quizzes (according to 5 course topics). You have 1 attempt to submit the test.
- Data-driven visualizationYour task is to visualize the given datasets using appropriate graphical representations. You will analyze the data and choose the best visualization techniques to effectively communicate the insights. Requirements: - Use at least three different types of visualizations (e.g., line charts, bar graphs, pie charts, etc.) to represent the data effectively. - Provide a brief explanation for each visualization, detailing why you chose that particular type and what insights it conveys. - Ensure that your visualizations are clear, informative, and visually appealing.
- Presentation of the articleCreating a Presentation Based on a Scientific Article The aim of this project is to enhance your understanding of scientific communication by creating a presentation based on a proposed scientific article. You will learn to summarize complex information, highlight key findings, and present them in a clear and engaging manner. Your task is to distill the key concepts, methodologies, results, and conclusions of the article into a concise presentation that effectively communicates the main points to your audience.
Interim Assessment
- 2024/2025 2nd module0.4 * Data-driven visualization + 0.5 * Presentation of the article + 0.1 * Quizzes
Bibliography
Recommended Core Bibliography
- Data analysis and decision making with Microsoft Excel, Albright, S. Ch., 2009
- Data mining and data visualization, , 2005
- Kirk, A. (2012). Data Visualization : A Successful Design Process. Packt Publishing.
- Krum, R. (2014). Cool Infographics : Effective Communication with Data Visualization and Design. Indianapolis, Indiana: Wiley. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=654832
- Presenting in English : how to give successful presentations, Powell, M., 2002
- Seamark, P. (2018). Beginning DAX with Power BI : The SQL Pro’s Guide to Better Business Intelligence. [United States]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1743806
Recommended Additional Bibliography
- Decision modeling with Microsoft Excel, Moore, J., 2001
- Giving presentations, Billingham, J., 2003
- Handbook of data visualization, , 2008