How to use a CTE? Should you use this “With” your SQL code?
Introduction You can use Common Table Expressions (CTEs) as temporary named result sets within a SELECT, INSERT, UPDATE, or DELETE statement. A WITH clause defines and allows the use of them to simplify complex queries and improve their readability. A CTE is created by first defining a query that generates a result set, and then […]
Business Analytics Process
Introduction Business analytics is the process of using data, methods, and tools to generate insights to help organizations achieve their goals. Business analytics is important for organizations because it can help them: Understand their current performance and identify opportunities for improvement. Predict future outcomes and trends and plan accordingly. Optimize their processes and resources and […]
Integrating Joblogic with Power BI
Introduction Our client provides nationwide engineering maintenance services. They use Joblogic, a comprehensive field service management software, to track activity. In this blog we talk about Integrating Joblogic with Power BI. Field Management Software Field service management software improves efficiency, productivity, and customer satisfaction of businesses. It helps them plan, schedule, invoice. Field service businesses, […]
Unlock the Power of Geo Data
Geo data, or geospatial data, is data that describes the location and attributes of objects or phenomena on Earth. This data can be used to create maps, analyse spatial patterns and trends, and model the real world. Geo data dashboards can also help organisations gain deeper insights into their customers, markets, operations, and performance. In […]
Improve Payroll Efficiency
Are you tired of your business spending hours on manually calculating overtime for your employees due to complex contracts? Do you wish there was a better way to automate and streamline your payroll process? If you answered yes, you are not alone. Many businesses face challenges of managing complex payroll processes in a fast pace […]
Connect BambooHR to Power BI: Streamlining HR Analytics
Connect BambooHR to Power BI to get real time visibility of your HR data On a recent project a client had a requirement to connect BambooHR to Power BI. This blog seeks to share some of the steps and experience. Getting Real Time Analytics Whilst the business was utilising BambooHR, a popular HR software […]
SQL Coalesce Function
An Introduction to the SQL COALESCE function The SQL COALESCE function is a simple, efficient function to handle NULL values in your SQL queries This quick guide shows you how it works, how it compares to using some alternative approaches and common use cases The SQL COALESCE function returns the first non-null value in a […]
What is Business Intelligence?
Business intelligence (BI) is a set of processes for gathering, analysing, and presenting data to make informed business decisions. BI applications include reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics, and prescriptive analytics. BI technologies provide historical, current, and predictive views of business […]
How do you upskill your IT Team?
How do you best upskill your IT team? How do you make sure you get the most out of software you just purchased? Your team complain they have not had the training to understand the software? How do you find the most efficient way of working with the software? Have tried training courses before but […]
Microsoft’s new direction – The release of Fabric
Microsoft Fabric has launched. What is it, what does it mean for the rest of Microsoft’s Infrastructure and what questions are outstanding? This blog aims to give a brief overview of Microsoft’s new direction. With this release Microsoft aim to leverage the popularity of Power BI by putting this at the centre of Fabric. Power […]
