Category: Amazon Web Services

AWS features to protect data in Amazon QuickSight

AWS

Amazon QuickSight ensures that AWS will be responsible for protecting the data, controlling the data to handle customer content and personal data. This protection can be done through AWS account credentials – setting up for individual user accounts with AWS identity and Access Management (IAM). Data is also protected by Multi-Factor Authentication (MFA), Secure Socket Layer (SSL) and by using advanced managed security services such as Amazon Macie. Users should note that content being delivered to Amazon S3 bucket may contain some sensitive data and it should be removed from the bucket to protect before sending it. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Viewing SPICE Ingestion history

Amazon Quicksight

Amazon QuickSight offers ingestion history for SPICE datasets which helps to see the latest ingestion started and what is the status of it. The SPICE ingestion history page includes information such as Date and time of the ingestion started Ingestion status Amount of time ingestion took place How many rows has been dropped and ingested Few job types such as refresh, scheduled and so on. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Tableau Server Management

Tableau Server Management

Tableau Server Management makes it easier to run large, mission-critical Tableau Server deployments. With Tableau Server Management, you can react quickly to the changing needs of your business and save time by streamlining the management process. Better visibility for efficient Server managementTableau’s Windows or Linux deployment provides improved monitoring through its agent-based Tableau Resource Monitoring Tool. With increased visibility into hardware utilization, VizQL sessions, data source queries, backgrounder workloads and more, it’s easier to manage and precisely tune the performance of your server.Simplified content migrationSimplify and streamline your workbook and data source content workflows with the Tableau Content Migration Tool. Manage the movement of content between projects, sites or Tableau Server environments.Leverage cloud services for better reliability and scalabilityFor large deployments hosted on AWS or Azure, customers can choose to host their Tableau Server metadata repository externally, with Amazon RDS Postgres or Azure Database for PostgreSQL. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts..

Read More +

Encryption of Data in Amazon QuickSight

Amazon Quicksight

Amazon QuickSight uses data such as names, email addresses and passwords but the administrators can view only the username and emails whereas the passwords will be completely private to each user. Amazon QuickSight encrypts data transfers such as data source to SPICE or from SPICE to the user interface and this is done by using Secure Socket Layer (SSL). You can also choose whether to encrypt or not while the data source is being transferred. All keys which are a part of encrypted data associated with Amazon QuickSight are being managed by AWS. If the database server certificates are not managed by AWS then the customers should take responsibility and it should be signed by trusted Certified Authority. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Unique features of Amazon QuickSight

Amazon Quicksight

Amazon Quicksight differentiates from other BI tools with the following unique features: ● AutoGraph – Visuals can be created in many different ways but if you choose the “AutoGraph” icon and select the necessary fields then Amazon QuickSight will determine the appropriate visual type in which the selected fields will be populated. This feature is very helpful when you don’t know what type of visualization is required for your report. ● SPICE – SPICE engine is an in-memory optimized engine for fast and ad hoc data visualization. It stores your data in a system architected for high availability till you choose to delete it. The performance of the database can be improved a lot by importing the data’s into this particular engine. ● ML Insights – Amazon QuickSight uses machine learning technology to continuously analyze all your data, detect anomalies, and send proactive email alerts. No need of manual analysis, custom development or Machine Learning Domain expertise is required. It automatically summaries into a plain language and embeds them into QuickSight dashboards which create shared understanding of the data within the organization and helps you make decision faster. DataTerrain, with years of experience and reliable experts, is ready to assist. […]

Read More +

Amazon QuickSight – Using Query Limits

Dataset SPICE

If importing data is not being done through SPICE then Query limits are being used. Otherwise timeouts can occur. ● Each result from a data query can have up to 2000 columns and each column can have up to 127 Unicode characters.● If a larger set of data is being retrieved you can reduce the size of the data by applying filters or u can deselect the columns.● This query limit has a 2-minute limit for generating a visual, or an optional dataset sample. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

HOW TO SHARE DATA IN SNOWFLAKE

Azure Snowflake

Snowflake enables sharing of data through named Snowflake objects called shares which supports data sharing by sharing tables, secure views, and secure UDFs in our Snowflake database (Data Provider) with other Snowflake accounts (Data Consumer). If the data consumer does not have a Snowflake account then we can create a reader account through which we can share data without requiring the consumer to become a Snowflake customer. All database objects shared between accounts are read-only so data consumers cannot make any change to the data. In secure data sharing, data is not actually copied or transferred between accounts; it means that shared data does not take up any storage in a consumer account. The only charges to consumers are for the compute resources used to query the shared data. In the case of a reader account, the provider will be charged for the compute resources used by users in the reader account. Data shares and reader accounts must be located in the same region of the same Cloud Provider (AWS, Azure or GCP). Data consumers cannot re-share the shared data with other accounts. In reader accounts data consumers are allowed to create new users. To start sharing data we need […]

Read More +

Benefits of using Jaspersoft with AWS

Jaspersoft reporting

Jaspersoft supports business intelligence reporting and analytics on the AWS cloud platform. The following are the major features and benefits of Jaspersoft with AWS. • AWS offers a secure cloud services platform, offering to compute power, database storage, content delivery that enable the business scale and grow. • Users can create interactive reports, dashboards and data visualizations and capable to quickly connect to Amazon RDS, Redshift and EMR data sources. • There is no data or user limits and no additional fees. • Jaspersoft for AWS is quick and easy to set up and offers a cost-efficient cloud analytics platform. • Provides a straightforward approach for installation and reports and dashboards can be created by a few clicks in less amount of time. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +