Questions
- What percentage of time is generally spent on data cleaning and preparation in a data visualization project?
- 20-30%
- 50-80%
- 10-20%
- 80-100%
- Name three tools provided by Power BI for data preparation.
- Power Extract, data integration, data expressions
- Power Query, data modeling, SQL queries
- Data analytics, Query Editor, data mining
- Power Query, data modeling, DAX formulas
- What is the primary function of Power Query in Power BI?
- Creating visualizations
- Writing SQL queries
- Data transformation and preparation
- Building relationships between tables
- What is DAX, and how is it used in Power BI?
- As a data visualization tool
- As a programming language
- As a formula language for creating calculations and measures
- As a data storage format
- Why was DAX created, and what problem did it aim to solve?
- To create charts and graphs
- To bridge the gap between relational databases and spreadsheet tools
- To replace SQL queries
- To handle big data efficiently
- Explain the dual role of DAX as a formula...