Category: Amazon Quicksight

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 +

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 +

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 +

Why use the Autograph feature in Amazon Quicksight?

Amazon Quicksight

Amazon QuickSight has a unique feature called Autograph- a graphical representation of a dataset using a type of diagram, chart, graph or table. Autograph isn’t a visual type, but chooses the visual type for you. All visuals begin in Autograph mode which selects appropriate visual type for the number and datatypes of the fields you select. Autograph works faster and better by choosing an exact visual for your 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 +

Difference between Authors and Readers in Amazon Quicksight

Quicksight Authors Readers

Authors and Readers are just a user type that cannot change account permissions or invite users. Both the users can be upgraded to admin at any time. Authors● An author is a user who can connect to data sources● Authors can create interactive dashboards using advanced QuickSight capabilities and publish dashboards with other users in the account.Readers● A reader is a user who uses interactive dashboards and they can view a shared dashboard, filter data and export as CSV files.● Readers can be upgraded to authors via user management options.● Readers with pay per session pricing exist only in enterprise edition 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 +

Machine Learning Insights in Amazon Quicksight

Machine Learning

Amazon QuickSight enterprise edition has introduced decision making insights using machine learning techniques. These are the benefits: ● Manual analysis, customer development, or machine learning domain expertise is not required to perform this action.● These insights can be embedded into a dashboard which creates a shared understanding of the data within the organization and helps t you make decisions faster.● ML powered anomaly detection can continuously examine all your data to detect anomalies.● Auto narratives can build rich dashboards with embedded narratives to tell the story of your data in plain language.● Custom insights enable you to create your own computation using your own words and it can be added to 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 +

Difference between Amazon Quicksight Standard and Enterprise editions

Amazon Quicksight

Amazon Quicksight is released in multiple versions; the following features would help in selecting the appropriate edition for your requirement. Standard Edition● You can invite any person with an email address to create an Amazon QuickSight–only user account.● When a user account is created, Amazon QuickSight sends an email to that user inviting them to activate their account.● When a user account is created, you can also choose to assign it either as an administrative or a user role.● You perform all management of users by adding, changing, and deleting user accounts in Amazon QuickSight.Enterprise Edition● All users in these groups are authorized to sign in to Amazon QuickSight as administrators.● You can only add or remove Enterprise edition user accounts by adding or removing a person from a Microsoft Active Directory group that you associated with Amazon QuickSight.● You can also bulk add or remove user accounts by integrating Microsoft Active Directory groups with, or removing Microsoft Active Directory groups from, Amazon QuickSight.● Deactivating a user by removing it from a Microsoft Active Directory group, or by removing their Microsoft Active Directory group from integration with Amazon QuickSight, does not delete the associated Amazon QuickSight user account for that […]

Read More +

Data Sources supported in Amazon QuickSight

Amazon Quicksight

Amazon QuickSight analyzes on a variety of data sources which include AWS data stores, salesforce, and other popular database engines. ● Data Sources can be accessed by using external data stores where Amazon S3 data sources save the manifest file information.● You can use any of the following relational data stores as data sources such as Amazon Athena, Amazon Aurora, Amazon Redshift, R, and so on.● Amazon QuickSight also has a list of supported files such as CSV/TSV, ELF/CLF, JSON, and XLSX. 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 Sources supported in Amazon QuickSight

Amazon Quicksight

Amazon QuickSight analyzes on a variety of data sources which include AWS data stores, salesforce, and other popular database engines. Data Sources can be accessed by using external data stores where Amazon S3 data sources save the manifest file information. You can use any of the following relational data stores as data sources such as Amazon Athena, Amazon Aurora, Amazon Redshift, R, and so on. Amazon QuickSight also has a list of supported files such as CSV/TSV, ELF/CLF, JSON, and XLSX. 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 +

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 +