Power BI
- Business analytics tool which relates to information sources available on-premises and cloud.
- Collect the data, build a relational model and analyze your organizational data in visually rich visualizations.
- We can also distribute the business-critical insights with governance and security built-in.
- Data development and research.
Components of Power BI
Power BI consists of three major components,
- Power BI Desktop
Windows desktop application where all of the growth of reports take place.
- Power BI Service
Online SaaS application that allows creating dashboards, handling workspaces, giving to intended users.
- Power BI Mobile
Mobile app accessible by Windows phones, tablets, iOS, and Android devices which assists in accessing dashboards/reports.
Apart from these, Organizations also uses the below components for Power BI,
- Power BI Report Server organization can host their reports on-premises
- Power BI Embedded Embedding power BI reports hosted on either Power BI Service or Report Server in native web applications.
How to Work with Power BI?
- Using a data model, you can create and share
visualizations, charts, tables
- Summarized information in a useful way leads to better business decisions.
Building Blocks of Power BI
- Visualizations
Visualization is a visual representation of data, such as a chart, graph, etc.
- Datasets
Set of data that Power BI does to create visualizations.
- Reports
Collection of visualizations that appear together on one or more pages.
- Dashboards
Collection of visuals from single or more reports to provide an overview of your business.
- Tiles
Its rectangular box contains each individual visual.
Overview of Power BI Service
- Power BI service connects to the cloud services and provides the insights with predefined dashboards and reports and edits the report/dashboard.
- Power BI Service allows a capability to the end-user to ask their question on data in words and it answers you in visual.
Overview of Modeling
- After data collection is completed with basic clean up and transformations, we need to create a model to work with different source
- A relationship between the data sources enables Power BI to know how tables are related to one another. However, Power BI auto-detects/identifies the relationship between the tables based on column names.
- Apart from establishing relationships, we can also create some calculated columns, calculated measures, calculated tables that serves business needs to identify KPI’s
DAX Query
DAX is the language of Power BI,
- DAX means data analysis expression.
- Functional language.
- Similar to excel formula language.