%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T06:38:15-05:00
2021-02-25T06:38:15-05:00
2021-02-25T06:38:15-05:00
Adobe Acrobat 21.0
application/pdf
SQL Server 2016 Integration and Analysis Services Training | SSIS/SSAS Course
uuid:e43b8499-d3a5-45c0-9a22-4e9b4ff6ac23
uuid:621961f9-754b-4a07-ae59-4c7c45bd14b8
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
16 0 obj
<>>>
endobj
17 0 obj
<>
endobj
18 0 obj
<>
endobj
20 0 obj
[19 0 R 19 0 R]
endobj
21 0 obj
[19 0 R 19 0 R]
endobj
22 0 obj
[19 0 R 19 0 R]
endobj
23 0 obj
[19 0 R 19 0 R]
endobj
19 0 obj
<><><><><><>]/P 17 0 R/Pg 12 0 R/S/Article>>
endobj
12 0 obj
<>/Font<>/ProcSet[/PDF/Text/ImageC]/XObject<>>>/StructParents 0/Type/Page>>
endobj
24 0 obj
[36 0 R 37 0 R 38 0 R]
endobj
25 0 obj
<>stream
BT
/Artifact <>BDC
/TT0 1 Tf
9 0 0 9 5 779 Tm
(SQL Server 2016 Integration and Analysis Services Training | SSIS/SSAS C\
ourse)Tj
EMC
/Artifact <>BDC
0 -86 TD
(file:///INSTSERVER/TrainingHottSite/HOTT-NEW/UK/CoursesPDF/SQL-Integrati\
on-Analysis-Services-2016-Training-Course.htm)Tj
53.687 0 Td
([2/25/2021 6:38:15 AM])Tj
EMC
ET
1 g
10 36 591.75 729.75 re
f
q
65.5 483 m
63.429 483 61.75 481.321 61.75 479.25 c
61.75 479.25 l
61.75 201 l
61.75 198.929 63.429 197.25 65.5 197.25 c
65.5 197.25 l
545.5 197.25 l
547.571 197.25 549.25 198.929 549.25 201 c
549.25 201 l
549.25 479.25 l
549.25 481.321 547.571 483 545.5 483 c
545.5 483 l
h
W n
0.976 g
61.75 483 487.5 -285.75 re
f
0.867 g
61.75 483 487.5 -285.75 re
65.5 482.25 m
545.5 482.25 l
547.157 482.25 548.5 480.907 548.5 479.25 c
548.5 201 l
548.5 199.343 547.157 198 545.5 198 c
65.5 198 l
63.843 198 62.5 199.343 62.5 201 c
62.5 479.25 l
62.5 480.907 63.843 482.25 65.5 482.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 478.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 183.75 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
(SQL Server 2016 Business Intelligence: Integration Services and)Tj
0 -1.538 TD
(Analysis Services)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
10.5 0 0 10.5 61.75 579 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 531.75 cm
0 0 m
54.346 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 385.1941 532.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 508.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 509.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 495.75 cm
0 0 m
123.103 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 414.2126 496.5 Tm
(.)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 69.25 464.25 Tm
(Students Will Learn)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
0 g
81.25 441.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 441.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 437.25 Tm
(Structure and function )Tj
11.665 0 Td
(of a data)Tj
-12.594 -1.214 Td
(warehouse or data mart)Tj
ET
81.25 408.75 3 -3 re
f
q 1 0 0 1 81.25 408.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
0 g
/TT3 1 Tf
10.5 0 0 10.5 91 404.25 Tm
(Data warehouse design to support)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
BT
10.5 0 0 10.5 81.25 391.5 Tm
(enterprise reporting)Tj
ET
81.25 375.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 375.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 371.25 Tm
(The role of SSIS within the business)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
BT
10.5 0 0 10.5 81.25 358.5 Tm
(intelligence framework)Tj
ET
81.25 342.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 342.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 338.25 Tm
(Developing SSIS Extract Transform)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
BT
10.5 0 0 10.5 81.25 325.5 Tm
(Load \(ETL\) processes to populate data)Tj
0 -1.214 TD
(warehouses)Tj
ET
81.25 297 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 297 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 292.5 Tm
(Functionality of all SSIS Control Flow)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
BT
10.5 0 0 10.5 81.25 279.75 Tm
(tasks)Tj
ET
81.25 264 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 264 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 259.5 Tm
(Deploying SSIS projects to SSIS)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
BT
10.5 0 0 10.5 81.25 246.75 Tm
(Catalogs)Tj
ET
81.25 231 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 231 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 226.5 Tm
(Configuring SSIS environments,)Tj
ET
q
81.25 201.75 231.75 245.25 re
W n
BT
10.5 0 0 10.5 81.25 213.75 Tm
(runtime variables and parameters)Tj
ET
Q
q
328 201.75 216.751 245.25 re
W n
328 441.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 441.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 437.25 Tm
(BI Semantic Model)Tj
ET
328 421.5 3 -3 re
f
q 1 0 0 1 328 421.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 337.75 417 Tm
(Multidimensional Expressions \(MDX\))Tj
-0.929 -1.214 Td
(syntax)Tj
ET
q
328 201.75 216.751 245.25 re
W n
328 388.5 3 -3 re
f
0.75 w
q 1 0 0 1 328 388.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 337.75 384 Tm
(Developing SSAS Multidimensional)Tj
-0.929 -1.214 Td
(models)Tj
ET
q
328 201.75 216.751 245.25 re
W n
328 355.5 3 -3 re
f
0.75 w
q 1 0 0 1 328 355.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 337.75 351 Tm
(Data Analysis Expressions \(DAX\))Tj
ET
q
328 201.75 216.751 245.25 re
W n
328 335.25 3 -3 re
f
0.75 w
q 1 0 0 1 328 335.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 330.75 Tm
(Developing )Tj
5.94 0 Td
(SSAS Tabular models)Tj
ET
q
328 201.75 216.751 245.25 re
W n
328 315 3 -3 re
f
0.75 w
q 1 0 0 1 328 315 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 310.5 Tm
(Deploying and securing)Tj
-0.929 -1.214 Td
(Multidimensional and Tabular models)Tj
ET
q
328 201.75 216.751 245.25 re
W n
328 282 3 -3 re
f
0.75 w
q 1 0 0 1 328 282 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 277.5 Tm
(Implementing SSAS Data Mining)Tj
-0.929 -1.214 Td
(models for predictive analysis)Tj
ET
q
328 201.75 216.751 245.25 re
W n
328 249 3 -3 re
f
0.75 w
q 1 0 0 1 328 249 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 244.5 Tm
(Consuming the BI Semantic Model in)Tj
-0.929 -1.214 Td
(reports and dashboards)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 64.75 166.5 Tm
(Course Description)Tj
0 g
/TT3 1 Tf
0.129 Tw 10.5 0 0 10.5 61.75 137.25 Tm
[(SQL )1.5 (Server )2.6 (2016 )1.9 (provides )0.8 (a )1.3 (rich )0.9 (environment )2.4 (for )1.6 (business )1.1 (intelligence )]TJ
0.143 Tw [(development. )2 (The)]TJ
0.029 Tw 0 -1.214 TD
[(focus )1.6 (of )1.3 (this )0.7 (five )1.4 (day )]TJ
0.026 Tw 10.944 0 Td
[(course )1.3 (is to )0.5 (familiarize )0.6 (developers )1.3 (with the )0.9 (use )0.9 (of )1 (SQL )1.1 (Server )2.2 (Engine,)]TJ
0 Tw -10.944 -1.214 Td
(SQL )Tj
0.033 Tw 2.379 0 Td
[(Server )2.7 (Integration )1.9 (Services )2 (\(SSIS\) )2.1 (and )1.5 (SQL )1.7 (Server )2.6 (Analysis )1.4 (Services )2 (\(SSAS\) )2.4 (to )]TJ
0 Tw 40.894 0 Td
(create)Tj
0.286 Tw -43.273 -1.214 Td
[(and )1.3 (populate )1.1 (data )1.5 (warehouses )2 (through )1.5 (ETL )0.6 (processing )1 (and )1.2 (build )]TJ
[(Multidimensional )0.5 (and)]TJ
0 Tw 0 -1.214 TD
(Tabular models to use and reporting data sources.)Tj
0 -2.214 TD
(Students )Tj
0.088 Tw 4.9 0 Td
[(will )-1.1 (learn )1.3 (how to )0.5 (design )0.5 (and )1.1 (build data )1.3 (warehouses )1.8 (and )1.1 (marts )1.5 (using SQL )1.2 (Server)]TJ
0.058 Tw -4.9 -1.214 Td
[(Management )2.3 (Studio. In a series )0.5 (of )0.5 (exercises, )1.1 (students )0.6 (develop SSIS )1.3 (packages )]TJ
0.071 Tw 40.507 0 Td
(designed to)Tj
ET
EMC
endstream
endobj
26 0 obj
<>
endobj
27 0 obj
(jpS#Sj :HY)
endobj
35 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