REGISTER   |   LOGIN   |   HELP
Home  |  Blogs  |  Message Boards  |  Webinars  |  Resources |  By Channel
Fabian Pascal

Down to the Basics of Business Modeling Concepts

NO RATINGS
View Comments: Oldest First | Newest First | Threaded View
BethSchultz
User Rank
Blogger
Best practice?
BethSchultz   1/16/2013 5:36:47 PM
NO RATINGS
Hi Fabian, I like the idea of laying out the definitions in this way. What's your advice on how to make sure people within a company are all working from the same dictionary, so to speak, as they work on their business modeling? Should they have a document with all of their terms spelled out, for example?

dbdebunker
User Rank
Data Doctor
Re: Best practice?
dbdebunker   1/17/2013 12:02:13 PM
NO RATINGS
Hi, Beth,

Of course, how businesses do that  makes the difference between success or failure.

The large and complex databases require (1) a formal process (2) management support (3) modeler-user-manager-dba team (4) thorough knowledge of the business (5) data foundation knowledge (6) proper documentation and design tools.

I believe that except for cases of relatively simple databases used by only a few application/users, the current practice of assigning a programmer/developer to do everything from business modeling to database design to database administration to application development will usually end up with serious problems.

The notion that eschewing this saves money and time is an illusion due to scarcity of foundation knowledge: the opposite is true. The argument that modeling and design is difficult, takes a long time, is expensive and so on is certainly true, but there is no free lunch: if you want the benefits of a true db system, that's the price for it, and thinking that you can eschew it and still get the benefits is delusional. You can do it, but then you must do it consciously and aware of the benefits you give up. The ndustry caters to this delusion by promoting magic wands.

Simplicity and parsimony are critical. Given the complex nature of business reality and the above process, it is crucial that we don't pile complexity of methodology and tools on top of it. Everything should be as simple as possible, but not simpler. That's the issue that the relational model addresses and the failure to comprehend that is one of the core problems in IT.

kq4ym
User Rank
Data Doctor
Re: Best practice?
kq4ym   1/28/2013 9:02:07 AM
NO RATINGS
Good points, more than just a programmer/developer is needed to make sense and hopefully some company profits out of the data massage.

Lots of data, means lots of brainpower is needed to figure the best ways to use it, and the persistence to keep trying new ways of looking at what's going on. It's not the first result that will define the answers.

dbdebunker
User Rank
Data Doctor
Re: Best practice?
dbdebunker   1/28/2013 1:10:29 PM
NO RATINGS
All that data were generated for different purposes and, therefore, do not have a common structure to which common sound operations can be applied for analytical purposes. There is this common delusion that such data can be taken as is and, without any effort, can be mined for information.

Another aspect is a disregard for the cruacial importance the ratio of method and tool complexity to usefulness. The purpose of models is to simplify the reality of interest to the most essential and to structure it optimally for multiple analytical purposes. Complexity and lack of generality defeats their purpose. This is largely missed by both business and IT and the industry encourages the opposite.

Codd's genius was not only to apply theory to data management, but also that the theory provides an optimal ratio of simplicity to generality: the relational approach is the simplest way to deal with data that is general enough to handle a vast majority of informational needs. In my paper "Businss modeling for database design" I specify the criteria that an alternative approach must satisfy to be superior. Unless it does, we trade down. The trite statement "the right tool for the right job" more often than not reflects a lack of foundation knowledge.

Best regards,
Fabian Pascal
www.dbdebunk.com
http://en.wikipedia.org/wiki/Fabian_Pascal
http://www.linkedin.com/profile/edit?trk=tab_pro
http://dbdebunk.blogspot.com/p/about_4.html
http://dbdebunk.blogspot.com/p/papers_3.html
http://dbdebunk.blogspot.com/p/seminars.html


 

More Blogs from Fabian Pascal
The term "unstructured data" is deceptive and misleading. Every analytics operation hinges on some form of data structure.
Claims of "distributed" computing must be regarded with suspicion; setting up a properly distributed environment is no easy feat.
If you want your projects funded, you need to make concrete recommendations while accounting for the possibility of being wrong.
Here's an example that shows what happens when you engage in database practice without a good grasp of data fundamentals.
Call me a skeptic, but I don't buy the hype of systems aimed at managing and extracting information from so-called "unstructured data."
Cartoon
Most recent post: Viewer beware!
CARTOON ARCHIVE
AllAnalytics House Ad
Quick Poll
AllAnalytics Video Blogs
We'll Be Your Eyes & Ears
We'll be on the scene at SAS Global Forum events in ...

2:15

0 comments
7 Tips for Deploying ...
We chat with Analise Polsky, a data visualization ...

33:15

0 comments
Top Big Data Platforms
All Analytics editors Beth Schultz and Michael ...

31:53

3 comments
Attention on Retail Shoppers
The retail store of the future will track customers ...

02:14

16 comments
Demand-Driven Forecasting
Charles Chase, chief industry consultant for the ...

02:22

1 comment
Intelligent Labels & LE ...
Andrew Dark, CEO of Displaydata, explains the ...

03:21

0 comments
Big-Data & In-Store Analytics
SAS Institute's Lori Schafer shares insights on ...

02:31

5 comments
Privacy Protection in 7 Steps
Gaurav Pant, SVP of Research and Principal Analyst ...

03:05

1 comment
Customer Insight Drives Retail
Lori Bieda, executive lead for customer ...

02:13

13 comments
NRF BIG Show Highlights
All Analytics Executive Editor Michael Steinhart ...

02:51

7 comments
Nurturing Analytics Talent
Sarah Gates, vice president of research for the ...

02:25

4 comments
Banking on Analytics
Capgemini Senior Manager Rex Pruitt explains how ...

02:39

1 comment
360-Degree Slam Dunk
Analytics helps the Orlando Magic score higher ...

01:50

3 comments
Securing Hadoop Data
Big data often contains sensitive or protected ...

06:20

5 comments
Powerful Analytics Ecosystems
Combining Hadoop with high-performance ...

02:04

1 comment
Digital Audio
Latest Archived Broadcast
Thought-leader Tom Davenport explains why you and your company need to recognize big data's importance.
April 29th 2pm EDT Tuesday
Readerboards
Have a question or topic but don't want to write a blog? Post it on our readerboards and get feedback from the community!
MORE READERBOARDS
Live Video
On-demand Video with Chat
As retailers evolve toward an omnichannel environment, much of their success will depend on how effectively they use big-data and analytics.
Upcoming Events
for the Business and IT Communities
Executive forums with additional hands-on learning opportunities offered around the world
Each ideal for practitioners, Business leaders & senior executives
SAS Health Analytics Virtual Conference
The Health care is rapidly transforming. And there has never been a greater need for analytics. We're tackling tough challenges like data transparency, care delivery, consumer engagement, and financial and clinical risk. And there are still numerous opportunities to use health data that we haven't even tapped into.
May 14, 2014
2014 VA Interactive Roadshow -- Houston
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
May 15, 2014
Houston, Texas
2014 VA Interactive Roadshow -- New York
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
June 19, 2014
New York, New York
2014 VA Interactive Roadshow -- Rockville, MD
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
July 17, 2014
Rockville, Maryland
2014 VA Interactive Roadshow -- Detroit
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Aug. 7, 2014
Detroit, Michigan
2014 VA Interactive Roadshow -- Chicago
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Sept. 16, 2014
Chicago, Illinois
2014 VA Interactive Roadshow -- Cary, NC
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Oct. 10, 2014
Cary, North Carolina
2014 VA Interactive Roadshow -- Boston
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Nov. 4, 2014
Boston, Massachusetts
2014 VA Interactive Roadshow -- Atlanta
The 2014 VA Interactive Roadshow will feature SASŪ Data Management and SASŪ Visual Analytics experts covering topics like prepping data for VA and VA integration with SASŪ Office Analytics. This year's events will keep presentations at a minimum and focus on giving attendees hands-on exposure to the latest version of VA.
Dec. 11, 2014
Atlanta, Georgia
Analytics 2014
The The Analytics 2014 Conference is a two-day educational event for anyone who is serious about analytics. This annual event brings together hundreds of professionals, industry experts, and leading researchers in the field of analytics. Register before April 30 for the early-bird discount.
June 4 & 5, 2014
Frankfurt, Germany
AllAnalytics on Twitter
AllAnalytics Twitter Feed
AllAnalytics Videos
Intro to Visual Analytics
Find a way to visualize your data and watch it come ...

1:58

0 comments
Visual Analytics, Instant ...
Analytics results delivered in visual form are ...

2:06

2 comments
Big Data, Fast Infrastructure
Big data calls for a high-performance analytics ...

