Course: Data Analytics with Microsoft Power BI
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
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 immediately. The lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience.
Sign In
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
Een zakelijk account aanmaken
Wanneer u besteld namens uw bedrijf doet u er goed aan om aan zakelijk account bij ons aan te maken. Tijdens het registratieproces kunt u hiervoor kiezen. U heeft vervolgens de mogelijkheden om de bedrijfsgegevens in te voeren, een referentie en een afwijkend factuuradres toe te voegen.
Betaalmogelijkheden
U heeft bij ons diverse betaalmogelijkheden. Bij alle betaalopties ontvangt u sowieso een factuur na de bestelling. Gaat uw werkgever betalen, dan kiest u voor betaling per factuur.
Cursisten aanmaken
Als u een zakelijk account heeft aangemaakt dan heeft u de optie om cursisten/medewerkers aan te maken onder uw account. Als u dus meerdere trainingen koopt, kunt u cursisten aanmaken en deze vervolgens uitdelen aan uw collega’s. De cursisten krijgen een e-mail met inloggegevens wanneer zij worden aangemaakt en wanneer zij een training hebben gekregen.
Voortgangsinformatie
Met een zakelijk account bent u automatisch beheerder van uw organisatie en kunt u naast cursisten ook managers aanmaken. Beheerders en managers kunnen tevens voortgang inzien van alle cursisten binnen uw organisatie.
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.
FAQ
Niet gevonden wat je zocht? Bekijk alle vragen of neem contact op.