We can now create a slicer with the Country Codes table. Rename the columns to Country and Code, and rename the query to Country Codes. Select the first two columns in Choose Columns window, and click OK. You will see a preview of that table on the right. In the Navigator window click on the third table which is marked in red below. The From Web window will appear. Paste the URL address in the text box URL, and click OK.Ĭlick Connect in Access Web Content window. Now, open Power BI Desktop (Please use the latest version), click the Get Data drop down menu in Home tab, and then click Web. We will start with the this website on wikipedia. So we will want to load to our dashboard a table of country codes and their equivalent names. While Power BI can associate the country codes to the relevant countries on the map, for us, mere mortals, it is sometimes easier to see the country by its real name. In this tutorial we will get country codes from Facebook. In our case: Power BI, Tableau & Qlikĭynamic Country Codes & the Countries Slicer Combine insights from multiple brands.Transform the query into a function that can load any brand from Facebook.Import Facebook Insights from Power BI page. Load dynamic country codes (You will see why we need it later).Here are the main elements we will focus on this tutorial: To download the actual Power BI Desktop file click here. To gain more from your Power BI and better analyze your brand, we will tap into Facebook pages’ insight information, and create a dashboard that compares between different brands. While the official tutorial showed you the basics, it didn’t drill down into Facebook page insights, which hold additional crucial data for marketers. Recently, the Power BI team have published a tutorial that analyzes pages on Facebook. As promised here, today I will walk you through the creation of a powerful brand analysis dashboard with Power BI Desktop which connects to Facebook page insights data.īefore we start, you can see the result here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |