Course: Data Analytics with Microsoft Power BI

$159.00
$192.39 incl. vat

ADD_TO_CART_INFO_FOR_BUSINESS

duration: 7 hours |

Language: English (US) |

access duration: 90 days |

Details

In this course you will learn to manage and analyze data using Micrsoft Power BI. You will learn the various concepts, searching data, data modeling and virtualization.

Among subjects that covered are Power BI app, Power BI groups, Power BI Gateway, append query, DAX and far more.

Result

After completing this course you are familiar with managing and analyzing data using Power BI.

Prerequisites

You have basic knowledge of working with data.

Target audience

Database Administrators

Content

Data Analytics with Microsoft Power BI

7 hours

Data Analytics using Power BI: Concepts

  • start the course
  • describe the purpose of business intelligence
  • determine what data is telling you
  • describe how data visualizations can convey meaningful messages
  • use self-provisioning to work with Power BI
  • define Excel functionality related to Power BI
  • recognize Power BI capabilities
  • explain what the Power BI cloud service is used for
  • create a personal Power BI service account
  • explain what Power BI desktop is used for
  • install Power BI Desktop
  • use mobile device apps to interact with Power BI dashboards and reports
  • install the Power BI app on Windows 10
  • determine which region your Power BI tenancy exists in
  • recognize when to use Power BI groups
  • describe Power BI concepts and establish data sources

Data Analytics Using Power BI: Data Sourcing and Preparation

  • start the course
  • describe where Power BI data comes from
  • recognize how Power BI can use data from files
  • recognize how Power BI can use data from databases
  • recognize how Power BI can use data from online sources
  • use Quick Insights in the Power BI Service to quickly generate interactive data visualizations
  • import a file data source into Power BI
  • import a database data source into Power BI
  • import a web URL data source into Power BI
  • recognize the purpose of the Power BI Gateway
  • configure the Power BI on-premises Gateway
  • describe why data in its raw form is sometimes not suitable for use with Power BI
  • determine when the use of queries is appropriate
  • recognize when data should be combined
  • explain how row values can be grouped together and how rows can be filtered out to remove unnecessary data
  • create an append query
  • create a merge query
  • filter out rows that are unnecessary
  • create a calculated column
  • ensure data is in a form usable by Power BI for querying and visualization

Data Analytics Using Power BI: Data Modeling and Visualization

  • start the course
  • recognize when to use Data View in Power BI Desktop
  • recognize when to use Relationship View in Power BI Desktop
  • navigate through Desktop View in Power BI Desktop
  • navigate through Relationship View in Power BI Desktop
  • explain the purpose of DAX, including syntax
  • create a DAX measure formula
  • define how visualization can quickly convey messages from large datasets
  • explain how KPIs are used to measure progress
  • explain how to work with and create reports
  • create a report in Power BI
  • explain how dashboards can be used to monitor data at a glance
  • create a custom Power BI dashboard
  • share a Power BI dashboard with other users
  • filter visualizations using slicers
  • ensure data is in a form usable by Power BI for querying and visualization

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

read more about the order process

What is included?

Certificate of participation Yes
Monitor Progress Yes
Award Winning E-learning Yes
Mobile ready Yes
Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Service World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact