data modeling Articles - Perficient Blogs

Posts Tagged ‘data modeling’

  • Topics
  • Industries
  • Partners





Custom Data Connector for Power BI Using MicroStrategy

The MicroStrategy platform allows custom data connectors to access data from nearly any source, which includes Microsoft Power BI. In order to bring the best of both worlds together, Perficient’s MicroStrategy experts have developed a custom data connector to help Power BI users do just that. This custom connector integrates the two products and provides […]

Read more

Trends in Governance: Enterprise Modeling is Essential

Of all the governance trends, none is more foundational and critical to the success of the governance program – indeed the organization itself – than the need for accurate, consistent, and relevant models that communicate the meaning, use, and residency of the information assets of the enterprise. Modeling not only addresses the integration and ingestion […]

Read more

Cassandra NoSQL Data Modeling Snip-pet

Data modeling in Cassandra is a little tricky and requires a combination of science and art.  Think of the Cassandra column family as a map of a map: an outer map keyed by a row key, and an inner map keyed by a column key. Both maps are sorted. To maximize Cassandra’s capabilities and for long […]

Read more

KScope14 Session: The Reverse Star Schema

This week, Perficient is exhibiting and presenting at Kscope14 in Seattle, WA.  On Monday, June 23, my colleague Patrick Abram gave a great presentation on empowering restaurant operations through analytics.  An overview of Patrick’s presentation and Perficient’s retail-focused solutions can be found in Patrick’s blog post. Today, Wednesday, June 25, I gave my presentation on […]

Read more

A Wish List for Data Modeling Technology

I was recently a panelist for a Dataversity webinar/discussion focused on the future of data modeling tools, functionality, and practice. Given the holiday season, the panelists discussed their wish list for modeling tools – from currently practical (but maybe not economically viable) to futuristic (e.g., using a 3D printer to print models for model reviews, […]

Read more

Healthcare Data Modeling Governance

I participated in a webinar/panel discussion last week hosted by Dataversity on Data Modeling Governance, which was well attended and lively. The focus was on governance of Data Models and the Data Modeling environment (e.g., tools, model repositories, standards). Data Modeling Governance is supported by Data Governance – and Data Governance benefits significantly from Data […]

Read more

PowerDesigner Tips – Model Patterns

Data model patterns identify common model structures and define how they should look and interact with other parts of the model.  PowerDesigner can assist in this process by automating the setup of objects (tables, columns, mappings) based on the pattern to be applied and ensuring consistency through the use of custom model checks. Stereotypes Anyone […]

Read more

PowerDesigner Tips – Deploying a Model

In its most basic form, deploying a data model means simply applying the model directly to a database via ODBC or a DDL script.  But that neglects much of that value in your model beyond the physical structure. Here are the steps in our model deployment process.  We’ve scripted these in the build tool, but […]

Read more

PowerDesigner Tips – Exporting Model Metadata

Once you’ve invested the time and effort into creating really solid, well documented data models, it would be really great to let some folks know about it, right!?!? If you’re using PowerDesigner, you’ve got a few options: Use the included (in some editions) web repository.  This requires the use of the model repository and displays […]

Read more

PowerDesigner Tips – Mappings in the Model

We’re constantly looking for ways to streamline the BI development process.  Data mapping (source to target) can be a complex and cumbersome process due to: Ongoing model changes – the target moves! Poor (or “loose”) communication between those mapping and the development team. Lack of consistency in collecting and documenting mappings (Excel, I’m looking at […]

Read more

PowerDesigner Tips – Column Ordering

In our standards XEM file (extended model definition), I’ve added column ordering functionality by categorizing each column and then ordering the categories. Column groups are defined in a BaseColumn template.  We have:   PRIM,0,%Primary% ROWMETA,3,%extIsRowDateMeta% META,4,%extIsMetaColumn% AKNONMETA,1,%AllKeys% BASE,2,TRUE  

Read more

PowerDesigner – Standards in Action

I love PowerDesigner.  It’s the Cadillac (Mercedes, BMW, etc.) of the modeling tools.  I love that I can do conceptual, logical, and physical data modeling.  I can do business process modeling with direct linkage to my data models.  And I can model mappings between everything for both data flow relationships (ETL mappings) and design flow […]

Read more

Creating the Canonical Modeling Environment – Part 2

Now that we’ve established what a canonical data model is, let’s talk about our objectives for what we want to achieve with our Canonical Data Model and what toolsets can be applied. In my Canonical Data Modeling environment, I want to store and manage my entities and their relationships. I want support for the Conceptual, […]

Read more

Plannning for Change – Data Modeling

As a data architect, iterative development scared the stuffing out of me at first.  I was accustomed to having the data model pretty well set up front and working hard to minimize or at least localize changes to the overall database structure.  Iterative development make change normal, so no more “holding the line!” Luckily, database […]

Read more

BI Tools – Data Modeling

Ah – my favorite topic in BI tools – data modeling and the modeling tool.  An effective data modeling tool is the primary design tool for the database tier of the BI stack and may be extended to capture the design of nearly any system component.  It’s an essential tool in the belt of all […]

Read more

Additional Tools Make Growing Performance Management Programs Agile and Scalable

At Perficient, we often talk to customers about the technical “requirements” to deliver Performance Management solutions.  Every situation is different – based on chosen platform, user counts and profiles, concurrency, hardware, OS, network, and a myriad of other items depending how deep you want to go. Especially for Business Intelligence, what we always find in […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up