Project estimate

Data sources and receiversXLS CSVSpreadsheetsInternal sourcesExternal sourcesERPCRMAccountingBillingWMS / POSSocialWeb analyticsAd platformsRatesWeatherData steward toolsViewsData entryManual adjustmentsELTData mappingQuality controlNotificationsKimball / Data VaultDWHInterface layerInternal objectsStaging areaMaster data layerMetadata layerAnalytics toolsDashboardsOLAP cubesPortalBusiness objects and eventsMDMData lineage
TasksWorking daysQty
Discovery and requirements for each separate stage2
1
Build and deploy the ETL pipeline project5
0
Set up the OLAP model service1
0
Deploy the dashboard service2
0
Connect to data sources (each dictionary and each fact table)5.2
2
Build each analytical dimension (hierarchies allowed)2
0
Define metric groups3
0
Build or modify the OLAP cube1
0
Build dashboards6
2
Document the system for the IT service5
0
Train staff to work with cubes1
0
Train staff to work with dashboards1
1