X

    Power BI

    FP-DNS-001-1.5

    •

    Fundamental

    •

    4 days

    •

    28 hours

    Discover how to transform your raw data into strategic information and learn how to create dynamic reports that will make all the difference to your decision-making.

    Target audience

    This course is aimed at all professionals wishing to use Power BI.

    Prerequisites

    There are no prerequisites, and this course is accessible to beginners.

    Objectives

    • Create and manage datasets in accordance with good modelling practice
    • Designe hard-hitting, dynamic reports
    • Use the service for collaboration and distribution

    Evaluation methods

    Practical work.

    Certification

    At the end of the course, trainees will be invited to take a skills test. If they pass, they will be awarded the “Power BI” certification, issued by Hexagone Executive.

    Programme

    1. Creating a data model
      • Introduction and the concept of “Self-BI”
      • Discovering the Power Query interface
      • Connecting to data sources
      • Setting up various transformations
      • Defining a star model and its importance
      • Creating a table of dates
      • Starring the data model
      • Cleaning up the data model
      • Introduction to measurements
      • Creating measurements using the DAX language
      • Creating time calculations
    2. Creating reports
      • Connecting to an existing dataset; Adding and formatting visuals for the report
      • Modifying the interaction between visuals
      • Using slicers for filtering
      • Configuring navigation
      • Implementing custom tooltips
      • Managing drillthrough
      • Implementing conditional formatting
    3. Using the Power BI service
      • Publishing the dataset in the Power BI service
      • Understanding what a dashboard is
      • Creating and configuring a dashboard
      • Discovering the “gateway” concept
      • Automating dataset refresh from the service
      • Sharing content within the organisation
      • Setting up RLS (line-level security)

    Register to a session

    999 999

    ₸

    Per trainee

    Request a quote

    Intra-company

    Would you like to organise this training course in your company? Contact us for more information.