Power BI

Power BI 2-day training introduces a powerful tool to help you make information-based decisions. With Power BI data can be collected, organized, and merged into a data model. Also, it can be visualized and shared with company employees or the public web.

After passing the course you will be able to:

  • import data from various sources into the data model using Power Query
  • visualize data using Power Bi Desktop.

NEW! To meet the needs and expectations of our customers even better we have made the DAX functions, filtering options and bookmarks course part even more detailed – and all of that for better data analysis.

Program:

  • Creating queries with Power Query
    • Importing data from different sources
      • From the web
      • From the database
      • From text files
      • From Excel spreadsheets
      • From Facebook, Outlook…
    • Joining tables
      • Merging tables
      • Taking data from a secondary table, i.e. linking tables
    • Organizing data
      • Filtering and sorting
      • Setting headers
      • Joining and splitting columns
      • Defining data types
      • Making a standard table from Pivot table
      • Adding columns with calculations
    • Updating and editing queries
    • Functions in queries (“M”-functions)
      • Conditional sentences
      • Format conversion functions
      • Time functions
      • Text functions
      • Statistical functions
    • Visualize data on the Dashboard using Power BI Desktop
      • Application installation
      • Working environment
      • Creating a data model
      • Key performance indicators (KPIs)
        • Calculation of key figures and summaries
        • Calculating new measures with DAX functions – Even more thorough!
        • Tables and matrices
      • Charts
        • Dynamic bar, line, pie charts
        • Geographic location charts
          • Set the location type
          • Points on the map
          • Regions
        • Tables and matrices
        • Filtering options – Even more thorough!
          • Slicers
          • Visual, page and report filters
          • Drill and its settings
        • Importing custom visuals (new charts, images…)
        • Design of visualization objects
          • Fonts, colors, adding and removing objects in graphics
          • Setting the scales
          • Adding dynamic lines
        • Desktop sharing options

You can participate in the training both in the classroom and online.

As for classroom training from our side, we have taken all precautionary measures to ensure that your participation in the training is a pleasant and safe experience. Read more about classroom training here.

You can participate in online training in the Zoom video conferencing environment. A link to enter the training environment with instructions will be sent to training participants prior to the training. As a diligent student, you enter the “classroom” 15 minutes before the start of the training to set up everything you need (camera, microphone etc). The ability to use two screens is very welcome (if not, you can handle with one as well). During the training, practical exercises are performed, which require the participant’s interactive contribution.

Teaching methods: practical exercise, independent work

Assessment method: independent work

Assessment criteria: the achievement of learning outcomes is checked through independent practical work

The price of the training includes coffee breaks and lunch.

BCS Koolitus offers computers and monitors for rent. See offer.

Tähelepanu! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.

Attention! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.

Внимание! Teie veebilehtiseja ei vasta kodulehe külastamiseks vajalikele nõuetele. Palun vahetage veebilehitsejat või seadet, millega te veebilehte sirvite.