BI & Data Stuff
My team and I currently manage six SQL Server instances, each on its own server. Our main need is to monitor how the databases on our instances are evolving and keep an eye on disk space.Our sysadmin team manages the OS and monitors the VMs vitals, but we don’t have a hand on that monitoring and we want to see […]
Now that we’ve deployed what I like to call the backend of our BI solution, lets look at how to deploy our PowerBI reports. For various reasons, we are not using PowerBI.com but PowerBI Report Server hosted by another team in our group, shared amongst companies.
Now that we have an artifact that we can deploy, lets push it onto our target environments. In this first article I will cover how we do it for DBs, SSIS, SSAS and why we do it. I’ll cover PowerBI in a later article as there is no task available for the On Premise version of PowerBI Report Server that we use and we had to rely on a custom script.
Now that we store our glorious code in Git and make sure some poor trainee will be able to go over it in 10 years (and maybe even understand it if we do end up documenting it fully one day), getting down to actually delivering it will help us justify our salaries better.
Everybody in IT uses source control. There is no more debating why. We’ve all struggled without it for long enough.
For us, it has become the root of our work. If it isn’t in source control, it doesn’t exist. But how do we go about it?
Over the next five blog posts, I’ll be going into the details of why and how my team has reached the level of maturity and control over its BI development process that it has.
Show me the state of your backups, I’ll tell you the state of your information system.
In my previous post, I pointed out a lot of ways things could go wrong and the necessity to control what users of a service can do because if you don’t, be sure they will abuse every right they have. Not all of them, but it usually only takes a few. And the worst part of it is they are […]
My first job was building KPIs. Over 10 years later, I’m back to building KPIs. Looking back at how it was then, or digging even further as to how it was done when I was still a child, we’ll notice not much has changed. The principles are still the same: Put stuff in a database, create a model, plug a […]
Having passed the 10-year experience mark working with Information Systems, I felt it was time to share some insight people might find useful.