Showing posts with label Data modeling. Show all posts
Showing posts with label Data modeling. Show all posts

Monday, 16 April 2012

Data Modeling Made Simple with CA ERwin Data Modeler r8

CA Erwin Data Modeler r8 simple business data modeling concepts or computer modeling of operational data and have sufficient knowledge of best practice has been to provide a professional and how to apply these principles, r8 CA Erwin Data Modeler. CA Erwin Data Modeler with before and after control of the more advanced features, based on the book, many along the path of CA Erwin data model we build. This book is a real world experience and the earth, humor, and even cartoons to help you master the following ten goals to help assemble best practices with Down syndrome:
  • The basic concepts of data modeling and relational theory, and how to apply these skills through CA Erwin Data Modeler
  • When reading a book with the same confidence in any size and complexity of a data model Read
  • Conceptual models, logical and physical layers, and how CA Erwin data modelers’ architecture designs to build these models to understand the difference between
  • Techniques both top-down and bottom-up design, and vice versa for the engineering front and rear, and physics to effectively implement a design to convert a logical data model
  • Naming standards, the new domain and create, CA Erwin Data Modeler and UDPS, templates and models to increase the company's quality and consistency of data, increasing to reduce the modeling time
  • Form modeling techniques and design, reporting and exchange of Meta data model that uses a variety of information sharing with the public
  • To create a workflow that meets your personal needs r8 CA Erwin Data Modeler, use the customization features, the new work area
  • Communications metadata and import / export with Microsoft Excel for bulk editing r8 CA ERwin Data Modeler updated to take advantage of new features
  • Fill Compare features CA Erwin data modelers and model comparison and merge changes
  • Themes, plots, themes, screensavers and much more through the use of their data models and optimize the layout of the organization


Part I provides an overview of data modeling: what is needed and why. CA Erwin Data Modeler is a basic simple functionality, introduced by a set of easy to follow.

Part II entities, relationships, keys, and provides the basic components of a data model that contains more. -Using the examples of how CA Erwin Data Modeler, these building blocks and scenarios "real world" context is given for each.

Hotels with the creation of new standards in Section III, and the importance of the organization. CA Erwin data modeling as a standard, such as UDPS creates a domain-specific properties such as the creation of this section to share with the creation of models, CA Erwin data modeling examples of these standards include a step by step how to create end-user through standard reports and queries.

Section IV, conceptual models, logical and physical data, discusses, and CA Erwin architecture design layer, to show the relationships between these models using CA Erwin Data Modeler provides a complete case study. Building real-world examples of conceptual data models, logical and physical r8 CA Erwin Data Modeler and tedious details, hands, working with commercial sponsors, gathering requirements is provided.

Tom Bilcze, CA Community Technology user modeling world from the preface of the President

R8 CA Erwin Data Modeler Data modeling is an excellent resource for the community is made simple with Erwin. With liberal use of images, data, graphics data models inexperienced Modeler to create the components and how they went R8 CA Erwin. As an experienced data modeler, Steve and Donna is my art form of life to make me a new and better r8 gives a guide to effective use.

About the Author

About Donna

Donna Burbank has a unique perspective in the field of data modeling - and the main tools to help design and market modeling metadata now have a variety of products, and spent many years in as a consultant to implement these solutions. As a consultant, worked with Global 2000 companies worldwide and as a software provider, Platinum Technology, Embarcadero Technologies, CA Technologies and Development efforts have been effective. Currently, senior director of product marketing for CA technologies.

About Steve

Steve Hoberman practice data modeling instructor in the world. Steve serious time and construction of software systems with the realities of budget and human limitations, data modeling and precision balances in form. Consultation and training with minimal investment in fruit models data modeling tools, and focuses on the principles. Taught his first class in 1992, data modeling and data modeling and business intelligence since then over 10,000 people trained. Steve data modeling, design of data model challenges the group's founder and ScorecardA, A ® inventor of the author of five books.

Wednesday, 11 April 2012

SAP BW Performance Optimization Guide

This book analyzes and optimizes the performance of SAP BW version 3.5 offers a comprehensive guide. First, the author of SAP BW (architecture, data modeling), a systematic specific data such as key tools for performance analysis methods and an introduction to basic concepts of design tips.

Then, indexes, statistics, databases and optimize the benefits of expert knowledge on critical aspects of performance reporting. Performance of extraction and loading, as the full length chapter’s deal with aggregates. In addition, compression and partitioning large InfoCubes will be discussed.

This unique reference managers of knowledge, practical advice and effective analysis and provides all the tools necessary to adjust the performance of your BW. In addition, when developers BW contain any detailed description of payload design and expert advice.

Features of SAP BW Performance Optimization Guide:

  • BW architecture, sizing and modeling data

  • Analysis of the system load

  • Indices and statistical database

  • OLAP Cache, query monitor and trace the declaration of biological warfare agent, by the end of the performance of the network, applications and Bex workbooks: Performance Report

  • Aggregates

  • Compression and Partitioning

  • Extraction efficiency and load: data sources, techniques of data flow, communication, and transfer a permanent staging area, aspects of performance load, extraction processes and data integration of data processing

  • Updating InfoCubes and ODS Objects

About the Author

Thomas Schroder Ader management consultant in the field of Finance Transformation Consulting Capgemini Deutschland GmbH,, Germany's request. His consulting work, business intelligence, business analysis, data modeling, architectures, data storage, and focuses on strategies for SAP BW.

Monday, 26 March 2012

SAP NetWeaver BW and SAP BusinessObjects: The Comprehensive Guide (English and German Edition)

