- Why should use Power BI.?
Because , power bi provides an easy way for anyone ,including non technical people to connect change and visualize their raw business data from many different sources and turn it into valuable data that make it easy to make smart business decisions.
- What is power pivot?
This add in allows importing large amount of data from several sources into one workbook. users can analyze data without the need for IT assistance.
- What is Power BI?
- Power BI is a business analytics tool developed by Microsoft that helps you turn multiple unrelated data sources into valuable and interactive insights. These data may be in the form of an Excel spreadsheet or cloud-based/on-premises hybrid data warehouses. You can easily connect to all your data sources and share the insights with anyone.
- What is the measure in Power BI?
The measure perform calculations on aggregated values dynamically based on filters applied within reports, they are recalculated based on user intaractions with visuals.
What are Filters in Power BI?
The term “Filter” is self-explanatory. Filters are mathematical and logical conditions applied to data to filter out essential information in rows and columns. The following are the variety of filters available in Power BI:
- Manual filters
- Auto filters
- Include/Exclude filters
- Drill-down filters
- Cross Drill filters
- Drillthrough filters
- URL filters–transient
- Pass-Through filters
What is a dashboard in Power BI?
A dashboard is a single-layer presentation sheet of multiple visualizations reports. The main features of the Power BI dashboard are:
- It allows you to drill through the page, bookmarks, and selection pane and also lets you create various tiles and integrate URLs
- A dashboard can also help you set report layout to mobile view.
What are the different types of relationship in power bi ?
One -to-one(1:1) – Each record in one table corresponds toone record in another table.
One-to-many(1:N) – One record from one table relates to multiple records in another table.
Many-to-many(N:N) – Records from tables can relate to multiple records from each other.Rows in one table can relate to multiple rows in another table and vise versa.
Dashboards
A Power BI dashboard helps you to share a single visualization with colleagues and clients to view your final dashboard.
Tiles
A tile is an individual visualization on your final dashboard or one of your charts in your final report.
- What are the different types of visuals used in Power BI ?
- 1) Bar Chart
- 2) Pie Chart
- 3) Stacked Bar Chart
- 4) Line Chart
- 5) Area Chart
- 6) Column charts
- 7) Combo charts
- 8) Doughnut charts
- 9) Funnel charts
- 10) Cards and Funnel
- 11) Scatter Chart
- 12) Ribbon Chart
What is Power BI Desktop ?
Power BI Desktop is a free application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model.
The most common uses for Power BI Desktop are as follows:
- Connect to data.
- Transform and clean data to create a data model.
- Create visuals, such as charts or graphs that provide visual representations of the data.
- Create reports that are collections of visuals on one or more report pages.
- Share reports with others by using the Power BI service.
Business Intelligence Tool :- BI Toll are the types of Application Software that collect and process large amounts of unstuctured data from internal and external systems, including books, journals, documents, health records, images, files, email, video and other business sources.
What is Power Query ?
Power Query is a data connection technology used in Power BI for transforming, cleaning, and shaping data before it is loaded into the data model.