Datafun

Source: iStock Motivation This project is part of my application process to The Data School Information Lab - Germany. After reviewing one my portfolio Road Crash Analysis, they decided to proceed to the final step. They provided me an already cleaned data to work with and asked me to analyze and build a dashboard out of it using Tablea... Read More

Source: wikipedia Motivation As a (future) data analyst, data acquisition is one of the day-to-day work. It is quite convenient when data we need is already published somewhere on the internet as open source data. We can of course get right into analysis. However, as we know that this world is not ideal. Sometimes, data analyst must go ... Read More

Source: wikipedia Part 2 Showing tables In this step, I added functionalities to see all created and updated tables based on designed keyword such as student ID, student name, etc. A. Departments Database function for reading table “departments”: # File: db.py def showing_department(department): with create_server_connection... Read More

Source: wikipedia Motivation After completing Data Analysis course, I still feel somehow that SQL topic hadn’t been explored sufficiently. In short, I’m not satisfied enough and need more exercises. I’ve done one SQL-based project using PostgreSQL in which SQL query was used to answer business questions. That project honestly really hel... Read More

Source: pixabay The dashboard for this analysis is built in Tableau, which can be found here. Overview - Business problem According to WHO, approximately 1.3 million people die each year as a result of road traffic crashes. Between 20 and 50 million more people suffer non-fatal injuries, with many incurring a disability as a result ... Read More

Source: emulatorpc.com Overview Being non-developer, but always dealing with code here and there, I have been feeling, my coding skill is lacking. So, this week, I wanted to refresh my programming skill and revisit a programming concept I have learned in the past, namely OOP (Object-Oriented Programming). I did some quick research on the s... Read More

Overview - Business problem Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing stiff competition from streaming services such as Netflix and Amazon Prime, the Rockbuster Stealth management team is planning to use its existing movie licenses to launch an online video rental service in order to ... Read More

Source: upload.wikimedia.org Overview - Business problem Instacart is an online grocery store that has already made very good sales, but they want to uncover more information about their sales patterns. They assume they can’t target everyone using the same methods, and they’re considering a targeted marketing strategy. They want to targe... Read More