EnglishMecenātiemMedijiem

Module I: Business and Data Analysis

The amount and importance of data in the economy and business is growing. Big Data facilitates and restructures decision-making capabilities. They help large companies, higher education and government institutions, as well as many other organizations, to expand their scope, increase sales, operate more efficiently and introduce new products or services. In order to be able to understand this data and use it to improve competitiveness, it is important for companies to apply both data analysis and business analysis in practice.

In this module, you can acquire skills in working with data, such as data visualization and analysis, the basics of cloud computing and its application to business development, as well as skills in working with Microsoft platform Power BI and other basic knowledge that will help to use data effectively in any field.

Start of the program: The most current course - starting on October 6, 2021. The course will be conducted in English. Registration will remain open when the course has already begun. Register - www.balticinternships.eu 

 

Programme content:

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