Category: Big Data & Analytics

AWS Quicksight – Creating New Analysis ”; Previous Next An analysis is a combination of one or more visuals. A visual is the representation of data in graphical, chart or tabular format. There are number of formats available to create any visual. This includes the pie charts, horizontal bar chart, vertical bar chart and pivot table. Once the input data set has been modified as per business requirement, double click on the dataset and click on visualize to start creating new analysis. It will show you the below screen or the workspace. Once you select a field, Quicksight automatically chooses the type of visual depending upon the field. If you want to change the visual type, you can select one of the visual types. For example, we start by selecting the Horizontal bar under visual types. First, drag any one field inside the visual in the centre. At the top, you will see “Fields wells” containing fields used in visual and the corresponding axis. You can click on the down arrow at the last just under user name. This will give you an expanded view. I have selected Gender on Y axis and Job family under Group/colour. You can modify the fields from dropdown. Under value, you can add any numeric field and use aggregate function on that field. By default, the visual will show count of rows. The visual will appear as follows − There are options to change the heading/title of the visual and number of other formatting options. Click the dropdown on the right most. The options will expand. Choose “format visual”. You will be able to see various options in left tab under “Format visual”. X-Axis/Y-Axis − This gives the option if you want to see the label or field name on the respective axis. It also allows you to rename these labels. Group/Color − This provides the option to change the default colors in the visual. Legend − This provides the options to change title and position of title in the visual. You can also rename the title by just clicking over it. Data labels − This provides the option to show exact values of each bar and the position where the values needs to be displayed. The below screen shows the visual with everything turned on − Print Page Previous Next Advertisements ”;

AWS Quicksight – Dashboards ”; Previous Next A dashboard shows the screenshot of the analysis. Unlike Analysis, dashboards are read as only screenshots. One can just use the parameters and filters created in visuals to create new visuals but with same charts To generate a dashboard of the analysis you have created, just click on publish dashboard under share icon. Provide any name to the dashboard and click on “Publish Dashboard” icon. You can opt to share the dashboard with all users in this account or only particular users. Now the dashboard is visible under “All dashboards” tab on home screen. Here is the sample dashboard with a filter attached to it. You can see that there is no option to edit the dashboard except applying filters added while creating visuals. Print Page Previous Next Advertisements ”;

