Samuel Dankard

Thank you @TechSphereAcad Ts Academy and to today’s tutor, Adetola Durojaiye, for an insightful session. Also a very big thank you to @aproko_doctor for this scholarship opportunity. Looking forward to learning, growing, and enjoying every step of this journey. #Hajime Cohort

Life in the day of a Data Analyst!

If you’re in your 20s or 30s. Learn Excel.

If you need Data Analysis Projects Idea. That you can add to your portfolio. Open this:

If you’re new to Data Analysis Let's start from the basics Stop trying to learn everything at once. - Excel: Learn how to clean and analyze data. - SQL: Learn how to query databases. - Power BI/Tableau: Learn how to visualize your data. Master these and you’ll stand out.

Important Excel skills to learn (especially for data analysis and business work): 1. Basic Excel Navigation •Worksheets and workbooks •Rows, columns, and cells •Formatting (numbers, dates, text) 2. Essential Formulas •SUM •AVERAGE •COUNT •MIN •MAX 3. Logical Functions •IF •IFS •AND •OR 4. Lookup Functions •VLOOKUP •HLOOKUP •XLOOKUP •INDEX •MATCH 5. Text Functions •LEFT •RIGHT •MID •LEN •TRIM •CONCAT / TEXTJOIN 6. Data Cleaning •Remove duplicates •Text to columns •Flash Fill •Find and Replace 7. Data Sorting and Filtering •Sort data (A–Z, Z–A, custom sort) •Filter data •Advanced filters 8. Pivot Tables •Creating pivot tables •Summarizing large datasets •Pivot charts 9. Data Visualization •Charts (bar, line, pie, column) •Conditional formatting •Sparklines 10. Data Validation •Drop-down lists •Restricting input values •Error alerts 11. Tables •Creating Excel tables •Structured references •Automatic formatting and filtering 12. Power Query •Importing data •Cleaning and transforming datasets •Combining multiple files 13. Power Pivot •Data modeling •Relationships between tables •Calculated columns 14. Basic Automation •Macros •Recording simple automation tasks 15. Keyboard Shortcuts •Ctrl + C / V (copy & paste) •Ctrl + Shift + Arrow (navigate data) •Ctrl + T (create table) •Alt + = (AutoSum) learn all here: youtu.be/8O_ws3SWjHs

This is really all you need:

6 HABITS THAT MAKE YOU SMARTER

Bro to bro: Lock in with this FREE course IF you really want to learn Power BI🔥🔥

Important projects to have in your portfolio as a Data Analyst.

If you're learning data analytics and love having textbooks alongside your courses, here are 4 solid ones worth knowing about 👇

Data Analyst Location: Abuja (on-site) Salary: N300,000 - N400,000 monthly You will be responsible for collecting, analysing, interpreting, and presenting data to support business decisions and improve operational efficiency. Qualifications Bachelor’s Degree in Statistics, Mathematics, Computer Science, Economics, Data Science, or a related field. Proven experience as a Data Analyst or in a similar analytical role. Strong knowledge of Microsoft Excel, SQL, and data visualization tools. Experience with Power BI, Tableau, or similar reporting tools is an added advantage. Basic understanding of statistics and data modeling. Strong analytical and problem-solving skills. Excellent attention to detail and accuracy. Good communication and presentation skills. Send CV to recruitment@mshelconstruction.com  Application deadline: 8th June, 2026

@prince_of_tech @vheeorji22 @victoria_echezu @vking9727 @Femiforge @FortuneDataGuy @nikku762 Join

Ready to level up your data skills in 30 days? 📊🔥 Join our 30 Days Data Analytics Challenge starting from 11th May – 6th June 2026 via WhatsApp Community. Learn, practice, analyze, and grow with other aspiring data analysts. Scan the QR code and join us now 🚀 Or comment ‘join’ so I can send you the link #DataAnalytics #DataScience #LearnInPublic #30DaysChallenge

She literally broke down how to learn anything in just 1 minute🔥

The results🔥🔥

Change your life in the next 6 months and become unrecognizable by December: 🧵 First, bookmark so you can always come back Second, retweet to help the next person!

@Godsent_Ogar As person who hasn't really broken into data analysis what advice can you give me i known how to use sql,excel,python,tableau,power bi, aws what is the advice to get an internship

In 2026, if you're learning - Al - SQL - Excel - Python - Tableau - Power BI - Cloud computing (AWS, Azure, GCP) I hope this page finds you!

Dear Data Analyst! Here’s how you build a Dashboard🔥 Repost for others❤️

This might be the most useful Data Analysis post I have ever made❤️