I was interested in generating some dummy data to do some load testing in MS Azure and came up with a pretty nifty way to generate lots and lots of data using U-SQL. The tip is to simply create a small U-SQL custom generator and use it to extract from a dummy file. First I Read more about How to generate 1 billion rows using U-SQL[…]
Earlier this month (September 2017), in the new version of Power BI Desktop, a new type of chart announced; Ribbon Chart. The very first look and feel of this chart are similar to Stacked Column Chart. The question that might come into your mind is that; why another way of showing the same thing? The Read more about Ribbon Chart is the Next Generation of Stacked Column Chart[…]
In this post, I want to explain the ARIM model (Autoregressive Integrated Moving Average). Exponential smoothing could not consider the relationship between the values in the different time span. while ARIMA able to handle these data. ARIMA Model needs three variables. ARIMA(p,d,q) First, let start with explanation of d value what is d? The first Read more about Time series Series with Power BI- Arima Model-Part 10[…]
A couple of months ago, I’ve written a blog post about Basics of M and explained few basics about this language. In this post, I’m going to the next step and will explain few other structure definitions in this language. In this post, you will learn about Tables, Records, Lists, and how to navigate through Read more about Basics of Value Structures in M – Power Query Formula Language[…]
In the last posts, I have explained about some main concepts of Time series. How to decompose time series that has irregular, trend and seasonality components have been explained in: seasonality component decompose). now image we have a dataset that does not have any seasonality also does not show a clear trend. This data is Read more about Power BI and R- Timeseries series Part 9- Decompose None seasonal Data[…]
In this post I am going to show how to create a polar chart using R codes inside Power BI. imagin that we have below dataset about 4 main groups and their related values. I am going to show you how to draw different polar charts with different shapes. imagin that we have a bar Read more about How to create Polar Charts[…]
A recent post to the Power BI community desktop forums asked if it might be possible to allow a user to make a slicer selection that dynamically updates the x-axis. The idea would be to present the end user with a slicer on the report page with options of Year, Quarter, Month and Day and when Read more about Dynamic X axis on charts – Power BI[…]
In last two steps you learned how you can create a date dimension that has calendar columns, and fiscal columns. In this step we are going to look at how Power Query can be leveraged to fetch public holidays live from APIs, and add that information into the date dimension. This step shows the importance Read more about Create a Date Dimension in Power BI in 4 Steps – Step 3: Public Holidays[…]
In step 1 of creating date dimension I explained how to create the base query with calendar columns. In this post I will explain how to add fiscal columns calculated in the date dimension. Many of business reports generates on fiscal year, fiscal quarter, and fiscal period, so having fiscal columns is important part of Read more about Create a Date Dimension in Power BI in 4 Steps – Step 2: Fiscal Columns[…]
Slope chart can be used for comparing data between two different time periods. it is a very easy way to depict the difference between to time, two elements or any other two attributes. The slope charts can be used to study the correlation between variables or to study the change in the same variable between Read more about Draw Slope Chart in Power BI: Part 8[…]