BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//METEOR Learning - ECPv6.16.4.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:METEOR Learning
X-ORIGINAL-URL:https://mlearning.meteor.com.my
X-WR-CALDESC:Events for METEOR Learning
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:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=Asia/Kuala_Lumpur:20260923T090000
DTEND;TZID=Asia/Kuala_Lumpur:20260924T170000
DTSTAMP:20260729T032635Z
CREATED:20260728T012918Z
LAST-MODIFIED:20260729T032635Z
UID:3980-1790154000-1790269200@mlearning.meteor.com.my
SUMMARY:POWER BI FOR BUSINESS ANALYSIS TRAINING
DESCRIPTION:OVERVIEW \nThis module is designed to equip you with the fundamental skills needed to handle and analyze big data seamlessly. Whether you are a business analyst\, data professional\, or an aspiring data scientist\, this course will cater to your learning needs\, taking you from the basics to advanced data manipulation and visualization techniques. \nThroughout the module\, you will discover how Power Query serves as a powerful ETL (Extract\, Transform\, Load) tool\, enabling you to connect to various data sources\, apply data transformations\, and prepare data for analysis. Moreover\, we will delve into the magic of M\, the powerful formula language behind Power Query\, and learn how to write custom functions and queries to tackle complex data challenges. Once your data is refined and ready\, we will introduce you to Power BI – Microsoft’s cutting-edge business intelligence platform. Power BI allows you to create stunning interactive visualizations and insightful reports\, providing you with the ability to communicate your findings effectively and make data-driven decisions. \n  \nLEARNING OUTCOMES \n\nMaster Power Query Fundamentals: Understand the core concepts of Power Query and utilize its data transformation capabilities to clean\, shape\, and integrate data from various sources effectively.\nLeverage Advanced Power Query Techniques: Apply advanced data transformation techniques\, custom functions\, and the Mformula language to handle complex data challenges and prepare data for analysis.\nCombine and Merge Data with Confidence: Seamlessly merge and append data from multiple sources\, ensuring data integrity and consistency in the resulting datasets.\nCreate Interactive Visualizations: Build compelling and interactive visualizations in Power BI to effectively communicate data insights and make data-driven decisions.\nUnderstand Data Modeling: Design efficient and optimized data models in Power BI\, establishing relationships between tables and utilizing calculated columns and measures to support analysis.\nHarness the Power of DAX: Utilize the Data Analysis Expressions (DAX) language to create sophisticated calculated columns and measures\, enabling advanced data analysis and business intelligence.\nImplement Time Intelligence Functions: Effectively use DAX time intelligence functions to perform date-based analysis and gain deeper insights from time-series data.\n\n  \nCOURSE OUTLINE \n\n\n\nTIME\nDAY 1\nDAY 2\n\n\n9:00 am – 9:30 am\nWelcome and Introduction \n\nWorkshop objectives and agenda overview\nBrief review of Power Query basics for context\n\n\nWelcome and Introduction \n\nWorkshop objectives and agenda overview\nRecap of Power BI basics for context\n\n\n\n\n9:30 am – 10:30 am\nAdvanced Data Transformations \n\nRecap of basic data transformations\nAdvanced filtering techniques (date filtering\, advanced text filters)\nConditional columns and custom expressions\n\n\nData Modeling in Power BI \n\nUnderstanding Power BI data models\nCreating relationships between tables\nUsing calculated columns and measures\n\n\n\n\n10:30 am – 10:45 am\nMorning Break\n\n\n10:45 am – 12:00 pm\nMerging and Appending Queries \n\nCombining data from multiple sources using merging and joining\nAppending queries vertically and horizontally\nHandling data inconsistencies during merging\n\n\nAdvanced Data Visualization Techniques \n\nEnhancing visuals with formatting options\nCustomizing interactions between visuals\nDrillthrough and drilldown capabilities\n\n\n\n\n12:00 pm – 1:00 pm\nLunch Break\n\n\n1:00 pm – 2:30 pm\nIntroduction to Functions in Power Query \n\nUnderstanding built-in functions\nCreating custom functions with the M formula language\nPractical applications of functions in data transformation\n\n\nIntroduction to DAX (Data Analysis Expressions) \n\nUnderstanding DAX basics and syntax\nCreating calculated columns and measures with DAX\nTime intelligence functions for date-based analysis\n\n\n\n\n2:30 pm – 2:45 pm\nAfternoon Break\n\n\n2:45 pm – 4:00 pm\nAdvanced Error Handling and Query Refinement \n\nHandling errors and invalid data in queries\nQuery diagnostics and troubleshooting techniques\nRefining queries for optimal performance\n\n\nAdvanced DAX Functions and Techniques \n\nUsing advanced DAX functions (FILTER\, ALL\, etc.)\nWorking with iterators and row context\nSolving complex business problems with DAX\n\n\n\n\n4:00 pm – 4:45 pm\nIntroduction to Query Parameters \n\nWorking with parameters in Power Query\nParameterizing queries for dynamic data refresh\nUse cases and benefits of query parameters\n\n\nPower BI Service and Collaboration Features \n\nPublishing reports to Power BI Service\nCreating and sharing dashboards\nCollaborating with colleagues on shared reports\n\n\n\n\n4:45 pm – 5:00 pm\nPower Query Best Practices and Tips \n\nGuidelines for efficient and maintainable query design\nSummary of key takeaways and final Q&A session\n\n\nPower BI Best Practices and Performance Tips \n\nGuidelines for creating efficient and optimized reports\nSummary of key takeaways and final Q&A session\n\n\n\n\n\n  \nMETHODOLOGY \n\nInteractive Presentation\nGroup Discussions\nGroup Activities\nRole Play\nSimulation\nSharing Experience\nGamification Method\nCase Studies
URL:https://mlearning.meteor.com.my/event/power-bi-for-business-analysis-training-2/
LOCATION:Menara OUM\, Block C\, Kompleks Kelana Centre Point\, Jalan SS7/19\, Kelana Jaya\, Petaling Jaya\, Selangor\, 47301\, Malaysia
ATTACH;FMTTYPE=image/png:https://mlearning.meteor.com.my/wp-content/uploads/2026/07/September-2026-programmes-web-poster-6.png
ORGANIZER;CN="METEOR Learning":MAILTO:meteorlearning@meteor.com.my
END:VEVENT
END:VCALENDAR