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:20200308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20201101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20210314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20211107T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20220313T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20221106T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20230312T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20231105T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20240310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20241103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20280312T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20281105T060000
END:STANDARD
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;TZID=America/Toronto:20210415T080000
DTEND;TZID=America/Toronto:20301231T170000
DTSTAMP:20260501T013846
CREATED:20210415T194336Z
LAST-MODIFIED:20211118T115345Z
UID:7737-1618473600-1924966800@fifalde.ca
SUMMARY:Microsoft Power BI (Intermediate)
DESCRIPTION:1.     Introduction to the course syllabus\nThis document provides the detailed outline of the 2-day Microsoft Power BI Intermediate 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 Beginner level Power BI course is a prerequisite for this Intermediate 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\n Analysts\n Data 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\nUnderstand the different relationship types in data modelling\nBuild a DAX Reference Tool: understand and use DAX most common functions\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\nConnect to a folder and combine files\nExplore Power Query Editor environment: Menus\, Applied Steps\, Advanced Editor\nExplore M language syntax\nEdit a query: remove columns\, extract text after delimiter\, add a conditional 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()\, Date.AddYears()\, Date.EndOfYear()\, Date.From()\nCreate a dynamic date list\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\nEdit model queries to eliminate Many-to-Many relationship\n\n\n3. Build a DAX reference tool \n\n\nUnderstand DAX basic concepts and syntax\nDifferentiate measures and calculated columns\nUse DAX functions: TODAY\, YEAR\, MONTH\, FORMAT\, COMBINEVALUES\, COUNTA\, COUNTBLANK\, COUNTROWS\, DISTINCTCOUNT\, SUM\, SUMX\, MAX\, FILTER\, CALCULATE\, ALL\, ALLEXCEPT\, DIVIDE\, USERELATIONSHIP\, IF\, AND\, OR\, SELECTEDVALUE\, TOTALYTD\, SAMEPERIODLASTYEAR\nUse CALCULATE function to override relationship\nUse Variables in DAX formulas\nUse the What If Parameter\nDeal with an inactive relationship\nSearch the web to resolve issues\nExplore recommended web resources\n\n\nFor more information\, please see the Microsoft-Power-BI-Intermediate-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=?\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-intermediate/
CATEGORIES:Analytics & Data Management
END:VEVENT
END:VCALENDAR