In this case, I am using the desktop Power BI version, commonly known as Power BI Desktop however, you are free to use the cloud version (Power BI Service) to visualize the key performance indicators (KPIs) by geographical regions in the USA.Īs previously mentioned, we will first import the Excel file using the Data Import menu in Power BI Desktop. Thus, our first task would be to import this Excel sheet into Power BI. Sales revenue and gross margin will be used to track the performance of these regions. We will use this information to showcase which regions in the US are the most significant contributor to sales and where Superstore can improve its performance. For instance, our interest columns are the State, City, and Postal Code, along with the Country (United States), of course. We will use the Orders sheet from the Excel file.Īs you may have already guessed by now, we will use the customers’ geographical information to showcase our analysis. For purposes of practice, I have uploaded the dataset here. In the picture below, we show a snapshot of the US Superstore data. The variables present in the data set are order ID (order identification number), order and shipment Date, mode of shipment, customer to whom the order was shipped, the customer’s geographical location, product bought, and the sales financials. The dataset records the orders placed by customers across the Superstore chain of stores in the USA. Those who have worked with Tableau must be already familiar with the sample US Superstore data. 10 Useful Data Analysis Expressions (DAX) Functions for Power BI Beginnersīefore we dive into creating map-based visualizations, let’s look at the dataset we will use for our analysis.For a beginner-friendly introduction to Power BI, check out these blogs: Note: I will assume some prior familiarity using the Power BI Desktop platform. As we explore both these map service providers’ features, I leave it to the user’s discretion to take their call while creating spatial data visualization. However, Power BI has an additional plug-in for ESRI’s ArcGIS maps that gives you a completely different experience for plotting spatial data. For instance, Bing Maps powered by Microsoft serves most of our map-making tasks in Power BI. In addition to the ease of use, it also gives you a host of options to choose from to make maps. Microsoft’s proprietary product Power BI is a powerful business intelligence tool that provides you with the capability to prepare map-based visualizations with a few clicks. You would most likely land on a web page that has a map of a region on which the figures are displayed. For instance, search for COVID-19 statistics on the internet. Nowadays, you would hardly come across a dashboard that does not contain a map-based visualization. The development and growth of GIS (Geographic Information Systems) tools have been a contributor. In recent years, digital mapping has lead to a paradigm shift in information visualization. While there are multiple options to create maps in Power BI, we will explore the features provided by Bing Maps and ArcGIS maps. In this article, we will learn how to create map-based visualizations in Power BI. Explore and compare Bing and ArcGIS maps in Power BI.Understand how to create map-based visualizations in Power BI.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |