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

How to Get Started with Machine Learning on Azure

We all know life can get hectic. Here at 3Cloud, we’re no different. But one of our goals is to learn something new about Azure every day, as things are constantly changing and being updated. Many people are still learning all the amazing things they can do within the Azure cloud and we want to help. Our posts in our Azure Every Day series are a great way to learn more about Azure each week.

If you’re like many of our customers, you’re looking to learn more about advanced analytics, machine learning and other data science type topics. In today’s post, I’d like to discuss what we do to help our customers get to where they want to be in these areas.

Steve HughesHow to Get Started with Machine Learning on Azure
Read More

Microsoft and BlackRock Announce Retirement Planning Partnership

Microsoft and BlackRock Announce Retirement Planning PartnershipWelcome back to Azure Every Day! We took a break in January to regroup, refresh and get some new writers involved in our Azure Every Day series. We’re back with more great content every weekday all about Azure, with tips, up to date info, use cases and more.

This first post is about retirement planning – an interesting topic these days. At this point, the state of financial planning is a potential major crisis with current and future generations coming upon retirement age with little or no savings to account for.

Tom WardMicrosoft and BlackRock Announce Retirement Planning Partnership
Read More

Building a More Effective Sales Team Using Analytics

Building a More Effective Sales Teams 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 of our customers and I’ll give you some insight into how we’ve been helping customers to use analytics to make their sales teams go from good to great.

Tom WardBuilding a More Effective Sales Team Using Analytics
Read More