Forum Replies Created

Viewing 15 posts - 16 through 30 (of 49 total)

  • RE: Using R to Identify Key Features Quickly

    evans911 (1/10/2017)


    I'm a DBA who has been exploring R. I have taken a class in R. This article helps to put R into practical use. Very cool....

  • RE: Using R to Identify Key Features Quickly

    tmagney (1/9/2017)


    Came to this article because of the subject line and hoping to learn more about what R is and how to use it. But with only a small snippet...

  • RE: Using R to Identify Key Features Quickly

    Glad you liked it. Thank you 🙂

    Nick

  • RE: Beyond prediction with R & SQL Server

    Hi Jonathan,

    Thanks for your question. The byRegion dataframe has 12 individual rows (one for each region / product pairing) with 36 columns (one column of sales info for every month)....

  • RE: Configuring R Services in SQL Server 2016

    G H G (2/1/2016)


    Nick, Great Post !! It is good to know that we have to allocate more memory to utilize R functionality in 2016.

    I am soooo...

  • RE: Configuring R Services in SQL Server 2016

    daniel.buskirk (1/27/2016)


    Thanks, Nick, for the informative article.

    I think that for jobs with small data loads, like analyzing SQL Server performance information, using good old-fashioned ODBC to bring the data into...

  • RE: Analysing Sales Patterns: R + SQL Server

    stephane.boinon (12/29/2015)


    hello nick

    Many thanks for this detailed feedback on my prior questions.

    Regarding Tableau integration with R language i was informed of what you've mentioned in your reply but regarding SSRS...

  • RE: Analysing Sales Patterns: R + SQL Server

    stephane.boinon (12/24/2015)


    hello nick and many thanks for this R tutorial

    I have some absolute R beginners questions: Are all graphs generated with RStudio ? if so could they be embedded in...

  • RE: Analysing Sales Patterns: R + SQL Server

    INCREDIBLEmouse (12/17/2015)


    I was able to immediately think of two use cases in my field of work, from your demonstrated market basket analysis, applied it, and found it to be quite...

  • RE: Analysing Sales Patterns: R + SQL Server

    yogmangela (12/17/2015)


    Thanks Nick,

    This is great,

    I had a question: Is it possible to extract Windows-log from event log and visualize some short of graph. (i.e login/ logoff time, Domain, LogonID etc)

    Hi...

  • RE: Analysing Sales Patterns: R + SQL Server

    yogmangela (12/16/2015)


    Thanks Nick,

    I have another Error:

    > by_region_filter <- with(majorSalesData, table(SalesTerritoryRegion, ProductKey))

    > results_filter <- CA(by_region_filter, graph=FALSE)

    Error in data.frame(value, row.names = rn, check.names = FALSE, check.rows = FALSE) :

    row...

  • RE: Analysing Sales Patterns: R + SQL Server

    Kyrilluk (12/16/2015)


    nick.dale.burns (12/15/2015)


    chris.smith 3432 (12/15/2015)


    Hi Nick,

    1. Embedding R in a stored procedure seems to be really useful when there is limited (i.e. no) required interaction. For...

  • RE: Analysing Sales Patterns: R + SQL Server

    bteague (12/15/2015)


    Yeah. I guess the question is if you have cubes but haven't invested the time in learning the requirements to implement or constraints/limitations of the SSAS data mining models,...

  • RE: Analysing Sales Patterns: R + SQL Server

    yogmangela (12/15/2015)


    have you created ODBC connection form Data Source ?

    Hi Yogs,

    Yes, I have and existing ODBC connection named "RSQLAnalytics2016" which I use to connect. Hope that answers your question?

    Cheers,

    Nick

  • RE: Analysing Sales Patterns: R + SQL Server

    bteague (12/15/2015)


    Great article and timely as I am currently in the process of explaining the power of R relative to what is currently in the MSBI stack. I might add...

Viewing 15 posts - 16 through 30 (of 49 total)