The best features Yellowbrick Data Warehouse offers include workload management, which helps me see how different workloads are available on warehouse resources. It is very helpful for executive dashboards, ETL data loads, and ad-hoc analysis queries. Workload management helps me keep dashboards, ETL loads, and ad-hoc queries from affecting one another in practice by showing me how to find the problems. It allows me to monitor the resource pools, review the queries and quick queries, monitor resource consumption, set workload priorities according to business requirements, and investigate resource contention. It is also very helpful for security management because it is my responsibility to ensure users have appropriate access. My typical responsibilities include creating database users, creating roles, granting permissions, and revoking unnecessary permissions. Yellowbrick Data Warehouse also receives a large volume of data from external systems, such as SQL Server, Oracle, PostgreSQL, Hevo Data, Informatica, Python ETL applications, and cloud storage. It is easy to monitor whether the data loads successfully, as Yellowbrick Data Warehouse provides me with the YBLoad utility as a bulk loading mechanism. The accuracy and reliability of the output from Yellowbrick Data Warehouse are positive, and so far in my experience, it has been very helpful.
