Transcript Microsoft Power BI

Microsoft Power BI
Business Intelligence
18 September 2013
Artis Group Pty Limited
Level 4,655 Pacific Hwy
St Leonards, NSW, 2065
1
(02) 8404 5800
www.artisgroup.com.au
Microsoft BI
2
3
POC Solution Overview
Ratings DB
Power View
Power Pivot
Data Model
Sales DB
Power
Query
Source Data
6
Pivot Tables
Power Maps
Excel 2013 – Client Desktop ddddd
Potential BI Architecture
Ratings
Sales
Finance
CRM
Other
Core Business Data
Enterprise Information Management
(SQL, SSAS, SSMDS, SSIS, SSRS
SSDQS)
Power View & Pivot
Tables
Data Warehouse
SharePoint
2013
Office 365
Power Pivot & Power
Query
Other data (unstructured and informal source sytems)
Source systems may move into the formal EIM area
7
Power Pivot Data Model
b
b
Artis
APPLICATIONS
DATABASE
SHAREPOINT
•Architecture
& design
•Architecture
& design
•Architecture
& design
•Rapid
development &
prototyping
•Business
Intelligence
•2010
implementation
•Performance
optimisation
•Governance &
business change
•Database
consolidation
•Integration
services
•Implementation,
migration &
upgrade
•Management &
health checks
•Enterprise
interactive web
development
•Application
redevelopment
•Coding &
process reviews
•Security &
management
•Archiving
8
•Document
management
SUPPORT
•SLA based
application support
& maintenance
•Application
modernisation
•Application
transformation
PROJECTS
•Project
management
•Release
management
•Test management
•Business analysis
•System
documentation
RESOURCING
•Accredited
supplementary
workforce
•Specialist skills
Easily combine data from
any source to create fully
interactive reports and
insights with guided
exploration
Visually discover and share
insights for collaborative
decision making across
the organization
Manage self-service BI
with control & compliance
for end user created assets
Self Service Business Intelligence
- Gartner
10