I have increasingly found myself searching through older .pbix files looking for a handy function that I DO NOT want to rewrite. Both the looking for and the rewriting of functions are laborious, frustrating, and above all, unnecessary endeavours. By using her extremely helpful Curbal vlogs, Ruth Pozuelo pointed me to a (now obvious) solution: … Continue reading GitHub as Storage
Category: Products & Services
EKlär Solutions is a small business offering IT consultancy services to individuals and small to medium businesses.
As mentioned in a previous post, I attended my first London Power BI User Group meeting last week. The presentation given by Reza Rad was titled Dataflows vs Datasets, but covered somewhat more. Data Architect ... Data Analyst ... Data Engineer... In addition to the expected comparison of dataflow and dataset definitions in the context … Continue reading Power BI Specialist is…
A recent post demonstrated the succinct and powerful quality of code native to Power Query. The original conundrum is highlighted in the Power BI forum here, and the posted solution no doubt works, but is a little cumbersome. The Power of M lies in it's human readability, which not only does not require encyclopaedic knowledge … Continue reading More on M
...Power Query M WARNING: convoluted geek joke ahead Three data analysts walk into a bar, and the bartender gives them a problem: "My data table includes a column containing Company Name, but I want the business acronyms in a new column, with a space between each initial. Oh, and the data contains some hinky characters … Continue reading The Power of M…
...and pretty understandable. Admit it: your business concurrently uses multiple legacy systems in multiple business areas -- whilst looking forward to the bright new shiny system you have commissioned -- and knitting all these data sources into a coherent ensemble presents a considerable reporting challenge. Power BI is a great way to render data meaningful … Continue reading Power BI: Making Data Pretty…
One of the benefits of copy-editing technical and academic work is that one becomes -- albeit briefly -- a bit of an expert in a niche subject. Over the past couple of years I have read some interesting research on crime and criminology from an anthropological perspective, wider uses -- beyond bitcoin -- for block chain … Continue reading Learning on the job
You have some shiny new software, whether off the shelf or bespoke, and you have invested a lot of time and money in your special system. Everyone is happy, productivity will improve and the software will pay for itself in no time. What can possibly go wrong? Beyond the inevitable teething problems, there will always be … Continue reading Support Models
EKlär Solutions has a wealth of experience in creating business applications, both for the desktop environment and also on the web. We primarily develop rapid development applications within the .NET framework using MS Visual Studio LightSwitch. This model requires no licensing fees from the client, and means a simple application, once designed, can be up … Continue reading Applications
The examples below demonstrate different methods of enhancing your favourite photographs. The power of cropping and rotating an image to expose a unique element is shown, as is how the feel of a photo can be significantly altered by rendering it in a different style. Highlighting colour can emphasise content or context, as can the … Continue reading Photographic Effects
Timesheets is a desktop application developed using MS Visual Studio Lightswitch. It is a customer relationship management system (CRM) with emphasis on project management. Features: Store details of all your clients Details of each project are associated with the relevant client Each Project has a number of requirements and associated tasks Running total for time taken for … Continue reading Timesheets: Project Management