%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T05:50:32-05:00
2021-02-25T05:50:32-05:00
2021-02-25T05:50:32-05:00
Adobe Acrobat 21.0
application/pdf
Power BI Training | Power BI Dax Course | Learn Power BI
uuid:e6c20d81-9892-4be9-b95e-836659575c4b
uuid:4ad3815f-d5d6-45df-891a-caab6a9045c0
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 43 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/HOTT/CoursesPDF/Power-BI-Da\
x-Power-Query-M-Course.htm)Tj
47.466 0 Td
([2/25/2021 5:50:32 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
( 5 Days )Tj
/TT4 1 Tf
9.48 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 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
-31.658 -2.214 Td
(Price:)Tj
0 g
/TT3 1 Tf
3.227 0 Td
( $2495 )Tj
/TT4 1 Tf
3.882 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 0 Td
(, or $1495 )Tj
/TT4 1 Tf
5.631 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-27.903 -2.214 Td
(Discounts:)Tj
0 g
/TT3 1 Tf
5.916 0 Td
( We offer multiple discount options. )Tj
0.137 0.322 0.486 rg
18.297 0 Td
(Click here)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 315.9854 561.75 cm
0 0 m
52.105 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 368.0906 562.5 Tm
( for more information.)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-29.175 -2.214 Td
(Delivery Options:)Tj
0 g
/TT3 1 Tf
( Attend face-to-face in the classroom, )Tj
0.137 0.322 0.486 rg
29.147 0 Td
(remote-live)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 367.7932 538.5 cm
0 0 m
60.713 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 428.5066 539.25 Tm
( or )Tj
0.137 0.322 0.486 rg
1.737 0 Td
(on-demand)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 446.7432 538.5 cm
0 0 m
60.288 0 l
h
S
Q
Q
BT
10.5 0 0 10.5 61.75 526.5 Tm
(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 61.75 525.75 cm
0 0 m
40.518 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 102.2683 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
(ԩBNȾ')
endobj
39 0 obj
<>/Filter/FlateDecode/Height 110/Length 19862/Name/X/Subtype/Image/Type/XObject/Width 650>>stream
H͎U{QCנ8;qx 0z#5 Ily^{vMegoWUϮD"H$D"H$D"H$D"H$D"H$D"H$D"H$D"H$D"H$D"H$D"e?D"3&{yD"HdIF"H$y?D"H䙒. Fǘ|#ÄΝ6R`{kFv+{ۏ1qӝPxAwaAc4ݴٕ7t:cx]rN0ce6A]fg3OA%&vV%9] &)0f9Q/M5FeLGGGF
S6?rIxvppp̙[nmD
3'0Q ML? ^ҵϗ/_>}4'o{5s:wNc7- Xͨ39j3wVɍ7.]Dۛ sn$&hhL\kgml[˘_
)7oуú~:=YC;c&"A,cSZm}m4o/^81wm_˛#ikY=MKnmmݺuF8ϫӞc^!*k# Saңg!7:Bzd΅~gZN?ٿ$߿`e}_]VzYp,|#Dz0
W\jvvvJwO0dx?=x@Lrfov+x7|+Ν;WRo<>F1_F[oňFܺΨC_ň2QH0>O˅<Z8|xxxS$z5fb`xj6e7('KgWp{ʠzF rCu F>Od "/+WMHP=&m
8!HM<qX[տw +Ҳ\[ŃrA Mh |i"&www}YO.٢*[p]O̽{jܖa@xv<J2#ZU~tO23w}gA{yoour3=;ge;h=vr
-SОZEA׀CtSb[
g|ʍmTny˴'3 kL/_iUl`+a&;R+GjE@W8-Z~VJK=Ƭ!jiY-\T_%~kqSISY &%@>fZ*q)8+rfSK֩ux봿e44ʌ:;(~47B]6˻j?2Q/ps bĦؗmi4T;?0VKb.*$ ذkMrKpbgն{C
3 L1Pf#,Sq"U06=#m
+26Z3_[P 36]V3VG}իWDM2N>27v]ڹpeRw
ib"!|X֪qD[t}mPp.+m?qttdxK;88 :%1r3%і1Cҙ欕s751wmg&6`~u[=|