Angielski dla BI Developera — dashboardy, raporty i data visualization po angielsku
CFO z Londynu patrzy na Twój dashboard i pyta, dlaczego revenue metric nie zgadza się z jego spreadsheetem — i musisz to wyjaśnić po angielsku. Poznaj 28 kluczowych terminów BI: data model, DAX, KPI, drill-down i row-level security.
CFO z Londynu patrzy na Twój dashboard — i pyta, dlaczego liczby się nie zgadzają
CFO z Londynu patrzy na Twój dashboard i pyta, dlaczego revenue metric nie zgadza się z jego spreadsheetem — i musisz po angielsku wyjaśnić różnicę w definicji miary, opisać data model i obronić metodologię, nie tracąc wiarygodności analitycznej.
Angielski przestał być opcjonalny w pracy z danymi. Narzędzia, dokumentacja, Stack Overflow, konferencje i zagraniczne zespoły — wszystkie operują tym samym językiem. Z tego artykułu skorzystają: BI Developer, Business Intelligence Analyst, Data Analyst, Reporting Analyst, Power BI Developer i Tableau Developer — wszyscy, którzy budują dashboardy i raporty dla zagranicznych interesariuszy.
Data Modelling — 8 terminów
| EN Term | PL | Przykład zdania |
|---|---|---|
| data model | model danych | "The data model uses a star schema with one central fact table." |
| fact table | tabela faktów | "The fact table stores transactional data at the order-line level." |
| dimension table | tabela wymiarów | "The Date dimension table enables time intelligence calculations." |
| star schema | schemat gwiazdy | "We chose a star schema for simplicity and query performance." |
| snowflake schema | schemat płatka śniegu | "The snowflake schema normalises dimension tables to reduce redundancy." |
| measure | miara (obiekt DAX) | "This measure calculates year-to-date revenue using time intelligence." |
| calculated column | kolumna obliczeniowa | "The calculated column adds a profit margin value at the row level." |
| relationship | relacja | "There is a one-to-many relationship between the Date and Sales tables." |
Reporting & Visualisation — 8 terminów
| EN Term | PL | Przykład zdania |
|---|---|---|
| dashboard | pulpit analityczny | "The executive dashboard shows five KPIs updated every morning at 8 AM." |
| report | raport | "The monthly sales report is distributed to all regional managers." |
| KPI | kluczowy wskaźnik efektywności | "The KPI for this quarter is gross margin improvement of 2 percentage points." |
| drill-down | przechodzenie do szczegółów | "You can drill down from country level to individual store performance." |
| filter | filtr | "Apply the Region filter to show only UK and Ireland data." |
| slicer | fragmentator | "The slicer on the left lets you select one or multiple product categories." |
| tooltip | podpowiedź | "The tooltip shows the exact revenue and unit count on hover." |
| data refresh | odświeżanie danych | "The dataset is scheduled for a daily refresh at 6 AM." |
DAX & Queries — 6 terminów
| EN Term | PL | Przykład zdania |
|---|---|---|
| DAX (Data Analysis Expressions) | język wyrażeń Power BI/Excel | "This measure is written in DAX and uses CALCULATE to override the filter context." |
| calculated table | tabela obliczeniowa | "I created a calculated table to generate a date dimension dynamically." |
| context (row/filter) | kontekst (wiersza/filtru) | "Understanding row context vs filter context is fundamental to writing correct DAX." |
| aggregation | agregacja | "The aggregation at the top level shows total revenue; drill-down reveals individual transactions." |
| time intelligence | inteligencja czasowa | "Time intelligence functions like SAMEPERIODLASTYEAR make YoY comparisons straightforward." |
| CALCULATE | funkcja DAX zmieniająca kontekst | "CALCULATE modifies the filter context to compute the metric for a specific subset." |
Tools & Deployment — 6 terminów
| EN Term | PL | Przykład zdania |
|---|---|---|
| Power BI | platforma BI Microsoft | "The report is published to Power BI Service and shared via a workspace link." |
| Tableau | platforma BI Salesforce | "We use Tableau Server for enterprise-wide dashboard distribution." |
| data gateway | brama danych | "The on-premises data gateway connects the local SQL Server to Power BI Service." |
| workspace | obszar roboczy | "The Finance workspace contains all reports restricted to the Finance team." |
| publish | opublikowanie raportu | "Once reviewed, publish the report to the Production workspace." |
| row-level security (RLS) | zabezpieczenia na poziomie wiersza | "Row-level security ensures that each regional manager sees only their territory's data." |
Scenariusze komunikacji
a) Dashboard review ze stakeholderem — 8 zwrotów
- "The revenue figure here uses the invoice date, not the payment date — that's why it differs from your spreadsheet."
- "If you drill down to the product level, you'll see which categories are driving the variance."
- "This KPI is calculated as gross revenue minus returns — it does not include tax adjustments."
- "The data is refreshed every morning at 6 AM, so yesterday's transactions won't appear until then."
- "The spike in May is not a trend — it's a one-off promotional campaign that inflated the numbers."
- "Would you like me to add a benchmark line showing last year's performance for direct comparison?"
- "The filter at the top applies to all visuals on this page — selecting 'UK' will update everything simultaneously."
- "I can add a tooltip showing the underlying transaction count if that would help you verify the numbers."
b) Requirements gathering — 6 zwrotów
- "What KPIs do you need on the executive dashboard? And what's the update frequency — daily, weekly or real-time?"
- "Who is the primary audience — C-suite or the operational team? That will determine the level of detail."
- "Do you need the ability to drill down, or is a summary view sufficient for your use case?"
- "What data sources should we connect? We'll need access credentials and confirmation of refresh permissions."
- "Is there an existing report this should replace, or are we building from scratch?"
- "What does 'revenue' mean in your context — invoiced, collected or recognised? The definition will affect the measure."
c) Wyjaśnienie problemu z jakością danych — 6 zwrotów
- "The spike you see on 15 May is a data quality issue — a batch of transactions was loaded twice. I've flagged it for the data team."
- "The zero values for Q1 are expected — the new data pipeline was not yet connected to that source."
- "There is a known discrepancy between the CRM and the ERP figures — we're aligning the definitions with the data engineering team."
- "I'd recommend treating this number with caution until the source data has been validated."
- "The data is complete for all regions except Southeast Asia — we're waiting on the local system export."
- "I've added a data quality flag to this visual so users can see when the last successful refresh occurred."
Krótki dialog — BI Developer broni definicji miary przed CFO
CFO: "Your revenue number is £2.3 million, but my spreadsheet shows £2.6 million. Which one is correct?"
BI Developer: "Both figures are technically correct — they use different definitions. My dashboard uses the payment date, so it reflects cash received. Your spreadsheet likely uses the invoice date, which captures revenue recognised."
CFO: "Right. For the board report, we need the invoiced figure."
BI Developer: "Understood. I'll create a separate measure using invoice date and add a clear label so both versions are visible. I'll also add a note in the tooltip explaining the difference."
CFO: "Can you have it ready by Thursday?"
BI Developer: "Yes — I'll publish it to the Finance workspace by Wednesday afternoon so you have time to review before the board meeting."
Słownictwo DAX — 6 zwrotów po angielsku
- "This measure uses CALCULATE to override the filter context and compute year-to-date revenue."
- "The SAMEPERIODLASTYEAR function shifts the date context back by exactly 12 months for the YoY comparison."
- "Row context iterates over each row in the table; filter context determines which rows are visible to the measure."
- "I've used a calculated table here to generate a disconnected date slicer that controls multiple visuals."
- "The DIVIDE function is used instead of the division operator to handle divide-by-zero gracefully."
- "ALL() removes all filters from the specified column so the measure evaluates against the full dataset."
Najczęstsze błędy Polaków
1. „raport" — wymowa /rɪˈpɔːrt/, akcent na drugiej sylabie. Polacy często wymawiają „REport" z akcentem na pierwszej sylabie jak w polskim. Po angielsku akcent pada na drugą sylabę. ✅ "I'll send you the re-PORT by Friday."
2. „make a dashboard" → „build / create a dashboard". Dashboard się buduje lub tworzy, nie robi. ❌ "I made a dashboard." → ✅ "I built a dashboard." / "I created a dashboard."
3. „DAX" — wymowa jak słowo „daks", nie litery D-A-X. DAX czytamy jako /dæks/, a nie rozwijamy jako litery. Dotyczy też kontekstu wypowiedzi: "This is a DAX measure" — nie "This is a D-A-X measure".
4. „measure" vs „metric" — dwie różne rzeczy. Measure to konkretny obiekt w modelu danych (formuła DAX). Metric to ogólny wskaźnik biznesowy omawiany na poziomie strategicznym. ✅ "I'll create a DAX measure for this metric."
5. „dataset refresh" — nie „dataset update". W Power BI operacja zasilania danymi to refresh, nie update. ❌ "The dataset update runs at 6 AM." → ✅ "The dataset refresh is scheduled for 6 AM."
Quick Reference Table — 28 terminów
| Termin angielski | Polskie tłumaczenie | Kategoria |
|---|---|---|
| data model | model danych | Data modelling |
| fact table | tabela faktów | Data modelling |
| dimension table | tabela wymiarów | Data modelling |
| star schema | schemat gwiazdy | Data modelling |
| snowflake schema | schemat płatka śniegu | Data modelling |
| measure | miara (obiekt DAX) | Data modelling |
| calculated column | kolumna obliczeniowa | Data modelling |
| relationship | relacja | Data modelling |
| dashboard | pulpit analityczny | Reporting & visualisation |
| report | raport | Reporting & visualisation |
| KPI | kluczowy wskaźnik efektywności | Reporting & visualisation |
| drill-down | przechodzenie do szczegółów | Reporting & visualisation |
| filter | filtr | Reporting & visualisation |
| slicer | fragmentator | Reporting & visualisation |
| tooltip | podpowiedź | Reporting & visualisation |
| data refresh | odświeżanie danych | Reporting & visualisation |
| DAX | język wyrażeń analizy danych | DAX & queries |
| calculated table | tabela obliczeniowa | DAX & queries |
| context (row/filter) | kontekst (wiersza/filtru) | DAX & queries |
| aggregation | agregacja | DAX & queries |
| time intelligence | inteligencja czasowa | DAX & queries |
| CALCULATE | funkcja zmiany kontekstu DAX | DAX & queries |
| Power BI | platforma BI Microsoft | Tools & deployment |
| Tableau | platforma BI Salesforce | Tools & deployment |
| data gateway | brama danych | Tools & deployment |
| workspace | obszar roboczy | Tools & deployment |
| publish | opublikowanie raportu | Tools & deployment |
| row-level security (RLS) | zabezpieczenia na poziomie wiersza | Tools & deployment |
Podsumowanie
Angielski BI developera to język precyzji definicyjnej — zanim pokażesz CFO cyfrę, musisz wiedzieć, jak po angielsku wyjaśnić, czym jest revenue recognition date, dlaczego measure to nie metric i co dokładnie robi CALCULATE. Opanowanie tej terminologii przekłada się bezpośrednio na wiarygodność analityczną w oczach zagranicznych interesariuszy.
Przećwicz te 28 terminów za pomocą fiszek z kategorii IT & Programowanie — ścieżka BI Developer / Power BI. Powiązane artykuły: angielski dla Data Scientista, angielski dla Data Engineera, angielski dla analityka biznesowego.