Master Class: Develop a Reporting Solution with Power BI (DRSPBI) Online

Kursinhalt

• Overview of the Power BI architecture
• Data connection concepts
  • Overview of Power BI connectors
  • Getting to know the connection types Import, Direct Query, and Live Query
• Cleaning, transforming, and loading data in Power BI
  • Overview of the Power Query Editor
  • Transformation options in the Power Query Editor
  • Introduction to the formula language M
  • Data connection and transformation with Python
  • Data profiling
• Designing a data model
  • Introduction to Data Modeling 3NF vs. Star Schema
  • Creating relationships between tables
  • Defining keys, hierarchies, and time dimensions
  • Configuring tables and column properties
• Model extensions with DAX
  • Introduction to DAX
  • Using DAX for model extension and KPI calculation
  • Creating derived columns, measures, and tables with DAX
  • Introduction to the DAX language (including Related, Calculate, etc.)
• Creating reports and dashboards
  • Getting to know the standard visuals
  • Data restriction with filters, slicers, cascading
  • Cross-report navigation with buttons and bookmarks
  • Controlling the interaction of visuals
• AI-Features in Power BI
  • Natural Language Query (NLQ) in Power BI
  • Anomaly detection
  • Identification of key influencers
  • Decomposition tree analysis
• Creating mobile reports for smartphones and tablets
• Creating paginated reports
• Deployment of reports and dashboards
  • Deployment on SSRS for Power BI and in the cloud
  • Administration of reports
  • Setup of automated data updates
  • Setting up row-level security

Voraussetzungen

Basic knowledge of SQL, basic knowledge of data modeling

Zielgruppe

Database developer, data analyst, business analyst, Excel power user