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 track everything here with a quick note on what each project does.
Feel free to chat with me on LinkedIn 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 |
Click HERE 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 |
Click HERE 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 |
- |