{"id":1342,"date":"2022-07-26T12:58:24","date_gmt":"2022-07-26T09:58:24","guid":{"rendered":"https:\/\/resourcefulscholarshub.com\/?p=1342"},"modified":"2022-07-26T13:01:09","modified_gmt":"2022-07-26T10:01:09","slug":"data-analysis-and-visualisation-using-power-bi-desktop","status":"publish","type":"post","link":"https:\/\/resourcefulscholarshub.com\/?p=1342","title":{"rendered":"Data Analysis and Visualisation using Power BI Desktop"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Power BI Desktop is a free version of Microsoft\u2019s Power BI software. It is available for <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/desktop\/\">download<\/a> and local installation on your laptop or personal computer from the website.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As a business intelligence tool, it allows you to connect to data, transform\/clean data, build visualisation reports, and derive meaningful insights from your data.<\/p>\n\n\n\n<ul class=\"wp-block-advgb-summary advgb-toc alignnone\"><li class=\"toc-level-1\"><a href=\"#how-to-load-data-into-power-bi-16dc0a68-c2d4-4767-a50e-b3f3f1db4893\">How to load data into Power BI<\/a><\/li><li class=\"toc-level-1\"><a href=\"#examples-of-data-analysis-reports-a935bfb3-6e36-47d7-905e-16f781aa5692\">Examples of data analysis reports<\/a><\/li><li class=\"toc-level-1\"><a href=\"#how-to-use-power-bi-dax-language-to-build-measures-and-calculations-66de8df5-9a83-484e-84d3-bc0dcafbb5f6\">How to use Power BI DAX language to build measures and calculations<\/a><\/li><li class=\"toc-level-2\"><a href=\"#how-to-add-measures-a66685ea-6c64-4089-8889-9a32e9c6f120\">How to add measures<\/a><\/li><li class=\"toc-level-2\"><a href=\"#how-to-add-slicers-b24a6f37-52e5-4c3a-8db9-409102809fba\">How to add slicers<\/a><\/li><li class=\"toc-level-1\"><a href=\"#how-to-format-power-bi-visuals-720f57f8-a015-4c7f-8a3d-5c1d7d237612\">How to format Power BI visuals<\/a><\/li><li class=\"toc-level-1\"><a href=\"#trend-analysis-and-forecasting-using-power-bi-46d5e722-5db5-4eff-90ce-f8675afb2b0d\">Trend analysis and forecasting using Power BI<\/a><\/li><li class=\"toc-level-2\"><a href=\"#how-to-do-a-trend-analysis-per-year-0856993d-fdd6-4871-8e0c-b107e7b3674c\">How to do a trend analysis per year<\/a><\/li><li class=\"toc-level-2\"><a href=\"#how-to-forecast-a670c49a-04b4-4472-890f-303cd802a666\">How to forecast<\/a><\/li><li class=\"toc-level-1\"><a href=\"#how-to-save-and-publish-power-bi-dashboards-3f943803-2aa3-4eb5-b5e2-126564e6f8a1\">How to save and publish Power BI dashboards<\/a><\/li><li class=\"toc-level-1\"><a href=\"#how-to-update-and-refresh-datasets-79fe94c1-ed63-4cae-8824-d92095414490\">How to update and refresh datasets<\/a><\/li><li class=\"toc-level-1\"><a href=\"#pros-and-cons-of-power-bi-desktop-efbdadb0-14a3-485f-8000-1e256535acd6\">Pros and cons of Power BI Desktop<\/a><\/li><li class=\"toc-level-1\"><a href=\"#final-thoughts-on-data-analysis-and-visualisation-using-power-bi-desktop-2d8b68ae-b48a-4df1-ac8c-23869ff54963\">Final thoughts on data analysis and visualisation using Power BI Desktop<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-load-data-into-power-bi-16dc0a68-c2d4-4767-a50e-b3f3f1db4893\"><strong>How to load data into Power BI<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Use the <strong>\u201cGet Data\u201d<\/strong> button available from multiple sections, as shown in these screenshots.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"431\" height=\"575\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_1.png\" alt=\"\" class=\"wp-image-1343\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_1.png 431w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_1-225x300.png 225w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"355\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_2.png\" alt=\"\" class=\"wp-image-1344\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_2.png 924w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_2-300x115.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_2-768x295.png 768w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI allows you to add data from numerous sources. We will be using data from a CSV file.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Go to <strong>Get data<\/strong> &gt; <strong>Text\/CSV<\/strong><\/li><li>Locate your data file and click on <strong>Load<\/strong>.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"454\" height=\"114\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_3.png\" alt=\"\" class=\"wp-image-1345\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_3.png 454w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_3-300x75.png 300w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">After a few minutes of loading, your data appears.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"793\" height=\"297\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_4.png\" alt=\"\" class=\"wp-image-1346\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_4.png 793w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_4-300x112.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_4-768x288.png 768w\" sizes=\"auto, (max-width: 793px) 100vw, 793px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use the <strong>Data<\/strong> view mode on the left side panel to explore your data before building your reports.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"examples-of-data-analysis-reports-a935bfb3-6e36-47d7-905e-16f781aa5692\"><strong>Examples of data analysis reports<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">We will create a sales performance report with the following insights:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What are the total sales per country?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We will use a column chart to display the total sales per country.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Select the <strong>column chart<\/strong> on the \u201cVisualizations\u201d panel.<\/li><li>Drag and drop <strong>\u201cCountry\u201d<\/strong> on the \u201cAxis\u201d section and <strong>\u201cSales\u201d<\/strong> on the \u201cValues\u201d section.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"275\" height=\"277\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_5.png\" alt=\"\" class=\"wp-image-1347\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_5.png 275w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_5-150x150.png 150w\" sizes=\"auto, (max-width: 275px) 100vw, 275px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Our data has 19 countries, with the USA having the highest sales.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"689\" height=\"502\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_6.png\" alt=\"\" class=\"wp-image-1348\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_6.png 689w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_6-300x219.png 300w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What are the total sales for each sales contact person?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s use a bar chart for this. The sales contact people have their first and last names on the field lists. We will use their first names for the bar chart.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Drag and drop the<strong> \u201cContact first name\u201d<\/strong> on the \u201cAxis\u201d section and <strong>\u201cSales\u201d<\/strong> on the \u201cValues\u201d section.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"364\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_7.png\" alt=\"\" class=\"wp-image-1349\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_7.png 545w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_7-300x200.png 300w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Our data has 10 salespeople, with Valerie having the highest sales.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-use-power-bi-dax-language-to-build-measures-and-calculations-66de8df5-9a83-484e-84d3-bc0dcafbb5f6\"><strong>How to use Power BI DAX language to build measures and calculations<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>DAX (Data Analysis Expressions)<\/strong> is a programming language containing a library of functions and operators for creating customized tables, calculated fields, and measures.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Besides presenting the total sales per sales person in a bar chart, we can use a table with DAX calculations.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the bar chart, we dragged and dropped the sales amount in the values section, and Power BI calculated it automatically. DAX allows you to specify how you want the values to appear.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-to-add-measures-a66685ea-6c64-4089-8889-9a32e9c6f120\"><strong>How to add measures<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Select a table from the \u201cVisualizations\u201d panel.<\/li><li>Drag and drop the sales \u201cContact first name\u201d field on the \u201cValues\u201d section.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"283\" height=\"122\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_8.png\" alt=\"\" class=\"wp-image-1350\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\" start=\"3\"><li>Right-click on the Sales amount and select <strong>\u201cNew Measure\u201d<\/strong>.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"343\" height=\"593\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_9.png\" alt=\"\" class=\"wp-image-1351\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_9.png 343w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_9-174x300.png 174w\" sizes=\"auto, (max-width: 343px) 100vw, 343px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Alternatively, click the<strong> \u201cNew measure\u201d<\/strong> button in the <strong>\u201cHome\u201d<\/strong> tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A text box appears where you can create the new measure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Our new measure will be the total amount of sales as shown.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"645\" height=\"72\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_10.png\" alt=\"\" class=\"wp-image-1352\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_10.png 645w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_10-300x33.png 300w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">New measures have both logic and visual aspects to them. Use the <strong>\u201cMeasure tools\u201d <\/strong>button to edit the visual effect of the new field by adding the currency symbol with no decimal point.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"339\" height=\"95\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_11.png\" alt=\"\" class=\"wp-image-1353\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_11.png 339w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_11-300x84.png 300w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click the<strong> \u201ctick\u201d<\/strong> mark on the left to add the new measure to the fields panel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">New measures are denoted with a <strong>\u201ccalculator\u201d <\/strong>symbol, as shown below, so you can easily spot them.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"254\" height=\"64\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_12.png\" alt=\"\" class=\"wp-image-1354\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When we drag and drop the total amount below the sales contact&#8217;s first name, all the salespeople and their total amounts are displayed. Here is a snapshot of a few.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"529\" height=\"439\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_13.png\" alt=\"\" class=\"wp-image-1355\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_13.png 529w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_13-300x249.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We can then add <strong>filters <\/strong>and <strong>slicers<\/strong> to our salespeople\u2019s table. For instance, we can filter the salespeople per country.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-to-add-slicers-b24a6f37-52e5-4c3a-8db9-409102809fba\"><strong>How to add slicers<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Select the \u201cslicer\u201d from the visualization panel.<\/li><li>Add the \u201cCountry\u201d field on the slicer.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"293\" height=\"472\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_14.png\" alt=\"\" class=\"wp-image-1356\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_14.png 293w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_14-186x300.png 186w\" sizes=\"auto, (max-width: 293px) 100vw, 293px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click on any country in the slicer to view the salespeople and their total amounts in that country. For example, Finland has three salespeople with a total sales amount of $ 329,582.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"824\" height=\"458\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_15.png\" alt=\"\" class=\"wp-image-1357\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_15.png 824w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_15-300x167.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_15-768x427.png 768w\" sizes=\"auto, (max-width: 824px) 100vw, 824px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-format-power-bi-visuals-720f57f8-a015-4c7f-8a3d-5c1d7d237612\"><strong>How to format Power BI visuals<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Rather than leaving our reports looking bland, we can format and adjust their appearance. For example, we can format the table displaying the salespeople and the total amount.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Select the table.<\/li><li>Click on the \u201cFormat\u201d icon shown as a paintbrush.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"220\" height=\"70\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_16.png\" alt=\"\" class=\"wp-image-1358\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019ll increase the value font size from 10 to 16.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Go to <strong>Values<\/strong> &gt; <strong>Text size<\/strong>.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"275\" height=\"404\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_17.png\" alt=\"\" class=\"wp-image-1359\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_17.png 275w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_17-204x300.png 204w\" sizes=\"auto, (max-width: 275px) 100vw, 275px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019ll also increase the <strong>row padding<\/strong> to make the table rows larger and easier to read.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Go to <strong>Grid<\/strong> &gt; <strong>Row padding<\/strong>.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019ve increased the padding from 1 to 3.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"262\" height=\"185\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_18.png\" alt=\"\" class=\"wp-image-1360\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Lastly, we\u2019ll enlarge the header, add a font color as well as a background color.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Go to <strong>Column headers<\/strong> &gt; <strong>Font color<\/strong> from black to white.<\/li><li><strong>Column headers<\/strong> &gt; <strong>Background color<\/strong> to blue.<\/li><li><strong>Column headers<\/strong> &gt; <strong>Text size <\/strong>of 18.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Our table now looks much better. We can sort the total amount from the highest to the lowest.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"806\" height=\"579\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_19.png\" alt=\"\" class=\"wp-image-1361\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_19.png 806w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_19-300x216.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_19-768x552.png 768w\" sizes=\"auto, (max-width: 806px) 100vw, 806px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">It may be hard to locate all the formatting features as you build reports. The search bar comes in handy.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"289\" height=\"97\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_20.png\" alt=\"\" class=\"wp-image-1362\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">We can make the table and slicer more interactive by adding another bar chart showing the quantity ordered by each salesperson.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you click on any country in the slicer, the table and the bar chart display the salespeople\u2019s total amounts and quantity of products ordered. For example, here is a snapshot of Germany.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"743\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_21.png\" alt=\"\" class=\"wp-image-1363\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_21.png 924w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_21-300x241.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_21-768x618.png 768w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"trend-analysis-and-forecasting-using-power-bi-46d5e722-5db5-4eff-90ce-f8675afb2b0d\"><strong>Trend analysis and forecasting using Power BI<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Trend analysis and forecasting are applicable if your data has <strong>dates<\/strong> or <strong>time elements<\/strong>. Our data has order dates, months and years that we can use to forecast sales and show the sales trends.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Trendsand forecasts <strong>compare<\/strong> and <strong>predict<\/strong> future movements of metrics you want to analyze. These could be sales, trade volume, stock price, customer segmentation, etc.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-to-do-a-trend-analysis-per-year-0856993d-fdd6-4871-8e0c-b107e7b3674c\"><strong>How to do a trend analysis per year<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Select the line chart from the visualization panel.<\/li><li>Drag and drop the <strong>\u201cOrder date\u201d<\/strong> on the axis field and the <strong>\u201cSales\u201d<\/strong> on the values.<\/li><\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI automatically builds a <strong>date hierarchy<\/strong> of the order date by listing the year, quarter, month, and day.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"289\" height=\"200\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_22.png\" alt=\"\" class=\"wp-image-1364\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The line chart shows a sharp decline in sales from 2004 to 2005.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"445\" height=\"481\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_23.png\" alt=\"\" class=\"wp-image-1365\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_23.png 445w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_23-278x300.png 278w\" sizes=\"auto, (max-width: 445px) 100vw, 445px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use the <strong>\u201cpinch fork\u201d<\/strong> icon at the top to change the order dates, for example, by year or day.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"429\" height=\"43\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_24.png\" alt=\"\" class=\"wp-image-1366\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_24.png 429w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_24-300x30.png 300w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">For example, let\u2019s see the sales trend by year and quarter.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"439\" height=\"487\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_25.png\" alt=\"\" class=\"wp-image-1367\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_25.png 439w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_25-270x300.png 270w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use the <strong>drill-up<\/strong> and <strong>drill-down<\/strong> arrows to add and remove the order dates.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"379\" height=\"54\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_26.png\" alt=\"\" class=\"wp-image-1368\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_26.png 379w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_26-300x43.png 300w\" sizes=\"auto, (max-width: 379px) 100vw, 379px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how-to-forecast-a670c49a-04b4-4472-890f-303cd802a666\"><strong>How to forecast<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Your line chart must have a <strong>single series line<\/strong> like the line chart above to forecast. The Y-axis has to have a single field, not multiple.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To forecast,<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Click on the <strong>\u201cAnalytics\u201d<\/strong> icon.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"239\" height=\"62\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_27.png\" alt=\"\" class=\"wp-image-1369\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\" start=\"2\"><li>Go to <strong>\u201cForecast\u201d<\/strong>.<\/li><li>Click the <strong>\u201cAdd\u201d<\/strong> button to input the forecast length and duration type. Let\u2019s forecast the sales trend for the next six months.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"231\" height=\"139\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_28.png\" alt=\"\" class=\"wp-image-1370\"\/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\" start=\"4\"><li>Click on the drop-down arrow after the forecast length to specify the duration. For example, the period can be years, months, or days. Let\u2019s use <strong>months<\/strong> for our example.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"318\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_29.png\" alt=\"\" class=\"wp-image-1371\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_29.png 150w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_29-142x300.png 142w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Our sales chart now displays the forecast as highlighted in red below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"452\" height=\"477\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_30.png\" alt=\"\" class=\"wp-image-1372\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_30.png 452w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_30-284x300.png 284w\" sizes=\"auto, (max-width: 452px) 100vw, 452px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Caution when using Power BI\u2019s Forecasting features is that it\u2019s purely based on <strong>statistical techniques<\/strong> and may not be helpful for real-world business cases.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-save-and-publish-power-bi-dashboards-3f943803-2aa3-4eb5-b5e2-126564e6f8a1\"><strong>How to save and publish Power BI dashboards<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before saving our reports, we\u2019ll format the pages by adding titles and positioning the graphs well.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here\u2019s the final dashboard.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"548\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_31.png\" alt=\"\" class=\"wp-image-1373\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_31.png 924w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_31-300x178.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_31-768x455.png 768w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use the <strong>\u201cPublish\u201d<\/strong> option at the top-right to share your reports with others in Power BI\u2019s cloud service.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"131\" height=\"170\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_32.png\" alt=\"\" class=\"wp-image-1374\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You must have an online Power BI account that you log into using a business, student or work email, not a personal email.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Once you log in, your reports appear online. Here is the online view.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"924\" height=\"445\" src=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_33.png\" alt=\"\" class=\"wp-image-1375\" srcset=\"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_33.png 924w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_33-300x144.png 300w, https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI_33-768x370.png 768w\" sizes=\"auto, (max-width: 924px) 100vw, 924px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI has a two-tier system for data and reports management:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>As the account owner, you can interact and edit the reports anytime.<\/li><li>Consumers and other users can only view, read and interact with the dashboards.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-update-and-refresh-datasets-79fe94c1-ed63-4cae-8824-d92095414490\"><strong>How to update and refresh datasets<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Once in a while, you may need to update your datasets by adding new data, editing existing data, or changing data formatting. What happens to the reports you\u2019ve already published? With Power BI, you can refresh the data, and your pages will automatically become updated.<\/p>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Use the <strong>\u201cRefresh\u201d<\/strong> button to update your data. Power BI will then recalculate all the totals, measures, and formulas you used in your reports, and the new values will appear.<\/li><li>Click the <strong>\u201cPublish\u201d<\/strong> button to update already published reports.<\/li><li><strong>Save<\/strong> and <strong>replace<\/strong> the existing dataset.<\/li><li>Refresh your browser window to view the updated reports.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"pros-and-cons-of-power-bi-desktop-efbdadb0-14a3-485f-8000-1e256535acd6\"><strong>Pros and cons of Power BI Desktop<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Power BI is one among many business intelligence software. There are advantages and disadvantages when using any software. Here are a few for Power BI.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Pros<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Power BI Desktop is free to use. Its paid version (Power BI cloud service) is pocket-friendly. The monthly subscription starts at <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/pricing\/\">$ 9.99<\/a> per user.<\/li><li>It allows data connectivity from a wide range of data sources.&nbsp;<\/li><li>Power BI and Excel have integrated tools. For example, pivot tables, power query, slicers, tables, and charts. Anyone with basic Excel skills can figure out Power BI quickly.<\/li><li>Power BI has monthly updates that come with more efficient features. These frequent updates come from suggestions and recommendations from users.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Cons<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Power BI Desktop has limited data volume. To handle bigger datasets, you have to upgrade to the paid version.<\/li><li>You must have a work or student email to publish reports online. If you are self-employed or a freelancer, you can incur unforeseen costs of paying for a domain email name just to publish your work with Power BI.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"final-thoughts-on-data-analysis-and-visualisation-using-power-bi-desktop-2d8b68ae-b48a-4df1-ac8c-23869ff54963\"><strong>Final thoughts on data analysis and visualisation using Power BI Desktop<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Whether you\u2019re a data analyst or a business using business intelligence tools to retrieve and analyze data, Power BI allows you to interact with your data to create meaningful and visually appealing insights.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Related posts<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/resourcefulscholarshub.com\/how-to-use-tableau-public-for-data-visualisation\/\">Data Visualisation using Tableau Public<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/resourcefulscholarshub.com\/data-analysis-and-visualisation-using-microsoft-excel-for-windows\/\">Data Analysis and Visualisation using Microsoft Excel for Windows<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Power BI Desktop is a free version of Microsoft\u2019s Power BI software. It is available for download and local installation [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":1376,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","_monsterinsights_skip_tracking":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[17],"tags":[],"class_list":["post-1342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data"],"author_meta":{"display_name":"Grace Njeri-Otieno","author_link":"https:\/\/resourcefulscholarshub.com\/?author=3"},"featured_img":"https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI-300x200.png","uagb_featured_image_src":{"full":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI.png",924,616,false],"thumbnail":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI-150x150.png",150,150,true],"medium":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI-300x200.png",300,200,true],"medium_large":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI-768x512.png",768,512,true],"large":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI.png",924,616,false],"1536x1536":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI.png",924,616,false],"2048x2048":["https:\/\/resourcefulscholarshub.com\/wp-content\/uploads\/2022\/07\/Power-BI.png",924,616,false]},"uagb_author_info":{"display_name":"Grace Njeri-Otieno","author_link":"https:\/\/resourcefulscholarshub.com\/?author=3"},"uagb_comment_info":0,"uagb_excerpt":"Power BI Desktop is a free version of Microsoft\u2019s Power BI software. It is available for download and local installation [&hellip;]","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/resourcefulscholarshub.com\/?cat=17\" class=\"advgb-post-tax-term\">Data collection and analysis<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Data collection and analysis<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 4 years ago","modified":"Updated 4 years ago"},"absolute_dates":{"created":"Posted on July 26, 2022","modified":"Updated on July 26, 2022"},"absolute_dates_time":{"created":"Posted on July 26, 2022 12:58 pm","modified":"Updated on July 26, 2022 1:01 pm"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/posts\/1342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1342"}],"version-history":[{"count":2,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/posts\/1342\/revisions"}],"predecessor-version":[{"id":1378,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/posts\/1342\/revisions\/1378"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=\/wp\/v2\/media\/1376"}],"wp:attachment":[{"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/resourcefulscholarshub.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}