01
How do SUMIFS and SUMPRODUCT differ?
Show answer
SUMIFS sums values meeting several criteria and is fast. SUMPRODUCT multiplies arrays and adds them, handling more complex conditions and weighted totals.
Red Hat Data Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Red Hat hiring for Data Analytics roles
Red Hat is an open source software company, now part of IBM, known for Red Hat Enterprise Linux, OpenShift and Ansible. It provides enterprise Linux, hybrid cloud, container and automation platforms with subscription-based support. In India it has a large presence in Pune and Bengaluru, hiring software engineers, quality engineers, support engineers and consultants.
For Data Analytics roles, this Red Hat practice set focuses most on Web & Marketing Analytics (6), Python for Analysis (5), Statistics and Case Studies (4), Power BI (4). It has 1 easy, 29 medium, 10 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Product
- Headquarters
- Raleigh, North Carolina, USA
- Main India offices
- Pune, Bengaluru
Red Hat Data Analytics interview process
- Online assessment or resume screening
- Technical round 1 (Linux + programming)
- Technical round 2 (domain or open source)
- Hiring manager and HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Red HatStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
02
Write pandas code to standardise inconsistent city names such as 'delhi ', 'New Delhi' and 'DELHI'.
Show answer
city_map = {
'delhi': 'Delhi',
'new delhi': 'Delhi',
'bombay': 'Mumbai',
'mumbai': 'Mumbai',
'bengaluru': 'Bengaluru',
'bangalore': 'Bengaluru',
}
clean = df['city'].str.strip().str.lower().str.replace(r'\s+', ' ', regex=True)
df['city_clean'] = clean.map(city_map).fillna(clean.str.title())
print(df['city_clean'].value_counts())
03
What is the difference between mean and median for reporting salaries?
Show answer
Salaries are right-skewed, so the median better represents the typical employee while the mean is pulled up by a few high earners.
04
How do you handle outliers in Pandas?
Show answer
Detect with IQR or z-score, then cap with clip, remove, transform with log, or keep and flag them depending on whether they are errors or real events.
05
How do you calculate month-over-month growth?
Show answer
Aggregate revenue by month, use LAG(revenue) OVER (ORDER BY month), then (revenue - prev) / prev x 100.
06
The CMO asks which marketing channel should lose 20% of its budget. How do you approach it?
Show answer
I would compare channels on incremental return, not last-click ROAS. Gather spend, attributed conversions under two models, customer quality such as repeat rate and margin, and any lift test or mix model results. Look at diminishing returns: the last rupee in a saturated channel is worth less than the average. Then recommend cutting where marginal return is lowest, ideally phased with a holdout to confirm the impact.
07
Site conversion rate rose from 2.0% to 2.4%, but total revenue stayed flat. What would you check?
Show answer
Check the components: sessions may have fallen, for example after cutting paid campaigns, which removes low-intent traffic and lifts the rate without new sales. Average order value may have dropped because of discounts or a mix shift towards cheaper products. Also check whether conversion definitions or tracking changed. Revenue equals sessions times conversion rate times AOV, so break down the change across those three factors by channel.
08
Your scheduled Python report failed silently and nobody noticed for a week. How do you make it reliable?
Show answer
Add logging to a file or central log, wrap the main steps in try and except that send an alert by email or chat on failure, and exit with a non-zero code so the scheduler marks the job failed. Add data checks, such as row counts above a minimum and no missing dates, before sending output. Use a proper scheduler or orchestrator with retries, and include the data date in every report.
09
A measure shows correct values per row in a table visual, but the grand total looks wrong. Why, and how do you fix it?
Show answer
Totals in DAX are not the sum of visible rows; the measure is recalculated in the total's filter context. A measure like a distinct count, a ratio or an IF condition can give a different result at total level. If the business wants the sum of row values, iterate explicitly, for example SUMX ( VALUES ( Product[Name] ), [My Measure] ). Confirm with stakeholders which total is correct before changing it.
10
Write Python code for a simple difference-in-differences estimate of a store pilot.
Show answer
import pandas as pd
# df columns: store_type ('pilot' or 'control'), period ('pre' or 'post'), sales
avg = df.pivot_table(index='store_type', columns='period',
values='sales', aggfunc='mean')
pilot_change = avg.loc['pilot', 'post'] - avg.loc['pilot', 'pre']
control_change = avg.loc['control', 'post'] - avg.loc['control', 'pre']
did = pilot_change - control_change
print(f'Estimated pilot effect per store: {did:.1f}')
11
How do you optimise a slow SQL query?
Show answer
Read the execution plan, add or fix indexes, select only needed columns, filter early, avoid functions on indexed columns, and replace correlated subqueries with joins.
12
Tell me about a time you worked with a marketing team to improve a campaign using data.
Show answer
Situation: a lead generation campaign had a high cost per lead and sales said leads were poor. Task: find what to change. Action: I joined ad data with CRM outcomes and found two audience segments produced most leads but almost no closed deals, while one smaller segment converted well. Result: we moved budget to that segment and changed the form questions; cost per qualified lead fell about 30% in six weeks.
13
A stakeholder wants 20 more visuals added to an already crowded dashboard page. How do you respond?
Show answer
I would ask which decisions each new visual supports and how often they will look at it. Usually a few are essential and the rest are nice to have. I would propose keeping the main page focused on core KPIs and moving detail into drill-through pages, tooltips or a separate analysis tab. Showing a quick mock-up of both versions helps them see that the cleaner page answers questions faster.
14
What questions do you ask a stakeholder before building a dashboard?
Show answer
Who will use it and what decisions will they make with it? Which three to five questions must it answer? What are the KPI definitions, targets and comparison periods? Which data sources are trusted? How often will they look at it, and on what device? Who needs access and are there security restrictions? What does success look like in a month? I summarise the answers in a short brief and get sign-off before building.
15
How do you present insights to non-technical stakeholders?
Show answer
Lead with the answer, use one simple chart per point, translate numbers into business impact (₹, %), avoid jargon and end with a clear recommendation and next step.
16
What is the peeking problem in A/B testing?
Show answer
Peeking means checking the p-value repeatedly during a test and stopping as soon as it drops below 0.05. Each look is another chance for random noise to look significant, so the real false positive rate can rise from 5% to 20% or more. Fix it by fixing the sample size in advance and analysing once, or by using methods built for continuous monitoring, such as sequential testing or always-valid confidence intervals.
17
Brand keyword ads show a ROAS of 15, and the team wants to double the budget. How do you respond?
Show answer
Brand search ROAS is usually inflated because people searching the brand name were already looking for you and would often click the free organic result anyway. Before increasing spend, I would propose an incrementality test, such as pausing brand ads in some matched cities or time periods and measuring the drop in total brand-search orders. The incremental ROAS is often far lower, so the extra budget may work better elsewhere.
18
What does the CALCULATE function do?
Show answer
It evaluates an expression after modifying the filter context, for example CALCULATE(SUM(Sales[Amount]), Region[Name] = "North").
19
What is the normal distribution and the 68-95-99.7 rule?
Show answer
The normal distribution is a symmetric, bell-shaped distribution described by its mean and standard deviation. The empirical rule says about 68% of values fall within one standard deviation of the mean, 95% within two and 99.7% within three. For example, if delivery times average 30 minutes with an SD of 5, about 95% arrive in 20 to 40 minutes. Many business metrics are skewed, so check before assuming normality.
20
A stakeholder says the Power BI report shows different revenue than their Excel file. How do you troubleshoot?
Show answer
I would first agree on definitions: gross or net, including tax or returns, order date or invoice date. Then compare one small slice, such as one month and one region, in both. I check filters on the report and page, relationships that drop unmatched rows, refresh time versus the Excel extract time, and duplicate rows. Once the gap is explained, I document the definition in the report so the question does not repeat.
21
Write a Tableau table calculation for year-over-year sales growth.
Show answer
// with YEAR(Order Date) in the view, Compute Using: Table (across)
(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1))
/ ABS(LOOKUP(ZN(SUM([Sales])), -1))
// the built-in Quick Table Calculation 'Year over Year Growth' generates similar logic
// format the field as a percentage
22
Write Python code to test whether conversion differs between control and treatment.
Show answer
from statsmodels.stats.proportion import proportions_ztest, proportion_confint
conversions = [1180, 1295] # control, treatment
visitors = [30000, 30100]
z, p = proportions_ztest(conversions, visitors)
print(f'z = {z:.2f}, p = {p:.4f}')
for c, n in zip(conversions, visitors):
low, high = proportion_confint(c, n, method='wilson')
print(f'rate {c/n:.3%} 95% CI {low:.3%} to {high:.3%}')
23
How do you calculate a simple customer lifetime value?
Show answer
A simple formula is CLV = average order value x purchase frequency per year x gross margin x expected lifetime in years. Example: 800 rupees x 6 orders x 30 percent margin x 3 years = 4,320 rupees. Expected lifetime can be estimated as 1 divided by annual churn rate. A better version discounts future value and calculates CLV by cohort or segment, because averages hide very different customer groups.
24
Tell me about a time an experiment result went against what the team expected.
Show answer
Situation: the team was sure a shorter signup form would raise registrations. Task: I owned the test analysis. Action: registrations rose 6%, but I checked the guardrail and found seven-day activation fell, because we had removed a question that personalised onboarding. I shared both results with the segment breakdown. Result: we kept the short form but moved the question to the first screen after signup, which recovered activation.
25
How would you automate a weekly report with Python?
Show answer
Pull data with SQL or APIs, clean and aggregate with Pandas, build charts and an Excel or PDF output, and schedule it with cron or Airflow with logging and alerts.
26
The column names in a monthly vendor file keep changing. How do you make your cleaning pipeline robust?
Show answer
Agree a data contract with the vendor if possible. In the pipeline, normalise headers by trimming, lower-casing and replacing spaces, then map known variants to standard names through a lookup table you maintain. Validate that all required columns exist after mapping and fail with a clear message if not, instead of producing silent blanks. Select columns by name, never by position, and log any unexpected new columns for review.
27
Explain correlation vs regression.
Show answer
Correlation shows the strength and direction of association; regression builds an equation to predict one variable from others.
28
What is the difference between a view and a materialised view?
Show answer
A view stores a query and runs it each time; a materialised view stores the result physically and must be refreshed, making reads faster.
29
Write SQL using LAG to compare each month's revenue with the previous month.
Show answer
WITH monthly AS (
SELECT DATE_TRUNC('month', order_date) AS month,
SUM(amount) AS revenue
FROM orders
GROUP BY 1
)
SELECT month,
revenue,
LAG(revenue) OVER (ORDER BY month) AS prev_revenue,
ROUND(100.0 * (revenue - LAG(revenue) OVER (ORDER BY month))
/ NULLIF(LAG(revenue) OVER (ORDER BY month), 0), 1) AS mom_pct
FROM monthly
ORDER BY month;
30
How would you reconcile two large lists in Excel?
Show answer
Use XLOOKUP or COUNTIF to flag missing items in each list, or merge them in Power Query with a full outer join and filter unmatched rows.
31
How do you remove duplicates in Excel but keep the latest record?
Show answer
Sort by date (newest first), then Data → Remove Duplicates on the key column — Excel keeps the first occurrence. Or use UNIQUE / a COUNTIFS helper column.
32
Tell me about a time you designed or improved a data model.
Show answer
Situation: our sales reports used five separate Excel extracts and numbers never matched. Task: build one reliable model. Action: I listed the business questions, fixed the grain at invoice line, built conformed date, product and branch dimensions and moved logic into SQL views, then rebuilt the Power BI reports on top. Result: refresh time dropped from 40 to 6 minutes and month-end reconciliation queries fell sharply.
33
What is Row-Level Security?
Show answer
Rules that restrict data per user role, for example sales managers seeing only their region, defined with DAX filters and assigned in the Service.
34
Write pandas code to calculate customer acquisition cost and payback period in months for each channel.
Show answer
# spend: channel, spend
# customers: channel, customer_id, monthly_margin
new_cust = customers.groupby('channel').agg(
new_customers=('customer_id', 'nunique'),
avg_margin=('monthly_margin', 'mean'))
summary = spend.groupby('channel')['spend'].sum().to_frame().join(new_cust)
summary['cac'] = summary['spend'] / summary['new_customers']
summary['payback_months'] = summary['cac'] / summary['avg_margin']
print(summary.round(1).sort_values('payback_months'))
35
Write SQL to get each order's customer city as it was on the order date, using an SCD Type 2 customer dimension.
Show answer
-- dim_customer has valid_from, valid_to (NULL for current row)
SELECT o.order_id,
o.order_date,
c.customer_id,
c.city
FROM fact_orders o
JOIN dim_customer c
ON c.customer_id = o.customer_id
AND o.order_date >= c.valid_from
AND o.order_date < COALESCE(c.valid_to, DATE '9999-12-31');
36
How do you create a new column from conditions?
Show answer
Use np.where for one condition, np.select for several, or df.apply with a function for custom logic.
37
How do you calculate a running total?
Show answer
SUM(amount) OVER (ORDER BY order_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) adds up values cumulatively.
38
Your sales data contains negative quantities. What do you do with them?
Show answer
Do not delete them blindly. First find out what they mean: often they are returns, cancellations or credit notes, which are valid business events. Check with the source team or a documentation note. If they are returns, keep them but report gross sales, returns and net sales separately. If some are clearly entry errors, such as a negative quantity on a new order, flag and correct them and log the rule.
39
Write pandas code to find the top 2 products by revenue in each region.
Show answer
top2 = (
df.groupby(['region', 'product'], as_index=False)['revenue']
.sum()
.sort_values(['region', 'revenue'], ascending=[True, False])
.groupby('region')
.head(2)
)
print(top2)
40
Write Python code to extract UTM source, medium and campaign from a column of landing page URLs.
Show answer
import pandas as pd
from urllib.parse import urlparse, parse_qs
def get_utms(url):
params = parse_qs(urlparse(str(url)).query)
return pd.Series({
'source': params.get('utm_source', ['(direct)'])[0].lower(),
'medium': params.get('utm_medium', ['(none)'])[0].lower(),
'campaign': params.get('utm_campaign', ['(not set)'])[0].lower(),
})
df[['source', 'medium', 'campaign']] = df['landing_url'].apply(get_utms)
Tips to crack the Red Hat Data Analytics interview
- Get comfortable with Linux commands, shell scripting, processes, permissions and networking, which are central to many Red Hat roles.
- Contribute to an open source project or show GitHub work, since Red Hat values public collaboration and community involvement.
- Learn the basics of containers, Kubernetes and Ansible, and consider Red Hat certifications such as RHCSA for support roles.
- Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
- Practise the hard questions on this page aloud; Red Hat interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Red Hat Data Analytics interview?
Candidates usually go through 4 stages: Online assessment or resume screening; Technical round 1 (Linux + programming); Technical round 2 (domain or open source); Hiring manager and HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the Red Hat Data Analytics interview?
This practice set leans on Web & Marketing Analytics (6), Python for Analysis (5), Statistics and Case Studies (4), Power BI (4). Revise those first, then practise explaining one or two of your own projects end to end, because most Red Hat interviewers ask you to walk through real work.
Are these the exact questions asked at Red Hat?
No. These are curated practice questions that match the skills and difficulty usually tested in product interviews like Red Hat's. They are not a leaked or verified list of past questions.
Where does Red Hat hire Data Analytics professionals in India?
Red Hat has large teams in Pune, Bengaluru. Openings and locations change often, so check the Red Hat careers page and filter by city and experience.
Data Analytics questions for similar companies
Product
Zoho
Data Analytics interview questions
Chennai, Tenkasi
View questionsProduct
Atlassian
Data Analytics interview questions
Bengaluru
View questionsProduct
Adobe
Data Analytics interview questions
Noida, Bengaluru, Gurugram
View questionsProduct
Ola
Data Analytics interview questions
Bengaluru
View questionsProduct
Amazon
Data Analytics interview questions
Bengaluru, Hyderabad, Chennai +2
View questionsProduct
Nutanix
Data Analytics interview questions
Bengaluru, Pune
View questionsMore ways to practise
Company-wise Data Analytics questionsPackage-wise Data Analytics questionsExperience-wise Data Analytics questionsRole-wise Data Analytics questionsCity-wise Data Analytics questionsMost asked Data Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsData Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsData Analytics topic sheets