Skill Check
Data Analytics Skill Check
12 questions across every topic of the Data Analytics track. You get your level, a score for each topic and what to learn next.
Sign in to save your result to your Skill Passport — or take it now and sign up afterwards.
Question 1 of 12
0:00
Thinking Like an Analyst "Our canteen is losing money." What is the best first step for an analyst?
A Build a dashboard immediately B Turn it into specific questions and identify the data needed C Train a machine learning model D Delete all rows with missing values
Thinking Like an Analyst "Sales fell 6% because two stores were closed for renovation." Which type of analysis is this?
A Descriptive B Diagnostic C Predictive D Prescriptive
Thinking Like an Analyst Some package values are missing and a few packages are extremely high. Which value is safest to fill the gaps with?
A 0 B The mean C The median D The maximum
Thinking Like an Analyst How should you decide whether two rows are duplicates?
A Same name B Same city C Same unique key, such as an order ID or roll number D Same date
Excel & SQL for Analysis Which formula gives total laptop sales in Pune from the Orders table?
A =SUM(Orders[Amount]) B =SUMIFS(Orders[Amount], Orders[City], "Pune", Orders[Category], "Laptops") C =COUNTIFS(Orders[City], "Pune") D =VLOOKUP("Pune", Orders, 7)
Excel & SQL for Analysis Why is XLOOKUP generally preferred over VLOOKUP?
A It is the only lookup that works in Tables B It can look in any direction, defaults to exact match and has a built-in "not found" value C It is faster to type D It sorts the data automatically
Excel & SQL for Analysis What is the difference between WHERE and HAVING in SQL?
A There is no difference B WHERE filters rows before grouping; HAVING filters groups after GROUP BY C HAVING works only with JOINs D WHERE works only on numbers
Excel & SQL for Analysis Which query pattern finds customers who never placed an order?SELECT c.name
FROM customers c
LEFT JOIN orders o ON o.customer_id = c.customer_id
WHERE ________;
A o.order_id = 0 B o.order_id IS NULL C c.customer_id IS NULL D COUNT(o.order_id) = 0
Python, Charts & Storytelling In pandas, which filter correctly selects Pune orders above ₹20,000?
A df[df["city"] == "Pune" and df["amount"] > 20000] B df[(df["city"] == "Pune") & (df["amount"] > 20000)] C df.filter("Pune", 20000) D df[df.city = "Pune"]
Python, Charts & Storytelling After a left merge of orders (10,000 rows) with customers, you get 10,450 rows. What is the most likely cause?
A pandas added random rows B Duplicate customer IDs in the customers table C Missing values in amount D The merge used too much memory
Python, Charts & Storytelling Which chart is best for showing monthly revenue over two years?
A Pie chart B Line chart C Scatter plot D 3D bar chart
Python, Charts & Storytelling Which chart title is the most useful for a manager?
A "Sales by city" B "Chart 3" C "Delhi grew fastest in Q3 (+18%) while Pune declined" D "Revenue data (₹)"
Tip: press 1–4 to choose, Enter for next
Next