Differences between SQL and MDX

I like the way the presenter explains the difference between SQL and MDX.

Understanding these differences is crucial for any developer who is interested in learning how to query OLAP cubes with the MultiDimensional eXpressions (MDX) language.

I found these really useful links and videos to help us get started with the basics:

Analysis and application of Agile Methodologies in BI Projects

As a software developer, the purpose of this post will be to analyze how different methodologies can positively impact the development of a project; I will compare the similarities and differences between IT and BI projects to proceed with an approach to the Agile methodology and its impact to BI projects.

For Business Intelligence professionals, with or without experience, I believe that the BI methodology topic should be considered the backbone of their professional development. A lot of professionals adopt methodologies based on Kimball’s industry standards for designing, developing, and deploying data warehouses and business intelligence systems; Likewise, other professionals design their own ‘flavours’ based on those same standards.

The Business Intelligence methodology gives us a better certainty that our project will achieve the proposed solutions within a range of time determined from an IT point of view, but it is very important to understand that BI projects have indeed two perspectives: business and IT.

The use of methodologies can orient us to correctly define the business solutions and project goals, but it won’t guarantee the success of them because of direct and indirect variables that can affect the outcome. For example, selected BI tools, employee’s technical and business backgrounds, budget, etc.

Even though I think it’s not a rule, generally in both IT and BI projects, the methodology is somehow aligned with the technology chosen as solution, in case of BI, the platform can define essential points related to the technology itself, like better practices, process documentation, component’s definition, roles involved, etc. Now, if we think about the standards that should not be affected by technology, we can consider that the business requirements should all look very similar regardless of the methodology.

We know that there are plenty of methodologies for software development. Traditionally, these methodologies focus on process control by establishing phases, tasks, techniques and tools; Reason why they tend to be squared and straightforward and are usually guided through the documentation generated in each of the designed phases.

This approach is not suitable for projects where the system environment is constantly changing — meaning BI projects — or where the nature of the project forces you to reduce the development time but keeping the quality — meaning IT projects —. Reason why, methodologies like Agile emerge as a good option to fulfill that methodology gap.


The impact of applying Agile methodologies to BI projects can be huge if it’s well done, BI applications are challenging by nature; As mentioned above, their requirements constantly change, plus the inevitable need to add indirect variables such as the addition of stakeholders, incremental scope and depth, which by result will directly impact on the project’s complexity. Agile Software Development addresses the challenges described above right on the principles that defines it ( But its success lies on the methodology used to apply those principles.

Agile development methodology attempts to provide many opportunities to assess the direction of a project throughout the development lifecycle. This is achieved through regular cadences of work, known as sprints or iterations, at the end of which teams must present a shippable increment of work. Thus by focusing on the repetition of abbreviated work cycles as well as the functional product they yield, agile methodology could be described as “iterative” and “incremental.” In an agile paradigm, every aspect of development — requirements, design, etc. — is continually revisited throughout the lifecycle. When a team stops and re-evaluates the direction of a project every two weeks, there’s always time to steer it in another direction.


The advantages of using Agile methodologies in BI projects become very clear after understanding the definition and principles: by developing a prioritized product features or requirements (Product Backlog) and dividing them into small chunks (Sprint Backlogs) we can deliver working software during frequent meetings with stakeholders, which at the same time will give us the opportunity to verify releases or even re-prioritize requirements.

In essence, I can conclude that the Agile methodology helps companies to build the right product instead of committing to develop a piece of software that hasn’t even been written yet. Agile empowers teams to optimize their release as it’s developed.


John C Jay

Some insightful lessons from Wieden+Kennedy’s Executive Creative Director, John C Jay. Although focused from a design perspective, I feel that these lessons would apply just as well for anyone working within any industry.

1: Be authentic. The most powerful asset you have is your individuality, what makes you unique. It’s time to stop listening to others on what you should do.
2: Work harder than anyone else and you will always benefit from the effort.
Get off the computer and connect with real people and culture. Life is visceral.
 Constantly improve your craft. Make things with your hands. Innovation in thinking is not enough.
5: Travel as much as you can. It is a humbling and inspiring experience to learn just how much you don’t know.
6: Being original is still king, especially in this tech-driven, group-grope world.
7: Try not to work for stupid people or you’ll soon become one of them.
8: Instinct and intuition are all-powerful. Learn to trust them.
9: The Golden Rule actually works. Do good.
If all else fails, No. 2 is the greatest competitive advantage of any career.




It has been a while since I wanted to start this blog project.

Since the world didn’t end in 2012 and I recently started my BI (Business Intelligence) career, I will use these means to keep track of and discuss topics related mainly to this area, but I will throw the random post about other interesting tech topics. As well, I will be writing about my experiences in BI development hoping other colleagues can benefit from them.

Thank you and here we go…