100+ Free BIDA Practice Questions

Pass your CFI Business Intelligence & Data Analyst exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

100+ Questions

100% Free

1 / 100

Question 1

Score: 0/0

In Excel Power Query, what is the name of the formula language used to write custom transformations?

DAX

VBA

MDX

to track

Same family resources

More Corporate Finance Institute Certifications Prep

Continue through related practice pages, study guides, comparisons, and articles from the same exam family.

Practice Pages

CBCA Commercial Banking & Credit Analyst Practice100 questions CFI FPAP Financial Planning & Analysis Professional Practice100 questions CFI FPWMP Financial Planning & Wealth Management Professional Practice100 questions CFI FTIP FinTech Industry Professional Practice100 questions CMSA Capital Markets & Securities Analyst Practice100 questions FMVA Financial Modeling & Valuation Analyst Practice100 questions

2026 Statistics

Key Facts: BIDA Exam

14 + 3

Core + Elective Courses

CFI

70%

Course Assessment Min

CFI

$497

Self-Study Annual Fee

CFI

$847

Full-Immersion Annual Fee

CFI

100-200

Estimated Study Hours

CFI estimate

5 tools

Power BI, Tableau, SQL, Excel, Python

CFI BIDA program

BIDA is CFI's hands-on data analytics certification built around Power BI, Tableau, SQL, Excel, and Python. The program requires 14 core courses plus 3+ electives, each with a 70% minimum on assessments, capped by a final exam. CFI estimates roughly 100-200 study hours and offers two membership tiers: Self-Study at $497/yr or Full-Immersion at $847/yr. Unlike CFA or other gated credentials, BIDA is open-enrollment with no prerequisite degree or work experience.

Sample BIDA Practice Questions

Try these sample questions to test your BIDA exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1In Excel Power Query, what is the name of the formula language used to write custom transformations?

A.DAX

B.M

C.VBA

D.MDX

Explanation: Power Query uses the M formula language (also called the Power Query Formula Language) for ETL operations. M is case-sensitive and functional. Each query step in the Applied Steps pane is an M expression, and the full script is editable in the Advanced Editor.

2Which Excel feature allows you to load multiple related tables into a single in-memory data model and create relationships between them?

A.Power Query

B.Power Pivot

C.Power View

D.PivotTables

Explanation: Power Pivot is Excel's in-memory analytics engine that lets you load multiple tables into a tabular data model, define relationships between them on key columns, and write DAX measures. It can handle millions of rows because the VertiPaq engine compresses columnar data.

3What is the key behavioral difference between a DAX measure and a DAX calculated column?

A.Measures are stored row-by-row in the table; calculated columns are evaluated at query time

B.Calculated columns are computed at refresh and stored per row; measures are evaluated at query time within filter context

C.Measures only work in Power BI; calculated columns only work in Excel

D.Calculated columns can use CALCULATE; measures cannot

Explanation: Calculated columns are evaluated row by row during data refresh and physically stored in the model, expanding its size. Measures are NOT stored — their formula is evaluated at query time using the current filter and row context (slicers, rows/columns of a visual). This is why measures should be used for aggregations and columns for row-level attributes.

4Which DAX function modifies or replaces the filter context applied to an aggregation?

A.RELATED

B.CALCULATE

C.SUMX

D.VALUES

Explanation: CALCULATE is the most important DAX function. It evaluates an expression in a modified filter context defined by its filter arguments. For example, CALCULATE(SUM(Sales[Amount]), Sales[Region]="West") forces a Region=West filter regardless of what the visual otherwise filters.

5Which DAX function is an iterator that evaluates an expression for each row of a table and returns the sum?

A.SUM

B.SUMX

C.TOTALYTD

D.ROLLUP

Explanation: SUMX is an iterator (X-function). It takes a table as the first argument and an expression as the second, walks the table row by row computing the expression in row context, and returns the sum. SUMX(Sales, Sales[Qty] * Sales[Price]) gives total revenue without needing a calculated column.

