Before building out the plan for a bi solution project, I always like to think about what other projects that I have done or know about that are similar to the one I am going to embark on. I always ask myself what issues or obstacles did I encounter in those projects? There are so […]
You can look at your data many different ways and it will help your business to look at that data in as many different ways as possible and not just one. We will cover some of the basics here and hopefully it will get your mind thinking about what data you currently have and how […]
The first step of building out a business intelligence solution is that you have identify all the data sources within the business. It is right after you identify the datasources is that you want to develop and document all the data collection processes. Why develop a data collection process? Not only will creating a data […]
There are several advantages of why I believe you should go with a data warehouse living in the cloud and not on premise. I know everyone has heard all the news and excitement around what AWS has been doing around their data warehouse offerings. AWS has been one of the leaders in the Cloud industry […]
The Why: When you look at each silo of data individually you do not get a complete picture of what a visitor or prospect is interested in, you only see what that one piece of the puzzle is showing you. You can get good information from your Google Analytics data (silo) when you look at […]
There are a lot of misconceived notions that cloud solutions have speed constraints leading to latency and have huge security vulnerabilities. These thoughts and some others have many companies move the cloud solution option to the bottom of the pile and that is simple not a good option for the business. To address the first […]
Businesses having a data governance committee is one of the most overlooked and undervalued areas when businesses are looking to start and/or maintain their business intelligence solution aka your single source of truth. I have fun exercise for you to do, one day go out and ask different friends and/or family of yours that are […]
I consider the data warehouse as the foundation of a business intelligence solution – your single source of truth. As with any good structure if the foundation is not good the structure will come crumbling down. Before we go any further about the importance of a data warehouse in a bi solution lets define it. […]
I have been asked many times in my career about my thoughts around using middleware versus writing custom code to integrate systems that need to communicate with each other. My thoughts have changed over the years as my experience has grown significantly. There are a lot of challenges that need to be thought about and […]
What are silos of data? I define silos of data as points of data that have been collected and being stored in many locations that could bring value to your business. Many times these silos of data store similar to identical information. Usually these systems are considered transactional systems that employees and/or customers are entering […]