Category: 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 +

Organizing Assets into Folders in Amazon QuickSight

Amazon QuickSight

In Amazon QuickSight, folders can be created and can be shared to your team members. Using these folders, users can easily organize, navigate, and discover dashboards.● Amazon QuickSight offers personal folders and shared folders.● Personal folders are visible to the user who creates it, whereas shared folders are visible to users who have access to it.● In personal folders, a user can create subfolders, and add assets to the folder (including datasets, analyses, and dashboards).● In shared folders, users can share with other users in the same AWS account and can give ownership to the other user. 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 +

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 +

Working with Stories in Amazon QuickSight

Amazon Quicksight

Amazon QuickSight allows users to create Stories wherein you capture a series of screens and play them one by one. ● Story can be preserved for multiple iterations of an analysis and can be played sequentially to provide a narrative about the analysis data, such analysis is called a scene.● Scenes preserves the visuals that are in the analysis at the time you create it which includes filters and sort orders too.● Data in the visuals cannot be captured as part of the scene but when you play the story, visuals will reflect the current data in the data set.● Every analysis of the story will be stored under a name called storyboard and you can add scenes to the storyboard when working on the analysis. 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 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 +

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 +

Using PrestoDB as a datasource in Amazon Quicksight

Using PrestoDB

PrestoDB is an open source and distributed SQL query engine and is designed for fast analytic queries against any data size. ● It also supports a non-relational and relational data source which includes HDFS, Amazon S3, Cassandra, MYSQL, PostreSQL, Teradata and so on.● The result of the queries which are run through the presto engine can be turned into Amazon QuickSight datasets.● You can also query your data through Presto and can import the results of the query into the SPICE.● It is necessary to configure the data source profile in Amazon QuickSight for each Presto data source that you want to access. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 250 customers in the US and an additional 70 customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +