Microsoft Power Bi Data Analyst
PL-300
Money Back Guarantee
98% Success Rate
Real Questions
1
Prepare the data 25%
1.1
Get or connect to data
4 subtopics1.1.1Identify and connect to data sources
1.1.2Configure data source settings
1.1.3Choose between DirectQuery and Import
1.1.4Create and modify parameters
Learning Objectives
- Identify and connect to data sources or a shared semantic model
- Change data source settings, including credentials and privacy levels
- Choose between DirectQuery and Import
- Create and modify parameters
1.2
Profile and clean the data
2 subtopics1.2.1Evaluate data quality
1.2.2Resolve data issues
Learning Objectives
- Evaluate data, including data statistics and column properties
- Resolve inconsistencies, unexpected or null values, and data quality issues
- Resolve data import errors
1.3
Transform and load the data
5 subtopics1.3.1Data type selection
1.3.2Column transformations
1.3.3Data reshaping
1.3.4Table operations
1.3.5Data modeling preparation
Learning Objectives
- Select appropriate column data types
- Create and transform columns
- Group and aggregate rows
- Pivot, unpivot, and transpose data
- Convert semi-structured data to a table
- Create fact tables and dimension tables
- Identify when to use reference or duplicate queries and the resulting impact
- Merge and append queries
- Identify and create appropriate keys for relationships
- Configure data loading for queries
Domain Hands-on Skills
Power Query Editor proficiencyM language basicsData profiling techniquesQuery optimization
Common Mistakes to Avoid
- Not setting privacy levels correctly
- Choosing wrong storage mode
- Inefficient query folding
- Not handling errors properly
2
Model the data 25%
3
Visualize and analyze the data 25%
4