Business Data Analysis for Practice
Brno University of Technology
Faculty of Business and Management
Field:
Computer use
Duration of the course:
78 Hours of teaching
Number of credits:
3
Language of teaching:
Czech
Type of assessment:
Project work, Continuous evaluation, Problem based learning
Course description
The course is focused on effective data analysis using available technologies to support the solution of managerial tasks using a system approach and the principles of data science and BI (Business Intelligence). The main goal of the course is to familiarize participants with the principles of databases, data analytics and the subsequent interpretation of results to support decision-making. The course is built on solving practical examples.
Content of the course
The course content:
I. BLOCK (Introduction to the issue)
Introduction to the field of Data Science and its use in practice (Introduction to the course: Organization, work style, study supports, usable technologies and resources; Data science and data analytics in the conditions of a global information (digital) society)
Transactional database and relational data model (Principles of transactional databases, use of relational data model and principles of data modelling)
Analytical databases and the data cube (Principles of analytical databases in the context of data warehouses and multidimensional databases.)
II. BLOK (Database and SQL language)
Introduction to the use of MS SQL Server and the use of the SQL language (The use of the SQL language for working in the database system, the MS SQL Server platform and the use of the MS SQL Server Management studio)
SELECT and query options including table joins (Use of SELECT syntax for queries including table joins and practical syntax examples)
Use of aggregation functions, subqueries, views and temporary tables (Possibilities of using aggregation and other functions within the SELECT syntax and the potential of working with views and temporary tables)
III. BLOK (Data analysis and interpretation using MS Excel or MS Power BI)
Introduction to data analysis in the chosen tool (Introduction to working with data in the chosen tool with a focus on analytical potential)
Creating a data model in the selected tool (e.g. using PowerPivot for MS Excel to work with the data model and its subsequent analysis)
Using the principles of the ETL process (e.g. using PowerQuery to transform and prepare data for the data model)
Data analysis using standard visuals (Analytical options in the selected environment and extension options - e.g. DAX language)
Extended interpretation and formatting options for results interpretation purposes (Combination of tools to maximize results interpretation options - e.g. KPIs, Dashboards, combined graphs, ...)
IV. BLOCK (Project)
Assignment of the final project (Including its more detailed explanation – process support, internal logic, …)
Processing of the final project (Individual processing of the final project)
Project consultation (Consultation dedicated to specific difficulties in solving the project)
Defence of the final project (Presentation of the final project with an emphasis on results that can be used to support managerial decision-making, including subsequent feedback and potential for improvement)
I. BLOCK (Introduction to the issue)
Introduction to the field of Data Science and its use in practice (Introduction to the course: Organization, work style, study supports, usable technologies and resources; Data science and data analytics in the conditions of a global information (digital) society)
Transactional database and relational data model (Principles of transactional databases, use of relational data model and principles of data modelling)
Analytical databases and the data cube (Principles of analytical databases in the context of data warehouses and multidimensional databases.)
II. BLOK (Database and SQL language)
Introduction to the use of MS SQL Server and the use of the SQL language (The use of the SQL language for working in the database system, the MS SQL Server platform and the use of the MS SQL Server Management studio)
SELECT and query options including table joins (Use of SELECT syntax for queries including table joins and practical syntax examples)
Use of aggregation functions, subqueries, views and temporary tables (Possibilities of using aggregation and other functions within the SELECT syntax and the potential of working with views and temporary tables)
III. BLOK (Data analysis and interpretation using MS Excel or MS Power BI)
Introduction to data analysis in the chosen tool (Introduction to working with data in the chosen tool with a focus on analytical potential)
Creating a data model in the selected tool (e.g. using PowerPivot for MS Excel to work with the data model and its subsequent analysis)
Using the principles of the ETL process (e.g. using PowerQuery to transform and prepare data for the data model)
Data analysis using standard visuals (Analytical options in the selected environment and extension options - e.g. DAX language)
Extended interpretation and formatting options for results interpretation purposes (Combination of tools to maximize results interpretation options - e.g. KPIs, Dashboards, combined graphs, ...)
IV. BLOCK (Project)
Assignment of the final project (Including its more detailed explanation – process support, internal logic, …)
Processing of the final project (Individual processing of the final project)
Project consultation (Consultation dedicated to specific difficulties in solving the project)
Defence of the final project (Presentation of the final project with an emphasis on results that can be used to support managerial decision-making, including subsequent feedback and potential for improvement)