Senin, 22 Juli 2013

Wow! eBook: The Data Warehouse Toolkit, 3rd Edition - 5 new eBooks


Wow! eBook: The Data Warehouse Toolkit, 3rd Edition - 5 new eBooks

Link to Wow! eBook

The Data Warehouse Toolkit, 3rd Edition

Posted: 22 Jul 2013 09:37 AM PDT

Book Description

Updated new edition of Ralph Kimball’s groundbreaking book on dimensional modeling for data warehousing and business intelligence!

The first edition of Ralph Kimball’s The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.

  • Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence
  • Begins with fundamental design recommendations and progresses through increasingly complex scenarios
  • Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more
  • Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more

Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

Table of Contents
Chapter 1. Data Warehousing, Business Intelligence, and Dimensional Modeling Primer
Chapter 2. Kimball Dimensional Modeling Techniques Overview
Chapter 3. Retail Sales
Chapter 4. Inventory
Chapter 5. Procurement
Chapter 6. Order Management
Chapter 7. Accounting
Chapter 8. Customer Relationship Management
Chapter 9. Human Resources Management
Chapter 10. Financial Service
Chapter 11. Telecommunications
Chapter 12. Transportation
Chapter 13. Education
Chapter 14. Healthcare
Chapter 15. Electronic Commerce
Chapter 16. Insurance
Chapter 17. Kimball DW/BI Lifecycle Overview
Chapter 18. Dimensional Modeling Process and Tasks
Chapter 19. ETL Subsystems and Techniques
Chapter 20. ETL System Design and Development Process and Tasks
Chapter 21. Big Data Analytics

Book Details

  • Paperback: 600 pages
  • Publisher: Wiley; 3rd Edition (July 2013)
  • Language: English
  • ISBN-10: 1118530802
  • ISBN-13: 978-1118530801
Note: There is a file embedded within this post, please visit this post to download the file.

Related Books

The post The Data Warehouse Toolkit, 3rd Edition appeared first on Wow! eBook.

Excel Dashboards and Reports, 2nd Edition

Posted: 22 Jul 2013 09:29 AM PDT

Book Description

Learn to use Excel dashboards and reports to better conceptualize data

Updated for all the latest features and capabilities of Excel 2013, this go-to resource provides you with in-depth coverage of the individual functions and tools that can be used to create compelling Excel reports. Veteran author Michael Alexander walks you through the most effective ways to present and report data. Featuring a comprehensive review of a wide array of technical and analytical concepts, this essential guide helps you go from reporting data with simple tables full of dull numbers to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.

  • Details how to analyze large amounts of data and report the results in a way that is both visually attractive and effective
  • Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly
  • Shows how to automate redundant reporting and analysis processes
  • Walks you through creating impressive dashboards, eye-catching visualizations, and real-world What-If analyses

Excel Dashboards and Reports, Second Edition is part technical manual, part analytical guidebook, and exactly what you need to become your organization’s dashboard dynamo!

Table of Contents
Part I: Getting Started with Excel Dashboards
Chapter 1. Introducing Dashboards
Chapter 2. Table Design Best Practices
Chapter 3. Using Excel Sparklines
Chapter 4. Chartless Visualization Techniques

Part II: Introducing Charts into Your Dashboards
Chapter 5. Excel Charting for the Uninitiated
Chapter 6. Working with Chart Series
Chapter 7. Formatting and Customizing Charts
Chapter 8. Components That Show Trending
Chapter 9. Components That Group Data
Chapter 10. Components That Show Performance Against a Target

Part III: Advanced Dashboarding Concepts
Chapter 11. Developing Your Data Model
Chapter 12. Adding Interactive Controls to Your Dashboard
Chapter 13. Macro-Charged Reporting

Part IV: Pivot Table Driven Dashboards
Chapter 14. Using Pivot Tables
Chapter 15. Using Pivot Charts
Chapter 16. Adding Interactivity with Slicers
Chapter 17. Using the Internal Data Model and Power View

Part V: Working with the Outside World
Chapter 18. Integrating External Data into Excel Reporting
Chapter 19. Sharing Your Work with the Outside World

