Get your Microsoft MCSA: BI Reporting training and certification in just 4 days and learn more than you could imagine.

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. Also this course gives students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

After completing this course, students will be able to:

Perform Power BI desktop data transformation.

Describe Power BI desktop modelling.

Create a Power BI desktop visualization.

Implement the Power BI service.

Describe how to connect to Excel data.

Describe how to collaborate with Power BI data.

Connect directly to data stores.

Describe the Power BI developer API.

Describe the Power BI mobile app.

Explore and extend a classic Excel dashboard.

Explore and extend an Excel data model.

Pre-format and import a .CSV file.

Import data from a SQL Server database

Import data from a report.

Create measures using advanced DAX functions.

Create data visualizations in Excel.

Create a Power BI dashboard with Excel.

At Readynez, we know your time is valuable. That's why we give you the opportunity to gain your Microsoft MCSA: BI Reporting training and certification in just 4 days. We provide the best conditions for you to learn.

With us by your side, encouraging and guiding you along the way, you can enjoy 4 intense, focused days of quality learning in a distraction free environment. Your expert instructor will be working with Readynez's unique accelerated learning methods, which include our exclusive lecture/lab/review methodology with real life cases putting you in the best possible position to learn and retain knowledge.

Sitting your Microsoft MCSA: BI Reporting course with Readynez means:

You'll get more hours of training per day, allowing you to get trained and certified faster and more cost-effectively than with any other training provider.

You will be trained by one of the most expert instructors in the world.

You can focus purely on learning in our distraction free environment.

Dedicated onsite support and access to your classroom at all hours.

The price you pay is all-inclusive and covers all course materials, exam, accommodation, meals and transportation service.

The Certification Guarantee allows you to train again for free, if you do not pass first time. You only pay for any exams and labs, and accommodation.

We have designed our course material in the way that best prepares you to learn and pass your exam.

Course 20778A: Analyzing Data with Power BI

Module 1: Introduction to Self-Service BI Solutions

Introduces business intelligence (BI) and how to self-serve with BI.

Lessons

Introduction to business intelligence

Introduction to data analysis

Introduction to data visualization

Overview of self-service BI

Considerations for self-service BI

Microsoft tools for self-service BI

Lab : Exploring an Enterprise BI solution

Viewing reports

Creating a Power BI report

Creating a Power BI dashboard

After completing this module, students will be able to:

Describe the trends in BI

Describe the process of data analysis in Power BI.

Use the key visualizations in Power BI.

Describe the rationale for self-service BI.

Describe considerations for self-service BI.

Understand how you can use Microsoft products to implement a BI solution.

Module 2: Introducing Power BI

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Lessons

Power BI

The Power BI service

Lab : Creating a Power BI dashboard

Connecting to Power BI data

Create a Power BI dashboard

After completing this module, students will be able to:

Develop reports using the Power BI Desktop app.

Use report items to create dashboards on the Power BI portal.

Understand the components of the Power BI service including licensing and tenant management.

Module 3: Power BI

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Lessons

Using Excel as a data source for Power BI

The Power BI data model

Using databases as a data source for Power BI

The Power BI service

Lab : Importing data into Power BI

Importing Excel files into Power BI

Viewing reports from Excel files

After completing this module, students will be able to:

Describe the data model and know how to optimize data within the model.

Connect to Excel files and import data

Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector

Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups.

Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, buil-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.

Lessons

Power BI desktop queries

Shaping data

Combining data

Lab : Shaping and combining data

Shape power BI data

Combine Power BI data

After completing this module, students will be able to:

Perform a range of query editing skills in Power BI

Shape data, using formatting and transformations.

Combine data together from tables in your dataset.

Module 5: Modelling data

This module describes how to shape and enhance data.

Lessons

Relationships

DAX queries

Calculations and measures

Lab : Modelling Data

Create relationships

Calculations

After completing this module, students will be able to:

Describe relationships between data tables.

Understand the DAX syntax, and use DAX functions to enhance your dataset.

Create calculated columns, calculated tables and measures.

Module 6: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Lessons

Creating Power BI reports

Managing a Power BI solution

Lab : Creating a Power BI report

Connecting to Power BI data

Building Power BI reports

Creating a Power BI dashboard

After completing this module, students will be able to:

Use Power Bi desktop to create interactive data visualizations.

Manage a power BI solution.

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons

Cloud data

Connecting to analysis services

Lab : Direct Connectivity

Direct connectivity from Power BI desktop

Direct connectivity from the Power BI service

