Explore topic-wise InterviewSolutions in .

FILTERS sort data based on the condition applied to it. Filters enable us to select particular fields and extract information in a page/visualization/REPORT level. For example, filters can provide SALES reports from the year 2019 for the Indian region.  Power BI can make changes based on the filters and create graphs or visuals accordingly. Types of filters are:

• Page-level filters: These are applied on a particular page from various pages available within a report.
• Visualization-level filters: These are applied to both data and CALCULATION conditions for particular visualizations.
• Report-level filters: These are applied to the entire report.

GetData offers data connectivity to various data sources. Connect data files on your local system. The supported data sources are:

• FILE: Excel, Text/CSV, XML, PDF, JSON, Folder, SharePoint.
• DATABASE: SQL Server database, Access database, Oracle database, SAP HANA database, IBM, MySQL, Teradata, Impala, Amazon Redshift, Google BigQuery, etc.
• Power BI: Power BI datasets, Power BI dataflows.
• AZURE: Azure SQL, Azure SQL Data Warehouse, Azure Analysis Services, Azure Data Lake, Azure Cosmos DB, etc.
• Online Services: SALESFORCE, Azure DevOps, Google Analytics, Adobe Analytics, Dynamics 365, Facebook, GITHUB, etc.
• Others: Python script, R script, Web, Spark, Hadoop File (HDFS), ODBC, OLE DB, Active Directory, etc.

The major differences between Power BI and Tableau are:

• While Power BI uses DAX for calculating columns of a table, Tableau uses MDX (Multidimensional Expressions).
• Tableau is more EFFICIENT as it can HANDLE a large chunk of data while Power BI can handle only a LIMITED AMOUNT. 
• Tableau is more challenging to use than Power BI.

Power QUERY is a function that filters transforms, and combines the data EXTRACTED from VARIOUS sources. It helps to IMPORT data from databases, files, ETC and append data

Power Pivot enables you to IMPORT millions of rows from heterogeneous sources of data into a single excel SHEET. It lets us create RELATIONSHIPS between the various tables, create columns, calculate using formulas, and create PivotCharts and PivotTables.

At a TIME there can be only one active RELATIONSHIP between the tables which is represented by a continuous line.

DAX is much more than Power BI. If you learn DAX as a functional language, you become better as a DATA professional. DAX is based on different nested FILTERS which magnificently improves the performance of data merging, modeling, and FILTERING tables.

Data Analysis Expression (DAX) is a library of formulas used for calculations and data analysis. This library comprises functions, constants, and operators to perform calculations and give results. DAX lets you use the data sets to their full potential and provide insightful reports.

DAX is a functional language containing conditional statements, nested functions, value references, and MUCH more. The formulas are either numeric (integers, DECIMALS, etc.) or non-numeric (string, binary). A DAX formula ALWAYS starts with an equal sign.

A: Name of the project
B: Start of the DAX formula
C: DAX FUNCTION (to ADD)
D: Parentheses defining arguments
E:  Name of the table
F: Name of the field
G: Operator

The three major versions of POWER BI are as follows:

• Power BI Desktop: The free interactive tool that CONNECTS multiple data sources, TRANSFORMS data, and creates visualized reports.
• Power BI Premium: The premium version is used for LARGER organizations with a dedicated storage capacity for each user. With premium, data sets up to 50GB storage capacity can be hosted along with 100TB storage on the cloud as a whole. It costs $4995 per month.
• Power BI Pro:  With the pro version, you get full access to the Power BI dashboard, creation of reports, along with unlimited sharing and viewing of reports. You also have a storage limit of 10GB per user.

Content packs are packages comprising different Power BI objects such as reports, dashboards, datasets, etc. The two types of content packs are:

Service PROVIDER content packs: Service PROVIDERS such as Google Analytics, Salesforce, etc. provide pre-built content packages

User-created content packs: Users can create their content packages and SHARE them WITHIN the organization.

The major building blocks of Power BI are:

• Datasets: Dataset is a collection of DATA gathered from various sources like SQL Server, Azure, Text, Oracle, XML, JSON, and many more. With the GetData feature in Power BI, we can easily fetch data from any data source.
• Visualizations: Visualization is the visual aesthetic representation of data in the form of maps, CHARTS, or tables.
• REPORTS: Reports are a STRUCTURED representation of datasets that consists of multiple pages. Reports help to extract important information and insights from datasets to take major business decisions.
• Dashboards: A dashboard is a single-page representation of reports made of various datasets. Each element is termed a tile. 
  Tiles: Tiles are single-block containing visualizations of a report. Tiles help to differentiate each report.

The dashboard is like a single-page CANVAS on which you have various elements to create and visualize reports created by ANALYZING data. It comprises only the most important data from the reports to create a story.

The visual elements present on the dashboard are called Tiles. You can PIN these tiles from the reports to the dashboard. CLICKING any ELEMENT on the dashboard takes you to the report of a particular data set.