Muutke küpsiste eelistusi

Business Intelligence in Microsoft SharePoint 2013 [Pehme köide]

3.88/5 (25 hinnangut Goodreads-ist)
, , , ,
  • Formaat: Paperback / softback, 408 pages, kõrgus x laius x paksus: 226x189x22 mm, kaal: 684 g
  • Ilmumisaeg: 15-May-2013
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735675430
  • ISBN-13: 9780735675438
Teised raamatud teemal:
  • Pehme köide
  • Hind: 40,52 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Business Intelligence in Microsoft SharePoint 2013Suurem pilt
  • Formaat: Paperback / softback, 408 pages, kõrgus x laius x paksus: 226x189x22 mm, kaal: 684 g
  • Ilmumisaeg: 15-May-2013
  • Kirjastus: Microsoft Press,U.S.
  • ISBN-10: 0735675430
  • ISBN-13: 9780735675438
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780735675438.html
Märksõnad:
Looks at the business intelligence features of Microsoft SharePoint 2013, covering such topics as trusted data, Excel services, PowerPivot, Visio, PerformancePoint Services, and dashboards.

Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions.

Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server® 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

Discover how to:

  • Manage the entire BI lifecycle, from determining key performance indicators to building dashboards

  • Use web-based Microsoft Excel® services and publish workbooks on a SharePoint Server
  • Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot
  • Create data-driven diagrams that provide interactive processes and context with Microsoft Visio® Services

  • Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business
  • Use SharePoint to view BI reports side by side, no matter which tools were used to produced them
