Microsoft Power BI

                                                        What is Power BI

  1. Power BI is a Data Visualization and Business Intelligence apparatus that changes over information from various information sources to intuitive dashboards and BI reports. 

  2.  Power BI suite gives various programming, connector, and administrations - Power BI work area, Power BI administration dependent on Saas, and portable Power BI applications accessible for various stages. 

3. These arrangement of administrations are utilized by business clients to expend information and assemble BI reports. 

4.Power BI work area application is utilized to make reports, while Power BI Services (Software as a Service - SaaS) is utilized to distribute the reports, and Power BI versatile application is utilized to see the reports and dashboards. 

Who should use Power BI?

Consumers are people who read / view things built in Power BI.

Power BI Creators are typically:

• Reporting professionals
• Analysts
• BI Developers
• Visualization Specialists
• Story tellers / Presenters

On the other-hand, almost anyone can be a Power BI consumer. 

                       

How is Power BI different from Excel?

• Power BI allows rich, immersive and interactive experiences
• Power BI works with large data sets
• Share and read reports easily
• Power BI is for story telling

                       

How to get Power BI Software?

• Power BI is always changing
• You do not need PowerBI.com account to use
• Login to publish & share your work.      

                     

Building your first report in Power BI

#1 - Understanding Power BI Desktop UI

#2 - Load data into Power BI

#3 - Adding Visuals

Changing Calculations for the Visuals

ou can use two methods to change the calculations for the charts. 

• Use default options for calculations – SUM / COUNT / AVERAGE etc.
• Write your own calculations with Power Pivot measures

To change the calculation of a chart with default options, follow below steps.

1. Select the power BI visual
2. Go to Value field.
3. Click on the little down arrow symbol.
4. Select the type of calculation you want.
5. Done.

•   
  
  
  

• Understanding Power BI Interactions

  Power BI visuals are interactive. This means, if you have more than one chart on a report page, when you click on a particular item on a chart, all other charts respond to the selection and change. 

  This is quite different from normal Excel charts, but once you get used to it, you will see the true power of Power BI visualizations.

  

  
  

  Putting it all together - Making a sample report in Power BI

  Now that you have some understanding of Power BI, let’s create our first Power BI report. The focus of this report will be,

  • For a specific manager
  • Show staff distribution by department
  • Gender break-down
  • All of their staff by salary and rating

  This is a fairly simple report, but it does demonstrate the power, elegance and ease of working with Power BI.

  Here is the final output we will create.

  

  Prepared by

  K.SANTHOSH KUMAR
  Business Development Manager
  Accent Techno Soft
  Coimbatore