In this article we’ll be looking at Concept Modelling and how this awesome technique can help your project stakeholders to unearth / discover and share the concepts of a project. The problem with Starting with a Data model I’m totally a data geek and whenever I start a new project, I always jump at the opportunity to create a data […]
Before we move on to hard core Conceptual data modelling, we need to first take a moment to look at the concept of Primary Keys or Identifier Keys. We’ll use the Database theory of Functional Dependency to provide some insight into Primary Keys. What is Functional Dependency ? Simply stated it’s a relationship that exists when one attribute uniquely determines […]
Words are at the core of all human concepts. They are the very things that distinguish us from animals – our ability to attach meaning to a sequence of sounds that manifest as words. As a analyst you will be expressing requirements in words to your developers. Here are some of my tips on working with Glossaries : 1 – […]
One of the dashboards I’ve created for my clients contains data from a massive query that populates SQL # temp tables and then reads from the result temp tables. My problem was how do I do this in Qliksense ? I don’t want to rewrite this query in the Qliksense language. I just basically want to take the query as […]
You have a simple database table (UserNames) as below You want to get this table and it’s contents into a csv file. You create a simple dataflow package (OLEDB = Source & CSV Flat File = Destination) You run the data flow task and feel happy that everything was soooo easy. You take a little peek inside the created CSV […]
The importance of good Acceptance Criteria cannot be underestimated, this article explains why you need it on all user stories.
One of the most important BA Analysis Techniques that is often overlooked by Analysts is the good old fashion Business Rule Analysis. In this article and video i explore Business Rules and how important they are in understanding and defining. Using various real life examples from Covid-19 lockdown to Soccer. I didnt really cover good practise & guidance principles for […]
Some more Tutorial video for Sparx System Enterprise Architect working with Elements
Quick Tutorial revealing the different ways of adding elements to your models in Sparx Systems Enterprise Architect.