I recently had a requirement to combine a set of approx. 100 CSV files into a single file and encountered an interesting problem along the way. The files all had the same simple structure which was 2 columns. I thought this would make a pretty straight forward exercise – until I started processing the files. I Read more about Taking a byte out of U-SQL[…]
In the last three parts, I have explained about the time series R custom Visual we have in Power BI. as you remember we have 3 main time series chart in Power BI store (see below): Decompose of time series (trend, seasonality and irregular components). the two other custom visual help us to do forecasting Read more about New Series of Time Series: Power BI Custom Visual (Part 7)[…]
I have written multiple blog posts so far about creating a date dimension. However, I still get the question about how to create a date dimension. In this series of blog posts I am going to explain in details how you can create a date dimension easily in Power BI (based on Power Query). this Read more about Create a Date Dimension in Power BI in 4 Steps – Step 1: Calendar Columns[…]
In the last post, I have explained how to do time series forecast using “Exponential Smoothing” approach in Power BI. I start to explain the main parameters that we need to set up. The main concepts behind of most of these parameters have been explained in previous posts (Post 4, Post 3, Post 2, and Read more about New Series of Time Series: Power BI Custom Visual (Part 6)[…]
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch Read more about Solving DAX Time Zone Issue in Power BI[…]
In previous posts, I have explained some basic concepts of time series. In the first post I have explained the basic concepts of time series, and in second and third posts I have explained: “Exponential Smoothing” for forecasting data without trend, and with the trend. In the last post, I have explained how we can Read more about New Series of Time Series: Power BI Custom Visual (Part 5)[…]
In this post, I am going to show how we can do time series inside Power BI using custom visual from Office store. First you need to download custom visual from office store, to download R custom visual please follow the below link https://store.office.com/en-001/appshome.aspx?ui=en-US&rs=en-001&ad=US&clickedfilter=OfficeProductFilter%3aPowerBI&productgroup=PowerBI now we are going to download some timeseries custom visuals Read more about New Series of Time Series: Power BI Custom Visual (Part 4)[…]
Using Merge in Power Query gives you the ability to join on a EQUAL join with one or more fields between two tables. However, in some situations you need to do the Merge Join not based on equality of values, based on other comparison options. One of the very common use cases is to Merge Read more about Dates Between Merge Join in Power Query[…]
The latest release of Power BI Desktop (August 2017) contains a pretty cool feature that was teased back in the keynote of the Microsoft Data Insights Summit which is the ability to add What If parameters to your data model. To add a What If parameter, just click New Parameter on the the Modeling tab which Read more about Power BI – What If parameters[…]
In the last posts, I have explained the main concepts behind the Timeseries (Post 1) and in the second one a simple forecasting approach name as “Exponential Smoothing” has been proposed Post 2. In this post I am going to show how to do see the error of forecasting and also how to forecast when Read more about New Series of Time Series: Part 3 (Holt’s Exponential Smoothing)[…]