What is Power BI?
- Microsoft Power BI is a Business Intelligence (BI) platform for aggregating, analyzing, visualizing and sharing data.
- Initial release date: 24 July 2015
- Developer: Microsoft Corporation
Power BI Desktop
Microsoft Power BI Desktop is built for the analyst. It combines state-of-the-art interactive visualizations, with industry-leading data query and modeling built-in. Create and publish your reports to Power BI. Power BI Desktop helps you empower others with timely critical insights, anytime, anywhere.
Try to down load Power BI Desktop
Microsoft Power BI
Popular Data Visualization Tools
Introduction
Power BI is business intelligence tool used for data visualization and analysis
User Interface
The major building blocks of Power BI are: dashboards, reports, workbooks, datasets, dataflows, and apps
Components of Power BI
Power Query, Power Pivot, Power View, Power Map, Power Q&A and Power BI Desktop
Data Modelling
Data modeling is the process of creating a visual representation of company data to communicate connections between data points and structures using table and chart with the help of nay business intelligence tool.
Data Modelling
Data modeling is a process of creating a conceptual representation of data objects and their relationships to one another.
Relationship
Being self-confident makes you perfect for gaining success. Assuring the enhancement of inner-power.
Append & Merge
Data modeling is a process of creating a conceptual representation of data objects and their relationships to one another.
(DAX) Data Analysis Expressions
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models
What is DAX?
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services.
Measure
the way of defining calculations in a DAX model, which helps us to calculate values based on each row.
Quick Measure
allowed Power BI Desktop users to create DAX measures using a built-in template instead of writing the DAX from first principles.
Column
A calculated column belongs to a single table, while a measure belongs to the whole data model.
Table
A table is a grid that contains related data in a logical series of rows and columns.
DAX Functions or Formula
DAX is a formula language. You can use DAX to define custom calculations for Calculated Columns and for Measures (also known as calculated fields). DAX includes some of the functions used in Excel formulas, and additional functions designed to work with relational data and perform dynamic aggregation.
Aggregate functions
An aggregate function (Count, Min, Max, Average, Sum) performs a calculation on a set of values, and returns a single value.
Logical functions
Logical functions act upon an expression to return information about the values or sets in the expression.
Date and time
Date and time functions help creating calculations based on dates and time.
Text functions
Data Analysis Expressions (DAX) includes a set of text functions based on the library of string functions in Excel
Time-intelligence functions
Time-intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years.
Filter functions
The filtering functions let you manipulate data context to create dynamic calculations
Table functions
Table manipulation functions return tables and these functions are used to manipulate the table like ADDCOLUMN, SELECT, ROW
Information functions
Information functions look at the cell or row that is provided as an argument and tells you whether the value matches the expected type.