Machine Learning

A Success Story Using Auto ML in Power BI Premium

Azure Machine Learning and Power BI are two of the most influential tools out there. I’d like to share a story about how a colleague and I recently completed a project for a public school district in Georgia using these powerful tools.

The purpose of this project was to integrate machine learning and predictive analytics to be able to feed inputs that existed in their data about students such as classes they’d taken, attendance, grades, etc. and use this information to predict the likelihood of high school graduation. The district could then use this to proactively guide students and give them the help they needed.

We used the Auto ML feature in Power BI Premium. My colleague, Brian Custer, oversaw the machine learning model design. Auto ML is a straightforward process in Power BI. All that was needed was to create data using the information we wanted to look at that may have an impact on graduation and then we put this through a wizard in Auto ML. Once we did that, out came a model that was trained and ready to go for prediction.

Machine learning models exist in several different forms and leverage the capabilities that are built into Azure – we have Azure Machine Learning, Python and R, integrations with SQL Server, as well as Auto ML and other features within Power BI.

So, what exactly is Auto ML in Power BI? It’s a wizard driven machine learning interface that works off dataflows. You start off with a dataflow and you must have your training and prediction entities in your dataflow. This is passed to an Auto ML model that you choose and then it automatically trains the model for you and delivers predictions.

This is a very simple pipeline to set up. In our case we simply hooked up to the data that was in Azure Data Lake Gen2 storage and brought it into some SQL tables.

The school district we created this for couldn’t have been happier with the results and they are currently using this machine learning model to help predict the probability of high school graduation and ensure that students in the path of not graduating get the help they need to succeed.

Need further help? Our expert team and solution offerings can help your business with any Azure product or service, including Managed Services offerings. Contact us at 888-8AZURE or  [email protected].

Paul TurleyA Success Story Using Auto ML in Power BI Premium
Read More

AutoML in Power BI Without Premium

Most of you probably know about the automated machine learning (ML) functionality in the Power BI Service. This provides a no-code mechanism for preparing, training, and applying machine learning models to your data analysis in Power BI, but is only available in Power BI Premium at this time.

Chris SilvernailAutoML in Power BI Without Premium
Read More

Microsoft’s Power BI a Leader in BI Solutions in the 2020 Gartner Magic Quadrant Report

We’re excited to share that, once again, Microsoft is a leader of Analytics and Business Intelligence (ABI) platforms in the 2020 Gartner Magic Quadrant – this is the 13th straight year that Microsoft has been recognized. In this Magic Quadrant report the analytics and BI platforms available on the market are compared based on their features, usability, and capabilities; and Power BI was a top leader.

3CloudMicrosoft’s Power BI a Leader in BI Solutions in the 2020 Gartner Magic Quadrant Report
Read More

Building a More Effective Sales Team Using Analytics

Your sales team is the backbone of your business. Today I’d like to talk about using analytics to build a more effective sales team. This is a big topic for many organizations and I’ll give you some insight into how to use analytics to make your sales teams go from good to great.


Adam JorgensenBuilding a More Effective Sales Team Using Analytics
Read More