Transcript Studio Moderna Business Intelligence in Studio Moderna/historical overview Technology Adoption Program (TAP) Power Pivot for Microsoft Excel 2010 Power Pivot experience in Studio Moderna BI.

Studio Moderna
Business Intelligence in Studio Moderna/historical overview
Technology Adoption Program (TAP)
Power Pivot for Microsoft Excel 2010
Power Pivot experience in Studio Moderna
BI road map to company success
Demo Share Point 2010/Power Pivot for MS Excel 2010
Q&A
2002
2003
2004
2005
2006
2007
2008
2009
2010
500
450
400
350
300
250
200
150
100
50
0
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
Solution
CPO
CPO
For DRTV
only
Multi
priceing
E-ordering
E-ordering
Multi
distribution
centers
Multi channel
PIS
PIS
Basic
informaton
for TV
products
Graphic and
movie
materials
OLAP
For sales
Time versioning
Print
E-ordering
Single sales
channel
OLAP
OLAP
Costumer
behavior
Supply
chain
OLAP
OLAP
OLAP
SHAREPOINT
integrated
PBX
CPO
Finance

Navision
Navision
Local
version
Corporate
edition
CatPro
CPO
Costumer
orientated
2003
2004
Local
implementation
start
CRMCatPro
CRMCatPro
Order taking
and invoice
generation
Navision
Multi company /
channel &
delivery
planning
2005
2006
2007
2008
2009
2010 2011
CENTRAL DATA WAREHOUSE
Metadata
BSI
Data Transfer
Microsoft SQL 2000
AZP file (MS Access 97)
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
CRM CATPRO
Microsoft Analysis Services 2000
CENTRAL DATA WAREHOUSE
Product
Information
Site
(PIS)
Working with
partners
Code tables
(Navison,
CRM CatPro)
Informing
(CRM CatPro,
Navision)
CPO
Integration and
synchronization
(PIS,
E-ordering,
CPO)
(CPO)
Warehouse
management and
e-ordering
ERP Finances
and accounting
(CRM CatPro,
Navision,
E-ordering)
(Navision)
Call centre
(CRM CatPro)
DW
RDBMS
+
UDM
Analysis
Services
Business
Intelligence
Data source
Data Model
End user Tools
Studio Moderna
Business Intelligence in Studio Moderna/historical overview
Technology Adoption Program (TAP)
Power Pivot for Microsoft Excel 2010
Power Pivot experience in Studio Moderna
BI road map to company success
Demo Share Point 2010/Power Pivot for MS Excel 2010
Q&A
Technology Adoption Program (TAP)
Technology Adoption Program (TAP)
Studio Moderna
Business Intelligence in Studio Moderna/historical overview
Technology Adoption Program (TAP)
Power Pivot for Microsoft Excel 2010
Power Pivot experience in Studio Moderna
BI road map to company success
Demo Share Point 2010/Power Pivot for MS Excel 2010
Q&A
Democratizing Business Intelligence
Improving organizations by providing business
insights to
all employees leading to better, faster, and more
relevant decisions
 Delivered through a familiar environment
 Integrated into business productivity infrastructure
 Built on a trusted and extensible platform
Get more out of products we already own
Business User Experience
Business Collaboration Platform
Data Infrastructure and BI Platform
Familiar User Experience
Self-service Access and Insight
Data Exploration and Analysis
Predictive Analysis
Data Visualization
Contextual Visualization
Integrated Content and Collaboration
Thin Clients
Dashboards
BI Search
Content Management
Compositions
Data Infrastructure
and BI Platform
Analysis Services
Reporting Services
Integration Services
Master Data
Data Mining Services
Data Warehousing
BI for Everyone
BI for a Few
1. Analysis and query
2. Self-service reporting
3. Sharing and collaboration
25
Retrieving and Combining unlimited data
Users experience with reports:
• What they have
• What is usefull
• Where to find
• How to use them
IT managing reports :
• Security, scalability, …
Manageable Self Service BI
Studio Moderna
Business Intelligence in Studio Moderna/historical overview
Technology Adoption Program (TAP)
Power Pivot for Microsoft Excel 2010
Power Pivot experience in Studio Moderna
BI road map to company success
Demo Share Point 2010/Power Pivot for MS Excel 2010
Q&A
New IT Platform in Studio Moderna
Product
Management
E-commerce
suit
(own development
and MS CRM
upgrade)
(MS Commerce
Server)
Customer
Management
(MS CRM)
Workforce
Management
Order
Management
(own
development or
standard solution)
Integration
and
synchroniz
ation
(MS BTS)
(MS Commerce
server)
Campaign
management
Finances
(own
development and
standard solution
for on-line part)
(MS NAV)
Communica
tion system
(Third party
solution – MPL
system)
Product
Procurement
(ERP solution
(Navision or
Axapta and own
development)
DW
RDBMS
+
UDM
Analysis Services
Business
intelligence
Power Pivot – Studio Moderna
Advantages
Power Pivot – Studio Moderna
Advantages
Power Pivot – Studio Moderna
Disadvantages / Issues
Power Pivot – Studio Moderna
Conclusion
Studio Moderna
Business Intelligence in Studio Moderna/historical overview
Technology Adoption Program (TAP)
Power Pivot for Microsoft Excel 2010
Power Pivot experience in Studio Moderna
BI road map to company success
Demo Share Point 2010/Power Pivot for MS Excel 2010
Q&A
BI road map to company success
Drive plan
BI road map to company success
Who decide and how decide?
Top Management
Strategic
Middle Management
Analytics
Tactical
Daily operative
Number of decisions / Reports
BI road map to company success
Visualization – Who and How?
Professional analytical
tools
Development
Advance
Reporting Tools
Advance Analyse
Open Navigation
Simple Reporting
Tools
Lead Navigation
Pre-prepared Reports
“Dashborad”,
“Scorecard”,...
Static Reports
Operative
Analytics
Middle Management
Top
Management
BI road map to company success
Microsoft SharePoint 2010 – 360 ͦ
BI road map to company success
DATA SOURCE
FRONTENDS
BI BACKEND
PBX
UDM
Analysis Services
Power Pivot for MS Office
2010
Navision
SOURCE
STAGING
ETL
CRM CatPro
MS Office 2010/2007
STAR
MS SharePoint 2010
Reporting Services
Data import
(Banka Slovenije)
MS SQL 2000
MS SQL 2008
MS SQL 2008 R2
ProClarity 6
MS SQL 2008
MS SQL 2008 R2
Analysis Services 2008 R2
Analysis Services 2005
Reporting Services 2008 R2
Share Point 2010/Power Pivot for MS Excel 2010
Q&A
IF
{Question = 0}
THEN
{write=“Thank you”}
ELSE
{write= “Oh nooo, we ran out of time ”}
BIC06-INT | SQLCAT: PowerPivot Best Practices and Enterprise Case Studies
BIC201 | Customer Experiences with Business Intelligence
TLC-65 | Microsoft SQL Server 2008 R2 Business Intelligence
BIO03-HOL | Managing Microsoft PowerPivot for Microsoft Excel 2010 Solutions in
SharePoint Server 2010
BIO207 | BI Power Hour!
www.microsoft.com/teched
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
Sign up for Tech·Ed 2011 and save $500
starting June 8 – June 31st
http://northamerica.msteched.com/registration
You can also register at the
North America 2011 kiosk located at registration
Join us in Atlanta next year