To filter Athena query data between two dates, you have to convert the date column data (saved as string) into timestamp and then type cast using date function.
athena
How to Stream Data from Amazon DynamoDB to Amazon S3 using AWS Lambda and Amazon Kinesis Firehose and analyse using Microsoft Power BI
With DynamoDB Streams and the data-transformation feature of Amazon Kinesis Firehose, you have a powerful and scalable way to replicate data from DynamoDB into data sources such as S3 and then analyse using Power BI