DRSPBIMTMaster ClassMT-DRSPBI1.0<p>Basic knowledge of SQL, basic knowledge of data modeling</p><p>Basic knowledge of SQL, basic knowledge of data modeling</p><p>Database developer, data analyst, business analyst, Excel power user</p><ul> <li>Overview of the Power BI architecture</li><li>Data connection concepts <ul> <li>Overview of Power BI connectors</li><li>Getting to know the connection types Import, Direct Query, and Live Query</li></ul></li><li>Cleaning, transforming, and loading data in Power BI <ul> <li>Overview of the Power Query Editor</li><li>Transformation options in the Power Query Editor</li><li>Introduction to the formula language M</li><li>Data connection and transformation with Python</li><li>Data profiling</li></ul></li><li>Designing a data model <ul> <li>Introduction to Data Modeling 3NF vs. Star Schema</li><li>Creating relationships between tables</li><li>Defining keys, hierarchies, and time dimensions</li><li>Configuring tables and column properties</li></ul></li><li>Model extensions with DAX <ul> <li>Introduction to DAX</li><li>Using DAX for model extension and KPI calculation</li><li>Creating derived columns, measures, and tables with DAX</li><li>Introduction to the DAX language (including Related, Calculate, etc.)</li></ul></li><li>Creating reports and dashboards <ul> <li>Getting to know the standard visuals</li><li>Data restriction with filters, slicers, cascading</li><li>Cross-report navigation with buttons and bookmarks</li><li>Controlling the interaction of visuals</li></ul></li><li>AI-Features in Power BI <ul> <li>Natural Language Query (NLQ) in Power BI</li><li>Anomaly detection</li><li>Identification of key influencers</li><li>Decomposition tree analysis</li></ul></li><li>Creating mobile reports for smartphones and tablets</li><li>Creating paginated reports</li><li>Deployment of reports and dashboards <ul> <li>Deployment on SSRS for Power BI and in the cloud</li><li>Administration of reports</li><li>Setup of automated data updates</li><li>Setting up row-level security</li></ul></li></ul>Basic knowledge of SQL, basic knowledge of data modelingBasic knowledge of SQL, basic knowledge of data modelingDatabase developer, data analyst, business analyst, Excel power user- 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 security5 days4995.004995.004995.004160.004995.004995.00