OB @OBCodeLab

Backend dev | Python dev | Data Scientist | Joined July 2020

Tweets

187
Followers

83
Following

47
Likes

113

^🥷 @JonnieDev

2 months ago

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

1 2 11 142 1

Download Image

OB @OBCodeLab

6 months ago

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__

0 0 2 24 0

Fidel Wole @Fidel_builds

6 months ago

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 👇

3 4 16 352 0

Download Image

OB @OBCodeLab

2 years ago

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

0 3 7 300 0

Download Image

OB @OBCodeLab

2 years ago

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

0 1 7 177 0

Download Image

OB @OBCodeLab

2 years ago

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

0 0 0 40 0

Download Image

OB @OBCodeLab

2 years ago

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

0 0 1 38 0

OB @OBCodeLab

2 years ago

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

0 0 0 43 0

Download Image

OB @OBCodeLab

2 years ago

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

0 0 0 37 0

OB @OBCodeLab

2 years ago

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

0 0 1 37 0

OB @OBCodeLab

2 years ago

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

0 0 1 53 0

L.A.M.Z @OlamideTowobola

2 years ago

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…

23 355 687 94K 1K

OB @OBCodeLab

2 years ago

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

0 0 1 42 0

Download Image

OB @OBCodeLab

2 years ago

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

0 0 1 38 0

OB @OBCodeLab

2 years ago

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

0 0 0 41 0

OB @OBCodeLab

2 years ago

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

0 0 0 35 0

Download Image

OB @OBCodeLab

2 years ago

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