Beskrivelse
Lær hvordan du modellerer, visualiserer og analyserer data med Power BI. På kurset gennemgår vi data fra forskellige datakilder, både relationelle og ikke-relationelle data, implementering af sikkerhedsstandarder og -politikker på tværs af Power BI. Herudover lærer du at administrere og opbygge rapporter og dashboards til deling og distribuering af indhold samt sideinddelte rapporter.
Forudsætninger
Du forventes at have praktisk erfaring i arbejdet med relationelle databaser, data warehouse og rapportering. Herudover skal du have et rigtig godt kendskab til Excel.
Deltagerprofil
Kurset er for dig som arbejder med databaser og Business Intelligence, og som ønsker at lære, hvordan du kan udfører dataanalyse i Power BI. Kurset har fokus på udvikling af rapporter fra de forskellige teknologiske data platforme, der findes både i skyen og on-premise.
Udbytte
Ingest, clean, and transform data
Model data for performance and scalability
Design and create reports for data analysis
Apply and perform advanced report analytics
Manage and share report assets
Create paginated reports in Power BI
Indhold
Modul 1: Get started with Microsoft data analytics
Data Analytics and Microsoft
Getting Started with Power BI
Modul 2: Prepare Data in Power BI
...%%%
...
Get data from various data sources
Optimize performance
Resolve data errors
Modul 3: Clean, Transform, and Load Data in Power BI
Data shaping
Enhance the data structure
Data Profiling
Modul 4: Design a Data Model in Power BI
Introduction to data modeling
Working with tables
Dimensions and Hierarchies
Modul 5: Create Measures using DAX in Power BI
Introduction to DAX
DAX context
Advanced DAX
Modul 6: Optimize Model Performance
Optimze the model for performance
Optimize DirectQuery Models
Create and manage Aggregations
Modul 7: Create Reports
Design a report
Enhance the report
Modul 8: Create Dashboards
Create a Dashboard
Real-time Dashboards
Enhance a Dashboard
Modul 9: Create Paginated Reports in Power BI
Paginated report overview
Create Paginated reports
Modul 10: Perform Advanced Analytics
Advanced Analytics
Data Insights through AI visuals
Modul 11: Create and Manage Workspaces
Creating Workspaces
Sharing and Managing Assets
Modul 12: Manage Datasets in Power BI
Parameters
Datasets
Modul 13: Row-level security
Security in Power BI
Certificering Kurset leder hen mod eksamen DA-100 Analyzing Data with PowerBI. Eksamen bestilles og betales særsklit. Ved beståelse opnår du certificeringen Microsoft Certified Data Analyst Associate.
Microsoft skriver om denne eksamen:
This is the exam for the Data Analyst role and the Microsoft Certified: Data Analyst Associate certification. Data Analysts enable businesses to maximize the value of their data assets by using Power BI. As a subject matter expert, data analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Data analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.
The Data Analyst should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.
This exam measures your ability to accomplish the following technical tasks: prepare the data; model the data; visualize the data; analyze the data; and deploy and maintain deliverables.
Læs mere om IT-certificeringer her.
Underviser Undervisningen vareteages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.
