When building out your business intelligence solution an important step of developing data collection processes and documenting those processes is critical to your business and its success. Why develop a data collection process? Not only will creating a data collection process standardize the way you collect data for all the groups in your business but […]
Well this was very frustrating to fix “Unable to load psycopg2” but I wanted to share my findings with everyone so they will not go through the ordeal that I did. I installed a new version of python to my work station, updated my python code to support that new version of python. After executing […]
Having no business intelligence solution in place impacts many things and many people. It impacts your bottom line, it impacts your customers, it impacts your employees, and it impacts the understanding of your business right now and in the future. Your bottom line With having no business intelligence solution in place, a business cannot see […]
What I have been seeing with all my clients over the last three years is them trying to get their arms around their data, cleaning it, gathering it into a central location which then they typically create dashboards and reports to see how their business did in the past but some are looking at how […]
I have been asked many times by my clients and by peers why do you think more business are not implementing a business intelligence solution. It is a great question and I am sure many executives, directors, and managers have discussed this in reference to their own businesses and have their own reasons why a […]
RIGHT JOIN Keyword Since I did LEFT JOIN the other day, I figured I might as well do a blog on the Right Join to keep it fair. Define In SQL the RIGHT JOIN keyword will return all records from the right table (table b), and the matched records from the left table (table a). […]
LEFT JOIN Keyword I wanted to write a quick blog on LEFT JOIN because I get so many questions about this topic from young DB Admin’s and developers as well as Business Managers. Define In SQL the LEFT JOIN keyword will return all records from the left table (table a), and the matched records from […]
Purchase The Kindle Edition Purchase The Paperback Edition Your Single Source of Truth is a quick-read for busy business and IT professionals struggling to create a Business Intelligence solution. Packed with advice, proven methods, and real-world uses cases, this book provides the knowledge to get you not only started but to keep your Business Intelligence […]
I wanted to write a quick how to blog in reference to show someone how to include dependencies with their python AWS Serverless function. The Use Case You have been assigned a project and you need to create a Lambda Serverless function in python that needs to execute a stored procedure or a SQL statement […]
Once you start to understand your data and the information is available throughout the business, a whole new world will open up to everyone that has access to the data. You will be able to see not only how the business is doing as a whole, but how each department of the business is doing […]