Part 3 – Power Query API – Table as Parameter for a Query Indeed!

This the third part in the Indeed! Series and we will cover how to parameterize a query with Power Query from a table in Excel. In Part 2 we setup our Indeed API calls to gather some basic parameterized data with Power Query. It’s nice that we can enter anything; but do we really want to manually enter information each time to change the query? Probably not. The file from Part 2 can be downloaded here. Hopefully you have had a chance to go over to Faisal Mohamood’s blog and read up on parameterizing a Yelp query or for a crazy parameterization in Power Query you can check out Devin Knight’s blog post. Continue reading

Part 2 – Power Query API – Parameterized Data Indeed!

This the second part in the Indeed! Series and we will cover how to parameterize a query in Power Query. In part 1 we setup our Indeed API calls to gather some basic data with Power Query. The file from Part 1 can be downloaded here. This probably didn’t help a whole lot of people out unfortunately; unless you are a software engineer in Austin, TX. Hopefully you have had a chance to go over to Faisal Mohamood’s blog and read up on parameterizing a Yelp query or for a crazy parameterization in Power Query you can check out Devin Knight’s blog post. Continue reading

Part 1 – Power Query Basics – Indeed!

While I am eagerly awaiting the preview for Power BI; I need to have something to test out in this online offering once it’s available. So in my first installment on Power Query, Power Pivot, Power View and Power Map I wanted to create an example that would truly be BI for everyone. Job search and employment opportunities came to mind. I started poking around for accessible API’s only to discover Indeed
offered one that could be hooked into with Power Query; now we are off to the races. In this post I just want to cover the basics of Power Query; importing data, splitting columns and getting data from an API. It’s a good idea to have an overall plan though; what does this running example need to be eventually be? Continue reading

I am Blog Summary (And NO You Can’t)

Blog summaries are fairly standard across the web. A paragraph with three periods and people can click the link or title to get to the full blog post is, for the most part, the norm in my experience looking at other people’s blogs. So how do you do it in the Office 365 public site blogging app? The short answer is you don’t without custom JSLink files or some major editing; I’ll be submitting another ticket listing this as a bug and updating this post with the responses. So here is my adventure in blog summary attempts… Continue reading

Power BI News Roundup

Awesome update on Power BI with a lot of links!

Chris Webb's BI Blog

This is just a quick post to summarise the Power BI-related information that has come to light over the last few weeks; this is all stuff that has been tweeted extensively (follow me!), but I know not everyone spends their life on Twitter so here you go:

View original post 91 more words

I Am Blog (And So Can You!)

Update 08/27/2013:

After trying to get the blog summary configuration in place in SharePoint and doing some feature discovery; I’ve decided to move on over to WordPress. WordPress seems more in line with Blogging; this first go around on SharePoint 2013 on the public side was disappointing. The internal site I still love with the rich feature set and sub-site spawning I could really see using it as a consultant to track documentation, deliverables and everything under the sun. Continue reading