PowerBI
Which visualization's sole purpose is to filter data?
Slicer.
What is the difference between User ID and User Pseudo ID?
A user pseudo ID (or "effective user ID") is a unique identifier for a user on a specific device or app instance, while a User ID is a custom identifier you set to track users across multiple device.
What is the difference between HAVING and WHERE?
The WHERE clause evaluates all rows, and the HAVING clause evaluates rows after they've been aggregated in the data set.
What is ETL?
ETL stands for “Extract, Transform, and Load” and describes the set of processes to extract data from one system, transform it, and load it into a target repository.
In Power Query, what language are data transformations coded in?
M language.
This GA4 feature uses machine learning to measure conversions that aren’t directly observable.
Conversion Modelling.
🟢 DOUBLE POINTS!
If you have many fields that you need to group, what is the quickest way to do that?
GROUP BY ALL
What is structured and unstructured data?
Structured data is organized and easily searchable, often stored in tables or databases with defined fields, while unstructured data lacks a predefined format or organization, such as images, audios or social media posts.
Which of the following is a way to access Power BI content offline?
You collect data on your point-of-sale system that could complement the data you are sending to Google Analytics from your website and app.Which of these features allows you to collect and send events directly to Google Analytics servers?
Measurement Protocol.
What are materialised views?
They are precomputed views that store query results for faster access. They can significantly improve performance for frequently accessed queries by reducing the need to recompute results.
What's the difference between Data Lake and Data Warehouse?
Data lakes store all types of raw data. Data warehouses store cleaned and processed data, which can then be used for analytics and reporting purposes.
What is a Dataflow?
It’s a reusable transformation logic that can be shared by many semantic models and reports inside Power BI.
Which feature, when enabled, associates event data collected from users on an app or website with the Google accounts of users who are signed in and have explicitly consented to sharing this information?
Google Signals.
What can be used in conjunction with partitioning to further optimize query performance?
Clustering. By clustering tables based on specific columns, BigQuery can reduce the amount of data scanned during queries.
What's a data layer?
It is a temporary data storage. It is a data structure available within a browser on a page and holds all data that you want to process and pass from your website to other applications such as GTM.
Which component of the Microsoft Power Platform can be used to allows users to create and manage automated workflows and notifications?
Power Automate
If you wanted to create a new data set with a wide view of your business across brands, products, or regions by combining data from multiple-source properties, you would use THIS Analytics 360 feature.
Roll-up Property
❌ - No question!
.
What is the difference between classification and regression?
Classification is a machine learning technique that assigns data to categories (e.g. spam detection, speech recognition) while regression predicts continuous values (e.g. house price prediction). Both are supervised learning algorithms that use labeled dataset.