Migrating BI To The Cloud Using Amazon QuickSight
Migrating BI to the cloud usingAmazon QuickSightDipayan SarkarSoujanya KonkaSr. Analytics Specialist SA, AISPLSolution Architect, AISPL 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
BI at hyperscaleWhy to migrate in Amazon QuickSightHow QuickSight worksEmbedded AnalyticsML InsightMultitenancy and Governance
Challenges with existing BI platformsRestrictive pricingHard to scaleDon’t integrate wellResource-intensiveLack ofadvanced features
Amazon QuickSightFirst BI service built for the cloud with pay-per-session pricing and ML insights for everyoneScalablepricingAuto scalingand serverlessDeeply integratedwith AWS Deploy globally to100Ks of users withoutprovisioning serversSecure, private accessto AWS dataProgrammaticallyonboard users andmanage contentBuilt-in anomalydetection and forecastingCost effectiveat any scaleBuilt-in high availabilityIntegrated S3data lake permissionsEasily embedin your appsBring your own modelfrom Amazon SageMaker
Duplicate SheetAthena Workgroups250M rowSPICE tablesFoldersHistogram2k ColumnsText AlignmentAWS Lake FormationIntegrationWaterfall ChartAthena QueryFederationSeconds / MillisecondsCustom PermissionsNavigation ActionsAmazon TimestreamConnectorAWS GovCloud(US) RegionPresto VPCEmbeddedAuthoringEmbedded PrintingAmazon ElasticsearchService (Amazon ES) ConnectorMulti-Metric ForecastingOn-Sheet FiltersCustom SQL Joins90 new features releasedsince re:Invent 2019Reference LinesFilled MapsOracle ConnectorCapacity PricingBox PlotDynamic TitlesColumn-Level SecurityPDF ExportNamespacesCascading Filter ActionsFunnel ChartSP-initiated SSOField FoldersLog ScaleAnonymous EmbeddingExport to ExcelPublic t WrappingAsia Pacific(Mumbai) RegionCustom FontsComposite Datasets
How QuickSight worksQuickSight allows you to connect to your data sources and create dashboardsthat can be securely shared across your organizationStore your data inAmazon Redshiftdata warehouse
Connect to your data, wherever it isQuickSight is natively integrated with AWS data sources, as well as on-premises and hosteddatabases and third party business applicationsOn-premisesIn the cloudApplicationsSecurely connect to on-premisedatabases and flat files likeExcel and CSVConnect to hosted database, bigdata formats, and secure VPCsConnect directly to thirdparty business applications ExcelCSVTeradataMySQLSQL ServerPostgreSQLOracle**In preview RedshiftRDSS3AthenaAuroraTeradataMySQL PrestoSparkSQL ServerPostgreSQLMariaDBSnowflakeOracle* IoT Analytics Timestream ElasticSearch* SalesforceSquareAdobe AnalyticsJiraServiceNowTwitterGithub
SPICEQuickSight is powered by SPICE, a super-fast calculation engine that deliversperformance and scale regardless of how many users are activeYour data sourceSPICE
Create beautiful, interactive dashboards Add rich interactivity likefilters, drill-downs, zooming,and more Blazing-fast navigation Accessible on any device Data refresh Publish to everyone with a click
Insights delivered to your inbox Schedule email reportson a daily, weekly, ormonthly basis Sent to individual usersor groups User-specific reports usingrow-level security Attach PDFs
New visuals: Histogram, waterfall,boxplot, and stacked area
New visuals: Sankey, funnel, and filled map
Poll 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Why serverless mattersServer-basedBI architectureSession-basedQuickSight architectureMore concurrent usersMore servers managementneededAutomatically scales to your userpopulationsMore complex dashboardsMore servers managementneededAll you can use in 30 minGeographic distributionMore servers managementneededDeploy as needed,no infrastructure mgmt.High availabilityMore servers managementneededNative HA,no infrastructure mgmt.True Total Cost ofOwnership (TCO)License Infrastructure costs management staffSession price all-in pricing fordashboard consumption
Demo 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Why QuickSight forembedded analytics? 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Challenges with building your ownembedded analytics Embedded out-of-the-box solutions have their own challengesHard to scaleRestrictive pricingLack ofadvanced features
Seamlessly embed and make QuickSight lookand feel like your appThemes and theme editorUse different colors, spacing, backgrounds,and fonts to match app branding and UIQuickSight Embedding SDKJavaScript SDK lets you efficientlyintegrate dashboards in your applicationpages, set defaults, connect controls,and moreAWS Single-Sign OnQuickSight supports SAML /OpenID Connect federation
Enable deeper insights: Empower usersto author their own dashboardsReadersOne-time data exploration Relying on the ISV or enterpriseapplication team to author newdashboards can often be a bottleneck Provide author privileges to customersReadersAuthorReadersCustomer 1to perform one-time analysis & buildand share specific views with their teamsMonetize and differentiateReadersReaders ISVs can provide QuickSight authorlicenses to their customers as a premiumfeature and leverage this as a new wayto increase their revenueAuthorReadersCustomer 2
Embed dashboards without user provisioning Dashboards in apps, wikis, websites forend-users Display same data for all users No named users required Scale to 10s of 1000s of usersCheck out sample dashboards athttps://aws.amazon.com/quicksight/galleryNEW
Embed dashboards for authenticated users Dashboards in apps with distinct end-users Personalize views of data for users with Row orColumn Level Security Named users Scale to 10s of 1000s of users
Embed dashboard authoring in apps Data exploration and dashboardcreation/sharing for power users Provide curated datasets withRow / Column level security Customize end-user authoring / sharingcapabilities Scale to 1000s of customers with 10s of1000s of users with multi-tenancy viaNamespaces
Poll 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Demo 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
ML Insight 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Enable deeper insights:Machine learning-enabled insightsML insights With built-in ML algorithms, easily performanomaly detection and forecasting analysis,discovering anomalies and variations, or do awhat-if analysis on forecasted data Or use Amazon SageMaker integration andyour own modelsNatural language narratives QuickSight automatically generates naturallanguage narratives that can be customizedand woven into your dashboards and reports toprovide deeper context for users
Anomaly Detection
Natural Language Narratives
Type your question and get instant answerAmazon QuickSight QNEW!Ask questions about your data and get answers in seconds
Key Benefits Natural Get Instant Ask about Get Ask questions in Get answers No need to Get startedLanguageQuestionsplan businesslanguage. Noneed to learn anysyntax.Answersinstantly to adhoc questionsnot found inyourdashboards.all of yourdataspecify aparticulardataset ordashboard toask question.started inminuteswith yourexistingdatasets justjust a fewclicks.
Hard problems we are tacklingQuery UnderstandingData UnderstandingDaily rptwk rpt w goalsDaily rpt customersnapshot datesnapshot date wksnapshot dateover week for California comparedstaterev grossstaterev grossrev netrev grossto New York in 2020”rev netgoal netrev netproduct idproduct idaccount idproduct nameproduct nameaccount namelast updatedlast updateLast update“Show me weekly revenue weekThere’s infinite different waysyou can ask this same question!Data is cryptic, dirty and overlapping. How dowe identify the right data to query?
How does it nkingDatasetSelection
Key featuresReadersAuthors Query autocomplete Custom vocabulary Synonyms matching Named filters and expressions Spelling mistakes User Metrics User disambiguation Validated answers Feedback loop Predefined answers All topics search
Poll 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Demo 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Multitenancy and DataGovernance 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Easy to manage: Multi-tenant architectureNamespaces Logically group and isolate sets of users(authors and readers) within an organizationfor enhanced security Authors from one namespace are restricted tosharing and collaborating with members withinthe same namespace onlyGovern data access Allow admins to provide a restricted set ofcapabilities to embedded or regular authors Create a customized experience for authors bysharing specific datasets or data sources withcurated sUsersNamespace 1Namespace 2Namespace 3
Enterprise governance using foldersAdminsAuthorsReadersQuickSight adminsCompany-wideExecutivesMarketingQuickSight adminsMarketing analystsFinanceSalesExecutivesDashboardsQuickSight adminsMarketing analystsExecutivesMarketing usersAssets (datasetsand analyses)USQuickSight adminsMarketing analystsAPACDashboardsEMEADashboardsAssetsAssets
Column-level security
Row Level SecurityRow level security allows you to create dashboards and reports that displaydifferent data for different users. Create a single dashboard for multiple userswith different roles or data access Centrally govern access at the dataset level Works with email reports!
Federated Access with SAML 2.0Federated SingleSign-On (SSO)Allows users to sign in to theirIdentity Provider portals withexisting credentials and thenaccess QuickSight using SAML 2.0UsersThird-partyIdentity ProviderUser Directory
Microsoft Active DirectoryUser Managementand AD IntegrationQuickSight Enterprise Edition canintegrate with your Active Directory todynamically manage users and groups
NEWEnterprise edition Reader pricingConsistent performance Scale to millions of users without serversUser pricingCapacity pricingUp toStarting at 5/ reader / month 0.30 / session* up to 5Predictable BI spend for organizations*1 session 30 minutes from login; session includes alldashboard usage and interactions within 30-minute periodOR 250/ monthfor 500 sessions valid monthlyAdditional sessions 0.50 / sessionIdeal for embedded applications, ISVs, and OEMs
APIs and SDKsQuickSight APIoperations provide:QuickSight supportsfollowing SDKs: User and group management Java SDK Data management Javascript (Node.js SDK)(data sources, datasets,templates, and SPICE ingestion) Dashboard management Template management Permissions management Python 3 SDK .NET/C# SDK AWS CLI
Thank you!Dipayan SarkarSoujanya KonkaSr. Analytics Specialist SA, AISPLSolution Architect, AISPL 2021, Amazon Web Services, Inc. or its affiliates. All rights reserved.
Migrating BI to the cloud using Amazon QuickSight Sr. Analytics Specialist SA, AISPL . Multitenancy and Governance. Challenges with existing BI platforms Restrictive pricing Lack of advanced features Hard to scale Don't integrate well Resource-intensive . Securely connect to on-premise databases and flat files like Excel and CSV In the .
May 02, 2018 · D. Program Evaluation ͟The organization has provided a description of the framework for how each program will be evaluated. The framework should include all the elements below: ͟The evaluation methods are cost-effective for the organization ͟Quantitative and qualitative data is being collected (at Basics tier, data collection must have begun)
Silat is a combative art of self-defense and survival rooted from Matay archipelago. It was traced at thé early of Langkasuka Kingdom (2nd century CE) till thé reign of Melaka (Malaysia) Sultanate era (13th century). Silat has now evolved to become part of social culture and tradition with thé appearance of a fine physical and spiritual .
On an exceptional basis, Member States may request UNESCO to provide thé candidates with access to thé platform so they can complète thé form by themselves. Thèse requests must be addressed to esd rize unesco. or by 15 A ril 2021 UNESCO will provide thé nomineewith accessto thé platform via their émail address.
̶The leading indicator of employee engagement is based on the quality of the relationship between employee and supervisor Empower your managers! ̶Help them understand the impact on the organization ̶Share important changes, plan options, tasks, and deadlines ̶Provide key messages and talking points ̶Prepare them to answer employee questions
Dr. Sunita Bharatwal** Dr. Pawan Garga*** Abstract Customer satisfaction is derived from thè functionalities and values, a product or Service can provide. The current study aims to segregate thè dimensions of ordine Service quality and gather insights on its impact on web shopping. The trends of purchases have
Chính Văn.- Còn đức Thế tôn thì tuệ giác cực kỳ trong sạch 8: hiện hành bất nhị 9, đạt đến vô tướng 10, đứng vào chỗ đứng của các đức Thế tôn 11, thể hiện tính bình đẳng của các Ngài, đến chỗ không còn chướng ngại 12, giáo pháp không thể khuynh đảo, tâm thức không bị cản trở, cái được
Migrating a SQL Server Database to Amazon Aurora MySQL (p. 93) Migrating an Amazon RDS for SQL Server Database to an Amazon S3 Data Lake (p. 110) Migrating an Oracle Database to PostgreSQL (p. 130) Migrating an Amazon RDS for Oracle Database to Amazon Redshift (p. 148) Migrating MySQL-Compatible Databases (p. 179)
Le genou de Lucy. Odile Jacob. 1999. Coppens Y. Pré-textes. L’homme préhistorique en morceaux. Eds Odile Jacob. 2011. Costentin J., Delaveau P. Café, thé, chocolat, les bons effets sur le cerveau et pour le corps. Editions Odile Jacob. 2010. Crawford M., Marsh D. The driving force : food in human evolution and the future.
