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


Learn More

\"myitschools\"

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

Download the version of Power BI Desktop that matches the architecture (x86 or x64) of your Windows OS. Run the EXE installer and follow the setup steps.
 

Power BI


\"myitschools\"

Microsoft Power BI

Popular Data Visualization Tools

\"\"

Introduction

Power BI is business intelligence tool used for data visualization and analysis


Read More


User Interface

The major building blocks of Power BI are: dashboards, reports, workbooks, datasets, dataflows, and apps


Read More


Components of Power BI

Power Query,
Power Pivot,
Power View,
Power Map,
Power Q&A and
Power BI Desktop


Read More

\"\"

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.


Read More


Relationship

Being self-confident makes you perfect for gaining success. Assuring the enhancement of inner-power.


Read More


Append & Merge

Data modeling is a process of creating a conceptual representation of data objects and their relationships to one another.


Read More

(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.


Read More


Measure

the way of defining calculations in a DAX model, which helps us to calculate values based on each row.


Read More


Quick Measure

allowed Power BI Desktop users to create DAX measures using a built-in template instead of writing the DAX from first principles.


Read More


Column

A calculated column belongs to a single table, while a measure belongs to the whole data model.


Read More


Table

A table is a grid that contains related data in a logical series of rows and columns.


Read More

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.


Read More


Logical functions

Logical functions act upon an expression to return information about the values or sets in the expression.


Read More


Date and time

Date and time functions help creating calculations based on dates and time.


Read More


Text functions

Data Analysis Expressions (DAX) includes a set of text functions based on the library of string functions in Excel


Read More


Time-intelligence functions

Time-intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years.


Read More


Filter functions

The filtering functions let you manipulate data context to create dynamic calculations


Read More


Table functions

Table manipulation functions return tables and these functions are used to manipulate the table like ADDCOLUMN, SELECT, ROW


Read More


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.


Read More