|
| Editorial |
Building or Buying Analytics One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. Often it's a limited discussion on whether we think the problem is close enough to one other organizations have. If so, let's buy something. If not, we might need to build an application to get what we want. Key card software for our doors? Buy it. Managing our core business flow, I might buy this. Analytics, or what has often fallen under the umbrella of business intelligence (BI) is an area where technology groups often wonder what's best. I have seen no shortage of decisions in the past for how best to implement this feature for our organization. Ultimately, I think this piece summarizes this well: time will make the decision easier. If you need this done now, buy it. If you don't have development resources, buy something. If you need similar analytics to what many companies need, buy this. Do you trust vendors to spend enough time on security, buy their service. Those are good reasons to adapt your process, your view, your requirements. If you can be flexible, it makes sense to buy some software that provides analytics for your data. Many companies have had success with purchased products, like Tableau, Qlikview, Cognos, Power BI, or some other pre-built package that allows users to analyze their own data. You might even just give them access to all views (or even tables) and ignore the entire part of your business. If you have time, however, I do find that developers working with analysts can truly add value and insight to the information a business holds. They can be responsive, while also providing knowledge about ways to structure and summarize data, and perhaps even identify those places where the way in which we gather and use data ought to change, perhaps even add new data elements. I do like the self-service, pre-built packages for multiple reasons, not the least of which is that users can do some Proof of Concept work themselves. I think Power BI Desktop is one of the best ways to do this today, using existing data sources that users can access. Let them go crazy and try whatever wild idea they have with data. When they find something useful, something that others need to also access, and something that becomes important to the organization, then it's likely time to involve IT to provide stabliity. If there are also ways to better structure the information and perform a more detailed analysis, this might also be the time to customize the way the analytics package works, and again Power BI provides the ability to do this. Making this decision is hard, and it might not ever be done, but I do think buying is a good place to start, especially with the wide variety of packages out there, but you might find yourself changing your mind as your analytic needs mature. Steve Jones - SSC Editor |
|
| The Weekly News |
| All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. |
| AI/Machine Learning/Cognitive Services |
This is part two in a series on Machine Learning w... |
| Administration |
Question: How to List All Memory Optimized Tables ... |
In this blog we would talk about fixing error 1527... |
How SREs can use a hierarchy for mature alerts. SR... |
Problem: You created a linked server on SQL Server... |
This month, I have added some new columns in some ... |
Here is a quick script that I find myself using fr... |
Forcing someone to change their password on a peri... |
Migration is nothing but moving a databases from..... |
IRL #3 – Slow Server Problem: I was recently app... |
Time for another short blog post, and this one com... |
I’m at the Techno Security and Digital Forensics... |
|
| Career Growth |
When looking at the Certified Information Systems ... |
| Conferences, Classes, and Events |
Hello Baton Rouge! David Pless and I will be teach... |
Are you coming to town for SQL Saturday 883 in Lou... |
The summer o’ ADF continues with another free we... |
| DMO/SMO/Powershell |
This is actually part of a process I am creating t... |
| Database Design, Theory and Development |
Database Engineering: Database Modelling: Do I nee... |
The Common Data Model (CDM) is a shared data model... |
| ETL/SSIS/Azure Data Factory |
Azure Resource Manager, or ARM, “allows you to p... |
This post is part of a series, Short Cuts to Biml ... |
| HA/DR/Always On/Clustering |
Here’s a little error that I stumbled across the... |
| Hardware |
The rather long lifespan of DDR4 memory has allowe... |
If you’ve been following our coverage of Compute... |
| Microsoft News |
Microsoft has closed its remaining specialty store... |
I didn’t attend the //build/ conference this yea... |
| Performance Tuning SQL Server |
A question that comes up on the forums all the tim... |
Lots of people had no idea that even index can als... |
In the documentation for TOP, the following is lis... |
Hugo Kornelis explains how index scans work in SQL... |
A Long Time Ago I had to write some hand-off train... |
Sometimes I feel like I have become a kid again. T... |
Erin Stellato shares her approach to using Query S... |
Blocked process detection provides the DBA an exce... |
Seldom does a DBA have the opportunity to get out ... |
Smoking Ain’t Allowed In School While working on... |
| Polybase/HDInsight |
Today’s PolyBase Revealed post covers another th... |
When Hadoop was introduced, it promised a faster t... |
| PowerPivot/PowerQuery/PowerBI |
Thanks for watching this week's Power BI news roun... |
Most of the time, you would like to know how the d... |
Patrick takes a look at the recent updates to Powe... |
It is very common to need to transform data from o... |
The default configuration for Power BI dataset is ... |
| Product Reviews and Articles |
This is a review of Anthony Nocentino’s Pluralsi... |
| Python in SQL Server |
Are you interested in guest posting? Publish at Da... |
Are you interested in guest posting? Publish at Da... |
| R Language |
Are you interested in guest posting? Publish at Da... |
Are you interested in guest posting? Publish at Da... |
Are you interested in guest posting? Publish at Da... |
For my third 'Rosetta Graph' example, I will focus... |
| Security |
As ransomware gets smarter and the use of AI incre... |
Bucking a major trend, company no longer advises o... |
Really interesting paper calculating the worldwide... |
Mayor says Baltimore is "open for business," but c... |
Today is the second day of the twelfth Workshop on... |
You can track down your stolen MacBook, but no one... |
After Google successfully beat back Triada in 2017... |
| Software Development |
Making the decision to adopt embedded analytics is... |
| T-SQL |
Ok, so I have been, and will mostly stay, in a bit... |
Watch this week’s episode on YouTube. While I kn... |
I came upon this issue when I was building some vi... |
I get this question a lot, so let’s set up an ex... |
| The Lighter Side |
To survive on Mars, and return, SpaceX would gladl... |
First Pikes Peak, now the Green Hell—the ID R do... |
The best driver assist tech just got a little bett... |
Desalination, electrolysis, CO2 capture, methanol ... |
| Vendors/3rd Party Products |
In this independent review of SQL Provision, the B... |
| Webinars |
Monday June 17 16.00-17.00 / 10.00-11.00 Central -... |
Wednesday June 12, 16.00-17.00 / 10.00-11.00 Centr... |
|
webmaster@sqlservercentral.com