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].

Data, Analytics & AI

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…
Data, Analytics & AI

Power BI XMLA Endpoint

I’m here to talk about a game changer in Power BI, the XMLA endpoint for Power BI Premium. How is this a game changer? XMLA…
Data, Analytics & AI

Import vs DirectQuery Storage Mode?

When designing a Power BI, SQL Server Analysis Service Tabular or Azure Analysis Services data model, what are the pros and cons for using Import…
Data, Analytics & AI

Correlating Coronavirus Outbreaks with Business Data Using Power BI

At the time of this post, the world is dealing with a serious health and economic crisis. The COVID-19, Coronavirus, is impacting the lives of…
Data, Analytics & AI

Introducing the Power BI Activity Log API

Are you still using Office 365 Audit Log to track activity in Power BI? Let me tell you about a better way. The new Power…
Data, Analytics & AI

Paginated Reports in Power BI

What do you know about implementing paginated reports in Power BI? A recent client wanted to know their options for implementing operational reports, which are…
Data, Analytics & AI

What You Need to Know About Power BI Licensing

What does it cost to use Power BI in my business or enterprise? This is a question I’m often asked by clients. One way I…
Data, Analytics & AI

Azure Storage Options

There are many options for data storage, how do you know which is right for your data? Today I’d like to discuss storage in relation…
Data, Analytics & AI

Power BI Timeline and Use Cases

One of the challenges with Power BI is that there are so many ways it can be used and so many nuances that the platform…
Data, Analytics & AI

Azure Data Lake Storage to the Rescue!

Do you have issues with data storage space? In today’s post I’d like to share a scenario that may be familiar to you and how…
Data, Analytics & AI

BI Model Options for Enterprise Scale BI Solutions

In today’s post I’d like to talk about a hot topic for me and for many of my clients lately. This topic is about enterprise…