What is a Microsoft Data Scientist?

One of the hottest IT terms for a work definition being bandied around currently is that of Data Scientist. A somewhat new workplace title that takes in a lot of technical abilities. A nice succinct definition of Data Scientist is "a person that analyzes digital data to assist in making business decisions". This definition has evolved from a Data Analyst or Business Intelligence(BI) Analyst due to applying technologies like Machine Learning, Big Data and statistics. But what does it take to become a Microsoft Data Scientist (MDS)? This post looks at the differing technologies and tools that define the position MDS and gives you links to a couple of free courses to get you started as a MDS.

Core Fundamentals for a MDS include querying relational data with SQL, analyzing and presenting data using Excel and/or Power BI (specializing in at least one) and a basic understanding of statistics. If you took statistics in college, this is the level we are talking about.

Core Data Science skills include the ability to take that understanding of statistics and data and be able to manipulate it in a statistical scripting language to analyze the data. The two most popular scripting languages for this purpose are R and Python. The MDS should have a proficiency in one of these. A basic understanding of Machine Learning (ML) is a core skill. ML is basically the capability of computers to learn with explicit programming with the main uses of predictive analysis, identification of outliers (threats/malfunctions) and pattern recognition such as speech, text and facial. Microsoft tooling around ML is Azure ML Studio, which allows you build ML experiments with supporting datasets, integration with R/Python/SQL and turn your ML models into Web Services.

Applying your Data Science skills requires a proficiency in R or Python. It also takes the capability of building complex Azure ML Experiments in Azure ML Studio which gives you a process design surface to integrate data, the scripting languages referred to earlier and many different statistical algorithms to create sophisticated ML models. Azure ML also gives you the elastic scaling power that the ML models require. Other areas of specialization in applying Data Science with Microsoft tooling are Predictive Models with Spark in Azure HDInsight and developing Intelligent Applications including use of the Microsoft Cognitive APIs.

If you want to get started with the Microsoft tooling around Data Science here are a couple of free EDX courses for you to get started. There will be a complete Microsoft Certified Data Scientist Curriculum in the future.


DAT204x: Introduction to R for Data Science


DAT203.1x: Data Science Essentials


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
$995
May 9-11 in Boca Raton, Florida 


cid:image004.jpg@01D158F1.69143670

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. 

Outline:

·       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
                                                        $295
                              April 14 Microsoft Fort Lauderdale Office

                      

Outline:

·      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