Latest Power BI and AI articles from RADACAD team
Power BI files can easily get big. You can have 50 tables in a Power BI model, and 25 reports. When Power BI file gets in that size, maintenance is always an issue. It will take lots of time to find out if all of those 50 tables actually used in reports and visualization or not. Read more about Power BI Cleanup Tool; Time Saving with Power BI Helper[…]
In this post, I am going to share my experiment in how to do file management in ADLS using with R studio environment, So how it works? we able to manage ADLS from Rstudio environment using R scripts, so without accessing the ADLS we able to manage the portal, bring Data from ADLS to R Read more about File Managment in Azure Data Lake Store(ADLS) using R Studio[…]
Power BI World Tour in San Francisco ran on 4th and 5th of October in Bay Area (Microsoft Sunnyvale). As a speaker, it is always a great opportunity for me and Leila to speak in such events and meet new people in the community. In San Francisco world tour, Leila and I presented 4 topics Read more about Download Slides of Presentations in Power BI World Tour San Francisco[…]
From 2016 we able to do machine learning inside the SQL Server 2016 and 2017. In these post series, I am going to show some tips and trips for that. such as set up R services in SQL Server 2016, how to be sure we able to do that, and also how we can see Read more about R in SQL Server – write R Scripts- Part 1[…]
In the last post, I have explained the d value for model ARIMA (p,d,q). In this post, I am going to show how to identify the p and q values as below. one of the main difference between exponential smoothing and Arima is that Arima considers the correlation of a value at a time with Read more about Time series Series with Power BI- Arima Model-Part 11[…]
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[…]