Favour Abada KGeN

❤️

[Favour Abada KGeN @favour_abada]

@jay_mikee One sure thing is that every soul will taste death both good and evil. So I don't know exactly what they are celebrating.
Everyone should be concerned about their own soul.

[Favour Abada KGeN @favour_abada]

@goshema_hub T'is another Half to smash our goals🥳

[Favour Abada KGeN @favour_abada]

@hertechtrail @Ogbonna42449096 @mychailblaise @phaibooboo @JoshuaAti https://t.co/HK7wELX4yr

[Favour Abada KGeN @favour_abada]

HTT DATA CHALLENGE
DAY 8 OF 15: CHARTS

I am particularly excited about today because it's Data Visualization.🤩.
I'll be expressing my analysis using a simple Bar chart and a slicer attached.
#hertechtrailacademy
#httdatachallenge
#DataVisualization

[Favour Abada KGeN @favour_abada]

@hertechtrail @Ogbonna42449096 @phaibooboo @mychailblaise @AtiJoshua Hence, Data validation. With this feature, I was able to restrict customers from typing in wrong values. Now if a customer types a value that does not fall between A to C or 1 to 10 for Quantity, it shows Error with a corrective message. This repeats until the entry is Valid.

[Favour Abada KGeN @favour_abada]

HTT DATA CHALLENGE
DAY 7 OF 15: DATA VALIDATION

Imagine a situation whereby there are only three colours of balls in a basket and you're asked to choose one, then you end up choosing a colour that does not exist in there!
#hertechtrailacademy
#httdatachallenge
#datavalidation

[Favour Abada KGeN @favour_abada]

@hertechtrail @Ogbonna42449096 @phaibooboo @mychailblaise @AtiJoshua Apart from this, in the rating session which is on the scale of 10, you might see very funny values which of course are less than 1 or greater than 10.
It can be really frustrating to analyze such data because that particular record might just be wasted.

[Favour Abada KGeN @favour_abada]

@hertechtrail @happiness_ajayi @Ogbonna42449096 @mychailblaise @phaibooboo @AtiJoshua ✔️ The Food and beverages product line generated more income even though more quantities of Electronic accessories were sold.
✔️ The average customer rating was 7 on a scale of 10.
✔️ More customers paid using E-wallet although more income was generated in cash.

[Favour Abada KGeN @favour_abada]

HTT DATA CHALLENGE
DAY 6/15: DATA ANALYSIS
Today's challenge is generating meaningful insights out of a range of confusing numbers. So I'll be sharing my observation on the supermarket dataset I've been working on.
#hertechtrailacademy
#hertechtraildatachallenge
#datainsights

[Favour Abada KGeN @favour_abada]

@hertechtrail @happiness_ajayi @Ogbonna42449096 @mychailblaise @phaibooboo @AtiJoshua ✔️ I observed that more than half of the total income were generated from the female customers.
✔️ The city with the highest sales was Naypyitaw which is Branch C.
✔️ Registered customers of the company generated more sales than normal customers.

[Favour Abada KGeN @favour_abada]

@hertechtrail @Ogbonna42449096 @phaibooboo @JulietChibuoke @mychailblaise @AtiJoshua https://t.co/KnTTbmGgAA

Full Post here🤗

[Favour Abada KGeN @favour_abada]

HTT DATA CHALLENGE
DAY 5/15: PIVOT TABLES
Oh yes I am here again.
Imagine having to work on a really large dataset and you're so confused about how to analyze it.
Straight to the point, Pivot tables are features that help to summarize a large amount of data into smaller tables.

[Favour Abada KGeN @favour_abada]

@hertechtrail Congratulations 🎉👏

[Favour Abada KGeN @favour_abada]

#NewProfilePic

[Favour Abada KGeN @favour_abada]

@hertechtrail @Ogbonna42449096 @JulietChibuoke @mychailblaise @AtiJoshua @phaibooboo @HappinessAjayi I calculated the average sales and used it as the bench mark in my formatting.
Hence, the high sales highlighted in the image below are those greater than the average calculated.
Conditional formatting helps you highlight specific cell values to make a table more understandable.

[Favour Abada KGeN @favour_abada]

HTT DATA CHALLENGE
DAY 4 OF 15: CONDITIONAL FORMATTING

Are you wondering why some values are reddened?
Are you also concerned about how I arrived at whatsoever condition I used?
Don't worry I can explain! 😁
#hertechtrailacademy #conditionalformatting
#httdatachallenge

[Favour Abada KGeN @favour_abada]

@hertechtrail @Ogbonna42449096 @JulietChibuoke @mychailblaise @AtiJoshua @phaibooboo @HappinessAjayi The formatted column represents sales in a supermarket dataset. In order to highlight the highest sales, I had to format using the Red colour.
Now to the condition, I can't just decipher which the high sales are , so I came up with something.

[Favour Abada KGeN @favour_abada]

@Ogbonna42449096 @mychailblaise @hertechtrail @AtiJoshua @JulietChibuoke @phaibooboo @HappinessAjayi ✅ They allow automatic dynamic updates when data changes.
✅They improve productivity and efficiency especially with large datasets.

[Favour Abada KGeN @favour_abada]

15 DAYS HERTECHTRAIL DATA CHALLENGE
DAY 3 OF 15 : BASIC FORMULAS
Today we are exploring Excel formulas. Excel formulas are written expressions used to calculate values in a cell.
#hertechtrailacademy
#httdatachallenge
#excelformulas
#dataanalysis

[Favour Abada KGeN @favour_abada]

@Ogbonna42449096 @mychailblaise @hertechtrail @AtiJoshua @JulietChibuoke @phaibooboo @HappinessAjayi The images below represent the Average orders and Total sales made in a supermarket using specific formulas.
Excel Formulas are important because:
✅They preserve Data integrity and reduces errors.
✅They make calculation easier and faster.