Hi, now I want to show you how easy make good and neat and super good looking chart with easy efforts with MS Excel 2013 with additional Power View and Power Query.
Open MS Excel 2013 Desktop version.
To activated Power View and Power Query go to Option in excel backstage view
Choose Add-Ins then choose COM Add-ins.
Select all add-ins that you want to show in excel menus.
For Power Map and Power Query please download to this URLs:
Power Map (a new 3D visualization add-in for Excel for mapping, exploring, and interacting with geographical and temporal data, enabling people to discover and share new insights)
Then go to page that give public data such as, exchange data, weather information, etc. Search home page that show the data to the table, it will be easy to power query to extract that information.
For this example, I have good site in bmkg.go.id that show the current weather daily with one simple URL.
Put the URL to the “Power Query” Ribbon, and choose “From Web”.
After that it will load the data from particular URL. There are two result, Table 0 and Document. You can preview by mouse over to the result label.
Choose the correct table that you want, in this example I choose Table 0.
Then Edit Table 0
Now you’re in Query Editor, you can manipulate the column and even you can filter the value that you want as final result.
In this example, I want to split Suhu (Remperature) Column to two new Column, Choose Split Column and Choose By Delimiter.
That fill the text below with “ – ” with space, to split the Suhu Column.
Repeat the process for the next column if necessary. In this example I also split Kelembaban (humidity) column. Then save and load it.
Now we have final result, the raw data automatically created to the new sheet.
And then colorize your data! In Insert ribbon choose Power View.
Power View now is opening.
After that new sheet created and now you can customize your chart looks.
Click the table and Go to Design Choose Line Chart. Viola! Just few click your table now presented.
Experience with another style, then you can show your data like this (Design ribbon then Map).
To upload your beautiful chart to the O365, make sure you have been subscribed Power BI. Go to portal office 365 then you can try Power BI for Office 365 for free for 30 Days.
After power bi site created, just simply drag and drop the excel file.
Now your Excel file has been uploaded.
And you can show your beautiful chart online! Make sure your Silverlight has been updated.
You also can show Excel with html5 format by click the icon in right corner bellow.
Now your power BI render in HTML5 Mode.