Analyzing Data with Power BI [DA-100T00]
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
- Data Analytics and Microsoft
- Getting Started with Power BI
- Get data from various data sources
- Optimize performance
- Resolve data errors
- Data shaping
- Enhance the data structure
- Data Profiling
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
- Introduction to DAX
- DAX context
- Advanced DAX
- Optimze the model for performance
- Optimize DirectQuery Models
- Create and manage Aggregations
- Design a report
- Enhance the report
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
- Paginated report overview
- Create Paginated reports
- Advanced Analytics
- Data Insights through AI visuals
- Creating Workspaces
- Sharing and Managing Assets
- Parameters
- Datasets
- 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.
Har du faglige spørgsmål, så kontakt:
- Charlotte Heimann
- Seniorspecialist
- +45 72203147