Book Details

  • Paperback: 432 pages
  • Publisher: Wiley; 2nd Edition (May 2013)
  • Language: English
  • ISBN-10: 1118490428
  • ISBN-13: 978-1118490426
Note: There is a file embedded within this post, please visit this post to download the file.

Related Books

The post Excel Dashboards and Reports, 2nd Edition appeared first on Wow! eBook.

Excel 2013 Formulas

Posted: 22 Jul 2013 09:16 AM PDT

Book Description

Maximize the power of Excel 2013 formulas with this must-have Excel reference

John Walkenbach, known as “Mr. Spreadsheet,” is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more.

  • Demonstrates how to use all the latest features in Excel 2013
  • Shows how to create financial formulas and tap into the power of array formulas
  • Serves as a guide to using various lookup formulas, working with conditional formatting, and developing custom functions
  • Shares proven solutions for handling typical (and not-so-typical) Excel formula challenges
  • Includes links to the “Mr. Spreadsheet” website, which contains all the templates and worksheets used in the book, plus access to John Walkenbach’s award-winning Power Utility Pak.

From charts to PivotTables and everything in between, Excel 2013 Formulas is your formula for Excel success.

Table of Contents
Part I: Basic Information
Chapter 1. Excel in a Nutshell
Chapter 2. Basic Facts about Formulas
Chapter 3. Working with Names

Part II: Using Functions in Your Formulas
Chapter 4. Introducing Worksheet Functions
Chapter 5. Manipulating Text
Chapter 6. Working with Dates and Times
Chapter 7. Counting and Summing Techniques
Chapter 8. Using Lookup Functions
Chapter 9. Working with Tables and Lists
Chapter 10. Miscellaneous Calculations

Part III: Financial Formulas
Chapter 11. Borrowing and Investing Formulas
Chapter 12. Discounting and Depreciation Formulas
Chapter 13. Financial Schedules

Part IV: Array Formulas
Chapter 14. Introducing Arrays
Chapter 15. Performing Magic with Array Formulas

Part V: Miscellaneous Formula Techniques
Chapter 16. Importing and Cleaning Data
Chapter 17. Charting Techniques
Chapter 18. Pivot Tables
Chapter 19. Conditional Formatting
Chapter 20. Using Data Validation
Chapter 21. Creating Megaformulas
Chapter 22. Tools and Methods for Debugging Formulas

Part VI: Developing Custom Worksheet Functions
Chapter 23. Introducing VBA
Chapter 24. Function Procedure Basics
Chapter 25. VBA Programming Concepts
Chapter 26. VBA Custom Function Examples

Part VII: Appendixes
Appendix A. Excel Function Reference
Appendix B. Using Custom Number Formats

Book Details

  • Paperback: 864 pages
  • Publisher: Wiley (April 2013)
  • Language: English
  • ISBN-10: 1118490444
  • ISBN-13: 978-1118490440
Note: There is a file embedded within this post, please visit this post to download the file.

Related Books

The post Excel 2013 Formulas appeared first on Wow! eBook.

Adobe Photoshop Lightroom and Photoshop Workflow Bible

Posted: 22 Jul 2013 09:12 AM PDT

Book Description

Photos the way you like them—from raw to well done

If you want to improve your photography, this comprehensive guide and Adobe’s powerful Lightroom and Photoshop tools are just the ticket. Discover how to download your images and edit them for impact; export, print, and present them with a flourish; and carefully archive everything at the end. You’ll find step-by-step techniques, expert advice, and great ideas for getting the most done in the shortest time, thanks to these practical and creative workflows.

  • Use Lightroom and Photoshop together to form a complete workflow
  • Build a non-destructive workflow, so you don’t lose valuable content
  • Get up to speed on Lightroom’s workspace and five modules
  • Import, organize, and edit groups of photos in Lightroom
  • Use Photoshop to take special images to the next level of quality
  • Smooth out wrinkles, whiten teeth, and add even more magic

Companion Web Site Visit www.wiley.com/go/workflow and download practice files for the book’s projects. You can start with the original images and work through the author’s step-by-step instructions.

Table of Contents
Part I: Understanding the Workflow
Chapter 1. Making Your Work Flow
Chapter 2. Comparing Lightroom and Photoshop
Chapter 3. Understanding Image File Basics

