Explore topic-wise InterviewSolutions in Current Affairs.

1. ANDROID Mobile
2. iPhone and IPAD
3. WINDOWS DESKTOP and Windows TABLETS
4. Windows Phone

No we cannot have more than one ACTIVE relationship between two table, but we can have more than one relationship between two tables but there will be only one active relationship and MANY inactive relationship as SHOWN below dotted LINES are inactive and CONTINUOUS line as active.

No we cannot have more than one active relationship between two table, but we can have more than one relationship between two tables but there will be only one active relationship and many inactive relationship as shown below dotted lines are inactive and continuous line as active.

New power bi have new designing tool called Power BI Desktop which is a stand alone designer for power bi which in back-end include Power view,Power-pivot and power query

where as older excel version have power bi add INS for excel (power view , power pivot, power query and power MAP )

And there are more GRAPHS AVAILABLE in new version of power bi like combo chart, line area chart, water FALL, tree map etc.

New power bi have new designing tool called Power BI Desktop which is a stand alone designer for power bi which in back-end include Power view,Power-pivot and power query

where as older excel version have power bi add ins for excel (power view , power pivot, power query and power map )

And there are more graphs available in new version of power bi like combo chart, line area chart, water fall, tree map etc.

It is a natural language DATA querying where we can directly plot charge by simplying typing question on data set LIKE:

Total SALES by year and AREA:

It is availabe only when reports are PUBLISHED to colud (Powerbi.com or sharepoint)

It is a natural language data querying where we can directly plot charge by simplying typing question on data set like:

Total sales by year and area:

It is availabe only when reports are published to colud (Powerbi.com or sharepoint)

Data Management Gatway is a application which is installed on SOURCE data MACHINES so that reports DEPLOYED on sharepoint can scheduled to automatic refresh

Similarly PowerBI Personal GATEWAY is for reports which are deployed on Powerbi.com

Data Management Gatway is a application which is installed on source data machines so that reports deployed on sharepoint can scheduled to automatic refresh

Similarly PowerBI Personal Gateway is for reports which are deployed on Powerbi.com

Yes we can REFRESH our REPORTS through DATA Management gateway(for sharepoint) and PowerBI PERSONAL gateway.

Yes we can refresh our reports through Data Management gateway(for sharepoint) and PowerBI Personal gateway.

It is a STAND alone application where we can MAKE Power bi REPORTS and then upload it to Powerbi.com, it does not requires excel.
Actually it is a combination of Power QUERY, Power PIVOT, and Power view.

It is a stand alone application where we can make Power bi reports and then upload it to Powerbi.com, it does not requires excel.
Actually it is a combination of Power query, Power Pivot, and Power view.

There are two destination for output we get from power query:

1. LOAD to table in a worksheet or 
2. Load to the EXCEL DATA Model

Power Query gives you two choices for where the output of a query will be LOADED: a table in a worksheet or the Excel Data Model.

There are two destination for output we get from power query:

Power Query gives you two choices for where the output of a query will be loaded: a table in a worksheet or the Excel Data Model.

For a data to be consumed in power MAP there should be location data like:

• Latitude/Longitude pair
• Street, City, Country/Region, ZIP CODE/Postal Code, and State/Province, which can be geolocated by Bing
• The primary requirement for the table is that it contains unique rows. It must also contain location data, which can be in the FORM of a Latitude/Longitude pair, although this is not a requirement. You can use address FIELDS instead, such as Street, City, Country/Region, Zip Code/Postal Code, and State/Province, which can be geolocated by Bing.

For a data to be consumed in power map there should be location data like:

At present Power Map is only available as Excel Add-in, using this we can visualize data on 3D map.

Power Map is an Excel add-in that provides you with a powerful set of tools to HELP you visualize and gain insight into large sets of data that have a geocoded component. It can help you PRODUCE 3D visualizations by plotting up to a million data points in the form of column, heat, and bubble maps on top of a Bing map. If the data is time stamped, it can ALSO produce interactive VIEWS that display how the data changes over space and time.

At present Power Map is only available as Excel Add-in, using this we can visualize data on 3D map.

Power Map is an Excel add-in that provides you with a powerful set of tools to help you visualize and gain insight into large sets of data that have a geocoded component. It can help you produce 3D visualizations by plotting up to a million data points in the form of column, heat, and bubble maps on top of a Bing map. If the data is time stamped, it can also produce interactive views that display how the data changes over space and time.

A new programming language is USED in power QUERY called M-Code. It is easy to USE and similar to other LANGUAGES. M-code is case sensitive language.

