Have more Charts by writing R codes inside Power BI: Part 2

In the previous post (Part 1) I have explained how to write a simple scatter chart in the Power BI. Now in this post I am going to show how to present 5 different values in just one chart via writing R scripts. I will continue the codes that I wrote in the previous post  as below : ...

Read More

Have more Charts by writing R codes inside Power BI: Part 1

Power BI recently able users to embedded the R graphs in Power BI. There are some R visuals that it would be very nice to have them in Power BI. What is R ? Based on Wikipedia,  R is an open source programming language and software environment for statistical computing and graphics that is supported ...

Read More

Prediction via KNN (K Nearest Neighbours) KNN Power BI: Part 3

K Nearest Neighbour (KNN ) is one of those algorithms that are very easy to understand and it has a good level of accuracy in practice. In Part One of this series, I have explained the KNN concepts. In Part 2 I have explained the R code for KNN, how to write R code and how ...

Read More

Script Component as Source – SSIS

Posted by on Jan 29, 2011 in Scripting, SSIS | No Comments

There are many situations which you can use power of scripting in SSIS data flow. Today I encounter a situation here , there is source flat file here with header and trailer records which have different structure from data rows. Data rows delimited by vertical line ( | ) , but header and trailer not. ...

Read More

Retrieve Part of XML File

Posted by on Jan 24, 2011 in Scripting | No Comments

Today I faced a question on changing style of an xml file and fetch desired result as another xml file,  The XML file has lots of un-necessary tags which should be removed , I tried to do this with C#.NET code. This is the input xml: <?xml version="1.0" encoding="utf-16"?><DataTable>  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">    <xs:element ...

Read More

How to use Script Component as Asynchronous Transformation

Posted by on Apr 16, 2010 in Scripting, SSIS | No Comments

Suppose you have a flat file which is not delimited or fixed width or Ragged right. the structure of data is not well formed for Flat File Connection manager to read,  This is an example of data file: date                     : 04/14/2010customer name        : John doeaddress                  : 2014 apple st. Chicago, IT 30000sale order        ...

Read More