Oracle_Apex Web-Application Development

This project explores trends in how people search using generative AI in the United States.

Used Programming Languages

• HTML
• CSS
• JS
• SQL

Data source

I got the data from a free website called Data World.

Source raw data file: (CSV)

• https://data.world/makeovermonday/generative-ai-search-trends-in-the-united-states

I successfully cleaned, analyzed, and transformed the data into an Oracle Database. I used SQL to create a new table called TBL_SEARCH_PRC to store generative AI search trends data

Database

• Oracle Database

Login Page

After making the data ready, I designed and developed a login page using HTML and CSS. For a successful login, there are two requirements listed below.

• Username
• Password

Login Page Screenshot

Data Visualization using Oracle Apex

By developing SQL queries and using Oracle APex Application - Page Designer, I designed and developed an appealing dashboard to illustrate trends. This dashboard provides an insightful breakdown of the percentage of searches in the United States for the terms 'Midjourney', 'Stable Diffusion', and 'DALL-E' since January 2022.

Dashboard Design