POWER BI QUESTIONS PART 4

 

Power BI Interview Questions For Experienced

1. What are the types of visualizations in Power BI?

Visualization is a graphical representation of data. We can use visualizations to create reports and dashboards. The kinds of visualizations available in Power BI are Bar charts, Column charts, Line chart, Area chart, Stacked area chart, Ribbon chart, Waterfall chart, Scatter chart, Pie chart, Donut chart, Treemap chart, Map, Funnel chart, Gauge chart, Cards, KPI, Slicer, Table, Matrix, R script visual, Python visual, etc.

2. What do we understand by Power BI services?

Power BI provides services for its cloud-based business analytics. With these services, you can view and share reports via the Power BI website. Power BI is a web-based service for sharing reports. Power BI service can be best referred to as PowerBI.com, PowerBI workspace, PowerBI site, or PowerBI portal.

3. What is the comprehensive working system of Power BI?

Power BI’s working system mainly comprises three steps:

• Data Integration: The first step is to extract and integrate the data from heterogeneous data sources. After integration, the data is converted into a standard format and stored in a common area called the staging area.
• Data Processing: Once the data is assembled and integrated, it requires some cleaning up. Raw data is not so useful therefore, a few transformation and cleaning operations are performed on the data to remove redundant values, etc. After the data is transformed, it is stored in data warehouses.
• Data Presentation: Now that the data is transformed and cleaned, it is visually presented on the Power BI desktop as reports, dashboards, or scorecards. These reports can be shared via mobile apps or web to various business users.

4. What are custom visuals in Power BI?

Using Power BI visualizations, you can apply customized visualizations like charts, KPIs, etc. from the rich library of PowerBI’s custom visuals. It refrains the developers from creating it from scratch using JQuery or Javascript SDK. Once the custom visual is ready, it is tested thoroughly. Post testing, they are packaged in .pbiviz file format and shared within the organization.

Types of visuals available in Power BI are:

• Custom visual files.
• Organizational files.
• Marketplace files.

5. What are the various type of users who can use Power BI?

Anyone and everyone can use PowerBI to their advantage. But even then a specific set of users are more likely to use it viz:

• Business Users: Business users are the ones who constantly keep an eye on the reports to make important business decisions based on the insights.
• Business Analysts: Analysts are the ones who create dashboards, reports, and visual representations of data to study the dataset properly. Studying data needs an analytical eye to capture important trends within the reports.
• Developers: Developers are involved while creating custom visuals to create Power BI, integrating Power BI with other applications, etc. 
  Professionals: They use Power BI to check the data scalability, security, and availability of data.