3:35

6 comments
Red Hot Analytics
Jayson Tipp, Redbox VP of Analytics and CRM, ...

3:51

5 comments
Hotelier Checks Out Analytics
InterContinental Hotels Group has woven analytics ...

06:55

11 comments
Like Us on Facebook
Point/CounterpointBlog
LEADERS FROM THE BUSINESS AND IT COMMUNITIES DUEL OVER CRITICAL TECHNOLOGY ISSUES

The Current Discussion

Visual Analytics: Who Carries the Onus?
The Issue: Data visualization is an up-and-coming technology for businesses that want to deliver analytical results in a visual way, enabling analysts the ability to spot patterns more easily and business users to absorb the insight at a glance and better understand what questions to ask of the data. But does it make more sense to train everybody to handle the visualization mandate or bring on visualization expertise? Our experts are divided on the question.
The Speakers: Hyoun Park, Principal Analyst, Nucleus Research; Jonathan Schwabish, US Economist & Data Visualizer
MORE POINT/COUNTERPOINT BLOGS
About Us  |  Contact Us  |  Help  |  Register  |  Twitter  |  Facebook  |  RSS


Beth Schultz
We'll Be Your Eyes & Ears

3|20|14   |   2:15   |   (0) comments


We'll be on the scene at SAS Global Forum events in Washington, D.C., March 23 to March 25, glad to share what we learn with our community members.
Beth Schultz
7 Tips for Deploying Visualization

3|7|14   |   33:15   |   (0) comments


We chat with Analise Polsky, a data visualization thought leader on the SAS Best Practices team, about what you need to know before you deploy data visualization.
Michael Steinhart
Choosing a Big-Data Analytics Platform

2|19|14   |   31:53   |   (3) comments


The big-data analytics market can be a confusing place. Among the vendors vying for your dollars are traditional database management providers, Hadoop startup services, and IT giants. In this video, All Analytics editors Beth Schultz and Michael Steinhart sit down in a Google+ Hangout on Air with Doug Henschen, executive editor of InformationWeek. Henschen discusses use cases for big-data analytics, purchase considerations, and his recent roundup of the top 16 big-data analytics platforms.

Related posts:

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Keeping a Close Eye on Shoppers

2|13|14   |   02:14   |   (16) comments


At the National Retail Federation BIG Show last month, All Analytics executive editor Michael Steinhart noted a host of solutions for tracking and analyzing customer activity in retail stores. From Bluetooth beacons to RFID tags to NFC connections to video analytics, retailers must find the right combination of tools to help optimize the shopper experience, streamline operations, and boost revenues.

Related posts:

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Real-Time Demand Drives Forecasting

2|11|14   |   02:22   |   (1) comment


The days when historical shipment trends and gut feelings were enough to forecast retail demand accurately are long over. SAS chief industry consultant Charles Chase outlines the benefits of pulling real-time sales information from point-of-sale and product scanner systems, then flowing that data into dynamic forecasting tools from SAS.

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Next-Gen Retail: Electronic Labels & Bluetooth Beacons

2|7|14   |   03:21   |   (0) comments


Electronic shelf-edge labels (ESLs) equipped with low-energy Bluetooth beacons enable retailers to deliver real-time customer interaction and execute dynamic pricing strategies. Andrew Dark, CEO of Displaydata, outlines the ESL architecture and explains how it integrates with backend management and analytics systems.

Related post:

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Retail Trends: Big Data Optimizes Sales & Operations

2|4|14   |   02:31   |   (5) comments


Retailers like Family Dollar and suppliers like Procter & Gamble are using big-data analytics to maximize efficiency and revenue across the entire supply chain. Lori Schafer, Executive Advisor for the SAS Institute Retail Practice, moderated a panel with executives from these companies at the National Retail Federation BIG Show in New York last month. Here, she shares insights on retail supply chain optimization and in-store customer tracking for targeted sales.
Michael Steinhart
7 Steps to Protecting Customer Privacy

1|31|14   |   03:05   |   (1) comment


EKN Research's "The Rising Importance of Customer Data Privacy in a SoLoMo Retailing Environment" report details the top challenges and opportunities that retailers face when embracing big data analytics. EKN SVP of Research and Principal Analyst Gaurav Pant explains the importance of data management and lays out seven steps that retailers can take to ensure customer privacy while reaping the benefits of big data.
Michael Steinhart
Integrating Customer Insight Across Retail Channels

