Learn the work behind Data, AI & Forward Deployed Engineering
Practical explanations, career decisions and reproducible workflows. Read the reasoning, inspect the evidence and follow the next skill into a real programme.
Prompt engineer as a job title: what the work actually involves
"Prompt engineer" as a standalone job title is less common than the attention it received suggests. Where it does appear, the work usually involves designing and testing the instructions an AI application uses, building…
Product analyst role: funnels, experiments and the weekly review
A product analyst studies how people use a digital product, using event data, SQL and experiments, and helps product managers decide what to build, fix or remove. The job centres on a small number of recurring…
Probability puzzles from analytics interviews, solved and simulated
Probability puzzles in analytics interviews are short problems — dice, cards, birthdays, alerts — that test four moves: counting outcomes carefully, using the complement ("at least one" is one minus "none")…
Pricing analyst role: margin, discount leakage and price tests
A pricing analyst works out what a company should charge and how much it actually earns after discounts, then tests and monitors price changes. The recurring deliverables are margin analyses, discount-leakage reports…
Prepaid pack mix: compare packs by validity-normalised revenue
To compare prepaid packs fairly, convert each one to value per 30 days of validity (price × 30 ÷ validity days) and spread every recharge evenly across the days it covers before assigning it to a month. Recharge-date…
Read dd/mm/yyyy dates correctly in Power Query with en-IN locale
To read day/month/year dates in Power Query, convert the column with Change Type > Using Locale, choose Date and English (India), rather than the plain Date type. In M this is Table.TransformColumnTypes(Source…
Power BI and DAX interview questions with model answers
Power BI interviews for analyst roles check three things: whether you model data as a star schema, whether you understand filter context well enough to predict what a DAX measure returns, and whether you can build the…
Power BI consultant role: scoping, estimating and client delivery
A Power BI consultant builds reporting solutions for client organisations, either at a Microsoft partner or analytics consulting firm or as an independent freelancer. Beyond modelling data and writing DAX, the…
Do data analysts need a portfolio website? A decision guide
Most data analysts do not need a personal portfolio website. A clean GitHub profile with three documented projects, plus one viewable output such as a published dashboard or a PDF case study, covers what hiring managers…
Map customer PIN codes to district and state without duplicate rows
To map PIN codes to district and state, clean every customer PIN to exactly six digits, collapse the PIN directory so each PIN appears once, and only then join. The directory is published at post-office level, so a raw…
PHP web developer to FDE: add a grounded AI feature to your app
A PHP web developer who builds and maintains client websites already does much of what a forward deployed engineer (FDE) does: take a loosely worded request from a business owner, change a live system, and deploy…
Lecturer or PhD to data scientist: what research training covers
A lecturer or PhD holder moving into data science already has study design, literature review, statistical inference and the habit of defending a method in front of sceptical people. The usual gaps are held-out…
Not sure which programme fits?
Tell us your background and we will map it to the right entry point — including saying so when a cheaper programme is the better fit. A counsellor replies within one working day.