Do you love the forecasting feature of Power BI's line charts but wish you could have more control of formatting? Need to break your forecast down by products and customers? I got you covered. In my latest video, I walk you through the DAX calculation for Time Series Forecast. In this video, you'll learn how to: Implement time series analysis using DAX in Power BI. Create a forecast measures from scratch. Break down data into trend and seasonality components for more detailed insights. #PowerBI #DAX #TimeSeriesAnalysis #DataAnalytics #Forecasting #BusinessIntelligence #obviEnce
Tag: Data Vizualization
Inforiver – The Best Custom Visual in Power BI?
This might be the first (and possibly only) time in a very long while that I got really excited about a custom visual for Power BI. Yes, I use custom visuals every now and then, but generally speaking I would have to admit that I am not a fan. Most of them do a good … Continue reading Inforiver – The Best Custom Visual in Power BI?
Taking another look at ALL() and ALLSELECTED() Functions
I have a video that takes another look at All() and AllSelected() functions. I start by talking about the flow of filters in the model. The direction of the arrow in the relationship between Fact and Dimension matters. With this background, I talk about using All() and AllSelected() function on Dimension table and compare it … Continue reading Taking another look at ALL() and ALLSELECTED() Functions
What is Power BI?
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?
How to Use Pictures in Your Power BI Power View Dashboards
If you used pictures in your Power View dashboards and tried to deploy these dashboards in your Power BI tenant you are likely to have seen the following warning message: "UNSUPPORTED FEATURES External pictures can't be displayed in Power View Sheets in Office 365". My guess it's only a matter of time when external pictures … Continue reading How to Use Pictures in Your Power BI Power View Dashboards
New Features of Power BI Demoed at WPC 14
(Image twitted by Naomi Moneypenny here) Some of the new features that we have been waiting for a long time have been demoed on the Day 1 of WPC 2014 in Washington DC. Although the demo was very brief, we were able to see new types of visualizations such as heat/tree maps, gauges, funnels, etc. … Continue reading New Features of Power BI Demoed at WPC 14
HTML5 Engine for PowerView Getting More Updates
I am very excited to report that as of few days ago, the HTML5 engine for Power View has closed some major gaps with the Silverlight Power View engine. In February of this year I wrote a post comparing various Power View artifacts between Silverlight, HTML5 and Power BI Windows 8 App. At the time, … Continue reading HTML5 Engine for PowerView Getting More Updates
HTML5 and Anonymous access in Power BI… or check out the new Demo Gallery
I don't expect that anyone will be blown away, at least initially, with the new demo gallery now available on the Microsoft Power BI site because to a business user, the content of those demos will look a little difficult to relate to if not a little nonsensical. Zany layouts aside, there is, however, a … Continue reading HTML5 and Anonymous access in Power BI… or check out the new Demo Gallery
HTML5 support In Power View and Power BI
Now that Power BI is Generally Available (GA) I thought it would be useful to do a quick analysis of how Power View visualizations are supported in Power BI across the three media – Silverlight (default), HTML5 and Windows 8 App Please find a table below for a quick reference Feature Silverlight HTML5 Windows 8 … Continue reading HTML5 support In Power View and Power BI
Microsoft self-service BI on premise vs cloud
It appears that Satya Nadella has added an additional layer of context to the already ambitious Microsoft strategy of transforming itself into a "devices and services" company by declaring that "Going forward, it's a mobile-first, cloud-first world". I believe that it is safe to assume that in the near future, the roadmap of every Microsoft … Continue reading Microsoft self-service BI on premise vs cloud
business intelligist 