A Basic Power Bi Report

Power BI Desktop is a free application you can install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model that lets you build visuals, and collections of visuals you can share as reports, with other people inside your organization. Most users who work on Business Intelligence projects use Power BI Desktop to create reports, and then use the Power BI service to share their reports with others.



The most common uses for Power BI Desktop are the following:

  • Connect to data
  • Transform and clean that data, to create a data model
  • Create visuals, such as charts or graphs, that provide visual representations of the data
  • Create reports that are collections of visuals, on one or more report pages
  • Share reports with others using the Power BI service
People most often responsible for such tasks are often considered data analysts (sometimes just referred to as analysts) or Business Intelligence professionals (often referred to as report creators). However, many people who don't consider themselves an analyst or a report creator use Power BI Desktop to create compelling reports, or to pull data from various sources and build data models, which they can share with their coworkers and organizations.
With Power BI Desktop you can create complex and visually rich reports, using data from multiple sources, all in one report that you can share with others in your organization
Connect to data
To get started with Power BI Desktop, the first step is to connect to data. There are many different data sources you can connect to from Power BI Desktop. To connect to data, simply select the Home ribbon, then select Get Data > More. The following image shows the Get Data window that appears, showing the many categories to which Power BI Desktop can connect.

When you select a data type, you're prompted for information, such as the URL and credentials, necessary for Power BI Desktop to connect to the data source on your behalf.

Once you connect to one or more data sources, you may want to transform the data so it's useful for you.
Transform and clean data, create a model:
Query Editor. With Query Editor you can make changes to your data, such as changing a data type, removing columns, or combining data from multiple sources. It's a little bit like sculpting - you can start with a large block of clay (or data), then shave pieces off or add others as needed, until the shape of the data is how you want it.

PBI have query editor which makes you to edit querys 

   The following image shows the Query Settings pane for a query that has been shaped, and turned       into a model.
Once your data is how you want it, you can create visuals

Create visuals:Once you have a data model, you can drag , fields onto the report canvas to create visuals. A visual is a graphic representation of the data in your model. The following visual shows a simple column chart.

my dashboard example  :)
the bellow one is example of filled maps:




the next part is generating reports ,and parameters,calculated fields measure and coulums,and DAX programing see you soon Happy weekend.........contiue





Comments

Post a Comment

Popular posts from this blog

Image
TABLEAU DONUT CHART: Many People Doest know how to create a basic donut chart in front of clients. I would suggest you simple steps with my  knowledge on tableau. i have Searched many website regarding donut chart every thing is complex and making no sense for beginners You refer this blog and give try :) Create a basic Pie chart as shown in bellow figure How to create a Basic pie chart Use pie charts to show proportions of a whole. The basic building blocks for a pie chart are as follows: Mark type : Pie Color : Dimension Angle : Measure To create a pie chart view that shows how different product categories contribute to total sales, follow these steps: Connect to the  Sample - Superstore  data source. Drag the  Sales  measure to  Columns . Tableau aggregates the measure as a sum. Drag the  Sub-Category  dimension to  Rows . The default chart type is a bar chart. Click  Show Me ...
Read more

Power BI

Image
WHAT IS POWER BI REPORT : A Power BI  report  is a multi-perspective view into a data set, with visualizations that represent different findings and insights from that data set. A report can have a single visualization or pages full of visualizations. Depending  on your job role, you may be someone who  creates  reports and/or you may be someone who  consumes  or uses reports. ADVANTAGES OF REPORTS : Reports are based on a single data set. The visualizations in a report each represent a nugget of information. And the visualizations aren't static; you can add and remove data, change visualization types, and apply filters and slicers as you dig into the data to discover insights and look for answers. Like a dashboard, but more-so, a report is highly interactive and highly customizable and the visualizations update as the underlying data changes HOW TO CREATE A REPORT: the report clearly indicates the pictorial representation of your  entire...
Read more