About AnalystSheets
I built AnalystSheets for a specific kind of person: the analyst who spends their day inside a spreadsheet, closing the month, reconciling a portfolio, or rebuilding a report that broke again. If that sounds like your job, this site is written for you.
Who I am
My name is Abdullah Elziady. I hold a BSc in Computer Science and an IBM Data Science Professional Certificate, and I have spent years working in data management, data science, and campaign management across the telecommunications and banking sectors.
That background shapes everything here. I have lived the gap between what analytics tools promise and what actually happens when you are handed a messy extract at 4 p.m. and asked for numbers by morning. Most of what I write comes out of solving that problem repeatedly, in real environments, under real deadlines.
What this site covers
AnalystSheets focuses on Excel and Power BI as they are used in finance and banking work:
- Excel techniques that matter in analytical work — Power Query, dynamic array formulas, PivotTables, and structured models that survive being handed to someone else
- Power BI from data model through DAX to report design, with attention to performance and maintainability
- Practical financial analysis: variance reporting, forecasting, portfolio and customer analytics, reconciliation workflows
- Cleaning, shaping, and validating the imperfect data that real reporting runs on
How I write
I try to write the article I wish I had found when I was stuck. That means a clear problem, a worked example, and an explanation of why an approach works rather than just which buttons to click. Where a technique has limitations or a better alternative exists, I say so.
I am not affiliated with Microsoft, and nothing on this site is official documentation. Everything reflects my own experience and testing.
A note on scope
The content here is educational. It covers tools and techniques, not investment advice, and it should not be treated as financial, legal, or professional guidance for any specific situation. Always validate methods against your own data and your organization’s requirements before relying on them.
Get in touch
I read everything that comes in. If you have a question, spot an error, or want to suggest a topic, email me at hello@analystsheets.com.