Has your executive team asked you to start a Self-Service BI initiative but you don't know where to start? Does it sound to you like this self-service stuff is really just dashboarding? Is your current Self-Service BI project failing?
Capax Global Blog
If you are looking for an MPP data warehouse and you would like to see some amazing performance, we suggest you check out the new compute optimized performance tier in Azure SQL Data Warehouse; we were blown away in our testing (and we have tested them all). You can read more about it here.
We are thrilled to announce that Capax Global been selected as runner up for the Microsoft Data Platform Worldwide Partner of the year!
This will be an introduction to Business Event Analysis and Modeling (BEAM); the agile data modeling approach developed by Lawrence Corr. One blog post cannot begin to cover the depth of this approach. To dive deeper, see his book Agile Data Warehouse Design.
First, we will review the key differences between Agile and Waterfall methodologies.
The Problem Statement
When working with customers they often have a need to aggregate data in a unique way that is not exposed by the Power BI Query designer. One such case that I run into frequently is the need to roll up text details by group. For example, figure 1 shows a list of task codes and the task names associated with it.
Arms stretched towards the sky, head (and sign) held high – this 2-year-old girl had something to say as she joined the multitude of supporters at one of the Women’s Marches last week. While the words on her sign may be tough to translate, the presentation of her prose can’t be ignored as toddler sized energy fuels her tiny fingers and ensures that her message can be seen by the world.
Unlike most of my peers at Capax Global, much of my career has not been Microsoft focused. I was initially trained in Oracle, learned Unix, Java/J2EE, and WebLogic early on, added DB2 UDB, Informatica, WebSphere, OBIEE and Cognos, and as recently as 2014 led the selection and implementation of Tableau as the strategic Business Intelligence and Visualization platform for my then employer.