Read more
2 Month/20 Hours Price:55,000
50,000
PL-300: Microsoft Power BI Data Analyst
The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam
should be proficient using Power Query and writing expressions by using DAX.
Prepare the Data (15-20%)
Get data from different data sources
identify and connect to a data sourcechange data source settings
select a shared dataset or create a local dataset
select a storage mode
use Microsoft Dataverse
change the value in a parameter
connect to a data flow
Clean, transform, and load the data
profile the dataresolve inconsistencies, unexpected or null values, and data quality issues
identify and create appropriate keys for joins
evaluate and transform column data types
shape and transform tables
combine queries
apply user-friendly naming conventions to columns and queries
configure data loading
resolve data import errors
Model the Data (30—35%)
Design a data model
define the tablesconfigure table and column properties
design and implement role-playing dimensions
define a relationship’s cardinality and cross-filter direction
design a data model that uses a star schema
create a common date table
Develop a data model
create calculated tablescreate hierarchies
create calculated columns
implement row-level security roles
use the Q&A feature
Create model calculations by using DAX
create basic measures by using DAXuse CALCULATE to manipulate filters
implement Time Intelligence using DAX
replace implicit measures with explicit measures
use basic statistical functions
create semi-additive measures
use quick measures
Optimize model performance
remove unnecessary rows and columnsidentify poorly performing measures, relationships, and visuals
reduce cardinality levels to improve performance
Visualize and Analyze the Data (25—30%)
Create reports
add visualization items to reportschoose an appropriate visualization type
format and configure visualizations
use a custom visual
apply and customize a theme
configure conditional formatting
apply slicing and filtering
configure the report page
use the Analyze in Excel feature
choose when to use a paginated report
Create dashboards
manage tiles on a dashboardconfigure mobile view
use the Q&A feature
add a Quick Insights result to a dashboard
apply a dashboard theme
pin a live report page to a dashboard
Enhance reports for usability and storytelling
configure bookmarkscreate custom tooltips
edit and configure interactions between visuals
configure navigation for a report
apply sorting
configure Sync Slicers
group and layer visuals by using the selection pane
drilldown into data using interactive visuals
export report data
design reports for mobile devices
Identify patterns and trends
use the Analyze feature in Power BIidentify outliers
choose between continuous and categorical axes
use groupings, binnings, and clustering
use AI visuals
use the Forecast feature
create reference lines by using the Analytics pane
Deploy and Maintain Assets (20—25%)
Manage files and datasets
identify when a gateway is requiredconfigure a dataset scheduled refresh
configure row-level security group membership
provide access to datasets
manage global options for files
Manage workspaces
create and configure a workspaceassign workspace roles
configure and update a workspace app
publish, import, or update assets in a workspace
apply sensitivity labels to workspace content
configure subscriptions and data alerts
promote or certify Power BI content
- Power BI Job Interview Question
- Tough Open-Ended Job Interview Questions
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview QuestionsWhat to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
Week End Classes For Professionals SAT | SUNCorporate Group Training Available
Online Classes – Live Virtual Class (L.V.C), Online Training
0 Reviews