1|29|14   |   02:13   |   (13) comments


Customer data is fueling a new phase of retail marketing across physical and online channels. Lori Bieda, executive lead for customer intelligence at SAS Americas, explains how integrated insight enables retailers to optimize offers and improve sales across product categories. She also shares some best-practices for leveraging analytics talent in retail.

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
National Retail Federation Show Highlights

1|27|14   |   02:51   |   (7) comments


This year's National Retail Federation BIG Show wrapped up on January 14. All Analytics executive editor Michael Steinhart reviews highlights of the conference and discusses trends around analytics, personalization, omnichannel, and retail security.

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Beth Schultz
Nurturing Analytics Talent

1|9|14   |   02:25   |   (4) comments


Sarah Gates, vice president of research for the International Institute for Analytics, shares advice on how to recruit and leverage analytics talent, whether your company is big or small.
Michael Steinhart
Analytics for Banking Regulation Compliance

1|7|14   |   02:39   |   (1) comment


In the wake of 2008's financial meltdown, banks are subject to strict regulations around the soundness of their loan portfolios. Capgemini senior manager Rex Pruitt explains how advanced transition matrices -- driven by SAS analytics tools -- help banks perform effective credit loss forecasting and meet their regulatory requirements.
Michael Steinhart
360-Degree Slam Dunk

12|24|13   |   01:50   |   (3) comments


David Bencs, assistant director of Insight and Analytics for the Orlando Magic, outlines different analytics projects and the benefits they're delivering to the NBA franchise. The team put demand-based pricing in place a few years ago, for example, and single-game ticket revenue grew 28% despite a disappointing season. Next up for the Magic is to combine social media activity, television viewership stats, and ticket sales data to achieve a 360-degree customer view.

— Michael Steinhart, Circle me on Google+ Follow me on TwitterVisit my LinkedIn pageFriend me on Facebook, Executive Editor, AllAnalytics.com

Michael Steinhart
Encryption for Hadoop & Big Data

12|9|13   |   06:20   |   (5) comments


David Tishgart, senior director of marketing and alliances at security provider Gazzang, explains the importance of data encryption for companies that are rolling out Hadoop environments to leverage big data analytics.
Michael Steinhart
Hadoop's Place in the Analytics Ecosystem

12|5|13   |   02:04   |   (1) comment


At the Strata Conference / Hadoop World 2013, Samuel Kommu, technical marketing engineer at Cisco Systems, shares some of the benefits that Hadoop brings to analytics platforms that leverage next-generation hardware. Kommu looks at big data operations that required 3,500 nodes in 2009, 2,000 in 2011, and now require only 64 nodes.
Videos
Intro to Visual Analytics

6|5|13   |   1:58   |   (0) comments


With today's advanced visual analytics tools, you can stream data into memory for real-time processing, provide users the ability to explore and manipulate the data, and bring your data to life for the business.
Videos
Visual Analytics, Instant Insight

5|16|13   |   2:06   |   (2) comments


Dynamic data visualizations let analysts and business users interact with the data, changing variables or drilling down into data points, and see results in a flash. Advance your use of data visualization with tools that support features like auto-charting, explanatory pop-ups, and mobile sharing.
Videos
Big Data, Fast Infrastructure

2|14|12   |   3:35   |   (6) comments


No doubt your enterprise is amassing loads of data for fact-based decision-making. Hand in hand with all that data comes big computational requirements. Can traditional IT infrastructure handle the increasing number and complexity of your analytical work? Probably not, which is why you need a backend rethink. Big data calls for a high-performance analytics infrastructure, as Fern Halper, a partner at the IT consulting and research firm, Hurwitz & Associates, discusses here.
Videos
Red Hot Analytics

1|10|12   |   3:51   |   (5) comments


Redbox's bright-red DVD kiosks are all but ubiquitous these days, located in more than 28,000 spots across the country. Jayson Tipp, Redbox VP of Analytics and CRM, provides an insider's look at how the company has accomplished its phenomenal nine-year growth.
Videos
Hotelier Checks In With Analytics

12|14|11   |   06:55   |   (11) comments


InterContinental Hotels Group (IHG), a seven-brand global hotelier, has woven analytics into the fabric of its operations. David Schmitt, director of performance strategy and planning, shares IHG's analytics story and his lessons learned.