BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//UOA Academy - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:UOA Academy
X-ORIGINAL-URL:https://uoa-academy.com
X-WR-CALDESC:Events for UOA Academy
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:Asia/Kuala_Lumpur
BEGIN:STANDARD
TZOFFSETFROM:+0800
TZOFFSETTO:+0800
TZNAME:+08
DTSTART:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;VALUE=DATE:20230515
DTEND;VALUE=DATE:20230517
DTSTAMP:20260505T003955
CREATED:20230416T215740Z
LAST-MODIFIED:20230420T002144Z
UID:3497-1684108800-1684281599@uoa-academy.com
SUMMARY:Analyzing Data with Power BI
DESCRIPTION:Overview\nThis two-day training provides participants with the basic knowledge and skills to create simple reports and analyse data with Power BI Desktop.\nTarget Audience\nThe target audience for this course are managers\, executives and business users who need to analyze data & create interactive reports or dashboards. \nLearning Objectives:\nAfter completing this course\, students will be able to: \n\nDescribe key features of a self-service BI solution\nDescribe Power BI and its data sources\nModel\, shape\, and combine data\nDescribe Power BI data visualizations\n\nCourse Outlines \nModule 1: Introduction to Self-Service BI Solutions\nIn this module students will be introduced to the key concepts in business intelligence\, data\nanalysis\, and data visualization. In addition\, they will learn the rationale for self-service BI\,\nconsiderations for using self-service BI\, and how Microsoft products can be used to implement\na self-service BI solution. \n\nIntroduction to business intelligence\nIntroduction to data analysis\nIntroduction to data visualization\nMicrosoft tools for self-service BI\n\nModule 2: Introducing Power BI\nThis module introduces Power BI desktop where you connect to data and build your reports. Power BI makes things visually appealing. It has an easy drag and drop functionality\, with features that allow you to copy all formatting across visualizations. \nPower BI service will host your reports on cloud for users to view & consume your reports without the need to install Power BI. Interactions between visuals\, drill down and filtering capabilities will still function as normal. \n\nPower BI Desktop\nCreating a Microsoft account and its advantages\nPower BI service (cloud based)\nMicrosoft Power BI vs Other BI applications\n\nModule 3: Power BI Data\nThis module describes Power BI data sources. Power BI can access vast volumes of data from multiple sources. It allows you to view\, analyse\, and visualize vast quantities of data that cannot be opened in Excel. When the source is changed\, a one click re-fresh is needed to see the updated reports. Power BI uses powerful compression algorithms to import and cache the data within the PBIX file. \n\nIdentify and connect to a data source\nHandling data from multiple sources\nChanging the data source settings\nSelect a storage mode / load setting\nExamine data structures\, interrogate column properties\nRemove unnecessary rows / columns for optimisation of performance\n\nModule 4: Interactive Data Visualizations\nThis module describes Power BI visualizations. Data visualization is the graphical representation of information and data. By using visual elements like charts\, maps\, data visualization tools provide an accessible way to see and understand trends\, outliers\, and patterns in data. \n\nCreating Power BI reports\nAdding visuals to reports & choosing the right visuals\nConfigure and formatting visuals\nImporting custom visuals from App Source\nImporting downloaded visuals from file\nUsing slicers to filter visuals\nUsing the filter pane to filter visuals & reports\nPerform top N analysis\nSorting visuals and configuring a custom sort\nCreating a hierarchy and performing drilldown into data\nUsing built-in measures to summarise data\nEdit and configure interactions between visuals\nDesign and configure for accessibility\n\nModule 5: Shaping and Combining Data\nThis module describes how to shape and combine data. The most important part of any BI tool is combining\, cleaning & re-organise data into a tabular format to enable data modelling & analytics. \n\nIntroduction to Power Query\nResolve inconsistencies\, unexpected / null values\, and data quality issues\nIdentify and create appropriate keys for joins\nTransforming and re-shaping data\, date transformations\nApply user-friendly naming conventions to columns and queries\nCombining data (multiple scenarios in appending data)\nCombining data (merging data vs related tables)\nConfigure data loading\nFormulas in Power Query\n\nModule 6: Modelling Data\nThis module describes how to model data in Power BI. Getting insights to your data is the goal of data analytics. Here\, important metrics is calculated for comparison / tracking performance. \n\nIntroduction to Power Pivot\nUnderstanding Relationships\nIntroduction to Data Analysis Expression (DAX)\nFormulas in Power Pivot – Calculated columns and measures\nHandling dates in Power Pivot\nBest practise in data modelling\nBuilding an Interactive Report\n\nPricing:\nRM 750 Per Person (HRD Corp Claimable Course) \n  \n\n  \nJoin Today!
URL:https://uoa-academy.com/events/analyzing-data-with-power-bi/
END:VEVENT
END:VCALENDAR