Data Lake Approach Document
The New Data Sources - Semi structured data, Time series data, Data with schema on read, need to be incorporated in the New Data Model – Adoption of Data Lake.
To Achieve Agility, ETL Speed Process needs to be changed to ELT
Direct Query Option will be configured to enable various departments specific reporting requirements through Power BI. This eliminates to directly query the master data base.
Advanced Analytics will be developed as per Business Requirements.
All manual activities / report fetching will be eliminated. All reports will be Automated and will be made available through schedular at specific time.