Data Science
Usually, I'd apply my data science skills from collecting data to making a report using Tableau or Power BI. I'm able to scrape data from webpages using Requests, BS4, and Selenium. Then, the data cleansed using python pandas library. The Clean dataframe then exported to Postgresql Database. Last, make report and visualization using Tableau or Power BI
Web Development
Now, I'm still learning Web Development Front End and Backend. There are many things, especially in the office that can be done through modern data web apps. I'm planning to learn Front End such as HTML, CSS, Javascript, and React Framework. After that, i will learn Backend with Django because my base knowledge is python
Docker
I like DevOps, we can immediately deploy our program with ease. I've learned docker and used the knowledge to deploy Nextcloud for my office named MadtimCloud. The cloud can be accessed through the internet using Cloudflared Tunnel. With docker, I can my website or apps on the internet easily.
Projects
Python
Load data from sql database, wrangled,cleaned,and perform ETL then save the data back to sql database to be analyse with other tools.
Python Script
SQL
Transform data from data source into database/datamart for special analysis. Using SQL to perform automatic update to the database when needed.
SQL Script
Power BI
After data prepared, using Power BI to draw visualization to gain any insights form the data. Also using Tableau to perform data visualization. But because the license is so highh for own my personal need i think Power Bi can be alternative.
Report