Taking a byte out of U-SQL

Posted by on Aug 31, 2017 in Azure Data Lake | No Comments

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

New Series of Time Series: Power BI Custom Visual (Part 7)

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

New Series of Time Series: Power BI Custom Visual (Part 6)

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

New Series of Time Series: Power BI Custom Visual (Part 5)

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

New Series of Time Series: Power BI Custom Visual (Part 4)

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

Power BI – What If parameters

Posted by on Aug 11, 2017 in DAX, Power BI | 3 Comments

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

New Series of Time Series: Part 3 (Holt’s Exponential Smoothing)

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