PowerBI to QuickSight Conversion

Executive Summary

Standup Wireless has chosen Amazon QuickSight for their data analysis, as it is a very fast, easy-to-use, cloud-powered business analytics service that makes it easy to build visualizations, perform ad-hoc analysis, and quickly get business insights from their data, and be able to discover data from multiple data sources such as Amazon Redshift, Amazon RDS, Amazon Aurora, Amazon Athena, and Amazon S3. QuickSight enables organizations to scale their business analytics capabilities to hundreds of thousands of users and delivers fast and responsive query performance by using a robust in-memory engine (SPICE).

Customer Challenge

There was an existing reporting platform in place using Power BI, which is not meeting customer needs with getting data to business users on time, Dataset refresh, Rising Licensing Costs, Large dataset performance issues and limited sharing of reports and dashboards capability to users. Data Refresh was the biggest challenge, with multiple scheduled refreshes per day, only brought delays to see the latest real time data. Customer has lot of external/internal users who need to access data analytics, which is getting very expensive with licensing all the external users and controlling their permissions on the existing workbooks and datasets at multiple places.

Partner Solution

AWS QuickSight has been the savior to them with Pay Per Session model pricing, Embedded Analytics Capability, Federation of Enterprise Users from Active Directory to QuickSight and blazing fast SPICE (Super-fast, Parallel, In-memory Calculation Engine) Engine to do the lowest grain aggregations. Single Sign on with AWS IAM Identity Centre has been proposed and implemented to solve the manual users maintenance and enable direct login from their own mobile app. Permissions Control for Dashboards, Analysis, Datasets, Topics is super-easy with Asset Management in AWS QuickSight. Dataset Refreshes are transparent to end users as they are super-fast even for huge datasets.

Why AWS QuickSight?

• The in-memory engine, called SPICE, responds with blazing speed.
• No upfront costs for licenses and a low total cost of ownership (TCO).
• Collaborative analytics with no need to install an application.
• Combine a variety of data into one analysis.
• Publish and share your analysis as a dashboard.
• Control features are available in a dashboard.
• No need to manage granular database permissions - dashboard viewers can see only what you share.
• Federated users, groups, and single sign-on (IAM Identity Center) with AWS Identity and Access Management (IAM) Federation, SAML, OpenID Connect, or AWS Directory Service for Microsoft Active Directory.
• Granular permissions for AWS data access.
• Row level security.
• Highly secure data encryption at rest.
• Access to AWS data and on-premises data in Amazon Virtual Private Cloud.

Why StandUp Wireless Chose ITTStar?

ITTStar is an expert partner for data-driven innovation and has a unique approach to solving complex infrastructure and security problems using AWS. As an AWS Advance Partner, our confidence comes from our understanding of how to integrate AWS services into our solutions, combined with our broken-down approach to solving holistic business challenges. Associates spend time gaining a deep understanding of AWS and other technologies by studying and designing solution architecture. Members of ITTStar also focus on solving real business problems with a diverse set of clients which prepare them for successful delivery on client projects.

Impact & Results

• Seamless login to users with Single Sign on to AWS QuickSight reduces manual login and maintenance of manual users in application.
• Enabled QuickSight Embedded analytics helped user’s login to their business Portal, while still getting the power of Analytics from within.