Getting started with Power BI Desktop. Welcome to the Power BI Desktop Getting Started Guide. This short tour of Power BI Desktop gets you acquainted with how it works, demonstrates what it can do, and accelerates your ability to build robust data models — along with amazing reports — that amplify your business intelligence efforts. Prefer to watch instead of read? Feel free to take a look at our getting started video. And if you want to follow along with the video with matching sample data, you can download this sample Excel workbook. Power BI Desktop lets you create a collection of queries, data connections, and reports that can easily be shared with others. Power BI Desktop integrates proven Microsoft technologies – the powerful Query engine, data modeling, and visualizations – and works seamlessly with the online Power BI service. With the combination of Power BI Desktop (where analysts and others can create powerful data connections, models and reports) and the Power BI service (where Power BI Desktop reports can be shared so users can view and interact with them), new insights from the world of data are easier to model, build, share, and extend. Data analysts will find Power BI Desktop a powerful, flexible, and a highly accessible tool to connect with and shape the world of data, build robust models, and craft well- structured reports. How to Use This Guide. · Understanding measures. In Power BI Desktop. Fields list with a calculator icon. result from an expression formula. When you create your own. · Microsoft Expression Design 2 is a professional illustration. Custom XAML Icon designs « Artistsvalley Designs. XAML, WPF, Expression Design. You can use this guide in a couple of ways – scan it for a quick overview, or read through each section for a strong understanding of how Power BI Desktop works. If you’re in a hurry you can do a visual sweep of this guide in just a couple minutes, and come away with a good sense of how Power BI Desktop operates, and how to use it. · Try Microsoft Edge A fast and. Design applications for the Windows desktop. These design principles will help you create a desktop. · Using Power BI Desktop to Create Data Visualizations and Explore Data. icon to ensure that the expression. Desktop that connected to a Microsoft. Double-click the installer icon.Get Microsoft Expression Web 4 and Expression Design 4 free.Download Microsoft Expression Design. Create. normal desktop. Microsoft Icons - Download 678 Free Microsoft icons @ IconArchive. Search more than 450,000 icons for Web & Desktop here. Icon Archive. Modern UI Icons. icons. donate. The only prerequisite is Expression Design which is provided free by Microsoft. Download Expression Design. Create a New.Most of this guide consists of screens that visually show how Power BI Desktop works. For a more thorough understanding you can read through each section, perform the steps, and walk away with your own Power BI Desktop file that’s ready to post onto the Power BI service, and share with others. How Power BI Desktop Works. With Power BI Desktop, you connect to data (usually multiple data sources), shape that data (with queries that build insightful, compelling data models), and use that model to create reports (which others can leverage, build upon, and share). When the steps are completed to your satisfaction – connect, shape, and report – you can save that work in Power BI Desktop file format, which is the . Power BI Desktop files can be shared like any other file, but the most compelling way to share Power BI Desktop files is to upload them (share them) on the Power BI service. Power BI Desktop centralizes, simplifies, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports. Ready to give it a try? Let’s get started. Install and Run Power BI Desktop. You can download Power BI Desktop from the Power BI service, by selecting the gear icon, then select Power BI Desktop. Power BI Desktop is installed as an application, and runs on your desktop. When you run Power BI Desktop, a Welcome screen is displayed. You can Get Data, see Recent Sources, or Open Other. Reports directly from the Welcome screen (from the links in the left pane). If you close the screen (select the x in the top right corner), the Report view of Power BI Desktop is displayed. There are three views in Power BI Desktop: Report view, Data view, and Relationships view. Power BI Desktop also includes Query Editor, which opens in a separate window. In Query Editor, you can build queries and transform data, then load that refined data model into Power BI Desktop, and create reports. The following screen shows the three view icons along the left of Power BI Desktop: Report, Data, and Relationships, from top to bottom. The currently displayed view is indicated by the yellow bar along the left. In this case, Report view is currently displayed. You can change views by selecting any of those three icons. With Power BI Desktop installed you’re ready to connect to data, shape data, and build reports (usually in that order). In the next few sections, we take a tour through each in turn. Connect to Data. With Power BI Desktop installed, you’re ready to connect to the ever expanding world of data. There are all sorts of data sources available in the Query window. The following image shows how to connect to data, by selecting the Home ribbon, then Get Data > More. For this quick tour, we'll connect to a couple different Web data sources. Imagine you’re retiring – you want to live where there’s lots of sunshine, preferable taxes, and good health care – or perhaps you’re a data analyst, and you want that information to help your customers. For example, perhaps you want to help your sunglasses retailer target sales where the sun shines most frequently. Either way, the following Web resource has interesting data about those topics, and more: http: //www. Select Get Data > Web and paste the address. When you select OK, the Query functionality of Power BI Desktop goes to work. Query contacts the Web resource, and the Navigator window returns what it found on that Web page. In this case, it found a table (Table 0) and the overall Web Document. We’re interested in the table, so we select it from the list. The Navigator window displays a preview. At this point we can edit the query before loading the table, by selecting Edit from the bottom of the window, or we can load the table. When we select Edit, Query Editor launches and a representative view of the table is presented. The Query Settings pane is displayed (if it’s not, you can select View from the ribbon, then Show > Query Settings to display the Query Settings pane). Here’s what that looks like. For more information about connecting to data, see Connect to Data in Power BI Desktop. In the next section, we adjust the data so it meets our needs. The process of adjusting connected data is called shaping data. Shape and Combine Data. Now that we’ve connected to a data source, we need to adjust the data to meet our needs. Sometimes adjusting means transforming the data – such as renaming columns or tables, changing text to numbers, removing rows, setting the first row as headers, and so on. The Query editor in Power BI Desktop makes ample use of right- click menus, in addition to having tasks available on the ribbon. Most of what you can select in the Transform ribbon is also available by right- clicking an item (such as a column) and choosing from the menu that appears. Shape Data. When you shape data in the Query Editor, you’re providing step- by- step instructions (that Query Editor carries out for you) to adjust the data as Query Editor loads and presents it. The original data source is not affected; only this particular view of the data is adjusted, or shaped. The steps you specify (such as rename a table, transform a data type, or delete columns) are recorded by Query Editor, and each time this query connects to the data source those steps are carried out so that the data is always shaped the way you specify. This process occurs whenever you use the query in Power BI Desktop, or for anyone who uses your shared query, such as in the Power BI service. Those steps are captured, sequentially, in the Query Settings pane under Applied Steps. The following image shows the Query Settings pane for a query that has been shaped – we’ll go through each of those steps in the next few paragraphs. Let’s get back to our retirement data, which we found by connecting to a Web data source, and shape that data to fit our needs. For starters, most ratings were brought into Query Editor as whole numbers, but not all of them (one column contained text and numbers, so it wasn't automatically converted). We need the data to be numbers. No problem – just right- click the column header, and select Change Type > Whole Number to change the data type. Microsoft Icons - Download 6. Free Microsoft icons here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |