In our last video https://youtu.be/yib2II91jz0, we explored the process of converting data from a manual flat-file system to a fully developed data model. If you missed it, the link is in the description below—be sure to check it out! Today, we’re taking things a step further. After implementing a fully automated system, we’ll showcase how […]
The SUMX function in Power BI is a row context function that evaluates an expression for each row in a table and then sums the results. It is commonly used in situations where you need to calculate values row by row and then aggregate those results.
CTEs & Temp Tables for Data Summarization: The article explains how to use Common Table Expressions (CTEs) and Temp Tables in SQL to summarize data, particularly for sales and cost reports. Step-by-Step Guide: It provides a detailed example of summarizing recipe data by month and year, including SQL code snippets. Benefits of CTEs and Temp […]
S&B Textiles, a garments manufacturing company with in-house Knitting, Dyeing, and Garments manufacturing units, was acquired by new management while operating at a loss. Dyeing, the most critical and cost-intensive unit, consumed large amounts of electricity, gas, dyes, and chemicals, accounting for a significant portion of production costs. In particular, dyes and chemicals, which have […]
By using the RankX function in Power BI, you can create dynamic, rank-based insights into your data, helping you better understand performance across different categories like products, regions, or time periods. Whether you’re analyzing sales, profits, or any other metric, the RankX function is a powerful tool to make your reports more insightful and actionable. […]
When working with relational databases, leveraging Common Table Expressions (CTEs) and ranking functions like RANK() can unlock significant potential for analyzing and organizing your data. This blog post will break down the concept of CTEs, the RANK() function, and how they can be combined effectively.
Business Case Study: Transforming S&B Textiles with Business Intelligence (BI) S&B Textiles, a garments manufacturing company with in-house Knitting, Dyeing, and Garments manufacturing units, was acquired by new management while operating at a loss. Dyeing, the most critical and cost-intensive unit, consumed large amounts of electricity, gas, dyes, and chemicals, accounting for a significant portion […]