6In a Power Pivot model with multiple inactive relationships between two tables, which DAX function activates a specific relationship for a single calculation?

A.CROSSFILTER

B.USERELATIONSHIP

C.TREATAS

D.RELATEDTABLE

Explanation: USERELATIONSHIP, used inside CALCULATE, temporarily activates an inactive relationship for a single expression. A common case is a Sales table with both OrderDate and ShipDate keyed to a Date table — only one can be active, and USERELATIONSHIP lets a measure pivot on the other when needed.

7Which Excel dynamic array function returns a subset of an array based on a Boolean condition?

A.SORT

B.FILTER

C.UNIQUE

D.SEQUENCE

Explanation: FILTER takes an array and a Boolean condition array and returns only the rows where the condition is TRUE. Syntax: =FILTER(array, include, [if_empty]). Example: =FILTER(A2:C100, B2:B100>1000) returns rows where column B exceeds 1000. The result spills into adjacent cells.

8Which Excel lookup function searches in any direction, returns multiple columns, and supports approximate or wildcard match in a single call?

A.VLOOKUP

B.INDEX/MATCH

C.XLOOKUP

D.HLOOKUP

Explanation: XLOOKUP (Excel 2021+/365) is the modern replacement for VLOOKUP. It can look left or right, return a single value or an entire row/column, default to exact match, supports a built-in if_not_found argument, and offers wildcard and approximate match modes — all in one function.

9In Power Query, what is the difference between 'Merge Queries' and 'Append Queries'?

A.Merge stacks rows; Append joins on a key column

B.Merge joins on a key column (like SQL JOIN); Append stacks rows from multiple queries (like SQL UNION)

C.Both perform identical operations

D.Merge is for files; Append is for databases

Explanation: Merge Queries performs a relational join on one or more matching key columns, similar to SQL JOIN — it adds columns. Append Queries stacks rows from queries that share the same schema, similar to SQL UNION ALL — it adds rows. Knowing which to choose is fundamental to Power Query ETL.

10A measure shows correct subtotals per row but the grand total does not equal the sum of the rows. What is the most likely cause?

A.The data has duplicates

B.The measure is non-additive — it is recomputed in the grand-total filter context, not summed across rows

C.There is a syntax error in the measure

D.Power Pivot does not support grand totals

Explanation: DAX measures are evaluated independently in every cell's filter context. At a grand total, the measure is recomputed against ALL rows together — for non-additive metrics like distinct counts, ratios, or weighted averages, this naturally differs from the sum of the row results. This is correct behavior, not a bug.

About the BIDA Exam

The CFI Business Intelligence & Data Analyst (BIDA) certification is a practical online program covering Power BI, Tableau, Excel, SQL, and Python for data analysis. Candidates must complete 14 core courses and a minimum of 3 electives, scoring at least 70% on each course assessment, before sitting the final BI and data analysis exam delivered through CFI's online platform.

Questions

100 scored questions

Time Limit

Final exam (online, ~2-3 hours)

Passing Score

70% per course assessment + final

Exam Fee

Self-Study $497/yr or Full Immersion $847/yr (CFI membership) (Corporate Finance Institute (CFI))

BIDA Exam Content Outline

20%

Power BI

Data modeling, star schema, DAX, time intelligence, RLS, DirectQuery vs Import, and composite models

15%

Excel for Data Analysis

Pivot tables, Power Query (M), Power Pivot data model, DAX measures, dynamic arrays, and XLOOKUP

15%

SQL Fundamentals

SELECT, JOINs, GROUP BY/HAVING, CTEs, window functions (ROW_NUMBER, LAG/LEAD, SUM OVER), date and string functions

15%

Python for Data Analysis

pandas DataFrames, .loc/.iloc, groupby, merge, pivot/melt, missing data handling, numpy vectorization, matplotlib/seaborn

10%

Tableau

