NJI PHILL NARD AWA👨🏾💻
34 posts

NJI PHILL NARD AWA👨🏾💻
@LarryDeAnalyst
DATA ANALYST || SOFTWARE ENGINEER || GRAPHIC DESIGNER. Excel || Tableau || Python || Power BI || SQL || PowerPoint || Figma || AWS || AZURE...
Katılım Ekim 2025
12 Takip Edilen2 Takipçiler

A nail tech finishes a long day at the salon.
Payments came in from a UK client, an Australian booking, and a regular customer paying locally.
Different currencies. Different amounts especially at this time of the year 🎄 with tourist and foreigner’s around
At night, she opens Excel and asks herself:
“So… how much did I actually make today in dollars?”
This is the reality for many small business owners, freelancers, salons, and creatives working with clients across borders.
Manual conversions, Google rate checks, inconsistent numbers, and by month-end, the figures don’t fully add up.
So I built a VBA-based Currency Conversion System in Excel to fix this exact problem.
What the system solve:
🔻Automatically converts foreign payments to USD
🔺Uses live exchange rates via API
🔻Stores every transaction in a clean, audit-friendly structure
🔺Eliminates manual calculations and conversion errors
How it works (behind the scenes):
🔺A structured Transactions sheet for accurate record-keeping
🔻A VBA UserForm that handles entry, validation, and instant conversion
🔺API integration with smart caching, so rates stay fresh without hitting limits
🔻Multiple fallback layers so it still works when the internet or API doesn’t
🔺Locked calculation fields to protect data integrity
What looks like a simple form is backed by careful logic, error handling, and performance optimization, because financial tools don’t just need to work, they need to be reliable.
If you’re interested in Excel automation, VBA, financial systems, or practical business tools, let’s talk.
And if you’re a business owner dealing with multi-currency payments, this is exactly the kind of problem Excel can solve when built right.
Tool: @msexcel x ExchangeRate-API.com
#Excel #ExcelVBA #MicrosoftExcel
English

Just completed this dashboard analyzing key metrics from HR data.
- attrition rate
- location analysis
- demographics and inclusivity
- how age and education affects income
Generally I believe @tableau visuals are better, although the tool has a steeper learning curve.
Who wants to take the challenge of replicating this with Power BI?
Walkthrough from @datawithbaraa

English

We’re kicking off AWS Community Day Buea with a bang!
Ernest Mougoue broke down the Shared Responsibility Model and the IMDS case study, noting that 80% of companies faced breaches last year—a sharp reminder for Cameroon’s builders to stay security-savvy.
#AWS #AWSCommunityDay



English

@Roshethequeen @ObohX @cheftee_lead @iam_daniiell @ThisIsDikky @starboy_abefe @TheMattAnalysis Your color choices are always top notch
English

𝗛𝗲𝘆 𝗴𝘂𝘆𝘀, 𝗴𝗼𝗼𝗱 𝗺𝗼𝗿𝗻𝗶𝗻𝗴.
Imagine being able to track your spending patterns and see trends over time. Not just “I spent £200 this month” but actually understanding WHERE your money goes and HOW it changes.
That’s what I built 👇
𝗨𝘁𝗶𝗹𝗶𝘁𝘆 𝗘𝘅𝗽𝗲𝗻𝘀𝗲 𝗧𝗿𝗮𝗰𝗸𝗲𝗿
A Power BI dashboard that tracks electricity, gas, water, and internet expenses month over month.
You can see:
→ Total expenses at a glance
→ Breakdown by utility type
→ 12-month trends with comparisons
→ What increased, what decreased, by how much
𝗧𝗵𝗲 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲:
I wanted a dynamic rolling 12-month period for the charts. Not fixed dates, but a window that moves as new data comes in.
Took me a while to crack it, but I got it working. This feature is something I’ll be implementing in future projects because it makes dashboards way more flexible.
𝗜𝗻𝘁𝗲𝗿𝗮𝗰𝘁 𝘄𝗶𝘁𝗵 𝗶𝘁 𝘆𝗼𝘂𝗿𝘀𝗲𝗹𝗳:
app.powerbi.com/view?r=eyJrIjo…
Play around with it. Filter by month. See how expenses move.
𝗠𝘆 𝗻𝗮𝗺𝗲 𝗶𝘀 𝗗𝗮𝗻𝗶𝗲𝗹. 𝗜’𝗺 𝗮 𝗗𝗮𝘁𝗮 & 𝗕𝗜 𝗔𝗻𝗮𝗹𝘆𝘀𝘁.
If you need dashboards that actually help you make decisions, let’s talk.
📧 ntedaniells@gmail.com
Also, I just launched a YouTube channel where I’m teaching data analytics from scratch. Subscribe here: @talkdatawithdanny?si=dW773Opl58W8qVLI" target="_blank" rel="nofollow noopener">youtube.com/@talkdatawithd…
𝗪𝗵𝗮𝘁 𝗲𝘅𝗽𝗲𝗻𝘀𝗲 𝘁𝗿𝗮𝗰𝗸𝗶𝗻𝗴 𝗱𝗼 𝘆𝗼𝘂 𝘄𝗶𝘀𝗵 𝘆𝗼𝘂 𝗵𝗮𝗱? 💬
#PowerBI #DataAnalytics #Dashboard #DataVisualization #BusinessIntelligence #datafam


English

or have you fully switched to Relationships/Noodles for your data prep? Share your modeling tips below! 👇
#Tableau #DataModeling #DataAnalytics #StarSchema #BusinessIntelligence #FactAndDimension
English

What’s your favorite Tableau trick to instantly add context to a visualization? Let me know below! 👇
#DataAnalysis #Tableau #DataVisualization #BusinessIntelligence #Analytics #DataStorytelling
English











