Power BI - Fundamentals
Power BI Desktop, data import, Power Query, data model, relationships, basic visualizations
1What is the main difference between Power BI Desktop and Power BI Service?
What is the main difference between Power BI Desktop and Power BI Service?
Answer
Power BI Desktop is a free Windows application for creating reports and data models locally. Power BI Service is the cloud platform for publishing, sharing, and collaborating on reports. The typical workflow involves developing in Desktop then publishing to Service for distribution.
2What is the main role of Power Query in Power BI?
What is the main role of Power Query in Power BI?
Answer
Power Query is the data transformation editor built into Power BI. It allows importing data from various sources, cleaning, transforming, and preparing it before loading into the data model. All transformation steps are recorded and can be automatically reapplied during refresh.
3What language is used behind the scenes by Power Query for data transformations?
What language is used behind the scenes by Power Query for data transformations?
Answer
Power Query uses the M language (also called Power Query Formula Language) to define transformations. Each action in the graphical interface generates M code. It is possible to manually modify this code via the Advanced Editor for more complex or custom transformations.
What is the function of a slicer in a Power BI report?
What type of relationship is recommended between a fact table and a dimension table in Power BI?
+17 interview questions
Other Data Analytics interview topics
Google Sheets - Fundamentals
Google Sheets - Advanced Formulas
SQL - Fundamentals
SQL - Aggregations and Grouping
SQL - Joins
BigQuery - Fundamentals
Data Cleaning
KPIs and Business Metrics
Descriptive Statistics
Zapier and No-Code Automation
Data Visualization Principles
Python & Pandas - Fundamentals
Google Sheets - Automated Dashboards
SQL - Subqueries and CTEs
SQL - Window Functions
BigQuery - Advanced Features
Data Modeling
Funnel and Conversion Analysis
Cohort and Retention Analysis
Google Tag Manager and Tracking
APIs and Webhooks
dbt - Fundamentals
AB Testing and Applied Statistics
Looker Studio (Google Data Studio)
SQL - Advanced Analytical Queries
dbt - Advanced Features
Power BI - DAX and Advanced Dashboards
Python Analytics - Advanced Analysis and ML
Master Data Analytics for your next interview
Access all questions, flashcards, technical tests, code review exercises and interview simulators.
Start for free