Get insights using Query engine

info

• Prerequisite: Ingestion task and Create Morph Job.

Query the ACME bank's tables

• Click on 'QUERY ENGINE' from the left navigation-bar.
• Select the domain as acmebank
• Select Dataset as acme_mobile_banking_merged_<your-userid>
• Click on Generate Sample Query or write any query of your own.
• Click on Run Query
• Click on Refresh Query Status
• Click on View Results once the query status becomes SUCCEEDED

• Click on 'Download Results' to download the result as a CSV file.

Insights from data

• Run the following sql queries to get some insights from data. Copy and paste query into Query Editor and click Run Query
• ⚠️ Make sure to change the userid suffix to your userid before running queries. ⚠️

Mobile banking usage by type of phone being used:

select a.phone_os,
       count(a.account_nbr) as nbr_of_trx,
       cast(sum(a.mobile_banking_usage_freq) as int) as mobile_banking_usage_total,
       cast(sum(b.deposit_amt) as decimal) as deposit_amt
       from acmebank.acme_mobile_banking_usage_<your_userid> a join acmebank.acme_mobile_banking_trx_<your_userid> b  ON a.account_nbr = b.account_nbr group by a.phone_os order by nbr_of_trx desc

Congratulations!!!

You have successfully queried tables. Now, proceed to 'Build Dashboard' task.