If you see the Traditional BI processing model and modern data lake environment then you will find the processing model are totally different.
In respect of schema or transformation or requirements.Before we were using schema on write and now we are doing schema on read. In BI model Transformation was done after extraction but now after load.
- Start with end-user requirement, to identify desired reports and analysis.
- · Define corresponding database schema and queries.
- · Identify the required data source
- · Create a ETL pipeline to extract required data and transform it to target schema.Create reports. Analyze data.
Thanks for reading
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757