Technical articles, content and resources for IT Professionals working in Microsoft technologies

Hmm, how can this happen, my last post is more than 12 months old … During this period some things have changed – it seems mostly to the better, and some things are still the same, I…

The MRAN website offers info about R and its packages as well as archives of past R package versions and downloads of Microsoft R Open.

Do you want to detect outliers in your data? Want a predictive way to complete missing values in your data, or do you want to perform other advanced analytics scenarios as part of data cleansing? Implementing advanced analytics data cleansing scenarios in Power BI is now easier than ever! Learn more about adding R steps in Power Query as part of the Power BI Desktop July Update.

Missed the introduction to this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Having interviewed and worked with hundreds of business analysts and P&L owners, I am impressed by the capacity of human intuition. People who have been in role for more ...

In the September 2016 update of the Power BI Desktop, the Power BI team took the first step toward providing Power BI users with the possibility to add forecasting to charts. Forecasting, a fundamental component of data mining, is one of the first steps towards providing artificial intelligence to u...

Missed the introduction to this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Reviewing individual business units and benchmarking them against one another is an important process to verify that investment levels are still appropriate. Working as a...

Missed the previous parts of this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Forecasting is an important part of most management positions. Knowing how many products will sell where and when, informs resource decisions like staffing and inventor...

Description Forecasting is used to predict next points in time series data sets. The prediction in this example is based on trend and seasonality.     Prerequisites (The sample .pbix files will not work without these prerequites completed) 1. Install R Engine Power BI Desktop does not include, deplo...

In the last few months we have added a lot of R capability to Power BI, with advanced analytics visualizations with R, data cleansing with R, and ways to get data with R. Customers and partners have told us about some amazing use cases that leverage these capabilities and add unique value. In order to demonstrate these use cases, we have created the Power BI Community R Showcase.

Today we are excited to announce that the Power BI service supports reports and dashboards with R visuals. This update extends Power BI service visuals with endless flexibility, and adds advanced analytics depth.

An in-depth guide to integrating your R scripts with Microsoft's PowerBI software to create eye-popping visualizations for your data.

Microsoft’s Power BI team has put together a tutorial on a proposed approach for visualizing the output of an Azure Machine Learning model inside Power BI. A blog post invites users to “imagine if you could have Power BI regularly bring in the latest output of your fraud model or the sentiment for recent Tweets...

Nate Silver to headline Microsoft Data Insights Summit http://blogs.msdn.com/b/powerbi/archive/2016/01/11/nate-silver-to-headline-microsoft-data-insights-summit.aspx

Power BI and R – Part 1 (Intro) http://blog.janmulkens.be/power-bi-and-r-part-1-intro/

Use R to export data from Power BI (and Power Query) http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/

I have to admit that I couldn’t resist to “recycle” my example from here to create the same (almost the same) Data Visualization in combination with Power BI. You can find the Pow…

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle…

Applying data science to business and financial analysis

Learn the skills you need to help land the career you want!

Mark V SQL - Mark Vaillancourt: Data Nerd