After completing this module, students will be able to:

Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop

Udfyld venligst de tomme felter for at gøre formularen klar til at sende.

Din besked er sendt

Sådan! Din chef har fået besked om din interesse for dette kursus.

YOUR BENEFITS!

Effective instruction must be highly varied and interactive to keep attention levels high, promote learning and teamwork between the students and instructor, and solidify knowledge through hands-on learning.
That's the Readynez way.

Your personal benefits

1

Your Microsoft Training programme will get you trained and certified in fewer days with more training hours per day than any other provider

2

Maximum learning in a distraction free environment

3

Dedicated, onsite support at all hours

4

Advanced career opportunities with official certification

5

Improved knowledge and confidence

6

Instructors with real-world experience – you will learn about real-world problems and solutions to strengthen your understanding and skill level

7

We help you study - our focus is on real learning, not just the course, so we support you to make the most of the course

“Simply put, Readynez combines professionalism, extraordinary good instructor and a relaxed environment, to put you in a state to perform your very best.”

Microsoft MCSA: SQL Business Intelligence Development

Per Gustavsson

Combitech

“Would definitely recommend Readynez to fellow work mates and friends. Super educational experience where everything that can be done to made you feel comfortable and immersed in an academic environment is done. Its the real deal and I wouldn't hesitate coming back for another course. Bring on the next course certification.”

Microsoft MCSA: SQL Business Intelligence Development

I.R.

“Simply put, Readynez combines professionalism, extraordinary good instructor and a relaxed environment, to put you in a state to perform your very best.”

Microsoft MCSA: SQL Business Intelligence Development

Per Gustavsson

Combitech

“This is my second time attending a course provided by Readynez training and I see consistency in quality of instructors, facilities and everything around the training is provided so I can focus on what is important.”

Microsoft MCSA: SQL Business Intelligence Development

Jimmy Johansson

Microsoft

Microsoft

Readynez has been awarded with the Microsoft Learning Partner award in Denmark no less than 5 times as the first and only education partner ever!

Plus - in 2017 we were named among 2800 partners worldwide as a finalist for the Microsoft Global Learning Partner of the Year!

WHAT'S INCLUDED

Everything! In addition to your all-inclusive course package specifically designed to your
requirements, we go the extra mile to make sure you have everything you need and will
attend to every detail, so you can focus solely on your studies.

Wherever you are in the world, you can experience a distraction-free environment by staying in one of our purpose-built training centres. To make it easy for you to train with us, we offer your a transporation service.
We´ll pick you up and drop you off after your course, from/to designated pick-up points - so you won´t have to think about how to reach us or get back home.

Accommodation

Our unique accelerated learning methodology offers you maximum knowledge within minimum time in a distraction-free environment.

You´ll be staying in a comfortable single room with private bathroom facilities and all amenities taken care of. Your room is on site, very close to your classroom, so you won´t be wasting any energy on gettting to and from.

Hands-on training

With Readynez you will learn by doing.

We help you study - our focus is on real learning and your expert Instructor will be teching you using our unique lecture/lab/review methodology that helps you learn more and retain knowledge better.

All course materials

All course materials are included in your course fee. There is no hidden cost.

We supplement the full courseware with our expert guidance and relevant, real-world situational reviews empowering your business to get real business value from this course.

Instructor-led programme

We provide the best conditions for you to learn.

Your training is in safe hands with us. We use the best instructors in the world, who will be using our unique accelerated learning methods to teach you. With our guidance you will be maximising your learning and be able to put your new skills to use in no time.

24 hour classroom access

Train as it suits you.

When you´re staying with us - there will be no limits to your learning. Your classroom will be open at all hours, so you have complete freedom to train and review as you please, without being limited by schedules.

All meals

We´ll take good care of you.

Your training days start with a full breakfast in the dining room, with its fantastic view of Oresund. Mornings and afternoons, good coffee and home-baked coffee bread will be served. Later, lunch is served and in the evening, you will enjoy your dinner as the sun sets over Denmark.

Certification guarantee

If the unlikely thing happens, and you don´t pass first time.

The Certification Guarantee allows you to train again for free in a 12 month period, if you do not pass first time. You only pay for any exams, labs and accommodation.

Onsite testing

Examination as part of your course.

As a part of your course, you will take your exams on site before you leave the course centre. This way, you are tested while knowledge and exam technique are fresh in your mind and you have the best possible chance of passing.

What do you get?

As part of your course, you will be prepared for, and tested in, the following exam, which is covered by your Certification Guarantee: