Microsoft Power BI Data Analyst
Beskrivelse
Kurset henvender sig til f.eks. data analysts og business intelligence professionals, som ønsker at dygtiggøre sig indenfor datahåndtering og dataanalyse i Power BI. Derudover er fokus på at udvikle rapporter til datavisualisering fra forskellige typer af datakilder, som kan være både i cloud og on-premise.
Du får erfaring med at tilgå og behandle data fra forskellige datakilder, både relationelle og ikke-relationelle. Desuden lærer du at implementere sikkerhedsstandarder og politikker samt at administrere datasæt og grupper i Power BI service. På kurset gennemgås også hvordan man administrerer, deployer og deler rapporter og interaktive dashboards.
Efter kurset vil du være i stand til at:
- Forbinde, rense, transformere og loade data
- Datamodellering med henblik på performance og skalerbarhed
- Lave og designe rapporter til datanalyse
- Anvende og benytte avancerede analytiske metoder i rapporter
- Administrere og dele rapporter og dashboards
Undervejs på kurset er hands-on øvelser, så du får viden og metodikker med hjem, som du kan bruge i dit arbejde i et Power BI setup. Kurset inkluderer øvelser udover Microsoft officielle, herunder om Data gateway og modeloptimering.
Certificeringspakker
Moduloversigt
- Modul 1Get started with Microsoft data analytics
Businesses need data analysis more than ever. In this learning path, you will learn about the life and journey of a data analyst, the skills, tasks, and processes they go through in order to tell a story with data so trusted business decisions can be made. You will learn how the suite of Power BI tools and services are used by a data analyst to tell a compelling story through reports and dashboards, and the need for true BI in the enterprise.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.
Lessons:
- Discover data analysis
- Get started building with Power BI
- Modul 2Prepare data for analysis with Power BI
You'll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You'll also learn to profile, clean, and load data into Power BI before you model your data.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.
Lessons:
- Get data in Power BI
- Clean, transform, and load data in Power BI
- Modul 3Model data with Power BI
Learn what a Power BI semantic model is, which data loading approach to use, and how to build out your semantic model to get the insights you need.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.
Lessons:
- Describe Power BI Desktop models
- Choose a Power BI model framework
- Design a semantic model in Power BI
- Write DAX formulas for Power BI Desktop models
- Add measures to Power BI Desktop models
- Add calculated tables and columns to Power BI Desktop models
- Use DAX time intelligence functions in Power BI Desktop models
- Optimize a model for performance in Power BI
- Enforce Power BI model security
- Modul 4Build Power BI visuals and reports
Turn data into interactive, actionable insights with Power BI Desktop visuals and reports.
Lessons:
- Scope report design requirements
- Design Power BI reports
- Configure Power BI report filters
- Enhance Power BI report designs for the user experience
- Perform analytics in Power BI
- Create paginated reports
- Modul 5Manage workspaces and datasets in Power BI
In this Learning Path, you'll learn how to publish Power BI reports to the Power BI service. You'll also learn how to create workspaces, manage related items, and data refreshes for up-to-date reports. Additionally, implement row-level security to restrict user access to relevant data without the need for multiple reports.This learning path can help you prepare for theMicrosoft Certified: Data Analyst Associate certification.
Lessons:
- Create and manage workspaces in Power BI
- Manage semantic models in Power BI
- Create dashboards in Power BI
- Implement row-level security
Er du i tvivl?
Det ligger os meget på sinde, at du finder det kursusforløb, der skaber størst værdi for dig og din arbejdsplads. Tag fat i vores kursusrådgivere, de sidder klar til at hjælpe dig!