Machine Learning(ML) 101 with Azure ML Studio and R with SQL Server 2016

By Joe Homnick, CPA and Microsoft Regional Director

August 11th at 6PM NSU in Davie

Joe gives an introduction to working with Machine Learning with both Azure ML Studio and the R Language that is now integrated into SQL Server 2016. Azure ML Studio incorporates a visual method to generate ML model integration into apps such as Power BI, while R is a statistical programming language that can call ML Models and is integrated into SQL Server 2016 TSQL. Joe will compare and contrast the two approaches to ML integration and also show how they can be complimentary.

Business Intelligence – The State of the Art by Joe Homnick

SQL Saturday on June 18th at Nova
Register or for more information

Join Joe on a fun and informative session on the current state of Microsoft Business Intelligence (BI) offerings. We will look at the array of tooling around BI in SQL Server 2016, Power BI and Cortana Intelligence. There have been major changes in reporting and cognitive data source capabilities the last few months. This session will get you caught up on your current BI possibilities with many dazzling demos, including delivering a self-service BI Solution through HoloLens!

Data Modeling and Power BI Class

Delivering Business Intelligence Dashboards
with Resilient Data Models using Power BI

3 Day Instructor Led Hands-On Course
May 9-11 in Boca Raton, Florida 


Let us help your enterprise “Deliver a Self-service BI solution”


This Instructor Led Hands-On course will teach IT Staff, Database Developers and Data Scientists how to deliver BI Dashboards supported by resilient Data Models to self-service users. This course is geared towards enterprises interested in creating a self-service Power BI that end users will be able to efficiently use. 


·       Overview of Data Warehousing and Business Intelligence with Power BI

·       Drilldown on Data Discovery using Power Query Integration

·       The Data Stewardship Experience

·       Data Modelling using Power Pivot integration

·       Building visualizations using Power View integration

·       Extending the Model with DAX

·       Natural language Query using Q&A

·       Data Management Gateway

·       Cortana Intelligence and R Data Sources

·       Delivering your Power BI Dashboards to end users


Register or for more information

Courseware by
Joe Homnick, CPA and Microsoft Regional Director

Business Intelligence updates in Microsoft SQL Server 2016

Join Joe to get an overview of the new capabilities and innovations specific to Business Intelligence in the upcoming release of SQL Server 2016. He will cover details of the new features added in SQL Server Analysis Services and SQL Server Reporting Services. Joe will also provide a look ahead outlining Microsoft's future plans for BI capabilities beyond SQL Server 2016.

Homnick Systems and the SharePoint Beast

Organization scenarios where SharePoint and Homnick Systems (HSI) can help:

  • Have you ever found yourself sending the same email attachment over and over again?

  • Have you dug through your emails laboriously, trying to pick up a conversation where you left off?

  • What about tracking changes you made to documents with versions?

  • Would you like to setup approval and/or collect signatures workflows on document creation and changes?

  • Do you have a requirement to control how a document is disposed of?

  • How do we setup a centralized Calendar and Meeting system?

  • It sure would be nice to have a controlled and secure system to deliver Intranet information by our Department without the need for developers or IT workers!

  • Could I be alerted when documents, tasks, calendars, contacts, etc. change?

These are the kinds of problems that SharePoint is designed to minimize. It’s meant to transform intranet communications into a seamless and comprehensive experience. It automates all the redundancy out of your organization’s workflow, so that you can focus on your core organization’s operations. In other words, it’s a way to transform technology from a distraction into a catalyst.

SharePoint’s core functions are to:

1.      Collaborate – Easily create teams that communicate effectively

2.      Organize – Simplify the process of finding information in documents and conversations

3.      Share – Make sure everybody who needs to be up to date on something easily is

4.      Manage – Easily track and manage projects simultaneously

Finally, one of the primary benefits of SharePoint over the alternatives is the fact that it’s powered by Microsoft, so it works together seamlessly with Office and Outlook.



