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
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.
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.
Organization scenarios where SharePoint and Homnick Systems (HSI)
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
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,
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
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.
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
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
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.
will our profit go up if we merge with company XYZ?
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
Power BI and Cortana Analytics Suite is a fully managed
big data and advanced analytics suite that transforms your data into intelligent
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.
by Joe Homnick, CPA and Microsoft Regional
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
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