INTRODUCTION TO POWER BI

Microsoft Power BI is a business intelligence platform that provides non-technical 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 self-service tool that requires little upfront training.

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. Users can download an application for Windows 10, called Power BI Desktop, and native mobile apps for Windows, Android and iOS devices. There is also Power BI Report Server for companies that must maintain their data and reports on-premises. That version of Power BI requires a special version of the desktop app called Power BI Desktop for Power BI Report Server.

Common uses of Power BI

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.

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 can provide dashboards and data reports to its users, visualizing their data


Power BI Flow:-


    Generally, the flow starts at the Power BI Desktop, where a report is created. This created report can be published to the Power BI Service and finally shared so that the users can use it from the Mobile apps.

    This is the most common approach for sharing reports. There are other approaches but we will stick to this flow for this entire tutorial to help learn the different aspects of Power BI.

The basic building blocks in Power BI are:

  • Visualizations
  • Datasets
  • Reports
  • Dashboards
  • Tiles

Following are the types of visualizations available in Power BI:-

Area charts: Basic (Layered) and Stacked

  • Bar and column charts
  • Donut charts
  • Gauge charts
  • KPIs
  • Line charts
  • Maps: Basic maps
  • Matrix
  • Pie charts
  • Tables
  • Waterfall charts







Comments

Post a Comment

Popular posts from this blog

Image
Model data in Power BI Introduction    Data model is a collection of loaded tables of data with one or more columns that have been loaded for a reason (don’t load any columns from your source into your model unless you have a reason). with one or more rows of data that have been loaded for a reason (don’t load rows from your source into your model unless you have a reason). relationships between the loaded tables the measures (formulas) written that apply the business rules to the raw data to extract business insights (e.g., sell price minus cost price is profit), including the formulas themselves the formatting applied to the formulas the business names were given to the formulas All of the above makeup what is referred to as “the data model” in Power BI The benefits of a data model based tool like Power BI are: the author of “the data model”  builds a reusable capability (the data model) that can be used to solve the current reporting requirements as well as (often) future requiremen
Read more