Pick any electronic book for just 5$. Packt has also created their very first Year in Review – https://www.packtpub.com/packt/five-dollar-skillup/report It will guide you through the biggest topics to come out of 2015 and show you what’s going to be defining 2016 and beyond. Merry learning and happy new year!
One of the most fascinating aspect of Business Intelligence is the power to picture data in an easy to understand way. I personally like maps a lot, not the google or bing type with lots of circular points which give very low added value to the information, but the Choropleth maps. Those shaped areas withRead More
EDIT 2016-07-12: Microsoft has changed their API and policies and functionality, so this article is obsolete now. I will shut down the sample site. For details, please see: https://powerbi.microsoft.com/en-us/blog/what-s-new-and-what-s-next-for-power-bi-embedded-july-2016/ Code re-usability is at the core of programming best practices and Business Intelligence is no exception. None wants to code multiple times just to refactor thousands of linesRead More
EDIT 2016-07-12: Microsoft has changed their API and policies and functionality, so this artcile is obsolete now. I will shut down the sample site. For details, please see: https://powerbi.microsoft.com/en-us/blog/what-s-new-and-what-s-next-for-power-bi-embedded-july-2016/ Creating dashboards is more witchcraft than art and more art than science. Think about how many times you have banged your head to produce a useful chartRead More
According to this post on the official Power BI blog it is now possible to bring your Excel file into a Power BI dataset as a whole (not only importing data); and use portions of it as tiles on your dashboard. Wow: you can (re)use your carefully crafted charts and amazingly engineered pivot tables in a web-shareableRead More
One of the things I like the most about Power BI is the ability to use custom visuals. I did not try building one myself and honestly I think it’s beyond my skills, yet there is a gallery with a growing number of pre-build viz that you can download and use. Go to https://app.powerbi.com/visuals?WT.mc_id=Blog_Visuals andRead More
Doing a very simple math: assuming a 30 days month, at 100DWU we will receive a $504 (USD) bill for computing + $62.5 (USD) for 1TB of data, a total $566.5* for a fully functioning SQL Data Warehouse. On the other end of the spectrum, 2000DWU for 1 month would be $10,080(USD)*.
The Lahman database is one of the most (if not the most) complete free sports dataset
How to use alpha opacity in MicroStrategy dashboards
Tom, Bill and Sandra have one euro each; they go and buy some fruits. Tom buys 3 apples for 1€. Bill buys 2 oranges for 1€ and Sandra buys a coconut for 1€. Tom says “apples cost 0,33 euro cents on average”. Bill “oranges are 0,50 euro cents on average” Sandra “coconuts are 1 euro onRead More