Typical process to build visualizations
Let's review the process for creating insights using traditional BI tools like Oracle OBIEE, SAP Business Objects, and IBM Cognos. At a high level, building a BI dashboard involves the following:
- Ingestion framework to collect data from source systems. These systems are typically files and relational databases.
- Standardize, clean, and build facts, dimensions, and aggregates based on key performance indicators requested by business.
- Build BI logical data models; typically star or snowflakes based on various dashboard needs.
- Build reports and dashboards on the web.
- Publish and share results with data analysts and business stakeholders.
The preceding data flow is shown in the following diagram and is primarily built ...
Get Effective Business Intelligence with QuickSight now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
