Power BI User Specialist (Academy) (conducted in English) kursus

You will learn

Self-service business intelligence (BI) is an approach to data analytics that enables business users to access and work with corporate data even if they do not have a background in statistical analysis, BI or machine learning. Self-service BI tools allow users to filter, sort, analyze and visualize data without involving the organization's BI and IT teams.

You will be able to gain valuable insights in corporate data and you will be able to use your insights to make decisions on both strategic and operational level.

More and more companies are working towards the use of self-service business intelligence focusing on data-driven solutions and decisions and Microsoft Power BI is one of the market leading tools for self-service business intelligence solutions. With this tool you can load and transform your data for analysis and you can create reports and dashboards that you can share with your organization to support data-driven decisions.

To develop solutions with Microsoft Power BI you need to know about different types of data models, and you need to know how to create expressions with DAX to enhance your data models. Finally you need to know how to design reports presenting data in a user friendly and intuitive way.

We have developed this Power BI User Specialist Academy to teach you the skills needed to work with Business Intelligence with Power BI efficiently in a modern data-driven organization.

On the course, you will learn to
  • Design data models using the Star Schema Model
  • Extract data with T-SQL
  • Load and transform data with Power Query
  • Design efficient data models for data analytics
  • Use DAX for calculations e.g. time intelligence
  • Design reports and formatting visuals
  • Use drill through and bookmarks in reports
  • Design dashboards
  • Use the Power BI Cloud Service to share reports and dashboards
In the section, ”Course Details” below, you will find more details about the content of this course in Power BI.

You get

During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off course Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.

After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

To get the best of this course we expect that you have a good knowledge of Excel and basic knowledge of Excel formulas.

Course Details

Data modelling and querying data - 2 days
In this module you learn how to query relational databases using T-SQL. You learn about different database designs and you learn how to query data from multiple tables, and you learn how to filter data and use aggregate functions.

The following will be covered:
  • Introduction to relational databases and designs
  • Simple queries with T-SQL
  • Filtering data
  • Querying multiple tables
  • Calculated columns
  • Aggregate functions

Power BI - 3 days
In this module you learn how to use applications and services in Power BI. You learn how to create and design data models using the Star Schema Model for efficient data analysis. You will learn to create reports and analyze data with Power BI Desktop. You learn how to prepare and transform data from different data sources with Power Query and you learn how to publish your reports to the Power BI Cloud Service and use these for dashboards that you can share in your organization for valuable insights and decisions.

The following will be covered:
  • Creating data models with Power BI Desktop
  • Introduction to the Star Schema Model
  • Transforming and cleaning data with Power Query
  • Creating calculated columns and measures using DAX
  • Designing reports and formatting visuals
  • Reports with drill through and bookmarks
  • Publishing reports to the Power BI Cloud Service
  • Refreshing data in the Power BI Cloud Service
  • Creating and sharing dashboards
  • Access to reports and dashboards in Power BI Cloud Service

Advanced DAX - 2 days
In this module you learn how to use DAX for advanced calculations and data models. You will learn the concept of evaluation context and you will learn the difference between row -and filter context and you will learn how to use context transition. You will learn how to use numerous DAX functions to work with tables and time intelligence.

The following will be covered:
  • Evaluation context
  • The function CALCULATE
  • Filter functions
  • DAX and variables
  • Calculated tables
  • DAX and relationships
  • Time intelligence functions
  • DAX queries

Hvad siger vores kunder om os?

Se vores google reviews

Se vores Trustpilot reviews

Se vores facebook Reviews

Google Bussiness har vi en score på 4,8 af 5 fordelt på 132 Reviews

Trustpilot har vi en score 4,7 af 5 fordelt på 153 Reviews

Facebook har vi en score på 4,9 af 5 fordelt på 90 Reviews

  Se alle vores Reviews   

 

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
Tirsdag: 08.30 - 16.30
Onsdag: 08.30 - 16.30
Torsdag: 08.30 - 16.30
Fredag: 08.30 - 16.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K