Category: Amazon Quicksight

Security and access features in Amazon Quicksight

AWS

Multi-factor authentication can be enabled for AWS accounts through AWS Management console. To enable the traffic flow into VPC (Virtual Private Cloud) and database instances, you can add Amazon QuickSight IP address range when your VPC is being connected with public connectivity. If your data is in AWS or on-premises without public connectivity, private VPC access uses an Elastic Network Interface for secure, private communication with data sources. It also allows using AWS Direct Connect to create a secure, private link with on-premises resources. Row-level security (RLS) enables owners to control access to data at row granularity based on permissions associated with users interacting with the data. 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 +

Data source using Apache Spark in Amazon Quicksight

Amazon Quicksight

Apache Spark is an analytics engine mainly for large scale data processing and it also supports a rich set of tools including Spark SQL, MLlib, GraphX and Structured Streaming. ● Apache Spark can be connected directly to Amazon QuickSight or it can be connected through SparkSQL.● Spark products must be configured before using it with Amazon QuickSight.● Amazon QuickSight requires the spark server to be secured and authenticated using LDAP which will be available in version 2.0 or later.● If there is any unauthorized access then Amazon QuickSight will refuse the connection to the server. 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 +

Supported and Unsupported Data values in Amazon Quicksight

Amazon Quicksight

Currently Amazon QuickSight supports the following primitive data types such as Date, Decimal, Integer, and String. ● Date primitive type supports both 24-hour and 12-hour clocks. It also supports in the range from Jan 1, 1400 00:00:00 UTC to Feb 26, 2364 23:59:59 UTC for SPICE datasets.● Whereas the decimal data type supports up to only four decimal points and if it is higher scale then it will be truncated to the four decimal places.● Boolean data types are converted to integers in Amazon QuickSight.● If a certain field contains values which are not being recognised by Amazon QuickSight then the rows with these values will be skipped.● In a few cases a particular data field might contain values that the JDBC driver can’t interpret for the source database then those values are being replaced by null.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 +

Amazon QuickSight advantages

AWS

Multiple data sources such as Apache Spark, Amazon Redshift, Amazon Aurora and so on, can be integrated easily into AWS with QuickSight.  Compared to other BI tools, QuickSight is cost-friendly and cost-effective. QuickSight has visualization recommendations for the data presented which is a popularly feature known as ‘AutoGraph’, which basically learns data and recommend the appropriate graphs. When it comes to Setting up QuickSight is very less complicated and can be done in fewer hours. The SPICE Engine requires no prior setups and also users can work simultaneously on the interactive analysis with different data sources in AWS. 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 +

SaaS connectors in Amazon Quicksight

Amazon Quicksight

SaaS connectors can be used to access data directly from Amazon QuickSight for analysing and reporting. ● The SaaS connectors simplify accessing third-party application sources using OAuth, without any need to export the data to an intermediate data store.● SaaS applications can be used on either cloud-based or server-based instances.● If Amazon QuickSight can’t access the application, it will generate an unknown host error.● Organizations can integrate with Adobe Analytics to build consolidated dashboards to visualize their online and web marketing data.● The SaaS source must support REST API operations for Amazon QuickSight to connect to 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 +

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 +

Major benefits of Amazon QuickSight

Amazon Quicksight

Amazon QuickSight is an Amazon Web Services which enables businesses to upgrade from a spreadsheet based reporting to an interactive tool that can analyze the data. The main purpose of this tool is to convert the unstructured data into actionable intelligence. Data source Compatibility – Almost all types of data sources can be accessed and in fact any form of data stored in an internet accessible environment can be worked with QuickSight. SPICE engine – It is a super fast, parallel, in-memory, calculation engine and it is quick and easy to use. It is designed to be more powerful with enormous amounts of data readily available through its replication process. Portability – This tool can be accessed from anywhere such as laptop, desktop, smart phone, tablets and even offline after installing offline mode. Flexibility – QuickSight is designed in such a way that users can play around with massive data with a world class data engine and flexibility of the tool which increases the usage. Smart visualizations – The feature such as ‘Autograph’ accurately predicts the data and analyses it based on your analytical patterns and comes out with a solution. Self-service analyses – The data can be separated as […]

Read More +

How to secure shared folders in Amazon QuickSight

AWS

Amazon QuickSight administrator have authorization to create or share the Shared folders to one or more groups. Shared folder on Amazon QuickSight has two access levels where the folder owner owns everything inside the folder whereas the folder viewer can only use the assets such as folders dashboards and datasets.● AWS security is enforced on each and every object within the folder which is applied to the assets of whoever the folder is shared with according to their access level.● When a sub folder is shared at any level the person whom the folder was shared with sees the root folder in the top level folders view.● A shared asset inherits its permission from the folder when it belongs to the owner.● A private asset is created when an asset is added to a shared folder and this can be viewed by but doesn’t belong to the folder owner. 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 +

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 +

Dashboard Elements in Amazon QuickSight

Amazon QuickSight

Dashboard Elements in Amazon QuickSight provide various options such as zoom in or Zoom out, filtering the data, and exporting the data. Specific data fields can be excluded or focussed action can be performed. If your dashboard contains data on which you can drill down or up, you can drill up to a higher level or drill down to explore deeper details. If the dashboard contains custom actions you can activate them by choosing a data point.Amazon QuickSight allows changing the chart colors or the specific field colors as a part of these elements. 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 +