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 about New Series of Time Series: Power BI Custom Visual (Part 5)[…]

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 about New Series of Time Series: Power BI Custom Visual (Part 4)[…]

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 about New Series of Time Series: Part 3 (Holt’s Exponential Smoothing)[…]

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

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

New Series of Time Series: Part 1

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

Optimization Problem in Power BI using R scripts: Part 3

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

Optimization Problem in Power BI using R scripts: Part2

In the last post, I have explained the main concepts and usage of “Optimization” problems and “Linear Programming”. In this post, I am going to explain a simple example of solving an optimization problems from [1]. Imagin, we have a company that produce Product 1 and Product 2,  we want to maximize the profit of Read more about Optimization Problem in Power BI using R scripts: Part2[…]

Optimization Problem in Power BI using R scripts: Part1

There are some traditional problems in most of industries like how we can reach maximum profit, sales, production or how we can minimize our cost and loos. These types of problems can be seen in different areas such as microeconomic and company management, such as planning, production, transportation, technology . Although the modern management issues Read more about Optimization Problem in Power BI using R scripts: Part1[…]

Table with Embedded Chart in Power BI using R

Visualization is any kind of graphical representation that enable us to: Exploration, it help us to get more deep insight through huge amount of data Discovery, It also gives extra vision Analysis, it can be used to find pattern Communication, visualization help us to communicate better A few years ago Dr. Andrew Abela published a good Read more about Table with Embedded Chart in Power BI using R[…]

Online Book: Analytics with Power BI and R

About the book; Quick Intro from Author In 2016, after bringing the capability of writing R codes inside Power BI, I’ve been encouraged to publish an online book through a set of blog posts. The main reason to publish this book online, was that there is no integrated and comprehensive book on how to use Read more about Online Book: Analytics with Power BI and R[…]