Power BI Fundamentals

Use Power Query profiling indicators to identify missing, invalid, and unusual values.

Assign appropriate data types to text, numeric, and date columns using the correct locale.

Resolve null values and conversion errors according to documented data-quality rules.

Standardize text fields using trim, clean, replace, and case transformations.

Derive analysis-ready date and numeric fields from raw source columns.

Reshape a wide healthcare table into a tidy table with unpivot.

Compare Import and DirectQuery for a stated reporting scenario.

Append tables that share the same schema into a single fact table.

Merge a fact table with a lookup table using an appropriate join type.

Aggregate detailed records with Power Query Group By.

Combine consistently structured files from a folder into one query.

Organize source, staging, and output queries using references and load settings.

Inspect Applied Steps and generated M code to explain how a query transforms its source.

State the grain of a healthcare dataset before modeling it.

Classify tables as facts or dimensions from their contents and intended use.

Transform a flat analytical dataset into a star-schema design.

Configure relationship cardinality and cross-filter direction for a given model.

Create and mark a continuous date table for time-based analysis.

Validate relationship behavior by tracing filters from dimensions to fact tables.

Choose between a calculated column and a measure for a stated analytical requirement.

Distinguish row context from filter context in a DAX expression.

Create explicit measures with SUM, COUNTROWS, DISTINCTCOUNT, and AVERAGE.

Calculate a healthcare rate safely with DIVIDE.

Use CALCULATE to evaluate a measure under an added filter condition.

Use variables to make a multi-step DAX measure easier to test and read.

Calculate month-over-month change using the model's date table.

Calculate a year-to-date healthcare measure with DAX.

Create a rolling-period average for an operational healthcare metric.

Calculate percent of total by modifying filter context with REMOVEFILTERS.

Rank healthcare categories dynamically with RANKX.

Use an iterator such as SUMX to calculate an expression row by row.

Select an appropriate Power BI visual for a comparison, trend, distribution, relationship, or composition question.

Design a report page with clear visual hierarchy and limited cognitive load.

Use conditional formatting to draw attention to KPI status and exceptions.

Configure drill-down and drill-through for movement from summaries to detail.

Create a report-page tooltip that supplies context without crowding the main page.

Build keyboard-friendly, color-accessible report navigation with buttons and bookmarks.

Configure a mobile layout for a priority report page.

Test a row-level security role in Power BI Desktop using a healthcare access scenario.

Use Performance Analyzer to identify a slow report visual.

Reduce model size by removing unnecessary columns and selecting efficient data types.

Diagnose an incorrect or blank result caused by relationships, filters, or DAX context.

Explain the roles of semantic models, reports, dashboards, workspaces, and apps in Power BI Service.

Design a scheduled-refresh plan that accounts for credentials and an on-premises gateway.

Package a portfolio-safe report for offline sharing without exposing sensitive data.

Translate a healthcare operations brief into measurable questions and precisely defined KPIs.

Build a documented Power Query pipeline for a synthetic patient-flow dataset.

Create a validated star schema for the patient-flow analysis.

Implement and verify a focused set of operational DAX measures.

Build an executive overview page that communicates trends, targets, and exceptions.

Build an operational detail page that supports investigation of delays and bottlenecks.

Perform a structured quality review of values, filters, interactions, accessibility, and privacy.

Deliver a concise walkthrough that connects report findings to operational recommendations.

Create a portfolio package containing the PBIX file, static report views, a data dictionary, and privacy-safe sample data.

Write a case study that explains the business problem, data preparation, model, measures, design decisions, and findings.

Publish a Power BI case study through GitHub or a personal portfolio without relying on Power BI Service.

Present the healthcare project in a three-minute recruiter-focused demonstration.

Answer common interview questions about Power Query, star schemas, relationships, DAX context, and storage modes.

Complete a timed Power BI task that turns an unfamiliar raw dataset into a validated one-page report.

Construct a STAR-format interview story about resolving a data-quality or reporting problem.