A system-wide data workflow for an analytical business information system is a high-level map of a BI System. Summarizing data movement from data sources through the ELT processes and, finally, the presentation layer. Figure 3.3.1 The Unified Data Workflow The figure highlights broad categories of sources, activities,...
It's impossible to graft a fixed number of data workflows onto every business, non-profit or government entity that is definitive. However, standard data workflows provide generalization and repeatable starting points. Typical Milestone Durations Guidelines for work durations, assuming you have a team dedicated to the project: Many SaaS...
Licensing SaaS (software-as-a-service) products can be complicated. Every vendor wants to encourage commitment. Commitment comes in long-term contracts of one or more years, with better prices associated with longer commitments. Clients ask InterWorks to help them make contract capacity and term commitment decisions. Once we have...
In the last post, I provided guidelines on security and preventing unauthorized access to your data. I warned you that an overly restrictive security model could encourage bad behavior. BI system security is like my wife's purse. I might want to look inside, but I wouldn't...
Security and data governance are often treated as the same thing. They aren't. Security is about preventing unauthorized access. Governance is making it easier for people to find the information they need. One is about prevention, and the other is about inclusion. IT staff are rarely...
If you skimp on training, you may burn every penny you save later in the project when it's inconvenient and more costly. Even your expert team members need training and time to become confident in their skills and knowledge of new tools and methods. Your core...
Looking to optimize your Tableau Server? If you are reading this, you are most probably on the right path. But how do you know where to start? Just like our health, before any treatment can be prescribed, a diagnosis is required. When it comes to...
Most people in your company are not database experts. They are interested in something other than databases and ELT programs. They want information that supports their work needs. Human beings are visual creatures, and interactive dashboards are visual data expressions. Dashboards enable everyone to see, understand...
The plans, quotes and project deliverables your selected consulting partner helped you develop should include a proof-of-concept project recommendation based on your combined due diligence. The proof-of-concept (POC) sprint is a crucial subproject that tests your platform and software selections. The first dashboards your end users...
Data workflows are like hiking boots — good-fitting ones can take you anywhere. Ill-fitting ones spawn misery. As you document the existing workflows in discovery meetings, these details will influence your software selections — the tools for the data workflows. The amount and type of work...
If you’re new to User-Centered Dashboard Development (UCDD), please check out the earlier posts in this series (also found at the bottom of this post) to get acclimated, then come back here! We’re almost to the end of our UCDD Framework and today will cover phase...
An essential part of any business intelligence system plan is to collect information on the vital data workflows within your company. An ounce of discovery is worth a pound of remediation. -Adapted from Benjamin Franklin During discovery, identify the business processes that comprise operations and provide data outputs....
One of the reasons I gravitated towards a career in data visualization was just that — the visualizations. My background is in the visual arts and to see data, facts and numbers, concepts and correlations, all brilliantly designed and represented in colorful graphs activated both...
As data grows more and more entrenched into everyday business decisions, the importance of questioning our data and how we interpret it becomes vital. At InterWorks, we work with all different types of data, organizations and decisions. We know the impact that data can have,...
In the previous post (that you can read here), we started doing some analysis on airline reviews. We did very basic data preparation, used the Dataiku Sentiment Analysis plugin and evaluated the model with the help of a confusion matrix. In this blogpost, we will...
A strategy vision roadmap (SVR) is a document that details the purpose of the project, expected benefits, training plans, project timeframe, proof-of-concept testing and validation. The SVR summarizes the overall project plan while also time-phasing all significant sub-projects (sprints) necessary to complete all the deliverables....
In this post, I'll cover team composition, focusing on technical and operational staff that will form the core of your team. The need for more detailed information about your business drives the desire to deploy a BI system. Typical goals include achieving better reporting, more detailed...
One thing I noticed: there's one last step that I always take before heading out into the street with two overflowing grocery bags. Just before the exit, I push the handicap door opener on my right. And it stays open long enough for me and...
Exciting news for Tableau users! With version 2022.4, Tableau has introduced the highly anticipated PROPER() function. This function makes it easy to transform string data into title case format, where the first letter of each word is capitalized, and all other letters are in lowercase. It...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072