Introduction xv
Chapter 1 Business intelligence in SharePoint
1(20)
Leading up to BI
1(3)
Beware of losing sight of what matters most
4(1)
What is BI?
5(2)
The need for BI today
6(1)
What is self-service BI?
7(1)
Microsoft's vision for BI and self-service BI
7(2)
What SharePoint does for BI
9(1)
The BI stack: SQL Server + SharePoint + Office
10(2)
Authoring in Microsoft BI tools
12(1)
Examples of BI in SharePoint 2013
12(7)
PerformancePoint and the BI stack
12(2)
Power Pivot and BISM Model: A Fulfillment Report for Tracking Products
14(2)
The steps to implementation
16(2)
Sharing with other teams (building user adoption)
18(1)
A summary of the fulfillment example
19(1)
Creating a report by using an Odata feed from a SharePoint list
19(1)
Summary
20(1)
Chapter 2 Planning for business intelligence adoption
21(34)
Business user communities
22(13)
Understanding your audience: Casual users vs. power users
22(2)
Organizational hierarchy
24(1)
BI communities
25(10)
The progression of BI
35(9)
The Business Intelligence Maturity Model
36(5)
Road map to analytical competition
41(3)
Tool selection
44(7)
Excel
45(2)
Excel Services
47(1)
Reporting Services
48(1)
SharePoint BI
49(1)
PerformancePoint Services
49(1)
Visio Services
50(1)
An action plan for adoption: Build it and they might come
51(2)
Summary
53(2)
Chapter 3 The lifecycle of a business intelligence implementation
55(42)
Working together: SQL Server 2012 + SharePoint 2013 + Office 2013
57(2)
SQL Server 2012 features
59(5)
1 The SQL Server database engine
60(1)
2 SQL Server Integration Services or other tools
60(1)
3 The Business Intelligence Semantic Model
61(1)
4 Additional BI tools
62(1)
5 SQL Server Data Tools
63(1)
The lifecycle of a BI implementation
64(30)
Step 1 Decide what to analyze, measure, or forecast
67(1)
Step 2 Get to trusted data
68(5)
Step 3 or 4 Load data into a SSDT (Visual Studio) project
73(6)
Step 5 Model the data
79(3)
Step 6 Deploy the model to SSAS
82(8)
Step 7 Create a BISM file in SharePoint 2013
90(4)
Summary
94(3)
Chapter 4 Using PowerPivot in Excel 2013
97(28)
The Data Model
97(14)
Creating the Data Model
99(9)
Adding data to the Data Model
108(1)
Creating table relationships by using the Data Model
109(2)
Working with the Data Model
111(1)
PowerPivot 2013
111(5)
Data refresh
114(1)
Compatibility issues
115(1)
Calculations with DAX
116(2)
A new DAX function
118(1)
Importing data from Windows Azure Marketplace
118(4)
Paving the ground
122(2)
Summary
124(1)
Chapter 5 Using Power View in Excel 2013
125(32)
Introducing Power View
125(1)
A brief history
125(1)
Comparing editions of Power View
125(1)
What's new in Power View
126(3)
More visualizations
126(2)
Additional formatting options
128(1)
Key performance indicators
128(1)
New drill functionality
128(1)
Using Power View
129(2)
When do you use Power View?
129(1)
When do you avoid using Power View?
130(1)
Setting up Power View
131(1)
Creating visualizations
131(18)
Getting started
131(2)
Creating a table
133(2)
Creating a matrix
135(3)
Creating a chart
138(6)
Creating a map
144(2)
Creating cards
146(1)
Using KPIs
147(2)
Filtering data
149(6)
Highlighting data
150(1)
Adding a slicer
150(1)
Filtering by using tiles
151(2)
Using the Filter pane
153(2)
Saving a Power View workbook
155(1)
Summary
156(1)
Chapter 6 Business intelligence with Excel Services 2013
157(32)
A brief history of Excel Services
158(3)
2007: The introduction of Excel Services
158(2)
2010: Expanded capabilities
160(1)
2013: Continued expansion
160(1)
When to use Excel Services
161(1)
It's already Excel
161(1)
It's fast to create and easy to adopt
161(1)
It is a great ad hoc tool
162(1)
It scales Excel files to many users
162(1)
The Data Model in Excel Services
162(1)
Configuring the server
163(8)
Installation
163(1)
Administration
164(2)
Excel Services security
166(2)
External data configuration
168(3)
Opening an Excel workbook in the browser
171(11)
Viewing workbooks
171(2)
Editing workbooks
173(1)
Configure a simple Excel dashboard by using Web Parts
173(9)
Extending Excel Services
182(5)
UDFs
183(1)
Excel Web Services
183(1)
ECMAScript (JavaScript, JScript) object model
183(1)
Excel Services REST
184(1)
Excel Interactive View
185(2)
Summary
187(2)
Chapter 7 Using PowerPivot for SharePoint 2013
189(24)
A brief history
190(1)
When do I use PowerPivot for SharePoint?
191(1)
Getting started
191(1)
Installing PowerPivot for SharePoint
191(1)
Publishing to SharePoint
192(2)
The PowerPivot Gallery
192(2)
Scheduling data refreshes
194(8)
Data Refresh
197(1)
Schedule Details
197(2)
Earliest Start Time
199(1)
E-mail Notifications
199(1)
Credentials
200(1)
Data Sources
201(1)
Workbooks as a data source
202(1)
Monitoring with PowerPivot for SharePoint
203(8)
Infrastructure - Server Health
205(3)
Workbook Activity
208(1)
Data Refresh
209(1)
Reports
210(1)
Summary
211(2)
Chapter 8 Using PerformancePoint Services
213(56)
A brief history of PerformancePoint Services
213(1)
An overview of PerformancePoint Services components
214(7)
Data sources
214(1)
Scorecards
215(1)
Reports
216(1)
Context menu features
217(1)
Dashboards
217(3)
Other features
220(1)
What's new in PerformancePoint Services 2013
221(2)
What's new for designers
221(1)
New for IT professionals
222(1)
When do I use PerformancePoint Services for BI?
223(1)
The PerformancePoint Services architecture
223(1)
PerformancePoint Services configuration
224(11)
Configure security for PerformancePoint
227(5)
Start PerformancePoint Dashboard Designer
232(3)
Providing a performance solution
235(32)
Design the KPIs, scorecards, reports, and dashboard
236(31)
Summary
267(2)
Chapter 9 Using Visio and Visio Services
269(40)
Background
269(1)
What's new in Visio 2013
270(1)
Six reasons to include Visio 2013 in your BI suite
271(12)
Linking to data
272(1)
Visualizing data
273(1)
Collaborating to create the best result
274(2)
Validating diagrams
276(3)
Saving as a website
279(2)
Saving to Visio Services
281(2)
When do I use Visio and Visio Services?
283(3)
Netaphor Software
284(2)
Additional case studies
286(1)
Incorporating Visio into a BI solution
286(1)
Visio Services: Example 1
287(8)
Organizing the data
287(1)
Creating the Visio diagram
288(5)
Visualizing data
293(1)
Saving to Visio Services
294(1)
Visio Services: Example 2
295(13)
Organizing the data
296(1)
Creating the Visio diagram
296(1)
Saving to Visio Services
297(1)
Linking to data
297(5)
Visualizing data
302(2)
Creating a Web Part page
304(2)
Refreshing the diagram when data changes
306(2)
Summary
308(1)
Chapter 10 Bringing it all together
309(22)
Dashboards
309(2)
Making dashboards useful
310(1)
Tools in SharePoint for authoring dashboards
311(1)
Which dashboard tool should I use?
312(3)
Dashboard (Web Part) pages in SharePoint
315(2)
Using Excel Services in the dashboard (Web Part page)
317(3)
Creating the Excel workbook
317(3)
Preparing the workbook for the dashboard: adding parameters
320(8)
Showing the workbook in Web Parts
322(4)
Setting other Web Part properties
326(1)
Using the filter added in Excel 2013
327(1)
Adding to the dashboard (Web Part page)
328(1)
Visio Web Access Web Part
328(1)
PerformancePoint Web Parts
328(1)
The Web Part page
328(1)
Summary
329(2)
Appendix A Running scripts to set up a demonstration environment
331(18)
Hardware considerations
331(1)
Introducing the scripts
332(1)
Step 1 Install the Active Directory Demo Build 2.1
333(3)
Prerequisites
333(1)
Installing the content pack
334(2)
Post installation
336(1)
Step 2 Install the SQL 2012 SP1 Content Pack Demo Build 2.0.0
336(4)
Contents of SQL 2012 SP1 Content Pack Demo Build 2.0.0
336(1)
Prerequisites
337(1)
Installing the content pack
338(1)
Post installation
339(1)
Step 3 Install the SharePoint 2013 Demo Build 2.0
340(2)
Prerequisites
340(1)
Installing the content pack
340(1)
Post installations and known issues
341(1)
Step 4 Install the UserProfile Provisioning Demo 2.0
342(1)
Prerequisites
342(1)
Installing the content pack
342(1)
Step 5 Install the Self-Service BI Demo 2.0 Content Pack
342(4)
Prerequisites
343(1)
Installing the content pack
343(1)
Post installations/known issues
344(2)
Step 6 Install the Visio Services Demo Content Pack
346(3)
Prerequisites
347(1)
Installing the content pack
347(2)
Appendix B Microsoft and "Big Data"
349(2)
What is Big Data?
350(2)
Volume
350(1)
Velocity
351(1)
Variety
351(1)
Comparing Big Data to electrification
351(1)
The "hype cycle" for Big Data
352(1)
The Big Data toolset
352(3)
Hadoop, MapReduce, and HDFS
352(1)
Pig and Hive
353(1)
Other tools
354(1)
What is NoSQL?
354(1)
Big players (companies)
355(1)
Using Microsoft's Big Data tools
355(2)
HDInsight
355(1)
Setting up in Windows Azure
356(1)
Getting value from Big Data
357(3)
Excel-Hive Add-in
357(1)
The Data Explorer for Excel Add-in (preview)
358(2)
Data Quality Services
360(1)
Summary
360
Index 351
Ivan Sanders is a Microsoft MVP for SharePoint and independent consultant focused on delivering Microsoft SharePoint solutions.