abilitics-microsoft days 11-case ctudy: where sharepoint, silverlight & bi meet the business
Post on 20-Jun-2015
636 Views
Preview:
DESCRIPTION
TRANSCRIPT
Where SharePoint, Silverlight & BI meet the Business
Rossen ZhivkovCEO / Solution Architect
Abilitics
Veselin Georgiev.NET Developer & Trainer
Abilitics
2
Presents
Data Centric SharePoint Solutions:The SharePoint, The Silverlight & The BI Movie
3
Getting the data in
Working with data
Getting the data out
Archiving the data
Reporting the data
The Movie Script
4
Based on true story
5
Initiate Sales / Service Request
Approval (Financial) Routing Servicing Reporting
Sales Pipeline Management
Ex: Office 365 - I am offering you 250 accounts for Exchange, SharePoint & Lync
8
Project Management Automation
Initiate Project / Change Request
Prioritization & PM
Assignment
Vendor Work
Planning
ProjectDelivery
Vendor CapacityControl
Ex: We want to offer Office 365. Please adjust the internal systems & put it on the web site
11
The Movie Stars
12
Solution Components
Excel Data Import Automation App Silverlight Grid
Document Generation Framework Archiving App
BI Data Sync App
13
THE MOVIE
14
Get the Data In
Work with the Data
Get the Data out
Archive the Data
Report the Data
The Director’s Cut
15
Get the data in
SharePoint / InfoPath /
Silverlight Forms
Excel Forms Import
Attached Documents Excel Data Import
16
Excel Data Import
Excel Data Files SharePoint Lists
Multiple sheets with linked entities via IDs
Importing Excel rows to SharePoint lists with lookup fixes & data
validation
18
Get the Data In
Work with the Data
Get the Data out
Archive the Data
Report the Data
19
Why Custom Silverlight App for Data Management
Simplified Views Management User Experience
Excel Like Editing Bulk Operations
20
21
Get the Data In
Work with the Data
Get the Data out
Archive the Data
Report the Data
22
Get the data out
23
Document Generation Process
+ =
Word Template
XML Configuration Document
?
24
Document Generation Process
+ =
Word Template
XML Configuration Document
Word Document
25
Get the Data In
Work with the Data
Get the Data out
Archive the Data
Report the Data
26
SharePoint BI Front End
Disaster Recovery Farm
Archival Farm
Internal users Mobile Users
Firewall
SQL 2008 R2 Cluster
SSAS Cubes
SQL Server 2008 R2 Archival
Log Shipping
BCS to Oracle DB
SharePoint 2010 Web Front Ends
Limited users
Solution Architecture
Read-only Farm SecuredEnterprise CAL
Management
27
Archiving Tool
Business Rules Archiving
• Date & Status based
• Content type archiving
Related Entities Archiving
• Related Lists Via Lookups
• Related Documents
Change Management
• Changed Data Management
• Users Management
28
Get the Data In
Work with the Data
Get the Data out
Archive the Data
Report the Data
29
Report the dataOrganize data into Multidimensional cubes, used as sources for
Excel, Excel Services & Performance Point Services
30
Reporting the data
Archiving the data
Getting the data out
Working with data
Getting the data in
To Sum it up
Business Intelligence
Archiving Farm & App
Document Generation
Silverlight Grids
Excel Importing
31
Q & A
We are waiting for you on our stand.
Fill in your questionnaire and win a
Chill Out Chair!
top related