AWS Quicksight – Embedding Dashboard ”; Previous Next You can also embed your Quicksight dashboards into external applications/web pages or can control user access using AWS Cognito service. To perform user control, you can create user pool and identity pool in Cognito and assign Embed dashboard policies to identity pool. AWS Cognito is an IAM service which allows administrators to create and manage temporary users to provide access to applications. With the use of identity pool, you can manage permissions on these user pools. Let us see how we can generate secure dashboard URL and perform user control − Step 1 – Creating user pools and users Create user pool in AWS Cognito and create users. Go to Amazon Cognito → Manage User Pools → Create a User Pool. Step 2 – Creating an identity pool When user pool is created, next step is to create an identity pool. Go to https://console.aws.amazon.com/cognito/home?region=us-east-1 Click on “Create New Identity Pool”. Enter the appropriate name of an identity pool. Go to the Authentication Providers section and select “Cognito” option. Step 3 – Creating Cognito roles Enter the User Pool ID (your User pool ID) and App Client ID (go to App Clients in user pool and copy id). Next is to click on ‘Create Pool’ and click on ‘Allow’ to create roles of the identity pool in IAM. It will create 2 Cognito roles. Step 4 – Assigning Custom Policy Next step is to assign custom policy to identity roles created in the above step − { “Version”: “2012-10-17”, “Statement”: [ { “Action”: “quicksight:RegisterUser”, “Resource”: “*”, “Effect”: “Allow” }, { “Action”: “quicksight:GetDashboardEmbedUrl”, “Resource”: “*”, “Effect”: “Allow” }, { “Action”: “sts:AssumeRole”, “Resource”: “*”, “Effect”: “Allow” } ] } You can pass dashboard Amazon Resource Name (ARN) under quicksight:GetDashboardEmbedUrl” instead of “*” to restrict user to access only one dashboard. Step 5 – Logging into Cognito application Next step is to login to Cognito application with user credentials in user pool. When user logins into application, Cognito generates 3 tokens − IDToken AccessToken Refresh Token To create a temporary IAM user, credentials are as shown below − AWS.config.region = ”us-east-1”; AWS.config.credentials = new AWS.CognitoIdentityCredentials({ IdentityPoolId:”Identity pool ID”, Logins: { ”cognito-idp.us-east-1.amazonaws.com/UserPoolID”: AccessToken } }); For generating temporary IAM credentials, you need to call sts.assume role method with the below parameters − var params = { RoleArn: “Cognito Identity role arn”, RoleSessionName: “Session name” }; sts.assumeRole(params, function (err, data) { if (err) console.log( err, err.stack); // an error occurred else { console.log(data); }) } Step 6 – Registering the user in Quicksight Next step is to register the user in Quicksight using “quicksight.registerUser” for credentials generated in step 3 with the below parameters − var params = { AwsAccountId: “account id”, Email: ”email”, IdentityType: ”IAM” , Namespace: ”default”, UserRole: ADMIN | AUTHOR | READER | RESTRICTED_AUTHOR | RESTRICTED_READER, IamArn: ”Cognito Identity role arn”, SessionName: ”session name given in the assume role creation”, }; quicksight.registerUser(params, function (err, data1) { if (err) console.log(“err register user”); // an error occurred else { // console.log(“Register User1”); } }) Step 7 – Updating AWS Configuration file Next is to update AWS configuration for user generated in step 5. AWS.config.update({ accessKeyId: AccessToken, secretAccessKey: SecretAccessKey , sessionToken: SessionToken, “region”: Region }); Step 8 – Generating embed URL for Quicksight dashboard With credentials created in step 5, call the quicksight.getDashboardEmbedUrl with the below parameters to generate URL. var params = { AwsAccountId: “Enter AWS account ID”, DashboardId: “Enter dashboard Id”, IdentityType: “IAM”, ResetDisabled: true, SessionLifetimeInMinutes: between 15 to 600 minutes, UndoRedoDisabled: True | False } quicksight.getDashboardEmbedUrl(params,function (err, data) { if (!err) { console.log(data); } else { console.log(err); } }); You have to call “QuickSightEmbedding.embedDashboard” from your application using the above generated URL. Like Amazon Quicksight, embedded dashboard also supports the following features − Drill-down option Custom actions (link to a new tab) On-screen filters Download to CSV Sorting on visuals Email report opt-in Reset dashboard to defaults option Undo/redo actions on the dashboard Print Page Previous Next Advertisements ”;

AWS Quicksight – Developer Responsibilities ”; Previous Next Following job responsibilities are performed by an AWS Quicksight developer − Person should have relevant work experience in analytics, reporting and business intelligence tools. Understanding customer requirements and design solution in AWS to setup ETL and Business Intelligence environment. Understanding different AWS services, their use and configuration. Proficient in using SQL, ETL, Data Warehouse solutions and databases in a business environment with large-scale, disparate datasets. Complex quantitative and data analysis skills. Understanding AWS IAM policies, roles and administrator of AWS services. Print Page Previous Next Advertisements ”;

AWS Quicksight – Managing Quicksight ”; Previous Next Manage Quicksight is to manage your current account. You can add users with respective roles, manage your subscription, and check SPICE capacity or whitelist domains for embedding. You would require admin access to perform any activity on this page. Under the user profile, you will find the option to manage Quicksight. On clicking Manage subscription, below screen will appear. It will show the users in this account and their respective roles. You also have a search option; in case you want to particularly search for an existing user in Quicksight. You can invite users with valid email address or you can add users with a valid IAM account. The users with IAM role can then login to their Quicksight account and view the dashboard to which they have access. Your Subscriptions will show the edition of Quicksight you are subscribed to. SPICE capacity shows the capacity of their calculation engine being opted for and the amount used so far. There is an option of purchasing more capacity if required. Account settings shows details of Quicksight account − notification email address, AWS resource permissions to Quicksight, or you also have an option to close the account. When you close Quicksight account, it deletes all the data related to below objects − Data Sources Data Sets Analyses Published Dashboards Manage VPC connection allows you to manage and add VPC connection to Quicksight. To add a new VPC connection, you need to provide the following details − Domains and embedding allows you to whitelist the domain on which you want to embed Quicksight dashboards for the users. It only supports https:// domain to whitelist in Quicksight − https://example.com You can also include any subdomains if you want to use by selecting the checkbox shown below. When you click on Add button, it adds the domain to the list of domain names allowed in Quicksight for embedding. To edit an allowed domain, you need to click on Edit button located beside the domain name. You can make changes and click on Update. Print Page Previous Next Advertisements ”;