Gethyn was brought in by the Royal College of Nursing during an upgrade to Microsoft CRM 2013 where it was highlighted that there were serious performance issues in returning data in the application, the processing of batch data tools and also very slow execution time for reports. The expertise was missing both internally in the RCN … [Read more…]
Dashboards Don’t Drive Decisions (and that’s the real analytics problem)I have a new conference talk that made it debut at Tenerife Winter Sessions last weekend and is scheduled for another outing at the Birmingham Power BI Meetup Group #PBIBrum at the beginning of March. The talk is called “Data-Driven Storytelling with Power BI” and this … [Read more…]
Understanding Slowly Changing Dimensions Slowly Changing Dimensions (SCDs) are a cornerstone of data warehousing design. They ensure that the descriptive attributes of business entities—customers, products, employees, locations—are handled correctly when they change over time. Without a clear strategy for tracking changes in dimension data, analytical systems either lose valuable history or become inconsistent, leading to … [Read more…]