This book is the front-end SAP NetWeaver BW and SAP BI and SAP BusinessObjects business intelligence tools, and with numerous data warehouse is a unique resource that covers all issues related offers.

Firstly, I must be clear: I'm a book more comprehensive and well written is simply because; they say the best books of BusinessObjects BW and the market (since 2006 have all of them).

795 pages these book details simple examples and clear suggestions, and a general description of each vehicle. Almost all pages containing the phrase "we recommend that you ...." and a test of a simple prose "you" and "us" was written. This book is an easy to read and understand things quickly. Best of all, the book is clear that certain books, such as BusinessObjects, did not return to show PowerPoint slides.

Section are:

1. Basics of BI - 57 pages introductory text for beginners (ideal for students and new employees)

2. High-end PC with a summary of the data storage and explanation BusinessObjects pages 70 - Summary of BW 7.3 and BI 4.0. This is well written and is unique to the computer and the latest version of CREATE.

3. Data modeling - This text refers to this approach is invaluable for BW InfoCubes, DSO, data flows, aggregates, BWA, and how to build a solid real "meat" on page 188.

4. Extraction - 32 pages. It is very short, but covers the basics of how to install BW 7.3. I LBWE tamponade for activation of the passenger, I would like to learn more about how to write optimized DSO. However, it covers all the bases...

5th. Management - 30 A short chapters dealing with transportation. The core team of experienced agents and even the all important enough to be useful for the "meat" there.

6. Permissions: 26 pages. Consume more than 2-3 points in this important subject; a book is nice to see BW. I have this book (more a part of the CREATE and integration of the update HANA) of this section, we expect to see in the next edition.

7. 36 pages - SAP BusinessObjects BI Platform. The weakest part of this book. BI launcher more public folders, tray, server management, sent, but should provide a good starting point for beginners.

8. Bex Query Designer - 63 pages. These authors understand the BEx query is an essential element of the BI landscape is really great to see that. BW BI features as I go through the analysis engine, and only DRGS (crap performance), and InfoCubes (create tools to connect directly suggest avoiding the so-called "expert" analysis engine and BI shudder when I read a book all functions). These authors, "he" and find all these great parts of this publication should be CREATE.

9. Advisory navigation - 15 pages. Other books often lack basic navigational equipment

10. BEx Analyzer - 22 pages. The vast majority of users of BW is good for older vehicles are used by the "wink".

11. The analysis of BusinessObjects - 20 pages. BEx Analyzer chapter in this section that the authors understand that this Chapter 10 shows that the replacement vehicle. Good comparison and contrast...

12. BEx Analyzer - Basic concepts and application templates, web design, 37 pages covering the basic level. Instead, both the (page 59 would be exposed to each other) within the host Bex Analyzer (Excel, Web etc.), such as division of the vehicle. Well done!

14. BusinessObjects Web
15. Crystal Reports
16. SAP Dashboards (Xcelsius)
17. SAP BO Explorer

All tools and expect a good example of the point "gotcha" on page 77 of this perspective on it. Suggestions or screenshots of a single clear and easy to follow demonstrations. I have examples a little more, but (Brog, BusinessObjects Web Intelligence by Sinkwitz and Holden), these sections (for example, "Dashboards by Lai and food Hacking BusinessObjects 4.0), and complement, are each areas there are books instead of another 3 to 4 a book, because everything. However, making the very important value in four sections of the book.

18. Integrated Planning - 13 pages. This technology is probably (instead of PCBs) at the point of death, this section really need to enhance or restore. 13 pages only a very small number.

19. SAP SEM BCS - 17 pages. This book (dead technology) is not part and should be removed.

Glossary - 10 pages - Unbelievable! If you do not need so much more.
Basic code tables and transactions - 8 pages - Awesome (more please!)
Notes for SAP - 4 pages (again, please do more, but its great!)

In general, the book is very, very, very, well, I was assigned to the SAP University Alliance, and all my students use it and the next step ... Highly Recommended!

Dr. Berg

SAP BI North America, Inc. Comerit (SAP Alliance and professor at the University) Vice-President


Sunday, 15 January 2012

SAP Business Intelligence (BI)

This book is a new version of SAP NetWeaver 2004s provides very detailed information on all the important features of BI. Readers gain a deep understanding of SAP BI and quickly, avoiding costly mistakes, learn to master the new version.

Data modeling, ETL, web reporting, and planning issues, such as new BI functions and core concepts in common, every day for work so this is an invaluable reference for knowledge of expert associated with his friend. The authors provide, Bex Analyzer and BEx Web Application Designer and Bex Report Designer, the BI Integrated Planning, BI Accelerator, and SAP Visual Composer, the question is a practical guide for other developments considered more important than specific details. Real-world examples, screen shots and step by step instructions, detailed maps and volumes quickly and easily allows you to familiarize yourself with the new features in BI.

The book, SAP consultants, team members and managers of IT, BI, and is designed to control.

Characteristics of SAP Business Intelligence (BI):

  • Concepts of Business Intelligence 
  • New features of SAP NetWeaver 
  • 2004 
  • Database Manager 
  • Machine
  • Data Recovery
  • Performance Optimization with BI accelerator and aggregates
  • Redesign functions: distribution and modification
  • BEx Query Designer
  • Analysis BEx
  • BEx Web Application DesignerReport Designer 
  • BI-Integrated Planning 
  • Visual Composer

About the Author
The authors are recognized experts CubeServ BI group. Since 1998, specializing in business intelligence solutions, the Group of SAP BW, SAP SEM and SAP NetWeaver for the implementation of the project has considerable experience of hundreds CubeServ.