BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Dynaas Training - ECPv6.15.18//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Dynaas Training
X-ORIGINAL-URL:https://training.dynaas.com
X-WR-CALDESC:Events for Dynaas Training
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Africa/Casablanca
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:+00
DTSTART:20250223T020000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:+01
DTSTART:20250406T020000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:+00
DTSTART:20260215T020000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:+01
DTSTART:20260322T020000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:+0100
TZOFFSETTO:+0000
TZNAME:+00
DTSTART:20270207T020000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0100
TZNAME:+01
DTSTART:20270314T020000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20260415
DTEND;VALUE=DATE:20260418
DTSTAMP:20260406T061711
CREATED:20260227T144819Z
LAST-MODIFIED:20260302T093808Z
UID:6571-1776211200-1776470399@training.dynaas.com
SUMMARY:PL-300: Design and manage analytics solutions using Power BI
DESCRIPTION:Overview \nThis training covers a range of methods and best practices aligned with business and technical requirements for data modeling\, visualization\, and analysis using Power BI. It also explains how to access and process data from a variety of sources\, including both relational and non-relational data. The training explores how to implement appropriate security standards and policies across the Power BI ecosystem\, including datasets and workspaces. It also covers managing and deploying reports and dashboards for content sharing and distribution. \nTarget Audience \nThis training is intended for data and business intelligence professionals who want to learn how to perform accurate data analysis using Power BI. It is also designed for those who build reports that visualize data from data platform technologies\, both in the cloud and on-premises. \nPrerequisites \nSuccessful data analysts typically start this role with experience working with data in the cloud. More specifically: \n\nUnderstanding of basic database concepts\nKnowledge of using relational data in the cloud\nKnowledge of using non-relational data in the cloud\nKnowledge of data analysis and data visualization concepts\n\nObjectives \n\nAcquire\, clean\, and transform data\nModel data for performance and scalability\nDesign and build reports for data analysis\nApply and perform advanced report analytics\nManage and share report assets\n\nContent \nModule 1: Get started with Microsoft data analytics \nThis module explores different roles in the data space\, highlights the key responsibilities of a data analyst\, and introduces the Power BI portfolio.\nLessons \n\nData analytics and Microsoft\nGetting started with Power BI\n\nModule 2: Get data in Power BI \nThis module covers identifying and retrieving data from various sources. You will also learn about connectivity and storage options\, and understand the differences and performance implications between direct connections and importing data.\nLessons \n\nData analytics and Microsoft\nPerformance optimization\nTroubleshooting data errors\nLab: Prepare data in Power BI Desktop\nPrepare the data\n\nModule 3: Clean\, transform\, and load data in Power BI \nThis module teaches how to profile data and understand its condition. You will learn to identify anomalies\, consider data size and shape\, and apply proper cleaning and transformation steps before loading data into the model.\nLessons \n\nData shaping\nData profiling\nEnhancing data structure\nLab: Load data in Power BI Desktop\nLoad the data\n\nModule 4: Design a data model in Power BI \nThis module teaches the fundamentals of designing and developing a data model for proper performance and scalability. It also addresses common modeling challenges such as relationships\, security\, and performance.\nLessons \n\nIntroduction to data modeling\nWorking with tables\nDimensions and hierarchies\nLab: Data modeling in Power BI Desktop\nCreate model relationships\nConfigure table and column properties\nCreate hierarchies\n\nModule 5: Create model calculations using DAX in Power BI \nThis module introduces DAX and how it strengthens a model. You will learn about aggregations\, measures\, calculated columns and tables\, and time intelligence functions for calculation and analysis scenarios.\nLessons \n\nIntroduction to DAX\nReal-time dashboards\nAdvanced DAX\nLab: Introduction to DAX in Power BI Desktop\nCreate calculated tables\nCreate calculated columns\nCreate measures\nLab: Advanced DAX in Power BI Desktop\nUse CALCULATE() to modify filter context\nUse time intelligence functions\n\nModule 6: Optimize model performance in Power BI \nThis module focuses on best practices—steps\, processes\, concepts\, and modeling techniques—to optimize a data model for enterprise-level performance.\nLessons \n\nOptimize the data model for performance\nOptimize DirectQuery models\n\nModule 7: Create reports in Power BI \nThis module introduces core principles of report design and creation\, including selecting the right visuals\, designing layouts\, and applying essential features. Accessibility design is also covered.\nLessons \n\nCreate a report\nEnhance the report\nLab: Enhance reports with interaction and formatting in Power BI Desktop\nCreate and configure slicer synchronization\nCreate a drill-through page\nApply conditional formatting\nCreate and use bookmarks\nLab: Report design in Power BI Desktop\nCreate a report\nConfigure visual fields and formatting properties\n\nModule 8: Create dashboards in Power BI \nThis module teaches how to tell a compelling story using dashboards and navigation tools. You will explore features and techniques to improve dashboard usability and insights.\nLessons \n\nCreate a dashboard\nReal-time dashboards\nEnhance a dashboard\nLab: Create a dashboard in Power BI Service\nCreate a dashboard\nPin visuals to a dashboard\nUse Q&A to create a dashboard tile\n\nModule 9: Identify patterns and trends in Power BI \nThis module helps you apply additional features to enhance reports and generate stronger insights. You will also learn steps to perform advanced analytics using AI visuals for deeper understanding of the data.\nLessons \n\nAdvanced analytics\nData insights through AI visuals\nLab: Data analysis in Power BI Desktop\nCreate animated scatter charts\nUse a visual to forecast values\n\nModule 10: Create and manage workspaces in Power BI \nThis module introduces workspaces and teaches how to create and manage them. You will also learn how to share content such as reports and dashboards\, and how to distribute an app.\nLessons \n\nCreate workspaces\nShare and manage assets\n\nModule 11: Manage files and datasets in Power BI \nThis module introduces parameters and datasets. You will learn how to manage datasets and parameters\, build dynamic reports with parameters\, and configure dataset refresh options.\nLessons \n\nParameters\nDatasets\nAfter completing this module\, students will be able to:\nManage datasets and parameters\nCreate dynamic reports with parameters\nSchedule dataset refresh\nTroubleshoot gateway connectivity issues\n\nModule 12: Row-level security in Power BI \nThis module introduces row-level security (RLS)\, including both static and dynamic methods\, and how to implement it.\nLessons \n\nSecurity in Power BI\nLab: Apply row-level security\nConfigure many-to-many relationships\nApply row-level security
URL:https://training.dynaas.com/event/pl-300-design-and-manage-analytics-solutions-using-power-bi/
ATTACH;FMTTYPE=image/png:https://training.dynaas.com/wp-content/uploads/2026/02/PL_Plan-de-travail-1-copie-4.png
END:VEVENT
END:VCALENDAR