Please enable JavaScript.
Coggle requires JavaScript to display documents.
Pidilite - Coggle Diagram
Pidilite
Current Architecture
Sources
Files (Via STFP)
SAP
Salesforce
Oracle
Business Application
DW Components
Storage Account (Blob)
ADF
Azure AS
SQL Datawarehouse
Data Flow
Landing (Azure Blob)
presaging (PRSTG)
Truncate/Load
Staging (STG)
Consolidation/Transformation
EDW
Dimensional Model
Azure AS
PowerBI (Serving Layer)
Our Understanding
Scope
Visualization Layer Improvement
PBI Data Model for all BR
1500 reports + 500 Models
Ask: Analyze data models & its Usage
For Each Model - Perform
Right Aggregation Levels
data filter levels
optimizing the datasets/datamodels
analyze relationships
Usage reports at model level
Calculated measures
Model vs Physicalization
Performance Optimizing of DAX logic
load time and recommend improvements for reports
Benchmark current time - report wise
ETL Improvements
DQ implementation recommendations
Improve ETL Load Performance
Server capacity utilizaiton
ADF Utilization Cost
Governance Controls
Governance and Control for development in PBI
Platform evaluation
Solution to replace AAS
right architecture that meets the future needs
Objectives
Cost Reduction
DW & PBI
Performance Improvement
reduce Reporting refresh time
reduce Compute size
reduce data model size
Recommend scalable architecture
DQ Improvements
reduce failures
Reduce pipeline monitoring costs
No impact to data democratization
Technical Walkthrough
Azure AS models walkthrough
Primary
Fact Invoice deatails
Fact Invoice secondary
Factscanneddata
fact
Secondar Sales
Tertary sales