Spg Infracon Interview Questions and Answers

I use simple language, visuals, and real-life examples to explain the dashboard to non-technical individuals.

• Use simple language and avoid technical jargon

• Include visuals like charts and graphs to make data easier to understand

• Provide real-life examples to illustrate the data and its implications

Data Flow is a Power BI feature that allows users to transform and load data from various sources into a Power BI dataset.

• Data Flow is a visual interface for building ETL (Extract, Transform, Load) processes in Power BI

• It allows users to connect to various data sources, transform data using Power Query Editor, and load the transformed data into a Power BI dataset

• Data Flow can be scheduled to refresh data on a regular basis

• Examples of data sources that can be used in Data Flow...read more

Views are virtual tables that display data from one or more tables, while tables store data physically.

• Views are saved queries that act as virtual tables

• Views do not store data physically, but tables do

• Views can be used to simplify complex queries or restrict access to certain columns

• Tables are used to store data permanently

• Example: A view can be created to display only specific columns from a table

Calendar function in DAX can be used to create a date table from scratch.

• Create a new table with a column for each date component (year, month, day)

• Use the CALENDAR function to generate a range of dates

• Join the new table with the existing dataset using a common key

• Use the new date table to perform time intelligence calculations

Dynamic row level security is a feature that allows restrictions to be applied to rows of data based on user roles or attributes.

• Implemented in BI tools like Power BI or Tableau

• Security rules are defined based on user roles or attributes

• Users only see data that they are authorized to access

M query and DAX are both case sensitive.

• M query is case sensitive, meaning that 'Hello' and 'hello' are considered different values.

• DAX is also case sensitive, so 'SUM' and 'sum' are not the same.

• It is important to be consistent with capitalization when working with M query and DAX.

Different types of loads include static, dynamic, thermal, and seismic loads.

• Static loads are constant and do not change over time, such as the weight of a building.

• Dynamic loads are variable and can change over time, such as wind or water pressure.

• Thermal loads are caused by temperature changes and can cause expansion or contraction of materials.

• Seismic loads are caused by earthquakes and can cause shaking or vibration of structures.

• Other types of loads include live loads (s...read more