This certification validates practical skills in business intelligence and reporting, including data preparation, analysis, governance, and communicating reliable insights. It is intended for professionals who build or operate data-driven solutions.
You are using the Apriori algorithm to determine the likelihood that a person who owns a home has a good credit score. You have determined that the confidence for the rules used in the algorithm is > 75%. You calculate lift = 1.011 for the rule, "People with good credit are homeowners". What can you determine from the lift calculation?
Consider a database with 4 transactions:
Transaction 1: {cheese, bread, milk}
Transaction 2: {soda, bread, milk}
Transaction 3: {cheese, bread}
Transaction 4: {cheese, soda, juice}
The minimum support is 25%. Which rule has a confidence equal to 50%?
Under which circumstance do you need to implement N-fold cross-validation after creating a regression model?
What is an appropriate data visualization to use in a presentation for an analyst audience?
When would you use GROUP BY ROLLUP clause in your OLAP query?