Search

datascientist_m5t5qq

Transforming Operational Data into Powerful Business Intelligence Insight

https://youtu.be/NNtUBU2ih_g In our last video https://youtu.be/yib2II91jz0, we explored the process of converting data from a manual flat-file system to a…

1 month ago

Key Points to Remember when using SumX and Sum Function

https://youtu.be/08qkiz5yJds The SUMX function in Power BI is a row context function that evaluates an expression for each row in…

1 month ago

Cost & Revenue Data Summarization Using CTE and Temp Table

https://youtu.be/VkluilMUDUo CTEs & Temp Tables for Data Summarization: The article explains how to use Common Table Expressions (CTEs) and Temp…

1 month ago

From Excel to Microsoft Access: The Journey from Flat File to Data Modeling

https://youtu.be/yib2II91jz0 S&B Textiles, a garments manufacturing company with in-house Knitting, Dyeing, and Garments manufacturing units, was acquired by new management…

1 month ago

RankX Function Power BI (DAX)

https://youtu.be/uHBze-kosYQ By using the RankX function in Power BI, you can create dynamic, rank-based insights into your data, helping you…

1 month ago

Understanding the Power of Common Table Expressions (CTEs) and RANK() in SQL

https://youtu.be/y-Nt5VXPbbA When working with relational databases, leveraging Common Table Expressions (CTEs) and ranking functions like RANK() can unlock significant potential…

1 month ago

Textile Business Intelligence Project

https://youtu.be/5YKeBIeis8Y Business Case Study: Transforming S&B Textiles with Business Intelligence (BI) S&B Textiles, a garments manufacturing company with in-house Knitting,…

1 month ago

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

2 months ago