- Notifications
You must be signed in to change notification settings - Fork0
oterrab/portfolio-projects
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
Hello 👋, is there anybody in there?
This is my Portfolio Summary where I provide a walkthrough to all of my forays into data analytics projects, courses, problem-solving, interviews, etc... I'll trackeverything here with a quick note on what each project does.
Feel free to chat with me onLinkedIn about my projects!
Click on the project's title (bold and coloured in Blue) to view my projects! Thank you!
Skills: Data cleaning, wrangling, visualisation, analysis
Libraries: pandas, numpy, matplotlib, seaborn, scikit-learn
Project Name | Area | Description | Libraries |
---|---|---|---|
✏️Education in ES | Data Wrangling, EDA | A project close to 🏡 home. Analysis of educational data from my home state using data from the institute responsible for promoting studies, research and periodic evaluations on the Brazilian educational system - Which city has the most number os schools, How many students there are per school, How much does each city invest in its students? | pandas, seaborn, matplotlib |
📑Natural Language Processing | Data Wrangling, EDA, Machine Learning | Analysis using NLP techniques to interpret text data that I was working with in my PhD and to learn some techniques I was going to use in other context. The text used to perform this analysis was a transcript of a chemistry class for undergraduation students. | pandas, scikit-learn, pickle, textblob, spacy, re, string, numpy, wordcloud, matplotlib |
Functions:
Libraries: ggplot2
Project Name | Area | Description | Libraries |
---|---|---|---|
🌊LCT | Data Visualization | This was developed during my PhD. I will keep it private until fully prublished. | ggplot2, dplyr, lubridate |
ClickHERE for my SQL specific summary. I'll keep here just the more relevant stuff.
Knowledge: handling NULLs functions, subqueries, nested subqueries, inline views, subquery factoring (WITH clause), row limiting clause, aggregate functions (count, avg, sum, min/max, etc..), CASE WHEN statements, analytic functions (windows, partitions, rankings, listagg, lag, lead, first, last, first_value and last_value), set operators (union, union all, intersect and minus), joins (inner, outer, cross, self, equijoins, non-equijoins), hierarchical queries (level, connect_by_isleaf, connect_by_root, sys_connect_by_path), procedural functions, procedures.
Project Name | Description | SQL 'Flavour' |
---|---|---|
📊SQL Made Practical | Documentation of a SQL course I took. Most courses, if not all, focus too much on “telling” or “demonstrating” how to do things, but don’t give the student the opportunity to test and practice what is being taught. In this course, every lesson has a coding task to practice what I was learning. You will notice that some of the queries are a little off topic because I was exploring learning possibilities within the lesson. Course content: 19 sections, 210 lectures, 16 h and 5 m total length, XX exercises. | Oracle SQL |
🍉Supermarket | I've analyzed this dataset which is the historical sales of a supermarket company in Myanmar which has recorded data from 3 different branches for 3 months data. I've draw conclusions in which I believe there are meaningful opportunities in Naypyitaw (Branch B) to increase revenue. | MySQL Tableau |
ClickHERE for my BI specific summary.
Functions:
Libraries:
Project Name | Area | Description | Placeholder |
---|---|---|---|
Power BI for Business Intelligence | [Placeholder] | [Placeholder] | [Placeholder] |
Skills:
Libraries:
Project Name | Area | Description | Libraries |
---|---|---|---|
🥷Maratona Java - Virado No Jiraya | -, - | More than 250 videoclasses where it's covered practically the entire core of the language. From the first 'Hello World', to Object Orientation, Collections, Database Connection, Exception Handling, Threads, Functional Programming and much more. 011/286 | - |
About
These will be my forays into learning techniques for data science. I'll track my projects here with a quick note on what each project does.
Topics
Resources
Uh oh!
There was an error while loading.Please reload this page.
Stars
Watchers
Forks
Releases
Packages0
Uh oh!
There was an error while loading.Please reload this page.