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

Posted on August 16, 2017 by Leila Etaati

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)[…]

Power BI – What If parameters

Posted on August 11, 2017August 12, 2017 by Philip Seamark

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[…]

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

Posted on August 7, 2017 by Leila Etaati

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)[…]

New Series of Time Series: Part 2 (Exponential Smoothing)

Posted on August 3, 2017August 3, 2017 by Leila Etaati

In the last post , I have explained the main concepts behind the timeseries. In this post, I am going to show how we can forecast for some periods. In the last post, I have mentioned that there is a possibility to have “seasonality” “Trend” and errors (residual) in one dataset: Seasonality+Trend+Residual we call it as Read more about New Series of Time Series: Part 2 (Exponential Smoothing)[…]

Infographic Designer: Not Just Another Visual

Posted on August 2, 2017 by Reza Rad

At the time of writing this post; there are already more than 97 custom visuals posted in Office Store. The list includes many interesting custom visuals. However, Infographic Designer is one of the visuals that is not just another visual. This custom visual has some unique features that you cannot see in many other visuals. Read more about Infographic Designer: Not Just Another Visual[…]

New Series of Time Series: Part 1

Posted on July 31, 2017August 3, 2017 by Leila Etaati

In this new series I am going to look at the time series models and how we able to use them for forecasting data. The first need in timeseries data is to have a series of data for years or for some qurdant. imagin that we have a time series data on birth rate from Read more about New Series of Time Series: Part 1[…]

Measure table madness

Posted on July 27, 2017September 4, 2017 by Philip Seamark

Measure tables in Power BI models are a fantastic way to group your calculated measures together in one place and make for a tidy model. Unlike calculated columns, a calculated measure can be placed on any table so long as the best practice of using the table name for every column reference. Power BI desktop Read more about Measure table madness[…]

Power BI Custom Connector: Connect to Any Data Sources. Hello World!

Posted on July 27, 2017 by Reza Rad

One of the recent features in Power BI Desktop is the ability to create your own custom connector and use it when connecting to the data source. This feature looks just one feature, but it opens doors to many possibilities. With this feature you can write your own custom connector to any types of data Read more about Power BI Custom Connector: Connect to Any Data Sources. Hello World![…]

Choose the Right Merge Join Type in Power BI

Posted on July 26, 2017December 2, 2021 by Reza Rad

Previously I have written a blog post explaining two ways of combining data sets with each other; Append vs Merge. In this post I want to explain in details what is the difference between all types of Merge Type and explaining how to choose the right merge (or Join) type. These Merge types are very Read more about Choose the Right Merge Join Type in Power BI[…]

Optimization Problem in Power BI using R scripts: Part 3

Posted on July 25, 2017July 25, 2017 by Leila Etaati

As I have discussed before, R is not only for doing Machine Learning (despite it is a really good tools for it), it also can be used for helping managers to so decision support. In the last two posts (Post 1 and 2), I have explained the main concepts behind the optimization problems. Also, how Read more about Optimization Problem in Power BI using R scripts: Part 3[…]