%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T06:38:12-05:00
2021-02-25T06:38:12-05:00
2021-02-25T06:38:12-05:00
Adobe Acrobat 21.0
application/pdf
Power BI Training | Power BI Dax Course | Learn Power BI
uuid:f704666f-e43a-4f39-be4a-54ddca81299d
uuid:f29a0710-6ee6-4547-9715-ea3cab5650e9
Acrobat Web Capture 15.0
endstream
endobj
5 0 obj
<>
endobj
6 0 obj
<>
endobj
3 0 obj
<>
endobj
7 0 obj
<>
endobj
8 0 obj
<>
endobj
18 0 obj
<>>>
endobj
19 0 obj
<>
endobj
20 0 obj
<>
endobj
22 0 obj
[21 0 R 21 0 R]
endobj
23 0 obj
[21 0 R 21 0 R]
endobj
24 0 obj
[21 0 R 21 0 R]
endobj
25 0 obj
[21 0 R 21 0 R]
endobj
26 0 obj
[21 0 R 21 0 R]
endobj
27 0 obj
[21 0 R 21 0 R]
endobj
21 0 obj
<><><><><><><><><><>]/P 19 0 R/Pg 12 0 R/S/Article>>
endobj
12 0 obj
<>/Font<>/ProcSet[/PDF/Text/ImageC]/XObject<>>>/StructParents 0/Type/Page>>
endobj
28 0 obj
[40 0 R 41 0 R 42 0 R]
endobj
29 0 obj
<>stream
BT
/Artifact <>BDC
/TT0 1 Tf
9 0 0 9 5 779 Tm
(Power BI Training | Power BI Dax Course | Learn Power BI)Tj
EMC
/Artifact <>BDC
0 -86 TD
(file:///INSTSERVER/TrainingHottSite/HOTT-NEW/UK/CoursesPDF/Power-BI-Dax-\
Power-Query-M-Course.htm)Tj
46.244 0 Td
([2/25/2021 6:38:12 AM])Tj
EMC
ET
1 g
10 36 591.75 729.75 re
f
q
65.5 513 m
63.429 513 61.75 511.321 61.75 509.25 c
61.75 509.25 l
61.75 81.75 l
61.75 79.679 63.429 78 65.5 78 c
65.5 78 l
545.5 78 l
547.571 78 549.25 79.679 549.25 81.75 c
549.25 81.75 l
549.25 509.25 l
549.25 511.321 547.571 513 545.5 513 c
545.5 513 l
h
W n
0.976 g
61.75 513 487.5 -435 re
f
0.867 g
61.75 513 487.5 -435 re
65.5 512.25 m
545.5 512.25 l
547.157 512.25 548.5 510.907 548.5 509.25 c
548.5 81.75 l
548.5 80.093 547.157 78.75 545.5 78.75 c
65.5 78.75 l
63.843 78.75 62.5 80.093 62.5 81.75 c
62.5 509.25 l
62.5 510.907 63.843 512.25 65.5 512.25 c
f*
Q
q
10 36 592 730 re
W n
0.137 0.322 0.486 rg
q 1 0 0 1 69.25 508.5 cm
0 0 m
472.5 0 l
474.157 0 475.5 -1.343 475.5 -3 c
475.5 -17.25 l
475.5 -18.907 474.157 -20.25 472.5 -20.25 c
0 -20.25 l
-1.657 -20.25 -3 -18.907 -3 -17.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
q 1 0 0 1 64.75 64.5 cm
0 0 m
481.5 0 l
483.157 0 484.5 -1.343 484.5 -3 c
484.5 -20.25 l
484.5 -21.907 483.157 -23.25 481.5 -23.25 c
0 -23.25 l
-1.657 -23.25 -3 -21.907 -3 -20.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
/Article <>BDC
EMC
/Article <>BDC
Q
q
61.75 677.25 487.5 82.5 re
W n
q
/GS0 gs
487.5 0 0 -82.5 61.75 759.75 cm
/Im0 Do
Q
Q
BT
0.608 0.169 0 rg
/TT1 1 Tf
19.5 0 0 19.5 61.75 636.75 Tm
(Analyzing Data with Power BI, DAX, and Power Query M)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
10.5 0 0 10.5 61.75 609 Tm
(Duration:)Tj
0 g
/TT3 1 Tf
( )Tj
/TT4 1 Tf
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
20.821 0 Td
(, or 35 Hours )Tj
/TT4 1 Tf
7.014 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-27.835 -2.214 Td
(Price:)Tj
0 g
/TT3 1 Tf
3.227 0 Td
( \2431,945 )Tj
/TT4 1 Tf
4.246 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 0 Td
(, or \2431,145 )Tj
/TT4 1 Tf
5.995 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-28.63 -2.214 Td
(Discounts:)Tj
0 g
/TT3 1 Tf
5.916 0 Td
( For multiple course purchases, please )Tj
0.137 0.322 0.486 rg
19.712 0 Td
(contact us)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 330.8484 561.75 cm
0 0 m
54.346 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 385.1941 562.5 Tm
( for applicable discounts.)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-30.804 -2.214 Td
(Delivery Options:)Tj
0 g
/TT3 1 Tf
( Perform training at your own pace via our )Tj
0.137 0.322 0.486 rg
31.514 0 Td
(on-demand training)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 392.6436 538.5 cm
0 0 m
104.498 0 l
h
S
Q
Q
BT
0 g
0.036 Tw 10.5 0 0 10.5 497.1411 539.25 Tm
[( )0.7 (option )0.6 (or)]TJ
0 Tw -41.466 -1.214 Td
(attend regularly scheduled live courses via )Tj
0.137 0.322 0.486 rg
21.844 0 Td
(remote-live attendance)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 291.1094 525.75 cm
0 0 m
123.103 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 414.2126 526.5 Tm
(.)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 69.25 494.25 Tm
(Students Will Learn)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
0 g
81.25 471.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 471.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
BT
/TT3 1 Tf
10.5 0 0 10.5 91 467.25 Tm
(The fundamentals and evolution of)Tj
-0.929 -1.214 Td
(business )Tj
ET
Q
BT
0 g
/TT3 1 Tf
10.5 0 0 10.5 130.3201 454.5 Tm
(analysis processes and tools)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
81.25 438.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 438.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 434.25 Tm
(The roles, tasks and tools involved in)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 421.5 Tm
(self-service business analysis)Tj
ET
81.25 405.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 405.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 401.25 Tm
(How to connect to and import data)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 388.5 Tm
(from numerous )Tj
ET
Q
BT
10.5 0 0 10.5 166.1165 388.5 Tm
(diverse sources into the)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 375.75 Tm
(Power BI Desktop and service)Tj
ET
81.25 360 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 360 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 355.5 Tm
(When to directly query data sources)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 342.75 Tm
(and when to )Tj
ET
Q
BT
10.5 0 0 10.5 150.4639 342.75 Tm
(import data)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
81.25 327 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 327 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 322.5 Tm
(How to shape, transform, and combine)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 309.75 Tm
(data from diverse sources to create)Tj
0 -1.214 TD
(useful reports)Tj
ET
81.25 281.25 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 281.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 276.75 Tm
(Using the Power Query Editor)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
81.25 261 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 261 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 256.5 Tm
(Which visualizations are best suited)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 243.75 Tm
(for various )Tj
ET
Q
BT
10.5 0 0 10.5 141.5481 243.75 Tm
(types of analysis)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
81.25 228 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 228 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 223.5 Tm
(How to create, organize and format)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 210.75 Tm
(visualizations that evoke insight and)Tj
0 -1.214 TD
(deliver optimal impact)Tj
ET
81.25 182.25 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 182.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 177.75 Tm
(How to use and develop data models)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 165 Tm
(and related )Tj
ET
Q
BT
10.5 0 0 10.5 144.9832 165 Tm
(tools to combine datasets)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 152.25 Tm
(for analysis)Tj
ET
81.25 136.5 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 136.5 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 132 Tm
(How to modify relationships,)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 119.25 Tm
(cardinality, and )Tj
ET
Q
BT
10.5 0 0 10.5 166.6907 119.25 Tm
(cross filter direction to)Tj
ET
q
81.25 82.5 231.75 394.5 re
W n
BT
10.5 0 0 10.5 81.25 106.5 Tm
(maximize the efficacy of analysis)Tj
ET
81.25 90.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 90.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 86.25 Tm
(Publishing to the Power BI service)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 471.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 471.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
BT
10.5 0 0 10.5 337.75 467.25 Tm
(Create and manipulating dashboards,)Tj
ET
Q
BT
10.5 0 0 10.5 328 454.5 Tm
(reports and )Tj
6.154 0 Td
(apps in the Power BI service)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 438.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 438.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 434.25 Tm
(Refreshing datasets, reports and)Tj
-0.929 -1.214 Td
(dashboards in )Tj
7.389 0 Td
(the Power BI Desktop and)Tj
-7.389 -1.214 Td
(service)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 393 3 -3 re
f
0.75 w
q 1 0 0 1 328 393 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 388.5 Tm
(Sharing reports, dashboards,)Tj
-0.929 -1.214 Td
(workbooks and )Tj
7.953 0 Td
(datasets in the Power BI)Tj
-7.953 -1.214 Td
(service)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 347.25 3 -3 re
f
0.75 w
q 1 0 0 1 328 347.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 342.75 Tm
(Creating hierarchical drilldown reports)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 327 3 -3 re
f
0.75 w
q 1 0 0 1 328 327 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 322.5 Tm
(Collaborating in the Power BI service)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 306.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 306.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 302.25 Tm
(Using DAX to add new Calculations to)Tj
-0.929 -1.214 Td
(an existing data model)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 273.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 273.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 269.25 Tm
(Simulating a Star data Schema from)Tj
-0.929 -1.214 Td
(an OLTP source with DAX)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 240.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 240.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 236.25 Tm
(Fixing Data Granularity issues with)Tj
-0.929 -1.214 Td
(DAX Calculations)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 207.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 207.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 203.25 Tm
(Providing Row Level security using)Tj
-0.929 -1.214 Td
(Row Filters in DAX)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 174.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 174.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 170.25 Tm
(Performing Transformations while)Tj
-0.929 -1.214 Td
(loading data with Power Query and M)Tj
ET
q
328 82.5 216.751 394.5 re
W n
328 141.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 141.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 137.25 Tm
(Using M language to write more)Tj
-0.929 -1.214 Td
(powerful queries than the standard)Tj
0 -1.214 TD
(Power Query user interface allows)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 64.75 47.25 Tm
(Course Description)Tj
ET
EMC
endstream
endobj
30 0 obj
<>
endobj
31 0 obj
(CVD9v>v)
endobj
39 0 obj
<>/Filter/FlateDecode/Height 110/Length 36528/Name/X/Subtype/Image/Type/XObject/Width 650>>stream
His8ʫE>@^8'qU @`c9e,qSGGb8u>n<3EU?fgz=3[=EQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQW+(2l4EQEQT#EQEQfz(("EQEY4"EQEQfa((ʌEQEY4!B:~DQP7_yH3UدQ#DMAٯMưd D.e KrKF@іV&?GdU}L}t`'D6rv~(.eO)GiIcT-fdBۂvsӠRCh>NaMRv%E|y˾+i5俩hvȻDPGPb'jZϝ (o$Y..Xy4n
.P..fF3bKRL_sy#N`H_`#
2г
$^Bp%ʁ?̌yJ͎ cD*]Ml5̐@FPfb3~h潠V(eb_[$@28k,g<0K!1C˂sR0%eؙ 2Y3&9db``R?قIWٮ\FX䁢:Bֿ&L^ڪwvғ- Gm> \HMRRguΪh4qK Sw(LI6nezX"{C3S. {Ų[l\6J#*ꜮKKpȁ2Mi/"lLٙDXdj'sy*/n+1-DC3ŊwvL<}b~k5[Woc'(~)a%(.O2Coxc$XI5u{ނN.q(eG%0dAK2S
F|4)XlI:4<=>|Zb&q4'>l)rDAP7Mݔ[
<3<]&V}k9`%VOw'_["O8,e*ɛƕ&ʛV{
0{:77LnD1IV<"ǵMبLNȋJ枏d:OR
: |b4xűtc+OLeJ9,Ⱥ~RoV[OjBNWJ~R`]F˞q4FCXJl,G'HIqPm
dy1awz+9LRi
BYD6֖?VN&bH(*lC3H2ry6~X
Gl
[mq$e
%m9X$
s]]uwvuΝ~=珟am+.ULf+@p\PR.נS`kdQXY.5SI{yMd|VX$!}4F*,0><.,+ہ52Rel8-<]"oy/Km( ١l9!ov/
.~k\Ryk2*̼lbt\*{UY;NMRIuZBQsOxp`P"OzA 2bF3,Ϟ:toigC*HaH"KNb9mHX!y++D#qKrSE}dxMR l]3x'ιbUyҜVNz8pђ[_NAFrǎnݶ.]|nz<0UɥsLшvN}-.F4#G^>&]4j
NLq
}59"WV(+t9b"d@y0:fBŕW+ 4'.T:|yݟb$]pRF`"~ɭϯ
m1_PI/S TZ}9lKT~R
HwMᢥb'30U c$DJRX caWɋщ
1OhYИTfV%@b8_d621_4:9-+,Aǧ
; hɗk+I2.%."̽y*$Qr̨e'kͥUBE 9_^w|8u9e|ɝr[, c)e` es5r0F\>Bpт;Gtz#N}.\|t"̞+t;]ABoCG_ʡbKЕ.R[Do0/ڻO9X
G:;7x,O^ xs\vq
ED
QLhUs|ݟ?ᑬ
2#}h
.뷐Ȟawq x(.y&r6?;?T7i+ˮŋ>[lcj7n]g*?v}GJfXv==+`tYϬ%v۰vo6~:_Os^u,sӓ\ҳ0fD><9 #ϫ^&r㛷nnKsE]_/V.=W(/qrK"/KWYy9xCl0tl XbpߑѶ[3#'N
\[0>}rjv$RC؏Ï
"Qda|/x6^v3.@ƳOI@yhTLٰi_fA]Wg(F+F
h[:&6t111("('9K2FA<\Ǿ^ZuüRTu@PP+;&Ɇ pcU5iV֖XIL>S *(m*MICVT#F~VeH 6{M I$K͖3sfzoȘxN)
oIYگ03[GOGdv;9 Fr:Bu<3
@Wo,Y&?mOLN>2&yS+Fgm&T,Zl
hwOԟ'o__0!,iX--/z2]y[6!Y
Y&b3
\ܜzɂ?C/@,w{d߬[
)LNhO~m=tvB?or6[vV!GO1G4O*4otNNW?ӆ~Ssgqal@N579,jߏ;m,qkwɇ\A8 0K%
Q癘wr.
.]pvq,ŕҲ]1N{=ӕ#@~mn^6AFyzѐ4JnӲQ&$q /&@ĞC!: ouh2?o8C?伸&Nwꡩ5wAQrij<>v,R ;Bsm]C='|I4|ĈQ 3ࡲ%rD3F)I9 2%4qH `oyEު}4Q`ujZKRs/
IE`%Ki(3묢6ǟ76>\h:|NEm_9*|e#GE=_54#@D
@ᣍ43~h1g|18sh2EޮoL
j ja?t'#fuǗUaNΝ7(i%E߾,#6
ND5=+a5bm8~
cP2Z]@D-Z+C]zP`NL#|22L~IPHc:ɓ'ѮnN]DD{=<<&&&rrr***''';;;751iOZb&z
tdd~~~㣣...ÇEǎ~M~~>LkroHHȞ={s300Ѷ6|mggm``ch`0>Bx%-
Xy$ҥK"cyy9"If{{;ocGGaOYY>bB{ff&VKr