The SAP BW to HANA Migration Handbook

Espresso Tutorials GmbH
Free sample

 SAP HANA has revolutionized the way we store data and architect reporting solutions. This book provides a step-by-step guide for moving an existing SAP BW system on any database to SAP HANA. Identify the differences between the database migration option (DMO) process and other options. Get sample staffing plans, tools for hardware sizing and planning, and budgeting tips for planning your migration project. Walk through the process for cleaning your SAP Business Warehouse (BW) system prior to migration and find out how doing so can reduce your SAP BW on HANA implementation costs. Walk through DMO process prerequisites and examine the SAP BW on HANA Migration Cockpit in detail. Get step-by-step instructions for executing a SAP BW on HANA migration using DMO and get tips based on lessons learned from the world’s largest DMO migration project. Walk away with best practices for monitoring the health of your SAP HANA implementation. Using practical examples, tips, and screenshots, the authors provide expert strategies to help your company’s migration project succeed.  

- Proven techniques for planning and executing a successful migration <br> 
- Building a solid migration business case  
- Sizing and optimization of SAP BW on SAP HANA  
- Step-by-step runbook for the migration process
Read more

About the author

 About the author:

Rob Frye served in the NC Army National Guard for nearly two decades and is a combat veteran of Operation Iraqi Freedom. After retiring from military service, he completed his Bachelor's degree in Computer Science at Lenoir-Rhyne University, where he was the first honor graduate with a 4.0 overall GPA. Currently, Rob is the manager of ComeritLabs, in Huntersville, NC. ComeritLabs provides infrastructure, remote development, and training services for COMERIT, Inc. Rob is an experienced SAP BusinessObjects and SAP HANA developer and has delivered training on SAP HANA and the BusinessObjects toolset in the United States, Canada, Mexico, and South Africa.


Joe Darlak, Senior Director of SAP Analytics at COMERIT Inc., has successfully implemented SAP BW at clients since 1998, including several large-scale, full lifecycle global rollouts. He has significant experience increasing the capacity, reliability, and performance of SAP BI systems, defining and implementing processes and controls to stabilize service and mitigate risk, and improving the competency and skill sets of implementation and client service teams. Recently, he architected one of the largest SAP NetWeaver BW migrations to SAP HANA on record and has been instrumental in defining best practices for SAP HANA at Fortune 100 clients. He is the lead author of SAP BW: Administration and Performance Optimization, published in 2014. Over the past decade, he presented at multiple conferences on various SAP BW performance tuning topics. He is a former principal consultant in the iAnalytics practice at PricewaterhouseCoopers and holds a Master of Business Administration degree from the McCombs School of Business at The University of Texas at Austin.


Dr. Bjarne Berg is the senior director of BI at COMERIT, Inc., and one of the most respected and dedicated thought leaders in the BI market. Prior to joining COMERIT, he was a senior manager at PwC's global data warehouse group, the director of BI at VIP Consulting, and the VP of BI at COMERIT. In these positions, he managed multi-year BI and data warehouse projects for various clients . He is an internationally recognized expert in BI and analytics, a published author in international BI journals, and a frequent speaker at major BI and SAP conferences worldwide. 

Read more
Loading...

Additional Information

Publisher
Espresso Tutorials GmbH
Read more
Published on
Mar 7, 2015
Read more
Pages
260
Read more
ISBN
9781508527619
Read more
Language
English
Read more
Genres
Computers / Databases / Data Warehousing
Read more
Content Protection
This content is DRM free.
Read more
Read Aloud
Available on Android devices
Read more
Eligible for Family Library

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:



Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

Bucketization, and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Prepare for Microsoft Exam 70-767–and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package.

Focus on the expertise measured by these objectives:

• Design, and implement, and maintain a data warehouse

• Extract, transform, and load data

• Build data quality solutionsThis Microsoft Exam Ref:

• Organizes its coverage by exam objectives

• Features strategic, what-if scenarios to challenge you

• Assumes you have working knowledge of relational database technology and incremental database extraction, as well as experience with designing ETL control flows, using and debugging SSIS packages, accessing and importing or exporting data from multiple sources, and managing a SQL data warehouse.

Implementing a SQL Data Warehouse

About the Exam

Exam 70-767 focuses on skills and knowledge required for working with relational database technology.

About Microsoft Certification

Passing this exam earns you credit toward a Microsoft Certified Professional (MCP) or Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of data warehouse management

Passing this exam as well as Exam 70-768 (Developing SQL Data Models) earns you credit toward a Microsoft Certified Solutions Associate (MCSA) SQL 2016 Business Intelligence (BI) Development certification.

See full details at: microsoft.com/learning

©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.