Discrete vs continuous, dimensions vs measures, calculated fields, LOD expressions (FIXED/INCLUDE/EXCLUDE), parameters, and dashboard design

10%

Statistics & Hypothesis Testing

Descriptive statistics, distributions, Central Limit Theorem, t-tests, chi-square, ANOVA, A/B testing, and correlation vs causation

10%

Data Visualization & Storytelling

Cleveland-McGill perceptual hierarchy, color theory, chart selection, Tufte data-ink ratio, and the 5-second dashboard rule

BI Strategy & Ethics

Data governance, master data management, data quality dimensions, GDPR/CCPA, model documentation, and the CFI Code of Ethics

How to Pass the BIDA Exam

What You Need to Know

Passing score: 70% per course assessment + final
Exam length: 100 questions
Time limit: Final exam (online, ~2-3 hours)
Exam fee: Self-Study $497/yr or Full Immersion $847/yr (CFI membership)

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

BIDA Study Tips from Top Performers

1Build a personal portfolio dataset early (e.g., a public sales dataset) and rebuild the same dashboards in Power BI AND Tableau to reinforce both tools side by side

2Drill DAX time intelligence and CALCULATE/USERELATIONSHIP patterns until they are reflexive — they appear repeatedly in Power BI assessments

3Practice writing SQL window functions (ROW_NUMBER, LAG, SUM OVER) on real data; they are the most-tested SQL topic in modern BI exams

4Memorize the LOD expression decision tree in Tableau: FIXED for absolute granularity, INCLUDE/EXCLUDE for relative adjustments to the view's level

5For the statistics module, focus on conceptual understanding (what a p-value really means, Type I vs II errors) over memorizing formulas — questions test interpretation, not arithmetic

Frequently Asked Questions

What is the CFI BIDA certification?

The Business Intelligence & Data Analyst (BIDA) certification is offered by the Corporate Finance Institute (CFI). It is a practical online program covering the modern BI stack — Power BI, Tableau, Excel, SQL, and Python — along with statistics, data visualization, and data storytelling. Candidates complete 14 core courses and at least 3 elective courses, each with a 70% minimum assessment score, before taking the final exam.

How hard is the BIDA exam?

The BIDA program is considered moderate-to-hard because of its breadth — you need working fluency across five different tools (Power BI, Tableau, SQL, Excel, Python) plus statistics and data viz theory. Each course assessment requires 70% to pass, and a final exam covers BI and data analysis end-to-end. Most candidates with some prior data exposure find it manageable; absolute beginners should expect to invest more time on Power BI DAX and SQL window functions.

How long does it take to complete the BIDA?

CFI suggests roughly 100-200 hours total, depending on prior experience. Most candidates finish in 3-6 months studying part-time. The self-paced format allows acceleration if you already know one or more tools. You must complete all 14 core courses and at least 3 electives, each with a 70% assessment score, before attempting the final.

What does BIDA cost in 2026?

Access to BIDA requires an active CFI membership: Self-Study at $497/year or Full-Immersion at $847/year. Both tiers include all BIDA courses, the final exam, and unlimited retakes during the active subscription. There are no separate exam fees or prerequisite expenses — no Excel or Tableau license required for course content (CFI provides files and instructions).

Is BIDA worth it compared to other data certifications?

BIDA is well-suited for finance, FP&A, and business-side analysts who want one credential covering the modern BI toolchain (Power BI + Tableau + SQL + Python). It is more affordable than vendor-specific paths (Microsoft DA-100/PL-300 + Tableau Desktop Specialist + a Python course can total $400-600 and require multiple exams). For deep ML/data science roles, complement BIDA with statistics-heavy programs; for pure Power BI roles, the Microsoft PL-300 may be more recognized by recruiters.

Do I need a finance background to take BIDA?

No. BIDA is open enrollment with no formal prerequisites — no degree, work experience, or finance background required. The 14 core courses build from fundamentals through advanced techniques. That said, candidates familiar with at least one of Excel, SQL, or basic statistics will move faster through the early modules.