BI solution Architect
Use Cases and Deployment Scope
TARGIT is one of the reporting tools we use.
Pros
- It can be used to create report efficiently
- Has some basic ETL capabilities
- Has some basic analytics capabilities
Cons
- needs better functionality for error handling
- needs to improve ETL progress monitoring
- needs a UI for configuration tool, that can be used to configure cube, etl logging, backups etc.
- need integration with sql server agent for easier scheduling
- needs UI to review etl and cube processing logs
Return on Investment
- It helped us start out BI solution, but soon we faced some difficulties, especially for logging, performance monitoring and configuration of the tool.
Alternatives Considered
Tableau Desktop and Microsoft Power BI
Other Software Used
Microsoft SQL Server, SQL Server Integration Services, Microsoft Power BI









