Developer Problem

Developer Problem

1. Back-end

   • Programming Environment
     • Database Management System
       • mySQL
       • Oracle
       • sqLite
     • Code Libraries
       • Numpy
       • Flask
       • Werkzeug
     • Programming Languages
       • Python
       • Javascript
       • Java
       • C#

2. Front-end

   • Graphical User interface
     • Design
     • Programming languages
       • HTML
       • CSS
       • Swift
     • Webpages
       • Login
       • Sign up
       • Navigation
         • Search bar
         • Hyperlinks
         • Filters
       • User Profile

3. Database

   • Normalisation
     • Flexibility
       • Eliminates redundancy
       • Minimization of data modification errors
       • Simplified query processes
     • Forms
       • 1st normal
         • No repeated data entries
         • No repeated groups
       • 2nd normal
         • No partial dependencies
         • Must be in 1NF
       • 3rd normal
         • No transitive dependencies
         • Must be in 2NF

4. data cleaning

   • tools
     • manual
     • data cleaning libraries
       • Python
         • Pandas
         • NumPy
         • Matplotlib
       • R
         • Tidyverse
           • collection of packages
             • dplyr
             • tidyr
             • purrr
             • stringr
     • automated
       • OpenRefine
       • Trifacta Wrangler
   • importance
     • accuracy
       • ensures that data is reliable
     • efficiency
       • removes irrelevant data
       • improves speed and efficiency of data analysis
     • consistency
       • ensures data adheres to same formatting
       • reduces risk of errors
     • better insights
       • more accurate flow of ideas