Category: Amazon Quicksight

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 +

Using Row Level Security in Amazon QuickSight

Amazon Quicksight

Amazon QuickSight allows users to restrict access to the dataset by configuring row-level security on it. This action can be performed either before or after the dataset is being shared. ● The permissions dataset cannot contain Duplicate values and it will be ignored when evaluating how to apply rules.● If you add a rule for a user or a group and leave all other columns with NULL value you grant them access to all the data.● If there is no rule being added then the user or group cannot see any of the data.● If you deny access then every user or group can see only the rows that don’t match the field values in the dataset rules.● If the data has been restricted they are marked with the word “Restricted” in the datasets screen.● Row Level Security only works for the fields such as string, char, varchar and so on. It doesn’t work for dates or numeric fields. 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 +

Visualization types supported in Amazon Quicksight

Amazon Quicksight

Amazon QuickSight supports assorted visualizations that facilitate different analytical approaches: ● Comparison and distribution – You can use the bar chart visual type to create a single-measure, multi-measure or clustered bar chart by using a dimension for the X or Y axis and a measure for the value.● Changes over time – Line charts show the individual values of a set of measures against the range displayed, whereas area line charts are represented by a colored area.● Correlation – Using heat map and scatter plots you can measure the intersection of the two dimensions.● Aggregation – It is the practice of grouping multiple objects with similar characteristics into a single object.● Tabular – Using pivot tables for tabular form you can add up to 20 fields as rows and 20 fields as columns. 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 +