Utilizing Tableau's technologies, we could extract data from its source to convert and publish it. We enabled user and data filters and permissions to comply with the security policy. Sigmasoft then used calculated fields to achieve compliant Federal Masking. We could use a single extract published data source for all dashboards. There was significant performance improvement on Enterprise Asset Management (EAM) and General Services Administration (GSA) dashboards. 

In doing this, we were able to optimize calculations at the sheet level and minimize the marks in the views used in each dashboard. The reload time for these real-time analytics was reduced from 90 to 30 seconds. And refreshes were kept smooth and seamless when new filters were added. Delays across the board were mitigated ,and upgrades were implemented as the technology continues to improve.  

We also used Snowflake to create queries for data and security that translate seamlessly into the Tableau application. We also removed dependency on Immuta (another data access platform) by implementing enhanced security programming using Structured Query Language (SQL). We then simplified the Security SQL to reduce the number of records and provide a bigger warehouse for data to reduce latency to refresh time. 

We selected specific dashboard modules that would best suit the business needs of NetApp. These dashboards range from Customer Intelligence, encompassing Freshness, Completeness, and Landscape. We also included Deal Registration Statistics and Metrics, Sales Bookings: Bookings Overview, Bookings and Discount, Territory Overview, and Top N Metrics. The varieties of dashboards offer versatility for different departments to achieve optimization in understanding their data