Skip to main content

Posts

Showing posts from July, 2024

Compare Power BI Desktop and the Power BI service

  Power BI Desktop  is a free application that you download and install 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 combine them (often called modeling) into a data model. Then you design a report based on that data model. Reports can be shared with others directly or by publishing to the Power BI service. Sharing reports requires a Power BI Pro license. The  Power BI Desktop getting started guide  walks through the process. The  Power BI service  is a cloud-based service, or  software as a service  (SaaS). It supports report editing and collaboration for teams and organizations. You can connect to data sources in the Power BI service, too, but modeling is limited. The Power BI service is used to do things such as creating dashboards, creating...

What is the Power BI service?

  Power BI is a collection of software services, apps, and connectors that work together to help you create, share, and consume business insights in the way that serves you and your business most effectively. The Microsoft Power BI service ( https://app.powerbi.com ) is the Software as a Service (SaaS) part of Power BI. The Power BI service lets you consume and interact with reports, as well as individual visual elements found in those reports, right from your browser.  Dashboards  in the Power BI service help you keep a finger on the pulse of your business. Dashboards display  tiles , which you can select to open  reports  for exploring further. Dashboards and reports create their interactive visuals based on the  semantic models  on which they are based, enabling your data to become visuals, and those visuals to be organized into reports to provide you with business intelligence you can act upon. Need help with understanding the building blocks ...

What is Power BI Desktop?

  Power BI Desktop   is a free application you 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. This data model 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 as follows: Connect to data. Transform and clean 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 by using the Power BI service. People who are responsible for such tasks a...

What is Power BI?

  Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want. The parts of Power BI Power BI consists of several elements that all work together, starting with these three basics: A Windows desktop application called  Power BI Desktop . An online software as a service (SaaS) service called the  Power BI service . Power BI Mobile apps for Windows, iOS, and Android devices. These three elements—Power BI Desktop, the service, and the mobile apps—are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively. Beyond those three, Power B...

Get and transform data with Power BI

  Get and transform data with Power BI The first step to insights begins in Power BI Desktop where you connect to and transform your data in preparation for data modeling. Start here to learn how to ingest and transform data in Power BI. Prerequisites There are no prerequisites for this learning path. Start Add Modules in this learning path Get data in Power BI You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data. Start Overview Introduction Get data from files Get data from relational data sources Create dynamic reports with parameters Get data from a NoSQL database Get data from online services Select a storage mode Get data from Azure Analysis Services Fix performance issues Resolve data import errors Exercise - Prepare data in Power BI Desktop Check your knowledge Summary Clean, transform, and load data in Power BI Power Que...