Module I: Business and Data Analysis

Data volume and importance in economics and business is growing. Big Data promotes and restructures possibilities of decision making. It helps to increase field of activity, increase sales volumes, working efficiency and helps to implement new products or services for both - large companies and higher education and public entities, as well as many other organizations. In order to be able to understand this data and use it for improvement of competitiveness it is important for companies to apply both – data analysis and business analysis in practice.  

In this module you can learn skills that are necessary to work with data, for example, data visualization and analysis, basics of cloud computing and their application for business development, as well as skills in work with Microsoft platform Power BI and other basic knowledge, which will help to use data effectively in every field.

In Short

Programme start: January 2021*

Programme duration: 8 weeks

Programme intensity: 32 academic lessons

Programme manager: Dr. oec. Edgars Brēķis, lecturer of the Faculty of Business, Management and Economics of the University of Latvia

Programme language: English

! In order to register for the study programme, go to the section “Apply here”. In order to get access to all resources necessary for studies and to be able to follow your study progress and achievements, please register in Microsoft Learn platform: https://docs.microsoft.com/en-us/learn/

*Program course that will be led by program leader and experts, will start on January 2021, but we are offering opportunity to start your learning path now, find below your learning path.

Block 1 (Learn about Power platform, explore what Power BI can do for you)

1. Discover Data analysis
2. Introduction to Power Platform
3. Introduction to Common Data Service
4. Cloud Concepts - Principles of cloud computing
5. Introduction to Power BI
6. Explore what Power BI can do for you
7. Get started building with Power BI

Block 2 (Basics of Power BI reports and dashboards)

1. Create and share your first Power BI report
2. Create a data-driven story with Power BI reports
3. Create dashboards in Power BI
4. How to build a simple dashboard

Block 3 (Start to work with data)

1. Get data in Power BI
2. Perform analytics in Power BI
3. Analyze data in Power BI
4. Add measures to Power BI Desktop models
5. Manage datasets in Power BI
6. Explore data in Power BI
7. Get data with Power BI Desktop

Block 4 (Let's talk with DevOps)

1. Introduce the foundation pillars of DevOps: Culture and Lean Product
2. Describe Power BI Desktop models
3. Model data in Power BI
4. Design a data model in Power BI
5. Analyze DevOps Continuous Planning and Continuous Integration
6. Define the foundation pillars of DevOps: Architecture and Technology

Block 5 (Power Query, calculated fields and data risks mitigation)

1. Clean, transform and load data in Power BI
2. Add calculated tables and columns to Power BI Desktop models
3. Implement row-level security
4. Back up and restore databases

Block 6 (DAX)

1. Optimize a model for performance in Power BI
2. Write DAX formulas for Power BI Desktop models
3. Introduction to creating measures using DAX in Power BI
4. Modify DAX filter context in Power BI Desktop models
5. Use DAX iterator functions in Power BI Desktop models
6. Use DAX time intelligence functions in Power BI Desktop models

Block 7 (Visuals)

1. Design with inclusivity in mind
2. Work with Power BI visuals
3. Use visuals in Power BI
4. Work with AI visuals in Power BI

Block 8 (Publish and Share)

1. Publish and share in Power BI
2. Create paginated reports
3. Introduction to Power Apps
4. Introduction to Power Apps portals
5. How to build a model-driven app