Part II: Using Lightroom to Manage Your Production Workflow
Chapter 4. Understanding the Lightroom Workspace
Chapter 5. Importing Images into Lightroom
Chapter 6. Getting Organized with the Library Module
Chapter 7. Processing Photos with the Develop Module
Chapter 8. Sharing Photos with Others
Chapter 9. Creating Files to Use Outside of Lightroom
Chapter 10. Putting the Production Workflow into Action

Part III: Understanding Basic Photoshop Concepts
Chapter 11. Opening Files in Photoshop
Chapter 12. Understanding the Photoshop Workspace
Chapter 13. Adjusting Tonality and Color
Chapter 14. Working with Layers

Part IV: Going Beyond the Basics
Chapter 15. Working with Selections
Chapter 16. Creating Flexibility with Layer Masks
Chapter 17. Using Photoshop's Main Retouching Tools
Chapter 18. Using Photoshop Actionswith Lightroom

Part V: Putting the Tools to Work
Chapter 19. Creating Strategies for Success
Chapter 20. Solving Special Portrait Retouching Problems
Chapter 21. Adding Finishing Touches
Chapter 22. Putting the Creative Workflow into Action

Book Details

  • Paperback: 560 pages
  • Publisher: Wiley (September 2008)
  • Language: English
  • ISBN-10: 0470303093
  • ISBN-13: 978-0470303092
Note: There is a file embedded within this post, please visit this post to download the file.

Related Books

The post Adobe Photoshop Lightroom and Photoshop Workflow Bible appeared first on Wow! eBook.

Adobe Camera Raw for Digital Photographers Only, 2nd Edition

Posted: 22 Jul 2013 09:07 AM PDT

Book Description

Expert photographer Rob Sheppard explains the details of Camera Raw, the steps for using it, the workflow process, and certain best practices that demonstrates how Camera Raw can empower the digital photographer. Encouraging you to use it as you see fit, he explores the enhancements in the newest generation and helps you deal with RAW’s limitations, manage white balance and exposure, reduce noise (especially in night shots,) and learn to use camera settings that make the most of RAW capabilities.

From the Back Cover
Camera Raw gives you power to make your images fit your visionRob Sheppard is, first and foremost, a photographer. He believes technology can support the creative process, but should never supplant it. So when he explains the details of Camera Raw, the steps for using it, the workflow process, and certain best practices, he demonstrates how Camera Raw can empower you. That said, he encourages you not to be limited by his perspective. Use Camera Raw as you see fit — because your work is your art.

  • Explore the enhancements in the newest generation of Camera Raw
  • Deal with RAW’s limitations
  • Manage white balance and exposure
  • Learn to use camera settings that make the most of RAW capabilities
  • Understand and apply the Camera Raw workflow
  • Reduce noise, especially in night shots
  • Discover the creative possibilities of black-and-white with Camera Raw
  • Take full advantage of Camera Raw’s special features

Table of Contents
Part I: Capture Workflow.
Chapter 1. What are RAW Files Really About?
Chapter 2. Shoot RAW Right from the Start
Chapter 3. Color and RAW
Chapter 4. What's New in Adobe Camera RAW?

Part II: Camera RAW Workflow.
Chapter 5. A Quick Look at Camera RAW Tools and Workflow
Chapter 6. Workflow Applied
Chapter 7. Advanced Tonal Control
Chapter 8. White Balance Decisions
Chapter 9. The Noise Problems No One Talks About
Chapter 10. Special Features of Camera RAW

Part III: Making Camera RAW Work Harder for You.
Chapter 11. Tough Decisions
Chapter 12. Black-and-White Processing
Chapter 13. Double Processing for Exposure
Chapter 14. Post Camera Raw Processing

Book Details

  • Paperback: 362 pages
  • Publisher: Wiley; 2nd Edition (January 2008)
  • Language: English
  • ISBN-10: 0470224576
  • ISBN-13: 978-0470224571
Note: There is a file embedded within this post, please visit this post to download the file.

Related Books

The post Adobe Camera Raw for Digital Photographers Only, 2nd Edition appeared first on Wow! eBook.
Diposting oleh dummy di 22.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)