In one of previous blog posts here in medium I modeled an OLAP system (Star Schema)for credit card transactions kaggle dataset as below. In… — In one of previous blog posts here in medium I modeled an OLAP system (Star Schema)for credit card transactions kaggle dataset as below. In this blog posts I implemented the OLAP design in Amazon Redshift and built a simple dashboard on the Redshift DWH using Amazon Quicksight.

In this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3 sing… — In this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3 sing Amazon Redshift Spectrum / Glue Crawler. AWS S3 & GLUE CRAWLER/DATA CATALOG In my last article I wrote about the .csv file I used…

In this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3. — In this article I would like to write about creating a Amazon QuickSight Dashboard for the data in a csv file located in Amazon S3. AWS S3 Find and enter S3 from AWS Management Console. Create a S3 bucket “02transactions” with the default options and upload the Transactions.csv …

In my previous article here in Medium, I built a simple stream processing pipeline in AWS which writes credit card transactions data into… — In my previous article here in Medium, I built a simple stream processing pipeline in AWS which writes credit card transactions data into an OLTP Database(Serverless Aurora RDS). https://arockianirmal26.medium.com/building-a-stream-processing-pipeline-in-aws-3224764a6d2b

In this article, I am writing about loading the .CSV file data in bulk from AWS S3 bucket into RDS Aurora Serverless using AWS Cloud9. At… — In this article, I am writing about loading the .CSV file data in bulk from AWS S3 bucket into RDS Aurora Serverless using AWS Cloud9. At the time of writing this article, Serverless Aurora clusters don‘t have the feature of loading data from a text file in S3 into the…

In my earlier article here in Medium, I took a kaggle credit card transaction dataset and modeled it for the OLTP and OLAP databases as… — In my earlier article here in Medium, I took a kaggle credit card transaction dataset and modeled it for the OLTP and OLAP databases as below. https://arockianirmal26.medium.com/oltp-olap-database-modelling-on-a-kaggle-dataset-3d52c2e02ac7 In this article I am writing, how I created a simple stream processing pipeline in AWS for the OLTP data model as in…

In this article, I took a Kaggle dataset and tried to design data models for OLTP (Online transaction processing) and OLAP (Online… — In this article, I took a Kaggle dataset and tried to design data models for OLTP (Online transaction processing) and OLAP (Online analytical processing) databases. The dataset I chose for this purpose is the credit card transactions which are synthetically generated. It contains the transaction, customer and merchant details. https://www.kaggle.com/kartik2112/fraud-detection