SmoothRaaCS™: Changes made to beta testing user experience

Below are the latest adjustments made to the SmoothRaaCS™ software application to support the beta release.  We are providing the change log here as part of our openness and transparency values. If you have a change that you would like to see made to the beta application, please send hour notes to contact@smoothcubeanalytics.com. ID Enhancement Date Entered Status B-001 Email support needs to be configured…

SmoothRaaCS™: A better requirements management experience!

We are pleased to announce the beta release of our requirements software application called SmoothRaaCS™ or Smooth Requirements as a Collaboration Service, an initiative by SmoothCube Business Analytics to provide a better requirements management experience to all business analysts. The site is available at https://smoothraacs.ca. We encourage all business analysts looking to participate in beta release testing to stop by, register for free and test…

SmoothRaaCS™ Documentation

Smoothcube is a firm believer in applying international standards to the development of its application documentation. Using this philosophy, we make every effort to conform to the guidelines of ISO/IEC 18019:2004(E), Software and system engineering — Guidelines for the design and preparation of user documentation for application software. To access the documentation, click the link below. SPROUT – Business Analysis Application  

BI for the BA – Live Blog 11:42 a.m.

Entity relationship diagrams ERDs show the relationship between classes of data, or data entities.  Unified Modelling Language (UML) is a common language to use to show the relationships between classes or entities.  Concepts of one-to-one, one-to-many or many-to-many is used here. Data models are good concept sources for having discussions with stakeholders. Data dictionary, not often used, can be developed to document the definition of…

BI for BA – Live Blog 10:47 a.m.

Dimensional modelling Tolerates redundancy to assist query speed across multiple tables Uses cubes rather than table concept Few tables; fact table concept is used; measures are connected to dimensional tables Uses OLAP (online analytical processing) – an environment where information is queried.  There are no updates, deletes or inserts in a data warehouse or data mart. OLTP is online transactional processing (this is the most…

BI for the BA – Live Blog 10:02 a.m.

Discussion focusses on workload where there are multiple systems that will feed a data warehouse.  A question came out as to how to tie the data sources together?  One aspect is the concept of mapping source information together using unique identifiers that can be created by a data modeller, or BA doing the data model in the staging environment where extraction and transformation occurs prior…

BI for the BA – Live Blog 9:44 a.m.

Cultural issues make post challenges to a BA working on a data project.  “We have always done it this way” is a common response to change. BA techniques to handle this type of response: Focus on the objective Listen attentively Ask “what did we miss” on past projects or activities that led to this type of response now. Ask questions about the culture or get…

BI for the BA – Live Blog 9:24 a.m.

Data warehouse is the target of extracted, transformed and loaded. ETL is one of the most time consuming aspects of business analysis work.  There could be many sources of information from which to extract information.  Transformation puts some quality on the information that is extracted.  Loading of transformed data is done in the data warehouse. ETL is a good method for standardizing data, putting quality…

BI for the BA workshop – live blog 9:14

Participant engagement right off the bat for the prioritization exercise for the case study goals and objectives of the sample organization, TBIXC. We need to know not only what the goals are but also what the top level priorities are for an organization.  From a data model perspective, we might use the approach of talking with key stakeholders about what current information they have to…