Category: Amazon Quicksight

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 +