“Homnick Systems helped us to setup an Intranet Portal with SharePoint that replaced our outdated Portal solution. We can disseminate information in a secure and controlled fashion that is driven from data posted from the different departments. This is all accomplished without IT Developers being involved.”


Miami International Airport Director



IoT with Raspberry Pi, Windows 10, Cortana Analytics Suite and Power BI

 By Joe Homnick, CPA and Microsoft Regional Director
Florida.Net @ Cendyn Spaces in Boca Raton Jan 19 6:30pm RSVP
SoFla CodeCamp at Nova University Feb 20 RSVP 

Joe is doing a Hands-on session showing how to setup a Raspberry Pi with Windows 10 and then capture sensor data to Cortana Analytics and Power BI. He will walk you through deploying a Universal Windows App to the Raspberry Pi that will capture sensor data and send that data to a Cortana Analytics Event Hub. Cortana Stream Analytics then picks up that sensor data from the Event Hub and delivers it to a real time Power BI Dashboard. Come join Joe for an informative and fun session.

Cortana Analytics Suite and Power BI

Homnick Systems can help you setup your Cortana Analytics Suite and Power BI system
Contact me about Cortana Analytics and Power BI

If you are asking these types of questions when doing strategic planning in your business, then Cortana Analytics and Power BI can help.

  • How much will our profit go up if we merge with company XYZ?

  • What are the best ways to take advantage of cross-selling to our customers?

  • What is the Social Media impact to our product strategy?

  • How can we detect fraud before it happens?

  • How can we gain operational efficiency in powering our buildings?

  • Is everyone in your supply chain pulling in the same direction?

Power BI and Cortana Analytics Suite is a fully managed big data and advanced analytics suite that transforms your data into intelligent action. 

Power BI and Cortana Analytics, implements years of Microsoft research and innovation – spanning technology & infrastructure for advanced analytics. Capabilities include machine learning, big data storage and processing in the cloud and Dashboards and Visualization with Power BI. This results in helping enterprise customers make better, faster decisions to accelerate their speed of business.

Business Intelligence using a Power BI approach

                               One Day Hands On Seminar 9AM-4PM
                              April 14 Microsoft Fort Lauderdale Office



·      Overview of Data Warehousing and Business Intelligence with Power BI

·      Drilldown on Data Discovery using Power Query

·      The Data Stewardship Experience

·      Building Stellar Data Visualizations using Power View

·      Building 3D visualizations using Power Map

·      Power BI Sites and Mobile BI

·      Natural language Query using Q&A

·      Data Management Gateway

·      Cortana Analytics and Machine Learning Deep Linking

·      Delivering your Power BI Dashboards to end users



Register or for more information

 Seminar courseware by
Joe Homnick, CPA and Microsoft Regional Director

SQL Server 2016 and Azure Database New Features

by Joe Homnick, CPA and Microsoft Regional Director

Joint Meeting with South Florida SQL Servers Users Group

September 2 at 6:30pm at Microsoft Fort Lauderdale Office


Come join Joe, who is a Microsoft Certified Database Professional, as he delves into SQL Server 2016 new features.

SQL Server 2016 delivers breakthrough mission-critical capabilities with in-memory performance and operational analytics built-in. Comprehensive security features like new Always Encrypted technology help protect your data at rest and in motion, and a world-class high availability and disaster recovery solution adds new enhancements to AlwaysOn technology.

Organizations will gain deeper insights into all of their data with new capabilities that go beyond business intelligence to perform advanced analytics directly within their database and present rich visualizations for business insights on any device.

You can also gain the benefits of hyper-scale cloud with new hybrid scenarios enabled by new Stretch Database technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure in a secured way so your data is always at hand for queries, no matter the size. In addition, SQL Server 2016 delivers a complete database platform for hybrid cloud, enabling you to easily build, deploy and manage solutions that span on-premises and cloud.


More info and registration