01Business analysis
Retail intelligence
TECHNOLOGY’S CONTRIBUTION
Sales43%
Gross profit21%
Technology leads sales. Home leads gross profit.
SQL · Python · Dimensional modelingOPEN TO ENTRY-LEVEL ANALYST ROLES
Omar Darrag.
Business & data analyst.
I turn business questions into clear analysis with Python, SQL and Power BI. My work connects retail profitability, restaurant demand and sustainability reporting with the decisions behind them.
BSc, Business Economics & ITKøbenhavns Erhvervsakademi · KEA
EXPERIENCE / 2030 BUILDERS INTERNSHIP
10 KPIstracked in internal reporting
3interactive Power BI dashboards
~2 h / weekestimated preparation time saved
01 / SELECTED PROJECTS
Selected work.
Three analytical projects, a working web portfolio, and a clear view of how I think.
02Data analysis
Restaurant demand forecasting
RECORDED MODEL ERROR · MAPE
12.29%ARIMA8.81%Prophet
Weekly and seasonal patterns change the inventory decision.
Python · ARIMA · Prophet03Business intelligence
Sustainability KPI reporting
2025 VS 2024 · SAME REPORTING SCOPE
+10.6%Output+5.2%Energy−4.9%Energy/unit
Energy per unit improves while total energy rises.
Pandas · SQL · Power BI / DAX04Additional capability
Responsive web development
This portfolio is a working example of how I structure and build interfaces.
Next.js · TypeScript · Tailwind CSSTAKE A CLOSER LOOK
Choose a project. Explore the reasoning.Showing Retail intelligence analysis.
Business analysis
Where does revenue become profit?
Which categories deserve attention when sales growth hides very different margins?
MY CONTRIBUTION
I joined transaction data, defined weighted measures and translated the category mix into a commercial recommendation.
Independent project · Northline
NORTHLINE / INTELLIGENCERetail intelligence · FY2025
A COMMERCIAL DECISION BRIEF FY2025
The sales leader isn’t
the profit leader.
Where does revenue turn into gross profit? Compare the category mix to find the next question to investigate.
- Net sales
- €464.2k +17.1% vs 2024
- Gross profit
- €191.8k +18.1% vs 2024
- Gross margin
- 41.3% +0.3 pp vs 2024
Same categories. Different contributions.
Each bar = 100% of its totalTHE ANALYTICAL TAKEAWAYTechnology
Review discount depth before investing in more volume.
The largest sales category contributes a much smaller share of gross profit. It represents 43% of sales and 21% of gross profit.
Inspect the SQL & measure logic
Order-product lines→Category join→Weighted measures
SELECT p.category,
SUM(f.net_sales_cents) / 100.0 AS sales_eur,
SUM(f.gross_profit_cents) / 100.0 AS gross_profit_eur,
1.0 * SUM(f.gross_profit_cents)
/ SUM(f.net_sales_cents) AS gross_margin
FROM fact_sales f
JOIN dim_product p USING (product_id)
WHERE f.order_date BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY p.category;Data source: Northline is a fictional retailer used for this independent portfolio project. Figures illustrate the analysis rather than client results.
Gross margin = total gross profit ÷ total net sales. Shares use the full 2025 total for each measure. One source row is an order-product line; distinct orders are counted separately.
Another signal: orders grew 19.4%, while average order value moved from €101 to €99. Revenue growth alone does not explain customer or product economics.
13,356 source lines · 2024–2025CSV ↔ SQL reconciled
02 / ABOUT
I bring the business context.
I’m a Business Economics & IT graduate from Københavns Erhvervsakademi (KEA), based in Copenhagen. At 2030 Builders, I used Python, SQL and Power BI to structure sustainability data and support recurring reporting.
Leading restaurant shifts and managing inventory taught me to consider the people, constraints and operational choices behind a dataset. I’m looking for an entry-level analyst role where I can combine that business perspective with reliable analysis and clear communication.
- Based in
- Valby, Copenhagen
- Looking for
- Business / Data / BI Analyst roles
- Background
- Business economics, IT & operations
03 / SKILLS
Tools, with a purpose.
The tools matter most when they support a clear question and a reliable answer.
Programming & databases
Python and SQL: data preparation and automation at 2030 Builders.
Analytics & business intelligence
Weighted margins in retail, KPI reporting, and ARIMA / Prophet model evaluation.
Tools & ways of working
Applied through operational inventory planning, reporting and this portfolio.
Languages
Fluent English and native Italian for clear, practical communication.
04 / EXPERIENCE & EDUCATION
Where I built that perspective.
- Jan — Sep 2024Work experience
Data & Sustainability Intern
2030 BuildersCopenhagen
- I analysed sustainability and business performance data with Pandas and SQL, tracking 10 KPIs for internal reporting.
- I built and maintained 3 interactive Power BI dashboards and validated the underlying data for reliable reporting.
- I streamlined recurring preparation with reusable Python scripts and SQL queries, saving approximately 2 hours per week.
- Feb 2022 — PresentOperational experience
Shift Manager
MoJoe Kitchen & BarCopenhagen
- I lead teams of 8–9 employees during shifts serving approximately 150–200 guests.
- I analyse weekly POS sales across 30 high-volume products to identify demand patterns and inform replenishment.
- I adjust purchasing, stock orders and staff allocation to expected demand, limiting overstocking and supporting service quality.
- Aug 2021 — Jan 2025Education
BSc, Business Economics & IT
Københavns Erhvervsakademi (KEA)Copenhagen
- I combined business economics with IT, analytics and software development.
- For my bachelor project, I built a predictive inventory management framework using ARIMA and Prophet.
Explore my full background in the downloadable PDF.
05 / CONTACT
Let’s talk.
I’m looking for a Business, Data or BI Analyst role in Copenhagen. I’d welcome a conversation about your team.