Power BI

Data analysis and visualization
    Duration
    Start hour
    Level

      Power BI – data analysis and visualization

      Online Microsoft Power Business Intelligence Training

      About Power BI training

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

      Full program

      Goals of the Power BI training

      The course aims to familiarize participants with the functions of analysis and data visualization using Power BI. After completing Microsoft Power BI 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
      Audience profile

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

      Requirements

      MS Power BI online training combines substantive knowledge with practical. 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.

      Training delivery method
      The training is carried out in the form of alternating lectures and practical exercises. MS Power BI online training combines substantive knowledge with practical.
      Duration

      2 days, 8 teaching hours each

      Price - 400 euro

      Theoretical and practical knowledge
      1. Introduction to Business Intelligence
      2. 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

          3. Loading data

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

          4.  Creating of standard visualizations

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

          5. Custom visualizations

      • Adding custom visualizations
      • Text box
      • Graphics
      • Shapes

         6. Filters managing

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

          7. Data model

      • Introduction to the data model
      • Creating relationships
      • Adding calculations: calculated columns, measures (DAX)
      • Grouping data, creating  hierarchies
      Development path
      • Power BI - Data analysis and visualization
      • Power BI, Power Pivot, Power Query – Analysis of data from spreadsheets and unstructured files
      • Power BI i DAX - Analysis based on dates
      • Power BI i DAX - Advanced analysis based on dates
      • DAX – Creating advanced formulas for Power BI,  SQL Server Analysis Services and PowerPivot in Excel.

      Similar trainings

      Consultant:

      Sylwester Woźniak
      Sylwester Woźniak

      sylwester.wozniak@comarch.com

      +48 12 687 78 11

      +48 608 646 465