A new programming language is used in power query called M-Code. It is easy to use and similar to other languages. M-code is case sensitive language.

Power query is a ETL Tool used to shape, clean and transform DATA using intuitive interfaces without having to USE code.

• IMPORT Data from wide range of source from files to databases , big data to social media
• Join and append data from MULTIPLE data sources 
• Shape data as per requirement by REMOVING and adding data.

Power query is a ETL Tool used to shape, clean and transform data using intuitive interfaces without having to use code.

To do basic calculation and data analysis on data in POWER pivot we use Data Analysis Expression (DAX).It is formula language to compute calculated column and calculated field. 

• Dax works on column values
• Dax can not modify or insert data
• We can CALCULATE calculated column and measures but we can not calculate rows using dax

Sample DAX formula syntax:

For the measure named Total SALES, calculate (=) the SUM of values in the [SalesAmount ] column in the Sales table.

A- Measure Name

B- equal sign - indicate beginning of formula

C- DAX Function

D- Parenthesis for Sum Function

E- Referenced Table

F- Referenced column name

To do basic calculation and data analysis on data in power pivot we use Data Analysis Expression (DAX).It is formula language to compute calculated column and calculated field. 

Sample DAX formula syntax:

For the measure named Total Sales, calculate (=) the SUM of values in the [SalesAmount ] column in the Sales table.

A- Measure Name

B- equal sign - indicate beginning of formula

C- DAX Function

D- Parenthesis for Sum Function

E- Referenced Table

F- Referenced column name

DATA Model in POWER pivot is made up of TABLES, COLUMNS, data TYPES, and table relations.Typically data tables are constructed to hold data for a business entity.

Data Model in Power pivot is made up of tables, columns, data types, and table relations.Typically data tables are constructed to hold data for a business entity.

The main engine behind power pivot is the xVelocity in-memory analytics engine.

It can HANDLE large amount of data because it stores data in columnar databases and in memory analytics which results in FASTER processing of data as it loads all data to RAM memory.

For best result use 64 BIT operating system as 64 bit can load more data to RAM.

The main engine behind power pivot is the xVelocity in-memory analytics engine.

It can handle large amount of data because it stores data in columnar databases and in memory analytics which results in faster processing of data as it loads all data to RAM memory.

For best result use 64 bit operating system as 64 bit can load more data to RAM.

DAX(DATA ANALYSIS EXPRESSION)

DAX(Data Analysis eXpression)

• Power Query—find, EDIT and LOAD external DATA
• PowerPivot—for data modeling for analysis
• Power View—design visually and INTERACTIVELY reports
• Power Map—display insights on 3D Map

Power BI is a cloud-based data sharing environment. 

Once you have developed reports (or PRESENTATIONS, if you prefer to call them that) using power query,PowerPivot and Power View, you will probably want to share your insights with your colleagues. This is where Power BI enters the equation. Power BI, which TECHNICALLY is an aspect of SHAREPOINT online, lets you load Excel workbooks into the cloud and share them with a chosen group of co-workers. Not only that, but your colleagues can interact with your reports to apply filters and slicers and to highlight data.

They are completed by Power BI—a simple way of sharing your analyses and insights on PCs and mobile devices from the Microsoft cloud.

Power BI FEATURES that allow you to:

• Share presentations and queries with your colleagues.
• Update your Excel FILE from data sources that can be on-site or in the cloud.
• Display the output on multiple devices. This includes PCs, tablets, and HTML 5-enabled mobile devices that use the Power BI app.
• Query your data using natural language processing .

Power BI is a cloud-based data sharing environment. 

Once you have developed reports (or presentations, if you prefer to call them that) using power query,PowerPivot and Power View, you will probably want to share your insights with your colleagues. This is where Power BI enters the equation. Power BI, which technically is an aspect of SharePoint online, lets you load Excel workbooks into the cloud and share them with a chosen group of co-workers. Not only that, but your colleagues can interact with your reports to apply filters and slicers and to highlight data.

They are completed by Power BI—a simple way of sharing your analyses and insights on PCs and mobile devices from the Microsoft cloud.

Power BI features that allow you to:

Microsoft has two parts for Self-Service BI:

• Excel BI Toolkit - It ALLOWS user to CREATE interactive report by importing data from DIFFERENT sources and MODEL data accorequirement.
• Power BI - it is the online solution that ENABLES you to share the interactive reports and queries that you have created using the Excel BI Toolkit.

Microsoft has two parts for Self-Service BI: