BEGIN:VCALENDAR
VERSION:2.0
PRODID:Imitheme.com
BEGIN:VEVENT
UID:20260417T134440-519612146
DTSTAMP;TZID=UTC:1776433480
DTSTART:20260417T134440Z
DTEND:19700101T000000Z
SUMMARY:Power BI DAX (Virtual)
LOCATION:VIRTUAL
DESCRIPTION: [vc_row][vc_column width="1/1"][vc_column_text uncode_shortcode_id="151535"]
<div class="course__introduction entry-content">

This is an advanced course for people who already have experience developing Power BI reports and want to develop their proficiency using DAX.

DAX allows us to enrich our data model and perform highly sophisticated data analysis, but there is some theory required to master DAX. In this course we delve into key concepts like evaluation context while also introducing best practise like the use of variables.

The course will also cover a wide range of DAX functions including Iterator, Table, Calculate and Calculate Modifier functions, Timeseries Intelligence and Hierarchy functions.

</div>
[/vc_column_text][vc_tabs][vc_tab title="Units" tab_id="1578020048-1-744290-96a91646970250426"][vc_column_text uncode_shortcode_id="668609"]
<div class="pm-tab-content-sbs">
<div class="pm-tab-content-sbs">
<h6>DAX AND THE DATA MODEL</h6>
<ul>
 	<li>Power BI Options</li>
 	<li>Create a Data Model</li>
 	<li>Manage Relationships</li>
 	<li>DAX Operators</li>
</ul>
<h6>DAX FUNDAMENTALS</h6>
<ul>
 	<li>Create a Fiscal Calendar</li>
 	<li>ADDCOLUMNS</li>
 	<li>Understand Variables</li>
 	<li>Add Comments</li>
 	<li>DAX Formatter</li>
 	<li>Date &amp; Text Functions</li>
 	<li>IF and SWITCH</li>
</ul>
<h6>MEASURES</h6>
<ul>
 	<li>Why Measures</li>
 	<li>Simple Measures</li>
 	<li>Row vs Filter Context</li>
 	<li>Create a Measures Table</li>
</ul>
<h6>ITERATORS</h6>
<ul>
 	<li>Understand Iterators</li>
 	<li>SUMX</li>
 	<li>AVERAGEX</li>
 	<li>RELATED</li>
 	<li>CONCATENATEX</li>
</ul>
</div>
<div class="pm-tab-content-sbs">
<h6>TABLE FUNCTIONS</h6>
<ul>
 	<li>VALUES</li>
 	<li>ALL &amp; ALLEXCEPT</li>
 	<li>SUMMARISE</li>
 	<li>FILTER</li>
</ul>
<h6>DAX TOOLS</h6>
<ul>
 	<li>Query View</li>
 	<li>DAX Studio</li>
 	<li>EVALUATE syntax</li>
 	<li>Performance Analyser</li>
</ul>
<h6>CALCULATE</h6>
<ul>
 	<li>Understand CALCULATE</li>
 	<li>Multiple Criteria</li>
 	<li>Calculate Modifiers</li>
 	<li>Calculation Sequence</li>
</ul>
<h6>TIME INTELLIGENCE</h6>
<ul>
 	<li>TOTALYTD &amp; DATESYTD</li>
 	<li>SAMEPERIODLASTYEAR</li>
 	<li>DATEADD</li>
 	<li>PARALLELPERIOD</li>
</ul>
<h6>HIERARCHY FUNCTIONS</h6>
<ul>
 	<li>PATH &amp; PATHCONTAINS</li>
 	<li>Dynamic RLS</li>
</ul>
</div>
</div>
[/vc_column_text][/vc_tab][vc_tab title="Audience" tab_id="1578020048-2-494290-96a91646970250426"][vc_column_text uncode_shortcode_id="182133"]<strong>Ideal for individuals who want to:</strong>
• Understand report design principles
• Create a wide range of visuals
• Use advanced report features
• Work with custom visuals[/vc_column_text][/vc_tab][vc_tab title="Format" tab_id="1578020247795-2-84290-96a91646970250426"][vc_column_text uncode_shortcode_id="670030"]• 2-day Virtual instructor-led program
• 2 x 3-hour web-based virtual sessions (MS Teams)
• Attendees <strong>must</strong> attend both days[/vc_column_text][/vc_tab][vc_tab title="What's Included" tab_id="1578020281851-3-54290-96a91646970250426"][vc_column_text uncode_shortcode_id="205519"]
<ul>
 	<li>Extensive Learning &amp; Reference Guides provided on USB</li>
 	<li>Participation in the workshop</li>
 	<li>Access to a Microsoft technical expert throughout and post the workshop</li>
</ul>
[/vc_column_text][/vc_tab][/vc_tabs][/vc_column][/vc_row][vc_row][vc_column width="1/1"][/vc_column][/vc_row]
END:VEVENT
END:VCALENDAR