Posts

Image
  Model data in Power BI Often we have to  connect to multiple data sources to create your reports. All that data needs to work together to create a cohesive report.  Modeling  is how to get your connected data ready for use. Creating relationship between your data sources The  Model view  in Power BI Desktop allows you to visually set the relationship between tables or elements. A relationship is where two or more tables are linked together because they contain related data. This enables users to run queries for related data across multiple tables.Use the Model view to see a diagrammatic view of your data. In the Model view, notice that a block represents each table and the lines between them represent relationships. Adding and removing relationships is straightforward. To remove a relationship, right-click the relationship and select  Delete . To create a relationship, drag and drop the fields that you want to link between tables. To hide a table or ...
Post a Comment
Read more

Explore Power BI Desktop

Image
  Explore Power BI Desktop Power BI Desktop allows us to build reports and share it across it makes sense when you explore it hands on,The first step in Power BI is to learn about the UI(User Interface) launch it and explore it. Launch Power BI Desktop To launch Power BI desktop click on Power BI Desktop app and launch it is launched you can see a welcome window which as report view data view and model view,and at the top you have all the options which you can use while creating your reports.Following image shows the different panes available in Power BI Desktop. Creating a visual You can create a visual in Power BI Desktop by selceting the  required column from the field pane as shown in the below image. Publish Report After creating report with the visuals we need to publish the report to Power BI Service to publish the report we have a publish report option in Power BI Desktop we need to login into Power BI service before publishing the report the following is the icon for ...
Post a Comment
Read more

Introduction to power Bi

Image
Introduction Microsoft Power BI  is a business intelligent tool which allows you to connect various data resources and work together.It allows us to connect data from,Excel,Web,SQL Server,text files and more then 100 data sources we can connect to power bi.We can load the data,transform the data and build reports and dashboards according to the user needs. Parts of Power BI Power BI Desktop Power BI Service Mobile apps The Power BI Desktop is a Microsoft Windows Desktop appliction,and all the reports,visuals,dashboards created in Power BI Desktop are published in Power BI Service which is a online Saas(Software as a Service). What is Power BI Desktop? Power BI Desktop  is an application that you download and install for free on your local computer. Desktop is a complete data analysis and report creation tool that is used to connect to, transform, visualize, and analyze your data. It includes the Query Editor, in which you can connect to many different sources of data, and comb...
Post a Comment
Read more