BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Laurel Ridge Community College - ECPv6.18.4//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Laurel Ridge Community College
X-ORIGINAL-URL:https://laurelridge.edu
X-WR-CALDESC:Events for Laurel Ridge Community College
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20270705T020000
DTEND;TZID=America/New_York:20270706T015959
DTSTAMP:20261029T072522Z
CREATED:20260407T040000Z
LAST-MODIFIED:20261029T072522Z
UID:202866-1814752800-1814839199@laurelridge.edu
SUMMARY:Intermediate Power BI
DESCRIPTION:Delve further into Power Query to ETL (Extract\, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. \nAgenda \nUnit 1: Power Query\n-Review the ETL Process\n-Insert columns using different methods\n-Group\, Summarize\, Pivot\, and UnPivot data\n-Merge and Append queries \nUnit 2: Data Modeling\n-What Data Modeling is\n-Modeling Options\n-Create and manage relationships\n-Create Date table \nUnit 3: DAX\n-Introduction to DAX\n-Calculate columns and measures\n-Time Intelligence functions\n-Quick Measures \nUnit 4: Reports\n-Filters versus Slicers\n-Visual Hierarchies and Drill downs\n-Drillthrough\n-Define visual interactions\n-Apply conditional formatting
URL:https://laurelridge.edu/event/intermediate-power-bi-3/
LOCATION:Online 24/7\, VA\, United States
CATEGORIES:Business Administration / Management,Business and Professional Development,Workforce Solutions
END:VEVENT
END:VCALENDAR