How to get and view WordPress Statistics in Power BI

Soheil Bakhshi from http://biinsight.com has a super good article on how to get your stats from a WordPress site/blog and analyze them in Power BI.

For lazy guys out there, he already built a Power BI template file that you can use straight away. The only thing you’ll need is WordPress API key but don’t worry, he explains how to get that one too!

Check it out: http://biinsight.com/analyse-your-wordpress-blog-stats-in-power-bi/.

How to use Word for Blog publishing

  1. Start your Office Word application. It works with any version starting with Word 2007.
  2. While you’re in the new template selection view, search for “blog” in the “Search for online templates” field.

  1. Blog post” template should be listed. Click it and then select Create button.

  2. On first run only, you’ll be asked to register your blog in Word. You can click Register Now and walk through this process or you can click Register Later and do it later by using Manage Accounts from Blog command group.

  3. If you clicked Register Now, you’ll be asked to select your blog provider. You see that this list does not include all possible blogging platforms, that’s kind of normal I’d say…, but you have the Other option and you then can add any blog details as long as you know the link to provider’s API.

    I selected WordPress because this is what I have.

  4. Next screen will ask for your blog’s URL. And, this is different from platform to platform but, for WordPress you need to provide the link to your xmlrpc.php file. It is usually in your root folder of your site but if it is in another folder, make sure to add the correct path.

    For default location, just paste your site’s address between the backslashes, thus replacing <Enter your blog URL here> with your blog’s URL.

    Add your username and password. Optionally, select Remember Password if you’re the only one who’s using your Windows account. If there are more people using same Windows account, to prevent others posting funny things to your blog, leave this option unchecked.

    Under Picture Options, you can select where your post’s pictures will be uploaded to. For simplicity, keep it as My blog provider.

  5. Once you have all fields completed, hit OK.

  6. If everything was done correctly and Word could connect to your blog, you’ll be presented with a nice confirmation message.
  7. Next, you’ll have your Word template changed to Blog. Notice Blog command group. It contains all your basic needs for creating and publishing blog posts. One thing is missing though, ability to add Tags.

    If you have a more complex blog, photography maybe or e-commerce, or if you use Featured Images or you need to add Location to your posts, probably Word is not that much suitable to you.

  8. From Insert tab, you have access to add a lot of items to your post, like images, shapes, tables etc.. As an example, below picture has Rounded Corners style added.

Below is a shape added from Word, it will be posted as a picture:

 

Just in case something went wrong and you have issues connecting to your blog or uploading images, please take a look at Microsoft’s article about this, scroll down to the bottom for troubleshoot problems.