Independent Data Consultancy
Another great release from Metabase. I’m just ashamed that I’ve not been writing enough about previous updates. I’ll go through the new stuff in 48 plus some of the other recent additions to this rapidly developing software. There’s a long list of bug fixes which surprised me as I rarely encounter any problems. Looking in […]
There’s more to reporting than just downloading spreadsheets to fiddle with. We’ve written the extracts to bring your CarePlanner data into PowerBI or any other data visualisation software. Here’s a small example: Yes, I know there are no numbers, there’s a good reason for that! Once designed, the PowerBI report can be securely published to […]
Your cloud migration completed successfully. Now you can access your application from anywhere without any concern about maintaining a server or installing client applications. Bliss!Then a colleague or customer requests some data in a specific format. You download a 100 column spreadsheet from the new cloud application, specifying the date range of the records you […]
Like most consultants, I’m using more and more open source software. A big change for me was to use PostgreSQL following 20 years experience of MS SQL Server. What follows is part comparison, part ‘things I wish I’d known before I started’.
The United Kingdom Homecare Association (UKHCA) published the chart above to calculate the minimum hourly amount that should be charged for care in the home. That tiny purple slice at the top is profit, so any change in costs can make a significant difference to the bottom line. This is then broken down further to […]
ECM gives huge gains in carer efficiency and client care by monitoring carers’ arrival and departure. Scheduling is enhanced. Lone care worker safety is greatly improved.However, it is greatly dependent upon high compliance rates. If a carer fails to check-in or check-out, the data quickly becomes less useful. It may be that the carer is […]
Over the last 3 years, I’ve started to do a lot more work using PowerBI. In terms of planning and designing, it’s similar to QlikView/QlikSense in that you first load and transform data, then do the pretty stuff. I’m now seeing more interest in migrating from Crystal Reports to PowerBI.At first, this made no sense […]
SAP BI 4.3/Crystal Server 2020 comes with the new Fiori launch pad. It’s the one that looks like this: The old 4.2 looks more like this: Admittedly, the new one is much more ‘modern’, but once you’ve got loads of users working from home right now and don’t have the time to retrain them for […]
It’s finally arrived, but how does the move to a 64 bit report designer change how you work? I’ve installed 2020, where’s Crystal Reports 2016 gone? That side by side install you were hoping for? Sorry, despite the move to 64 bit, you’ll find that your existing 32 bit version of Crystal Reports 2016/13/11 has […]
We’ve been helping student accommodation providers report and analyse their Starrez data for over 5 years. The built-in reports are fine up to a point, but most users soon need a little more. Whether you’re using StarRez installed on your own servers, or in the cloud, the data is there waiting for you. It’s great […]
