{"course":{"productid":34654,"modality":1,"active":true,"language":"en","title":"Master Class: Develop a Reporting Solution with Power BI","productcode":"DRSPBI","vendorcode":"MT","vendorname":"Master Class","fullproductcode":"MT-DRSPBI","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/masterclass-drspbi","objective":"<p>Basic knowledge of SQL, basic knowledge of data modeling<\/p>","essentials":"<p>Basic knowledge of SQL, basic knowledge of data modeling<\/p>","audience":"<p>Database developer, data analyst, business analyst, Excel power user<\/p>","contents":"<ul>\n<li>Overview of the Power BI architecture<\/li><li>Data connection concepts\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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>","summary":"<ul>\n<li>Overview of the Power BI architecture<\/li><li>Data connection concepts\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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\n<ul>\n<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>","objective_plain":"Basic knowledge of SQL, basic knowledge of data modeling","essentials_plain":"Basic knowledge of SQL, basic knowledge of data modeling","audience_plain":"Database developer, data analyst, business analyst, Excel power user","contents_plain":"- Overview of the Power BI architecture\n- Data connection concepts\n\n- Overview of Power BI connectors\n- Getting to know the connection types Import, Direct Query, and Live Query\n- Cleaning, transforming, and loading data in Power BI\n\n- Overview of the Power Query Editor\n- Transformation options in the Power Query Editor\n- Introduction to the formula language M\n- Data connection and transformation with Python\n- Data profiling\n- Designing a data model\n\n- Introduction to Data Modeling 3NF vs. Star Schema\n- Creating relationships between tables\n- Defining keys, hierarchies, and time dimensions\n- Configuring tables and column properties\n- Model extensions with DAX\n\n- Introduction to DAX\n- Using DAX for model extension and KPI calculation\n- Creating derived columns, measures, and tables with DAX\n- Introduction to the DAX language (including Related, Calculate, etc.)\n- Creating reports and dashboards\n\n- Getting to know the standard visuals\n- Data restriction with filters, slicers, cascading\n- Cross-report navigation with buttons and bookmarks\n- Controlling the interaction of visuals\n- AI-Features in Power BI\n\n- Natural Language Query (NLQ) in Power BI\n- Anomaly detection\n- Identification of key influencers\n- Decomposition tree analysis\n- Creating mobile reports for smartphones and tablets\n- Creating paginated reports\n- Deployment of reports and dashboards\n\n- Deployment on SSRS for Power BI and in the cloud\n- Administration of reports\n- Setup of automated data updates\n- Setting up row-level security","summary_plain":"- Overview of the Power BI architecture\n- Data connection concepts\n\n- Overview of Power BI connectors\n- Getting to know the connection types Import, Direct Query, and Live Query\n- Cleaning, transforming, and loading data in Power BI\n\n- Overview of the Power Query Editor\n- Transformation options in the Power Query Editor\n- Introduction to the formula language M\n- Data connection and transformation with Python\n- Data profiling\n- Designing a data model\n\n- Introduction to Data Modeling 3NF vs. Star Schema\n- Creating relationships between tables\n- Defining keys, hierarchies, and time dimensions\n- Configuring tables and column properties\n- Model extensions with DAX\n\n- Introduction to DAX\n- Using DAX for model extension and KPI calculation\n- Creating derived columns, measures, and tables with DAX\n- Introduction to the DAX language (including Related, Calculate, etc.)\n- Creating reports and dashboards\n\n- Getting to know the standard visuals\n- Data restriction with filters, slicers, cascading\n- Cross-report navigation with buttons and bookmarks\n- Controlling the interaction of visuals\n- AI-Features in Power BI\n\n- Natural Language Query (NLQ) in Power BI\n- Anomaly detection\n- Identification of key influencers\n- Decomposition tree analysis\n- Creating mobile reports for smartphones and tablets\n- Creating paginated reports\n- Deployment of reports and dashboards\n\n- Deployment on SSRS for Power BI and in the cloud\n- Administration of reports\n- Setup of automated data updates\n- Setting up row-level security","skill_level":"Intermediate","version":"1.0","duration":{"unit":"d","value":5,"formatted":"5 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":4995},"AT":{"country":"AT","currency":"EUR","taxrate":20,"price":4995},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":4995},"GB":{"country":"GB","currency":"GBP","taxrate":20,"price":4160},"SI":{"country":"SI","currency":"EUR","taxrate":20,"price":4995},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":4995}}},"lastchanged":"2026-03-04T21:02:59+01:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/34654","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/masterclass-drspbi"}}