Category: Amazon Quicksight

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 +

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 +