MS Fabric – Introduction to data processing, analysis and visualization (FABA1)

Microsoft, Fabric

This course introduces Microsoft Fabric through practical exercises and demos, giving you hands-on experience with core services. You will learn to ingest, clean and integrate data using Dataflows, store and manage datasets in Datamarts, and build a reusable Semantic model for analysis.

During hands-on labs you'll build one-off and scheduled reports, create interactive dashboards and use AI report generation, learn basics of DAX for calculations, export results to Excel and share or publish reports across the Fabric workspace with governance and refresh options.

Location, current course term



Brno + online (volitelně)
11/12/2025 - 11/14/2025 CZECH
Order 		1/5/2026 - 1/7/2026 CZECH
Order
Praha + online (volitelně)
11/12/2025 - 11/14/2025 CZECH
Order 		2/4/2026 - 2/6/2026 CZECH
Order
Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Introduction to MS Fabric components for data analysis
    1. Dataflow / Dataflows
    2. Semantic model
    3. Report
    4. Dashboard
    5. Datamart
    6. OneLake
  • Creating a process for regular data refresh
    1. Possible data sources
    2. Possible data destinations
    3. Handling missing, erroneous or duplicate values
    4. Adding new columns
    5. Merging data from multiple sources
    6. Basic overview of the applied procedure
  • Building a semantic model for analysis
    1. Creating relationships
    2. Generating an automatic report using AI
    3. Exporting data to Excel
  • Creating reports and dashboards for visualization
    1. Difference between a report and a dashboard
    2. Overview of visual types and import options
    3. Adjusting visual interactions
    4. Page types and their use for advanced visuals
    5. Export options (PowerPoint, PDF, etc.)
    6. Sharing and publishing options
  • Creating a datamart to store transformed data
    1. Possible data sources
    2. Data transformation and shaping
    3. Using the datamart for reports, custom SQL or DAX analysis
    4. Visual queries via SQL generated by the datamart
  • Introduction to DAX
    1. DAX syntax
    2. Calculated columns, measures and calculated tables — principles and differences
    3. Handling errors in calculations
    4. Calculation context (filter, row and query contexts)
    5. Basic DAX functions for numbers, text and dates
    6. Filter functions
    7. Iterators (MINX, SUMX, RANKX, ISINSCOPE, etc.)
    8. Conditional calculations
Assumed knowledge:
Comfortable with MS Excel and pivot tables; basic database familiarity is helpful.
Recommended previous course:
MS Excel – Data transformation in Power Query, step by step (MSE5)
Schedule:
3 days (9:00 AM - 5:00 PM )
Course price:
576.00 € ( 696.96 € incl. 21% VAT)
Language:

Vybrané zákaznické reference

T-Mobile Czech Republic a.s., Jakub S.
MS Fabric – Introduction to data processing, analysis and visualization ( FABA1)
"skvělé, moc děkuji"
Kraj Vysočina, Michal N.
MS Fabric – Introduction to data processing, analysis and visualization ( FABA1)
"Opravdu přínosné školení. Lektor pozorný, měl zájem o věci které nás zajímají. K tomu profesionál s obecným přehledem. Jsem rád, že jsem školení absolvoval."
Kraj Vysočina, Filip Ř.
MS Fabric – Introduction to data processing, analysis and visualization ( FABA1)
"Lektor odpovídal na dotazy, včetně otázek které se nepřímo týkaly obsahu kurzu. Přínos bylo i uvedení do umělé inteligence v PowerBI Fabric. Lektor byl v problematice znalý a školení bylo maximálně přínosné. Určitě doporučuji."