OBCodeLab's profile picture. Backend dev | Python dev | Data Scientist |

OB

@OBCodeLab

Backend dev | Python dev | Data Scientist |

OB reposted

Over the past few days, while participating in the Build For Good hackathon by MantaHQ x NexaScale, I have been working alongside @OBCodeLab to create a platform that enables students to share academic resources with one another @MantaHQTech @NexaScaleHQ

JonnieDev's tweet image. Over the past few days, while participating in the Build For Good hackathon by MantaHQ x NexaScale, I have been working alongside @OBCodeLab to create a platform that enables students to share academic resources with one another 

@MantaHQTech @NexaScaleHQ

Trying to improve my knowledge on python for backend development I decided to build a URL shortener with fastapi github.com/Obcodelab/url_… Details on how to use it on the readme Any improvement ideas or suggestions will be appreciated. #Python #backend @Fidel_builds @3rdSon__


OB reposted

A few weeks ago, I applied for a backend role, aced the interview, but didn’t get the job. When I asked why, they said it was due to my lack of experience in Programmatic Advertising so I went online to research it cause well that was my first time hearing such. Check thread 👇

Fidel_builds's tweet image. A few weeks ago, I applied for a backend role, aced the interview, but didn’t get the job. When I asked why, they said it was due to my lack of experience in Programmatic Advertising so I went online to research it cause well that was my first time hearing such.
Check thread 👇

I created a coffee sales dashboard to show the top 5 customers, sales by country and total sales over time coupled with an order date timeline, slicers(roast type, size and loyalty card) Dataset used: github.com/mochen862/exce… #dataanalysis #excel

OBCodeLab's tweet image. I created a coffee sales dashboard to show the top 5 customers, sales by country and total sales over time coupled with an order date timeline, slicers(roast type, size and loyalty card)

Dataset used: github.com/mochen862/exce…

#dataanalysis #excel

Below is a dashboard I created to show total casualties in respect to severity, vehicle type, area, light condition with monthly trends in comparison to 2021 and 2022 Dataset Used: docs.google.com/spreadsheets/d… All corrections are appreciated #dataanalysis #Excel

OBCodeLab's tweet image. Below is a dashboard I created to show total casualties in respect to severity, vehicle type, area, light condition with monthly trends in comparison to 2021 and 2022

Dataset Used: docs.google.com/spreadsheets/d…

All corrections are appreciated

#dataanalysis #Excel

Day 12 of data analysis with Excel: I learnt how to create dashboards by cleaning the dataset, creating pivot tables, selecting appropriate charts and lastly adding slicers. Dataset used: github.com/AlexTheAnalyst… #dataanalysis #excel

OBCodeLab's tweet image. Day 12 of data analysis with Excel: I learnt how to create dashboards by cleaning the dataset, creating pivot tables, selecting appropriate charts and lastly adding slicers.

Dataset used: github.com/AlexTheAnalyst…

#dataanalysis #excel

Day 11 of data analysis with excel: I learnt about data cleaning, the things I learnt to look out for are: duplicate values, naming errors, whitespaces, currency format, date format and unnecessary columns. #dataanalysis #excel


Day 10 of data analysis with excel: I learnt how to create and edit different charts/graphs, how to edit features such as Legend, Axis name, Chart name and so on. Here is an image of a line chart generated from the sales revenue of amazon over the years. #dataanalysis #excel

OBCodeLab's tweet image. Day 10 of data analysis with excel: I learnt how to create and edit different charts/graphs, how to edit features such as Legend, Axis name, Chart name and so on.
Here is an image of a line chart generated from the sales revenue of amazon over the years.

#dataanalysis #excel

Day 9 of data analysis: I learnt about how to use xlookup to find exact matches, handle multiple rows, and various match modes, nesting , combining with SUM, using wildcards("*") and how to create and manage rules with conditional formatting #dataanalysis #excel


Day 8 of data analysis with excel: I learnt about more formulas in Excel, LEN, LEFT, RIGHT, TEXT, SUBSTITUTE, CONCATENATE, DAYS, NETWORKDAYS, and how to connect a drop down menu with a VLOOKUP #dataanalysis #excel


Day 7 of data analysis with excel: I learnt about pivot tables, how to create a pivot table(manually or using recommended tables), how to add fields(default and custom) to the table and how to create pivot charts #dataanalysis #excel


OB reposted

If you are looking to learn DATA ANALYSIS this year, Freecodecamp has released a 19-hour course that will take you on an in-depth journey, whether you're a beginner or more advanced in your skills. You'll learn about: Python, Excel, SQL, Tableau Power BI & much more You…


An exercise to test my knowledge on what I learnt so far Completed the table of the first image with SUM and IFS Completed the table of the second image with COUNTIF, SUMIF, /, COUNTIFS and SUMIFS with cell referencing #dataanalysis #Excel

OBCodeLab's tweet image. An exercise to test my knowledge on what I learnt so far

Completed the table of the first image with SUM and IFS
Completed the table of the second image with COUNTIF, SUMIF, /, COUNTIFS and SUMIFS with cell referencing
#dataanalysis #Excel
OBCodeLab's tweet image. An exercise to test my knowledge on what I learnt so far

Completed the table of the first image with SUM and IFS
Completed the table of the second image with COUNTIF, SUMIF, /, COUNTIFS and SUMIFS with cell referencing
#dataanalysis #Excel

Day 6 of data analysis with excel: I learnt how to use basic formulas(*, /, +, -, ^), functions(SUM, AVERAGE, MODE, MIN, MAX, TODAY, NOW, IF, VLOOKUP), conditional functions(SUMIF, SUMIFS, COUNTIF, COUNTIFS) and the function wizard #dataanalysis #excel


Day 5 of data analysis with Excel: I learnt how to import data from the web(auto refresh every certain amount of time or when opening the sheet), how to create tables, sorting values in a table, how to add table styles and options #dataanalysis #excel


Day 4 of data analysis with excel: I learnt about conditional formation(how to add custom rules), how to create dropdown list using data validation, how to hide cells and how to add slicers #dataanalysis #excel

OBCodeLab's tweet image. Day 4 of data analysis with excel: I learnt about conditional formation(how to add custom rules), how to create dropdown list using data validation, how to hide cells and how to add slicers
#dataanalysis #excel
OBCodeLab's tweet image. Day 4 of data analysis with excel: I learnt about conditional formation(how to add custom rules), how to create dropdown list using data validation, how to hide cells and how to add slicers
#dataanalysis #excel
OBCodeLab's tweet image. Day 4 of data analysis with excel: I learnt about conditional formation(how to add custom rules), how to create dropdown list using data validation, how to hide cells and how to add slicers
#dataanalysis #excel
OBCodeLab's tweet image. Day 4 of data analysis with excel: I learnt about conditional formation(how to add custom rules), how to create dropdown list using data validation, how to hide cells and how to add slicers
#dataanalysis #excel

Day 3 of data analysis with Excel: I learnt the various paste types(paste special), transpose, how to use flash fill and how to add links to cells #dataanalysis #excel


Loading...

Something went wrong.


Something went wrong.