- What You Are Actually Preparing For
- Exam Mechanics: Format, Timing, Fees and Delivery
- The Five Objective Domains and What to Master in Each
- Scoring, Readiness and the 150-Hour Guideline
- A Domain-Sequenced Study Plan
- Tool Fluency: SQL, Python, R and Excel/Power Query
- Common Traps in ITS-DA Questions
- Exam-Day Logistics and Voucher Planning
- After You Pass: Validity and Career Use
- Frequently Asked Questions
- The exam is a computer-based test of 35-45 questions with a 50-minute maximum, so pacing matters.
- A passing score is 700 on a 1-1000 scaled range, not a raw 70 percent.
- Five official domains cover data basics through responsible analytics; no percentage weights are published, so study all five.
- Current coverage spans SQL, Python, R, Excel/Power Query, date/time, tuples, and clustering, PCA and association analysis.
What You Are Actually Preparing For
The Information Technology Specialist - Data Analytics exam (abbreviated ITS-DA throughout this site) is a Pearson credential administered through Certiport, a Pearson VUE business. It is a knowledge assessment built from a published set of exam objectives. It is not a coding lab you complete on your own machine, and it is not a general statistics test. It sits between the two: you need to recognize how data is structured, manipulated, analyzed, visualized and handled responsibly, and you need enough hands-on exposure to tools to answer scenario questions confidently.
One point causes confusion early: Data Analytics is its own exam, separate from the Databases exam in the same IT Specialist family. Do not assume a Databases study resource covers what you need. SQL appears here, but as one tool among several in an analytics workflow, alongside R, Python and Excel with Power Query. If you want the broader context first, start with what the ITS-DA certification is and then return to this guide for the preparation plan.
Pearson publishes the official objectives in a short two-page document. Treat the five headings in that document as what the exam measures, not as a curriculum that teaches you the material. They tell you what could be asked; you still need to build the skills yourself. For a deeper walk through each area, see the complete guide to all five ITS-DA content areas.
Exam Mechanics: Format, Timing, Fees and Delivery
Format and timing
The exam is computer-based and proctored. Pearson MindhubPro estimates 35-45 questions with a 50-minute maximum. That is a range rather than a fixed form count, so do not build your pacing around an exact number of items. A safe approach is to plan for the upper end: with 45 questions in 50 minutes, you have roughly a minute per item, which leaves very little room for lingering on a single question.
The 50 minutes refers to timed exam time. Administration steps and the tutorial are not counted against it. Certiport's interface tutorial describes how answer options are navigated; that document is older and quotes a generic question estimate, so rely on the exam-specific listing for question counts but use the tutorial to get comfortable with the interface before test day.
Fees and voucher rules
Pearson MindhubPro displays USD 127 web/member pricing for the exam-only voucher. A few details matter before you buy:
- The voucher is country-restricted and is not available in some listed markets, so confirm availability for your location first.
- The voucher expires 12 months after purchase. That expiry is separate from how long the credential itself stays valid.
- An alternative is a USD 133, US-only voucher sold through the Certiport store that includes a retake. It is intended for the Certiport Authorized Testing Center (CATC) channel, proctoring may cost extra, and it cannot be used at Pearson VUE centers or through OnVUE.
For a fuller breakdown of what you might spend beyond the voucher, see the ITS-DA certification cost guide.
Where you can test
You can sit the exam at a Pearson VUE center, online through OnVUE, or through a separate CATC channel. OnVUE requires a system check and a live webcam proctor. CATC sessions come with their own conditions: photo and signature identification, a non-disclosure agreement, parental consent for candidates under 18, and no personal paper or communication devices in the room. Choose your delivery channel before you buy, because the voucher types are not interchangeable.
The Five Objective Domains and What to Master in Each
The official outline lists five domains. No percentage weights are published, so you cannot rationally skip one to concentrate on another. Assume each domain can appear and plan your time accordingly.
Domain 1: Data Basics
This is the vocabulary and structural foundation for everything else. Expect questions on how data is classified, stored and described before any analysis happens.
- Data types and structures, including how tuples differ from other collection types.
- Date and time values, which are a recurring source of formatting and calculation questions.
- The basic roles AI and machine learning can play in analysis. The outline covers these roles at a conceptual level and explicitly excludes specific machine-learning algorithms, so do not spend weeks memorizing algorithm internals.
Domain 2: Data Manipulation
This domain is where tool knowledge is tested most directly: getting data into the shape you need.
- SQL for retrieving, filtering and combining data.
- Python and R approaches to cleaning and transforming data.
- Excel and Power Query for importing, reshaping and cleaning tabular data.
- Handling messy inputs such as inconsistent date formats, missing values and duplicated records.
Domain 3: Data Analysis
Here the exam moves from preparing data to drawing conclusions from it.
- Descriptive reasoning about distributions and summary measures.
- Principal component analysis, cluster analysis and association analysis, which are named in the current coverage.
- Knowing what each technique is for, what question it answers and what kind of output it produces, rather than deriving the math.
Domain 4: Data Visualization and Communication
Choosing the right chart and communicating honestly are both fair game.
- Matching chart types to the question, including Sankey diagrams for flows and box plots for spread and outliers.
- Recognizing misleading charts, such as distorted axes or selective framing.
- Communicating findings clearly to a non-technical audience.
Domain 5: Responsible Analytics Practices
This domain is easy to underestimate because it feels like common sense, yet it produces precise scenario questions.
- Privacy considerations when working with personal data.
- Why small samples can compromise anonymity.
- Sources of bias and the limits on generalizing from a sample to a wider population.
Key Takeaway
Because weights are unpublished, build a coverage checklist from the five domain names and tick off concrete topics under each. Do not guess which domain is "worth more" and neglect the rest.
Scoring, Readiness and the 150-Hour Guideline
The passing score is 700 on a scale of 1 to 1000. This is a scaled score, which means it does not translate to answering 70 percent of questions correctly. Do not use a raw percentage target to judge your readiness. For more on how to interpret the number, read the ITS-DA passing score explainer.
Certiport does not publish pass rates, and any figure you see quoted without a source should be treated skeptically. If you want a sober look at what is and is not known, the ITS-DA pass rate discussion covers it, and the difficulty guide helps you calibrate expectations without relying on invented numbers.
On preparation time, the program suggests approximately 150 hours, and the objective profiles describe at least 150 hours. Read that as a readiness profile for a candidate starting with limited background, not as a logged-hours application requirement. Nobody checks a timesheet. There is also no degree requirement beyond knowledge of the objective domains; the ITS-DA requirements overview covers eligibility in more detail.
A Domain-Sequenced Study Plan
Generic study techniques matter less here than the order in which you tackle the domains. The sequence below follows dependencies: you cannot manipulate data well until you understand its types, and you cannot analyze or visualize reliably until it is clean. The responsible-practices domain is deliberately spread through the plan rather than saved for the end, because its judgment-style questions benefit from repeated exposure.
Data Basics
- Review data types, tuples, and date/time handling in Python and Excel.
- Read the AI and machine-learning role descriptions in the outline, and stop at the conceptual level.
- Take a baseline practice set to find weak spots.
Data Manipulation
- Write SQL queries for filtering, joining and aggregating a small dataset.
- Repeat the same cleaning task in Python, R and Power Query so you recognize each tool's approach.
- Practice date/time cleanup, since it spans Domains 1 and 2.
Data Analysis
- Study what principal component, cluster and association analysis each accomplish and when to choose them.
- Interpret outputs from small worked examples rather than memorizing formulas.
Visualization and Communication
- Match scenarios to chart types, including Sankey diagrams and box plots.
- Collect examples of misleading charts and explain what is wrong with each.
Responsible Analytics and Full Review
- Work through privacy, small-sample anonymity, bias and generalization scenarios.
- Run timed mixed practice sets at one minute per question to rehearse the pace.
If your schedule is tight, compress by trimming the tools you already know, not by dropping a domain. The main ITS-DA study guide and the training overview offer additional resource ideas, and the one-page cheat sheet is useful for a final-week skim.
Tool Fluency: SQL, Python, R and Excel/Power Query
A defining feature of this exam is the number of tools it touches. You are not expected to be an expert in all four, but you should recognize what a snippet or a described workflow is doing in each. A practical way to prepare is to pick one realistic mini-dataset and complete the same sequence of tasks in every tool: load it, fix dates, remove duplicates, summarize, and produce one chart.
| Tool | Where it shows up | What to practice |
|---|---|---|
| SQL | Data Manipulation | Selecting, filtering, joining and aggregating rows from tables |
| Python | Data Basics, Data Manipulation | Data structures including tuples, date/time handling, cleaning steps |
| R | Data Manipulation, Data Analysis | Reshaping data frames, summarizing, recognizing analysis outputs |
| Excel / Power Query | Data Manipulation, Data Visualization | Importing and transforming tables, building basic charts |
Common Traps in ITS-DA Questions
Because the exam is scenario-driven and covers a wide scope, certain mistakes recur. Watch for these patterns while you practice:
- Over-studying machine learning. The outline covers AI and ML roles in analysis but excludes specific algorithms. Time spent on algorithm internals is time not spent on SQL or visualization.
- Confusing this exam with Databases. SQL is present, but the exam frames it as part of an analytics workflow. Deep database administration topics are not the focus.
- Ignoring date and time. It appears in current coverage and cuts across domains. Formatting, parsing and arithmetic on dates are easy marks if you have practiced them.
- Treating charts as decoration. Questions can ask which chart best fits a goal, or what makes a chart misleading. Know why a Sankey diagram suits flows and what a box plot reveals about spread.
- Dismissing responsible practices as soft. Small-sample anonymity and limits on generalization have defensible right answers. Learn the reasoning, not just the terms.
- Assuming the content is static. Pearson announced additions for the fall in a May 14, 2025 article, and the current coverage reflects them. No exact release date or version is publicly stated, so always rely on the current official objectives rather than an old study resource.
Key Takeaway
If a study resource predates the current objectives, check it against the official two-page outline. Anything about date/time, tuples, R, Power Query, or PCA, cluster and association analysis that your resource omits is a gap you must fill elsewhere.
Exam-Day Logistics and Voucher Planning
Good preparation can be undone by avoidable logistics problems. Handle these well before the day:
- Decide on delivery. Pearson VUE center, OnVUE online, or a CATC. Your voucher type must match.
- Buy the voucher at the right time. It expires 12 months after purchase, so avoid buying a year ahead of when you will actually sit the exam.
- Run the OnVUE system check early if testing online. A live webcam proctor will monitor you, so test your camera, microphone, connection and room setup in advance.
- Prepare identification. CATC sessions require photo and signature ID, and you will be asked to accept a non-disclosure agreement.
- Leave personal paper and communication devices out of reach where those restrictions apply.
For scheduling windows and deadlines, consult the ITS-DA exam dates guide. When you are ready to measure yourself under realistic conditions, take a timed run on the ITS-DA practice test site and review every miss against its domain.
After You Pass: Validity and Career Use
Credentials awarded on or after 2025-06-18 are valid for five years, while earlier awards remain nonexpiring. Recertification means purchasing a new voucher and passing the current exam, so keep your records and watch the objectives for changes as your renewal approaches. Remember that voucher expiry and credential validity are two separate clocks.
As an entry-level credential, it signals structured knowledge of the analytics workflow: handling data, choosing methods, presenting results and respecting privacy. It tends to be most useful for students, career changers and early-career staff pursuing analyst-style roles, and it works best alongside a small portfolio of real projects. To weigh it against your goals, read the ROI analysis, browse the ITS-DA jobs overview and check the salary guide for how earnings are discussed without inflated claims. If you want extra practice material to round out your preparation, the practice question bank is a convenient place to keep drilling weak domains.
Frequently Asked Questions
Pearson MindhubPro estimates 35-45 questions with a 50-minute maximum. This is a variable range rather than a fixed form count, so prepare for the higher end and practice at roughly one minute per question.
The passing score is 700 on a 1-1000 scale. It is a scaled score, not a raw 70 percent, so you cannot convert it directly into a number of correct answers.
No. Data Analytics is a separate exam from Databases. It includes SQL but also covers Python, R, Excel/Power Query, analysis techniques, visualization and responsible analytics practices.
The program suggests approximately 150 hours, and the objective profiles describe at least 150 hours. These are readiness guidelines rather than a verified requirement to log hours, so adjust them based on your existing SQL, Python, R and Excel experience.
Awards on or after 2025-06-18 are valid for five years, while earlier awards remain nonexpiring. Recertification requires a new voucher and passing the current exam. The voucher itself expires 12 months after purchase, which is a separate matter from credential validity.