-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
1/46
Confguring SharePoint
or Business Intelligence
John P WhiteChief Technical OcerUnlimitedViz Inc
jpw@unlimitedvizcom@diverdown!"#$
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
2/46
% & 'harePoint 'aturda( )ew *or+ Cit( %,!-
.ou/e+eepin0 Plea/e remem1er to turn in (our 2lled out
1in0o card/ and event evaluation/ for prize/
'harePint i/ /pon/ored 1( 'lalom at Whi/+e( Trader 34etween 55th and 5#th on #th 6venue7
8ollow 'harePoint 'aturda( )ew *or+ Cit( on Twitter @/p/n(c and ha/hta0 9/p/n(c
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
3/46
Thanks to Our Sponsors!
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
4/46
John WhiteCTO:Co;8ounder of UnlimitedViz'harePoint 'erver
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
5/46
5 &'harePoint 'aturda( )ew *or+ Cit( %,!-
60enda
8ramewor+ andwhatA/ new
Beuirement/=architecture andin/tallation
ItA/ a little +nownfactD
'calin0 (our 4Iinve/tment/
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
6/46
Eoin0 deep with FGcel'ervice/
Elo1al 'har+ 6ccident 8ile http::www/har+attac+2lenet:incidentlo0htm
http://www.sharkattackfile.net/incidentlog.htmhttp://www.sharkattackfile.net/incidentlog.htm
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
7/46
H &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
8/46
!! &'harePoint 'aturda( )ew *or+ Cit( %,!-
WhatA/ new in Oce:'harePoint %,!- 4I
GVelocit(en0ine inFGcel clientPowerPivot
Power View
Per;U/er
6uthenticationPower Viewenhancement/
PerformancePoint 't(lin0
6nal(/i/
'ervice/'harePointmodePowerPivot for'harePoint notreuired
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
9/46
Beuirement/= architecture
and in/tallation
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
10/46
!- &'harePoint 'aturda( )ew *or+ Cit( %,!-
FGcel 'ervice/ famil(
reuirement/FGcelOce Pro Plu/ licen/e
GVelocit( model ena1leda/ reuired
PowerPivot add;inincluded= mu/t 1eena1led
PowerView and;inincluded= ena1led a/needed
FGcel'ervice/'harePoint Fnterpri/e
C6?
Included on 'P media
eplo(/ a/ /erviceapplication
Beuire/ 6' 'P ? 'erver 4I orFnterpri/e
'>?
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
11/46
!# &'harePoint 'aturda( )ew *or+ Cit( %,!-
GVelocit( compati1ilit(matriGPowerPivot orSharePoint (SQLServer "#$
PowerPivot orSharePoint (SQLServer %$
&nal'sis ServicesSharePoint o)e(SQL % SP%$
FGcel %,!, withPowerPivot 3%,,KB%7
*e/ *e/L *e/L
FGcel %,!, withPowerPivot 3%,!%7
*e/ *e/ *e/LLL
FGcel %,!, withPowerPivot 3%,!%'P!7
)o *e/LL *e/LL
FGcel %,!- with or
Without PowerPivot )o )o *e/L Can Onl( Befre/h 'licer/LL Cannot u/e 'P! feature/ with Power ViewLLL ?imited to pre 'P! PowerPivot feature /et
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
12/46
!H &'harePoint 'aturda( )ew *or+ Cit( %,!-
Beportin0 'ervice/reuirement/ 3I? 'erver4I or
Fnterpri/e6lertin0
'elf /ervice/u1/cription/
Power View
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
13/46
!K &'harePoint 'aturda( )ew *or+ Cit( %,!-
PerformancePointreuirement/'harePoin
t
Fnterpri/eeplo(/ a/ 'P /erviceapplication
'>? 'erver
6nal(/i/'ervice/8or anal(ticchart/:0rid/
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
14/46
!" &'harePoint 'aturda( )ew *or+ Cit( %,!-
In/tallin0 'harePoint 4IComponent/
OceFGcel 'ervice/
PerformancePoint
Other 'tuM
'>?
'erverBeportin0 'ervice/PowerPivot
6nal(/i/ 'ervice/
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
15/46
%, &'harePoint 'aturda( )ew *or+ Cit( %,!-
'tandard % /erver'harePoint farm
'erver O'
'harePoint8oundation
8F Pro2leFGcel
'ervice/'earch DD
'erverO'
'>?'erver
4 ''6' ''I'
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
16/46
%! &'harePoint 'aturda( )ew *or+ Cit( %,!-
4I inte0ration N cla//icmi/ta+e
'erver O'
'harePoint8oundation
8F Pro2leFGcel
'ervice/
'earch DD
'erver O'
'>? 'erver
'harePoint8oundation
4 ''6' ''I' ''B' PP
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
17/46
%% &'harePoint 'aturda( )ew *or+ Cit( %,!-
4I inte0ration N % /erverfarm
'erver O'
'harePoint8oundation
W8F Pro2leFGcel
'ervice/
'earch DD ''B' PP
'erver O'
'>?'erver
4 ''6' ''I'
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
18/46
'etup and con20uration
6nal(/i/ 'ervice/ 'harePoint mode
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
19/46
%$ &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
20/46
%H &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
21/46
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
22/46
'etup and con20uration
PowerPivot for 'harePointPowerPivot 6dd;in availa1le a/ a download 3'>? 8eature Pac+7 ; http::wwwmicro/oftcom:en;u/:download:detail/a/pGid-55K,
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
23/46
-% &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
24/46
-- &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
25/46
-$ &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
26/46
-# &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
27/46
'etup and con20uration
Beportin0 'ervice/ 'harePoint mode
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
28/46
-" &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
29/46
$, &'harePoint 'aturda( )ew *or+ Cit( %,!-
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
30/46
'etup and con20uration
PerformancePoint
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
31/46
'calin0
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
32/46
5# &'harePoint 'aturda( )ew *or+ Cit( %,!-
'in0le /erver with 4I
'erver O'
'>? 'erver
'harePoint 8oundation
8F Pro2le IndeGer 'earch
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
33/46
5H &'harePoint 'aturda( )ew *or+ Cit( %,!-
% /erver farm with 4I
'erver O'
'harePoint8oundation
W8F Pro2leFGcel
'ervice/
'earch DD ''B' PP
'erver O'
'>?'erver
4 ''6' ''I'
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
34/46
5K &'harePoint 'aturda( )ew *or+ Cit( %,!-
'eparate role/
'erver O'
'harePoint8oundation
Pro2leFGcel'ervice/
'earch
DD ''B'
'erver O'
'>? 'erver
4''6
'''I'
'erver O'
'harePoint8oundation
8F
'erver O'
'>? 'erver
6nal(/i/ 'ervice/ N'harePoint
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
35/46
5" &'harePoint 'aturda( )ew *or+ Cit( %,!-
4I inte0ration N miGedrole/
'erver O'
'harePoint8oundation
Pro2le Crawl
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
36/46
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
37/46
'calin0 the 4I 'ervice/Beportin0 'ervice/6dd Beportin0 'ervice/ N 'harePoint to all application /erver/
6dd Beportin0 'ervice/ 6dd;In to all front end /erver/ 3Q7
GVelocit(:6nal(/i/ 'ervice/:PowerPivotIn/tall on /tandalone /erver for 6nal(/i/ 'ervice/ 'harePoint ? 8eature Pac+7 ; http::wwwmicro/oftcom:en;u/:download:detail/a/pGid-$H,%
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
38/46
ItA/ a little +nown fact
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
39/46
Per u/er identitie/
The Rdou1le hopS Pro1lem
er1ero/ N 6 dou1le ed0ed /word
Claim/ N future /olutionPer u/er identitie/ without er1ero/
F88FCTIVFU'FB)6
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
40/46
Imper/onation emo
Beportin0 'ervice/
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
41/46
#5 &'harePoint 'aturda( )ew *or+ Cit( %,!-
Imper/onation Option/
SQL Server &nal'sis Services&nal'sis Services *SharePoint o)e
FGcel 'ervice/ )o *e/ )o
Beportin0 'ervice/ *e/ *e/ )o
Power View ):6 *e/ )o
PerformancePoint )o *e/ )o
4oth 'FTU'FB37 and F88FCTIVFU'FB)6?7
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
42/46
Inte0ration
Whole @'U
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
43/46
#H & 'harePoint 'aturda( )ew *or+ Cit( %,!-
Oce We1 6pp/ Turn O88 Benderin0 for Gl/G 2le/
)ew;'PWOPI'uppre//ion NeGten/ion Gl/G Nactionview
http::1lo0/technetcom:1:eGcel/ervice/powerpivotfor/harepoint/upp
ort1lo0:archive:%,!-:,!:-!:powerpivot;for;/harepoint;1row/er;refre/h;fail/;data;refre/h;not;/upported;in;oce;we1;app/a/pG
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
44/46
'harePoint a/ a data/ourceBeportin0 'ervice/ doe/ it nativel(
'>? 'erver Inte0ration 'ervice/Warehou/in0
Operational ecienc(
CodePleG Projecthttp::/l/rvinte0ration/rvcodepleGcom:relea/e/:view:!H#5%
.ow To U/ehttp::dataueenunlimitedvizcom:%,!!:,#:how;to;u/e;a;/harepoint;li/t;a/;a;data;/ource;in;(our;//i/;pac+a0e:
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
45/46
.ealth 6nal(zer
Eood Tool= 1ut too man( fal/e po/itive/PowerPivot ha/ /pecial rule/
Correct the real pro1lem/= di/a1le the other/
.ow tohttp::whitepa0e/unlimitedvizcom:%,!%:,#:the;health;anal(zer;and;powerpivot;for;/harepoint:
-
8/17/2019 Managed Metadata in SharePoint 2013 Step by Step Vlad
46/46
>ue/tion/