Creating a Table in Power BI Using DAX Table Constructor

There are some functions in DAX that are useful in very specific scenarios. For example, sometimes, you might want to create a table entirely in DAX. If you want to do that, what are your ways and how it is possible? This might be helpful especially in the first days of learning about DAX. Let’s Read more about Creating a Table in Power BI Using DAX Table Constructor[…]

Interactive Charts using R and Power BI: Create Custom Visual Part 2

In the last posts, I have explained the main process of creating R custom visuals. In this post I am going to show how to: 1- Have more custom visuals 2- Different charts that we can have in Power BI 3- Explain some issues Have more custom visuals to have more R visuals, it is Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 2[…]

Interactive Charts using R and Power BI: Create Custom Visual Part 1

I am so excited about using Plotly packages in Power BI. So What is Plotly: is an R package for creating interactive web-based graphs via the open source JavaScript graphing library: https://plot.ly/r/getting-started/ this feature has been added recently and had been announce by Christian Christian Berg in Data insight summit 2017. I started to search about Read more about Interactive Charts using R and Power BI: Create Custom Visual Part 1[…]

Azure Machine Learning Part 2: Azure ML Environment

In the previous post, the main concepts of Machine Learning has been explained very briefly. However, if we want to talk about Machine Learning, it needs to read a whole book. In the second part, I am going to show the main Azure ML environment and its essential components. Azure ML has two type of Read more about Azure Machine Learning Part 2: Azure ML Environment[…]

Export Data Starting From Special Cell in Excell File – SSIS

Sometimes you have a formated Excel file, which you want to use this file as Destination, so you may need to import data start from special Cell inside the excel file.By default SSIS import data from Column1 and Row1 in excel file. But you can change it. Solution: Suppose this excel format: in this sample Read more about Export Data Starting From Special Cell in Excell File – SSIS[…]

Excel to SQL Server, Dynamic Data Flow

You need to import data from excel file to sql server table, you can do this with a simple import wizard or simple data flow task in SSIS. But there are lots of times which you want to do this data transfer dynamically. Suppose these scenarios: 1- you have many excel files with same structure Read more about Excel to SQL Server, Dynamic Data Flow[…]