The archive
Pie charts are one of the most widely recognised and frequently used chart types in data visualisation. Despite their popularity, many experts have criticised the use of pie charts, arguing that they are ineffective in communicating information.
Read the piecePower BI: Version control for your files. Collaborate, experiment, and track changes with ease. With Power BI’s new file format, you can easily keep track of every modification made to your files, including who made the change and when.
Read the pieceAre you looking to get the most out of Power BI? There are a number of steps you can take to ensure success with Power BI. To help you on your journey, I've compiled some of my top tips for getting the most out of this powerful business intelligence tool.
Read the pieceTo maximise data analysis capabilities in Power BI, consider creating a dedicated date table in your data model. While Power BI's built-in features are convenient, they have limitations. A separate date table offers flexibility for custom scenarios and deeper insights.
Read the pieceMeet Azure Quick Review (azqr): a tool that scans Azure resources, provides detailed Excel reports, and helps you optimize your setup. Install it on Linux, Mac, or Windows. Simple authentication with Azure CLI or Service Principal. Scan your resources easily.
Read the pieceBehind the scenes of Power BI lies a language called Data Analysis Expressions (DAX), which is used to manipulate data within the application. In this blog post, we’ll take a deep dive into DAX and explore how it can help you make better business decisions.
Read the pieceWe all know that the =NL (Lookup) function is used to pull a list of values from a database, but there's a few features of it that are probably not as often used. Let's take a look.
Read the pieceAnalysing customer revenue is a critical aspect of understanding the performance of any business. In this blog post, we will explore how to use SQL and the AdventureWorksDW2019 database to group customers into four quartiles based on their total revenue.
Read the pieceLearn how to analyse sales trends with a moving average calculation in SQL. This powerful tool can help you identify growth opportunities and improve business performance.
Read the piece
