BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Fifalde - ECPv6.15.17.1//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:Fifalde X-ORIGINAL-URL:https://fifalde.ca X-WR-CALDESC:Events for Fifalde REFRESH-INTERVAL;VALUE=DURATION:PT1H X-Robots-Tag:noindex X-PUBLISHED-TTL:PT1H BEGIN:VTIMEZONE TZID:America/Toronto BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20290311T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20291104T060000 END:STANDARD BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20300310T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20301103T060000 END:STANDARD BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20310309T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20311102T060000 END:STANDARD END:VTIMEZONE BEGIN:VEVENT DTSTART;VALUE=DATE:20300101 DTEND;VALUE=DATE:20300102 DTSTAMP:20260407T015838 CREATED:20211118T111339Z LAST-MODIFIED:20211118T115207Z UID:8647-1893456000-1893542399@fifalde.ca SUMMARY:Microsoft Power BI *(Advanced) DESCRIPTION:1. Introduction to the course syllabus\nThis document provides the detailed outline of the 2-day Microsoft Power BI Advanced course. Upon registering for the course\, you will be provided you with: \n\n\nCourse syllabus\nPresentation material\nExercise material\n\n\nPower BI is a radically new tool in the hands of business enterprises who are overwhelmed with the amount of data at hand and until now did not have a cost-effective tool to extract insights from it. \nUpon the completion of this Power BI course online\, as a trained professional\, you can start using this BI tool\, which is a set of tools and applications that let you extract data from multiple unrelated sources and convert it into a neatly managed and coherent set of information\, visually appealing insights\, interactive data\, charts\, graphs\, and reports\, etc. \nToday\, all business enterprises and departments need extensive business insights\, and this Business Intelligence tool puts the power in your hands. You can easily work with multiple sources of data\, convert the data into a report\, graph\, or data visualization as needed. By deploying Power BI\, you get real-time insights and can deploy them faster than any other BI tool available in the market. It is open-source and highly intuitive and does not need technical knowledge or IT support. \n2. Course preparation\nThe Intermediate level Power BI course is a prerequisite for this Advanced level course. \n3. Administrative and logistical activities\nThere is no specific administrative nor logistical activities for this course. \n4. Target group\nThe target group of the IT Security Planning training is drawn from: \n\n\nAnalysts\nData analytics professionals\nAccountants\nReport builders\n\n\n5. Course objectives\nThis training course is intended to help participants understand and become familiar with the different concepts with regard to…. \nThe following are the course objectives: \n\n\nUse advanced functionalities in Power Query Editor and M language to prepare and transform data\nUnderstand the different relationship types in data modelling\nBuild a DAX Reference Tool: understand and use DAX most common functions to create reports with advanced analytics\nPublish in Power BI Service with Row-Level Security roles\nDevelop a learning strategy to pursue M and DAX learning\n\n\nFor virtual training\, it is recommended to have access to 2 monitors: using a laptop and a second monitor is adequate. With this setting\, participants may display the instructor desktop on one monitor and complete activities on the other monitor. \n6. Delivery method\n6.1 Educational alternatives\nThis course was designed so that it makes use of the following educational alternatives: \n\n\nDeduction: Using anecdotes and examples\, the training presents use cases before the concepts have even been covered. The students deduct the learning from their own analysis. The topic and its concepts are presented afterwards to demonstrate how theory applies to what was deducted.\nQuestioning: Asking questions forces participants to stop and think about different variables. It also enables the participants to put the newly acquired knowledge to the test. Quizzes have been incorporated as part of the training to make sure that the concepts are well understood by the participants.\nDemonstrating: Some use cases have been incorporated to the training AFTER the concepts. These serve to explain a cause and effect relationship using the newly acquired knowledge.\n\n\n7. Session plans\nThe following provides individual session objectives for the different modules covered in the training. \nCourse Outline:\n1. Power Query and M language \n\n\nExplore Power Query Editor environment: Menus\, Applied Steps\, Advanced Editor\nExplore M language syntax\nExplore the different ways to get data: import\, direct query\, live connection\nDiscuss query folding and incremental refresh\nEdit a query: remove columns\, extract text after delimiter\, add a conditional column\, add a computed column\, filter\, unpivot columns\, group by\, drill down\nManage an error message\nEdit an Applied Step using M language\nCreate Values\, Lists and tables from blank queries\nUse M functions: List.Dates\, #date\, Duration.Days\, #duration\, DateTime.LocalNow()\, etc.\nCreate a dynamic custom date table\nSearch the web to resolve issues\nExplore recommended web resources\n\n\n2. Understand relationship types in data modelling \n\n\nExplore data model and table relationships concept\nVisualize the impact of wrong relationships\nCreate relationships: edit type and filter direction\nUse and understand the impact of Many-to-Many relationships\nFavor a star schema data model\n\n\n3. Build a DAX reference tool \n\n\nUnderstand DAX basic concepts\, the syntax and the evaluation context\nDifferentiate measures and calculated columns\nCreate explicit measures with DAX functions: TODAY\, YEAR\, MONTH\, FORMAT\, COMBINEVALUES\, COUNTA\,\nCOUNTBLANK\, COUNTROWS\, DISTINCTCOUNT\, SUM\, SUMX\, AVERAGEX (iterator function)\, MAX\, FILTER\, CALCULATE\, ALL\, ALLEXCEPT\, DIVIDE\, USERELATIONSHIP\, IF\, AND\, OR\, SELECTEDVALUE\, TOTALYTD\, SAMEPERIODLASTYEAR\nUse the CALCULATE function to override the relationships and manipulate the filter context\nDeal with an inactive relationship\nFormat measures\nUse Variables in DAX formulas\nExplore recommended web resources\n\n\n4. Create reports using advanced functionalities \n\n\nImport custom visuals\nExplore the AI tools: create visuals with Quick Insights and Q&A\nAddress complex analytics with grouping\, binning\, clustering\, time series analysis\nEnhance the end-user experience with hierarchies\, drill through\, drill down\, Tooltip pages\nProgram Row-Level Security roles to enable partial data availability to specific groups or individuals\n\n\n5. Power BI Service workflow \n\n\nWorkspace\, dataset\, report\, dashboard\, app\nchedule refresh\nSet permissions and access\nManage Row-Level Security roles\n\n\nFor more information\, please see the Microsoft-Power-BI-Advanced-course syllabus-EN-V1.0.pdf \nRegister Your Interest or get more info ×You didn't see a suitable course listed or you just want more info\n\n\n \n Name of the training you are interested in*Organization name*Your Name*\n \n \n \n First\n \n \n \n \n Last\n \n \n Email*\n \n I would like to complete the course within:\n \n \n This month\n \n \n \n Next month\n \n \n \n 3 months\n \n \n \n 6 months\n How many people would take this course?\n \n \n 1\n \n \n \n 2\n \n \n \n 3\n \n \n \n 4\n \n \n \n 5+\n Online course & private training\n \n I would consider an online course\n \n \n I would consider a private training\n CommentsMath Test!*10+2 x 2=?CAPTCHA\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nClose URL:https://fifalde.ca/competence/microsoft-power-bi-advanced/ CATEGORIES:Analytics & Data Management END:VEVENT END:VCALENDAR