Power BI – Data analysis and visualization

    Czas trwania
    Godzina rozpoczęcia
    Stopień trudności

      Power BI – Data analysis and visualization


      Remote and stationary training options

      About training

      During the training, the participant gets to know Power BI Desktop application and Power BI as a cloud service, an interesting element of which is the ability to export to Excel and PowerPoint. For the participant, this means the possibility of implementing the idea of Self-Service BI - creating own analytical solutions without much involvement of IT departments.

      View the training programme

      What will you gain from the training?

      Goals of the training

      The course aims to familiarize participants with the functions of analysis and data visualization using Power BI. After completing the training, the participant will be able to implement his own Business Intelligence solution, starting from getting data from external sources, through creating a simple data model, defining your own measures and formulas using DAX, to preparing an interactive report consisting of visualizations available in Power BI. During the training, the participant gets to know Power BI Desktop application and Power BI as a cloud service, an interesting element of which is the ability to export to Excel and PowerPoint. For the participant, this means the possibility of implementing the idea of Self-Service BI - creating own analytical solutions without much involvement of IT departments. This increases the efficiency of the analyst's work while reducing the costs of the entire process.

      Skills 

      Thanks to the training, the participant will be able to:

      • Load data into Power BI program
      • Create a data model
      • Create a dynamic analytical dashboard
      • Share dashboards with other people
      • Present the data from the analytical dashboard in PowerPoint program
      Is this training for you?

      Profile of participants

      The course is intended for people who perform data analysis and create reports using data from different systems, who want to visualize their data.   

      Prerequisites

      The training participants are required to have an intermediate level of knowledge of the Windows environment and the use of a spreadsheet. Knowledge of PowerPivot, DAX, and Power Query will be useful, but not required.

      Duration

      Duration:

      • 2 days, 8 teaching hours each
      Detailed training program

      Detailed training program

      Introduction to Business Intelligence

      Tools overview

      • Power Bi Desktop: loading and transforming data, working with a data model, working with visualizations, publishing reports
      • Power BI Online: sharing reports Datasets, Reports and Dashboard

      Loading data

      • Introduction to the query editor
      • Getting and transforming data 
      • Combining tables

      Creating of standard visualizations

      • Creation 
      • Modification
      • Drill down of data
      • Adding and removing chart elements

      Custom visualizations

      • Adding custom visualizations
      • Text box
      • Graphics
      • Shapes

      Filters managing

      • Slicer filters
      • Chart filters
      • Page filters
      • Report filters

      Data model

      • Introduction to the data model
      • Creating relationships
      • Adding calculations: calculated columns, measures (DAX)
      • Grouping data, creating  hierarchies

      Download file

      Training delivery method

      The training is carried out in the form of alternating lectures and practical exercises. The training combines substantive knowledge with practical examples of its use in the work environment. 

      Development path

      Podobne tematy