Why should finance take over business intelligence?

I fully agree; if finance takes over BI will start making money for the company.

The Death of Business Intelligence

Information is mined by programmers and technicians, but when it comes to the processing of data, the Journal of Accountancy argues the finance department should be taking the lead role.

Data has transformed most roles in the business sphere, but the corporate finance function has been particularly affected by the influx of information. According to Donny Shimamoto, a certified information technology professional at Chartered Global Management Accountant, finance should own the business intelligence (BI) role for the good of accountants and the good of the organization.

Speaking at the AICPA Financial Planning & Analysis Conference in Las Vegas, he explained that there are three reasons why finance should focus more onBI. First and foremost, the finance department can usually add clarity, accuracy and relevance to what is often just confusing numbers to those without the skills or expertise to process. A recent Gartner report says that businesses are “still struggling to make progress with (business intelligence)…

View original post 286 more words


How to avoid the pitfalls of BI

Death of BI! Wasn’t it already dead? Serious arguments here! Worth reading

The Death of Business Intelligence

Business Intelligence (BI) technology has become more and more common in the world of fast-paced business as a way to make sure that owners, managers and other decision makers can carry out the correct course of action at all times by making use of all the data and analysis available to them, ensuring a degree of safety in what they decide to do.

However, while it has become something that is more and more prevalent throughout the world, the complex array of tools and platforms on offer has meant that there are often pitfalls that companies need to make sure they avoid, with some being common problems experienced time and again across the market.

Exercising best practice is always a way to ensure the greatest chance of success, but even the top companies make mistakes from time to time, so what are the most common errors seen in BI?


View original post 396 more words

If a capabiity grows in the forest does it solve a problem?

Just for the sake of this sentence:
As another wise pundit said “Computers make great slaves, but terrible masters”

Brian's Blog

Don’t want to bust anyone’s balloon.  However, despite all the hoopla, Big Data and BI are still as Gartner has labeled it in the early stages of the Hype-Cycle.  While the technology is approaching critical mass, the market is still hasn’t crossed the chasm.  That is not to say vendors of such capabilities are full of puffery –actually not.  The problem become one of Strategic Execution and Exploitation.   Over the past ten+ years I have been actively engaged on and off on what arguably could be call BI and Big Data projects [Yup ten+ years!] What I’ve experienced from these projects is that for a first for IT, they’re ready before the line of business is to deploy the capability.  Example: one instance, I developed an approach to infer what markets are heating up and which are cooling off.  It took sales data, several other sources of information and some basic statistics -well may be a tiny bit…

View original post 455 more words

Traveling and Talking to Wrap Up 2013

or Hell on Wheels heh heh . I add this to my collection

Data on Wheels - Steve Hughes

I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly busy travel and speaking schedule for me this year. Having spent much of the summer at home with my family which was great, I now embark on some trips, primarily out east.

For starters, I am kicking off my busy end of summer, beginning of imagefall, in New York City. I am looking forward to being there for the second time. This should be a great event. As Regional Mentor for the NorthEast this trip allows me to be in that region for an event.  I will be speaking on Building BI Solutions with Microsoft Excel.

Next, up is some quality time in Boston. I have a contract that will put me in downtown Boston for about 4 weeks. After that trip, I cm-logoskip a week and then return to…

View original post 352 more words

Standards = Starting Point

quick and dirty is more practiced than slow and clean

Pragmatic Business Intelligence

(Originally posted in the B-eye network)

In a data migration project, Standards are synonymous with Quality.

Every developer has a different philosophy of what works.  It is easier to develop with “what I know”…which rhymes with “quick and dirty”…

Definition of, or existence of Standards of Development and Naming Conventions provide guidelines within which developers should be expected to work.  Without these, your environment quickly becomes rife with development packages, interfaces and jobs with different naming conventions, different approaches…and widely varying levels of development quality.

I think it is common that, lacking a mentor or some kind of guidance, developers new to data migration start the same way – monster jobs, lack of flexibility, lack of clarity…and lack of documentation.  Result: effectively, unmaintainable, throw-away jobs.

The good news is, as discussed, there is a remedy : Take the time to define standards, or work with a supplier who uses a…

View original post 117 more words

SSIS Challenge Accepted!


Ms Kathy V


Earlier this week I posted about having a new challenge – how to use SSIS to dynamically define and generate rules for data cleansing. This week I discovered that the way to do this was NOT to do it! Instead of writing a custom set of code, I will be using SQL Server features Data Quality Service and Master Data Services to help import our data, and I will have SSIS call those packages to actually process the data. While I had known about these two features in SQL Server, I hadn’t had an opportunity to dig deep into what they do. I read about it this week and started playing with the tools, and I will be using them to help develop a non-code-driven data cleansing engine for my customer. By the end next week I should be an expert 😉

My customer aggregates data from various sources, and has no…

View original post 304 more words