%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T06:54:13-05:00
2021-02-25T06:54:13-05:00
2021-02-25T06:54:13-05:00
Adobe Acrobat 21.0
application/pdf
SSIS/SSAS Course | SQL Server 2017 Integration Services and Analysis Services Training
uuid:2bfcc5d7-6a25-4ade-ba47-2ae8829d489b
uuid:2a511167-f180-4494-ae36-92d54d053327
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
<>/ExtGState<>/Font<>/ProcSet[/PDF/Text/ImageC/ImageI]/XObject<>>>/StructParents 0/Type/Page>>
endobj
24 0 obj
[36 0 R 37 0 R 38 0 R 39 0 R 40 0 R]
endobj
25 0 obj
<>stream
BT
/Artifact <>BDC
/TT0 1 Tf
9 0 0 9 5 779 Tm
(SSIS/SSAS Course | SQL Server 2017 Integration Services and Analysis Ser\
vices Training)Tj
EMC
/Artifact <>BDC
0 -86 TD
(file:///INSTSERVER/TrainingHottSite/HOTT-NEW/SST/CoursesPDF/ssis-ssas-20\
17-training-course.htm)Tj
42.636 0 Td
([2/25/2021 6:54:13 AM])Tj
EMC
ET
1 g
10 36 591.75 729.75 re
f
q
10 36 592 730 re
W n
0.016 0.267 0.518 rg
q 1 0 0 1 64.75 482.25 cm
0 0 m
481.5 0 l
483.157 0 484.5 -1.343 484.5 -3 c
484.5 -30.75 l
484.5 -32.407 483.157 -33.75 481.5 -33.75 c
0 -33.75 l
-1.657 -33.75 -3 -32.407 -3 -30.75 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
q 1 0 0 1 64.75 146.25 cm
0 0 m
481.5 0 l
483.157 0 484.5 -1.343 484.5 -3 c
484.5 -30.75 l
484.5 -32.407 483.157 -33.75 481.5 -33.75 c
0 -33.75 l
-1.657 -33.75 -3 -32.407 -3 -30.75 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
/Article <>BDC
EMC
/Article <>BDC
Q
q
61.75 699.75 487.5 66 re
W n
q
/GS0 gs
487.5 0 0 -66 61.75 765.75 cm
/Im0 Do
Q
Q
BT
0.016 0.267 0.518 rg
/TT1 1 Tf
24 0 0 24 61.75 666.75 Tm
(SQL Server 2017 Business Intelligence:)Tj
0 -1.531 TD
(Integration Services and Analysis Services)Tj
/TT2 1 Tf
12 0 0 12 61.75 596.25 Tm
(Duration:)Tj
0 g
/TT3 1 Tf
( 5 Days )Tj
/TT4 1 Tf
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
21.616 0 Td
(, or 35 Hours )Tj
/TT4 1 Tf
(\(On-Demand\))Tj
0.016 0.267 0.518 rg
/TT2 1 Tf
-21.616 -2.188 Td
(Price:)Tj
0 g
/TT3 1 Tf
( $2495 )Tj
/TT4 1 Tf
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
19.62 0 Td
(, or $1495 )Tj
/TT4 1 Tf
(\(On-Demand\))Tj
0.016 0.267 0.518 rg
/TT2 1 Tf
-19.62 -2.188 Td
(Discounts:)Tj
0 g
/TT3 1 Tf
( We offer multiple discount options. )Tj
0.333 0.733 0.922 rg
21.008 0 Td
(Click here)Tj
ET
q
10 36 592 730 re
W n
0.333 0.733 0.922 RG
0.75 w
q 1 0 0 1 313.8437 543 cm
0 0 m
53.35 0 l
h
S
Q
Q
BT
0 g
12 0 0 12 367.1934 543.75 Tm
( for more information.)Tj
0.016 0.267 0.518 rg
/TT2 1 Tf
-25.454 -2.188 Td
(Delivery Options:)Tj
0 g
/TT3 1 Tf
( Attend face-to-face in the classroom, )Tj
0.333 0.733 0.922 rg
(remote-live)Tj
ET
q
10 36 592 730 re
W n
0.333 0.733 0.922 RG
0.75 w
q 1 0 0 1 363.2031 516.75 cm
0 0 m
59.35 0 l
h
S
Q
Q
BT
0 g
12 0 0 12 422.5527 517.5 Tm
( or via )Tj
0.333 0.733 0.922 rg
(on-demand)Tj
ET
q
10 36 592 730 re
W n
0.333 0.733 0.922 RG
0.75 w
q 1 0 0 1 458.5645 516.75 cm
0 0 m
60.709 0 l
h
S
Q
Q
BT
12 0 0 12 61.75 503.25 Tm
(training)Tj
ET
q
10 36 592 730 re
W n
0.333 0.733 0.922 RG
0.75 w
q 1 0 0 1 61.75 502.5 cm
0 0 m
39.357 0 l
h
S
Q
Q
BT
0 g
12 0 0 12 101.1074 503.25 Tm
(.)Tj
1 g
/TT1 1 Tf
18 0 0 18 64.75 456.75 Tm
(Description)Tj
0 g
/TT3 1 Tf
12 0 0 12 61.75 419.25 Tm
(SQL Server 2017 provides a rich environment for business intelligence de\
velopment. The)Tj
0 -1.187 TD
(focus of this course is to familiarize developers with the use of the SQ\
L Server Database)Tj
T*
(Engine, SQL Server Integration Services \(SSIS\), and SQL Server Analysi\
s Services)Tj
T*
(\(SSAS\) for business intelligence purposes. )Tj
19.232 0 Td
(Students will design an OLAP database utilizing)Tj
-19.232 -1.187 Td
(a star schema \(Data Warehouse\), and then populate it using ETL routine\
s designed in)Tj
T*
(SSIS. )Tj
2.834 0 Td
(After the data warehouse has been populated, SSAS will be used to build \
both)Tj
-2.834 -1.187 Td
(Multidimensional and Tabular models that will serve as reporting data so\
urces.)Tj
0 -2.188 TD
(Students will learn how to design and build data warehouses and marts us\
ing SQL Server)Tj
0 -1.187 TD
(Management Studio. In a series of exercises, students develop SSIS packa\
ges )Tj
35.242 0 Td
(designed to)Tj
-35.242 -1.187 Td
(maintain a data warehouse using the Data Flow control flow task. )Tj
29.126 0 Td
(Also demonstrated are)Tj
-29.126 -1.187 Td
(other control flow tasks that can interact with an NTFS )Tj
(file system, FTP server, execute)Tj
T*
(Win32 processes, send emails, and run .NET )Tj
20.342 0 Td
(scripts.)Tj
-20.342 -2.188 Td
(Based on )Tj
(the populated data warehouse they have created, students will then learn\
how to)Tj
T*
(develop both Multidimensional and Tabular SSAS models using the language\
s)Tj
T*
(Multidimensional Expressions \(MDX\) and Data Analysis Expressions \(DAX\
\). Cubes )Tj
37.125 0 Td
(will be)Tj
-37.125 -1.187 Td
(customized to include Key Performance Indicators \(KPIs\), Calculated )Tj
30.847 0 Td
(Members, Named)Tj
-30.847 -1.187 Td
(Sets, Navigational Hierarchies, and Perspectives.)Tj
1 g
/TT1 1 Tf
18 0 0 18 64.75 120.75 Tm
(Prerequisites)Tj
0 g
/TT3 1 Tf
12 0 0 12 61.75 83.25 Tm
(Familiarity with database concepts, Windows desktop navigation and Trans\
act-SQL.)Tj
T*
(Attendance at )Tj
(our )Tj
0.333 0.733 0.922 rg
(Microsoft Transact-SQL Programming)Tj
ET
q
10 36 592 730 re
W n
0.333 0.733 0.922 RG
0.75 w
q 1 0 0 1 159.8184 68.25 cm
0 0 m
202.055 0 l
h
S
Q
Q
BT
0 g
12 0 0 12 361.873 69 Tm
( course is highly recommended)Tj
-25.01 -1.187 Td
(although not required.)Tj
ET
EMC
endstream
endobj
26 0 obj
<>
endobj
27 0 obj
(y% 4Q]TXi)
endobj
35 0 obj
<>stream
H͋tN29Dxi
`
944vzFh۵"\vd=Yf==)Jnda߃=}_ ٷ e''YهSS!ET;TUe}Q$OIpjuHu=yU{f_\@vΫL5j(i-u"{2S;ZAi'OSSCvΫL5j ݑB WS DŽq^1gr #B3%o5c 3湼4 f<b1'FsJGg@A Bk4}^ y5VQυr.J۶~S*y8DR5eO힂2y6T=m6J2msӿ87IXGfw5~T/ \`R%zN(|얈)'fXjVE^1azD${rĐ {tsCU͉.#/%2N`ԧڸ= 1a"~܍XQh.ҹidSD(TF0-='GĠ"5K=NJ:͉ꦤUEC_nWp" gG +M(vc]wVq{;т7YN,yme;}=<NL P3C'z%Ē7jb(W~4ҼSJb
גj\'ZTi,UdωDvb*c7]b9WiNl6C9q BXjd,wTܫF97XHq'9NctOw7 ̟zs:<6RT6C7 {e߉⎴QX4vMЉ1ejU92tWIN?݉ +IV6q' GGd5g
A$+s!'6RPqNJ H|+N~R}!'%^HiMpXbj8Xk~ޥM1l/$'6NL/ 8?b%6jҠsu-x^u,!D/5