Kurser

Kursusadministration

Brug for hjælp?

  • Gregersensvej 8
  • 2630 Taastrup
Google MapsApple MapsRejseplanen
  • Forskerparken Fyn, Forskerparken 10F
  • 5230 Odense M
Google MapsApple MapsRejseplanen
  • Teknologiparken Kongsvang Allé 29
  • 8000 Aarhus C
Google MapsApple MapsRejseplanen
  • NordsøcentretPostboks 104
  • 9850Hirtshals
Google MapsApple MapsRejseplanen
  • Gammel Ålbovej 1
  • 6092Sønder Stenderup
Google MapsApple MapsRejseplanen

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

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 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.

Har du faglige spørgsmål, så kontakt: