Bright De Analyst 📊📈

📊 Aspiring Data Analyst | Learning Excel, SQL & Power BI
Documenting my journey + sharing what I learn
#DataAnalysis #LearningInPublic

[Bright De Analyst 📊📈 @0X_Brighto]

@datedopikin_OG Time to hop in

[Bright @datedopikin_OG]

Best way to position for $ANSEM

- Register on Bullpen: https://t.co/w9TkTQqqgy
- Click on join $ANSEM at top of the site

Make sure you connect the wallet you hold $ANSEM

Complete the tasks:

- Hold $ansem
- Connect your x account
- Post about ansem on x

Goodluck

[Bright De Analyst 📊📈 @0X_Brighto]

@datedopikin_OG LFG man

[Bright De Analyst 📊📈 @0X_Brighto]

@datedopikin_OG @Zetarium_ Supper bullish on @Zetarium

[Bright De Analyst 📊📈 @0X_Brighto]

- I made used of the result obtained from the pivot table to plot an interactive dashboard

Please, i am opened to corrections

[Bright De Analyst 📊📈 @0X_Brighto]

Just completed my first data analytics project using only excel.
- First of all, i cleaned the data using power query; i removed duplicate as well as fixing all irregularities from the dataset.

[Bright De Analyst 📊📈 @0X_Brighto]

- I used pivot table to calculate total sales per product, average unite sold per gender, average sales per season, total unite sold in each location, effect of promotion on sales and most material used in production.

[Bright De Analyst 📊📈 @0X_Brighto]

@ObohX @paschaldubem21 Nice Dashboard

[Bright De Analyst 📊📈 @0X_Brighto]

@HollandAnalysis Steady progress man

[Bright De Analyst 📊📈 @0X_Brighto]

In the example above we have a sales dataset categorized by:
Department
Sales
Region
Quatres

I made used of pivot table to get the average sales by region, total sales gotten at each quatre of the year and total sales by department. All data where arranged in descending order

[Bright De Analyst 📊📈 @0X_Brighto]

Still on the journey in becoming a job ready data analyst. Today i studied pivot table in excel.

Pivot tables are powerful tools use to summarize, analyze and explore large dataset, with just a drag.
🪜

[Bright De Analyst 📊📈 @0X_Brighto]

Steps in Creating a pivot table in excel:
1. Select your dataset
2. Go to Insert and locate PivotTable
3. Drag fields to:
- Rows (e.g., Region)
- Columns (e.g., Quatres)
- Values (e.g., Sum of Sales)
- Filters (optional)

[Bright De Analyst 📊📈 @0X_Brighto]

Still on The LOOKUP Functions 💯
Today I learnt INDEX and MATCH Function

INDEX and MATCH are two excel functions often used together as a more powerful and flexible alternative to VLOOKUP.🪜

[Bright De Analyst 📊📈 @0X_Brighto]

Still on the journey on the of becoming a data analyst✅. Today I studied VLOOKUP Function🪜

VLOOKUP (Vertical Lookup) is an Excel function used to search for a value in the first column of a table and return a value on the same row from another column.

[Bright De Analyst 📊📈 @0X_Brighto]

@datedopikin_OG Great thread mate

[Bright De Analyst 📊📈 @0X_Brighto]

@datedopikin_OG @idOS_network Nice threads man

[Bright De Analyst 📊📈 @0X_Brighto]

AND Function
Under this function, it would be marked true if all conditions are ment. For example: in the picture below, Any student that scored above 84 and is either an engineering or science student should be marked eligible otherwise ineligible

[Bright De Analyst 📊📈 @0X_Brighto]

In continuation to my Excel Journey, I explored logical functions.

Logical functions are functions that can't be neglected in excel and could be regarded as the foundation in which other Formula thrives. Logical functions includes :
✅ IF
✅ AND
✅ OR
✅ NOT

[Bright De Analyst 📊📈 @0X_Brighto]

OR Function

The OR Function is a true or false function. It returns true if one of the two criteria are ment.
For example: in the picture below, Any staff that worked less than 6 hours or came late was "Flagged" otherwise "OK"