Microsoft Power BI


Microsoft Power BI is a business intelligence platform that provides business users with tools for aggregating, analyzing, visualizing and sharing data. Power BI's user interface is fairly intuitive for users familiar with Excel and its deep integration with other Microsoft products makes it a very versatile tool.

A free version of Power BI is intended for small to midsize business owners; a professional version called Power BI Plus is available for a monthly subscription fee.

Microsoft Power BI is used to find insights within an organization's data. Power BI can help connect disparate data sets, transform and clean the data into a data model and create charts or graphs to provide visuals of the data. All of this can be shared with other Power BI users within the organization.

Power BI Data Models

The data models created from Power BI can be used in several ways for organizations, including telling stories through charts and data visualizations and examining "what if" scenarios within the data. Power BI reports can also answer questions in real time and help with forecasting to make sure departments meet business metrics.

Power BI can also provide executive dashboards for administrators or managers, giving management more insight into how departments are doing.

Power BI with DAX

DAX (Data Analysis Expressions) is a formula expression language and can be used in different BI and visualization tools. DAX is also known as function language, where the full code is kept inside a function. DAX function can also include other functions, conditional statements, and value references.

Why is DAX so important?

Do you need to analyze growth percentage across product categories in different date ranges? Or do you need to calculate year-over-year growth compared to market trends? DAX formulas provide this capability and many other important capabilities as well.

Who uses Power BI?

Power BI is BI tool that brings data analytics to employees. It's mostly used by business owners, managers, data analysts and business intelligence professionals.

Interactive Demo Dashboard with Power BI