Please enable JavaScript.
Coggle requires JavaScript to display documents.
PLDT & Smart - Coggle Diagram
PLDT & Smart
Estimation
1 WS = 1 SSAS server
Allocate time for ws analyis
Bulk Conversion - Standard conversion - Tabular modeler editor
Issue fixing
resources
1 person 1 week DE3
Architect
1 DE2
1 DE 3 - Data Engineering space
1 week to resolve each model (large Model) + 1 week for rest
Regression testing
Write DAX query
Automation
Compare results
Approach
Build 1 obi report per model (Cust)
3 weeks for framework
56 Queries -
Objectives
Expand Platform Capacity
Migrate to Cloud Native Services
Simplify Platform Architecture
To look at the data from Cloud - Phase 2
Current Architecture
PBI Flow
VM1- Enterprise gateway
VM2 - SSASS PBI
VM3 - Integration services Server
Oracle DataMart + Hadoop
SSRS Flow
VM1 - Report Server
VM2 - SSASS - SSRSS1
VM3 - Integration Serice server (same as PBI flow)
Oracle datamart + Hadoop
Data Sources
PLDT
All Cloud
Smart
Hybrid
Question
Current Architecture
What is the role of Enterprise Gateway here?
What are the volumes from oraDM & Hadoop?
What is the role of Hadoop here?
Proposed Approach
What are the XMLA endpoints
Is there any transformation required before consumption from PBI
Expectations
Sizing discovery
Assumptions
Check the version compatibility - 2016?
Proposed Approach