Sad to see Denny Cherry won’t be at SQL in the City but, still a worthwhile event if your in Los Angeles around the 9th!
Microsoft is really ramping up the press and documentation on Power BI. I’m hopeful I’ll get to play around with the preview really soon!
Some NYSE stock info and Power BI; enjoy all! I’m hoping this gets us closer to the preview. webinar the 17th release?
My favorite part of the article:
“We also have a lot of experience with eventual consistency systems at Google,” they write in the paper. “In all such systems, we find developers spend a significant fraction of their time building extremely complex and error-prone mechanisms to cope with eventual consistency and handle data that may be out of date.”
So severe a penalty do these systems impose on developers that Google called it an “unacceptable burden”. For this reason, F1 offers full transactional consistency across snapshot transactions, pessimistic transactions for holding locks in place across distributed checks, and optimistic transactions for writing globally without needing to check certain states locally.
Time to dive into the actual F1 whitepaper!
After a number of hours spent experimenting and searching I’ve fallen a little short on this post ladies and gents! I was looking a simple way for the non-programming public to refresh data in an excel sheet on a regular basis. In an Ideal world I would have liked to be able to give the Indeed! Excel file to anyone and say follow these steps to accumulate data for a job search. Alas; the simplicity I was looking for I could not find. So what I will cover in this post is the least technical way I could come up with to refresh a Power Query worksheet. Then I’ll go over how I imagine most reports or data marts will access Power Query’s accumulating data. As always the files we have been working with can be downloaded here. Continue reading
Self-service BI with the familiarity of Office and the power of the Cloud
Get complete self-service BI for your on-premises and cloud-based data by using the new data discovery and analysis features in Excel with the collaboration capabilities in the new Power BI for Office 365 online service.
Power BI for Office 365 provides everyone with powerful new ways to work with data in Excel and Office 365. Easily search, discover, and access data within and outside your organization and, with just a few clicks, shape and transform data. Analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device.
This is the fourth part of the Indeed! Series and for me at least the most exciting part of the series! Executing parameterized queries to an API is great; but as someone who works in Business Intelligence I know that accumulating data and the insights garnered from evaluating data over time are invaluable. In Part 4 we will be merging the two concepts presented on Chris Webb’s Blog and Faisal Mohamood’s (or Devin Knight’s Blog if you prefer). All the workbooks for this series can be downloaded here.
A new video is out from Microsoft about the Power BI Admin Center; it’s only 7.5 minutes give it a look!
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