Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business with this book and eBook.

The authorized guide to the latest edition of the #1 business intelligence software product - Crystal Reports. More than 16 million licenses of Crystal Reports have been shipped to date. This book is a reference designed to provide hands-on guidance for the latest release of the product suite. The latest version of Crystal Reports and the Business Objects enterprise reporting suite delivers vast product enhancements and a tighter integration that will drive upgrades from licensees. Brand new features (e.g. Dynamic and Cascading Parameter Generation) will also appeal to new audiences. Over 1 million new Business Intelligence licensees will be migrating to the Crystal Enterprise Reporting platform, as this is the first release of the software with the existing Business Objects (BO) products being integrated into the Crystal infrastructure. As Business Objects insiders, the authors bring unique and valuable real-world perspectives on implementations and uses of the Crystal Reports product. The book also includes content, tutorials and samples for reporting within the Microsoft Visual Studio.NET and J2EE development environments and also on top of the SAP Business Information Warehouse (BW) and the Peoplesoft platform. Advanced content on report distribution and integration into the secured managed reporting solution known as Business Objects Enterprise XI, is also now included in this definitive user guide with coverage on the new Web Services SDK.

This best-seller has been fully updated for Crystal Reports XI (extreme insight) -- the first jointly developed release of this leading report writing and analysis software since the acquisition of Crystal Decisions by Business Objects. Readers will learn to create visually appealing reports that communicate content effectively using helpful features such as charts, complex formulas, custom functions, sorting and grouping, Business Views, and more. Publishing and viewing reports on the Web is also explained in detail. NEW coverage includes: All the new user interface elements; New Dynamic/Cascading Parameter Fields; and, Using Crystal Reports with Business Objects Enterprise XI.

Fourth Edition - The Beginner's Guide to Crystal Reports 2016 was written as a quick start guide for beginners, and not intended as a comprehensive reference manual. The beginner-level skills of Crystal Reports is easy to learn and can be achieved within a few hours of hands-on learning. With an established data source connection, learning and using Crystal Reports 2016 is as easy as using Microsoft Office. Learn how to setup a data connection, examine a data structure, create a new report, add data fields, format a report, add pictures, charts and create formulas. See how to filter data, setup user parameters and create a summary report with drill-down features. This book demystifies the complexity of learning Crystal Reports and presents it as a user-friendly application. This book is currently used in corporate training focused primarily for non-programmers how to extract system data and create basic reports. This book is intended to provide the reader the basic skills at creating simple reports and the confidence to learn additional skills independently. This book is NOT a reference manual.

Implement SAP HANA as a standalone data warehouse Integrate SAP Data Services and the SAP BusinessObjects BI tools with SAP HANA Benefit from step-by-step instructions, technical details, and downloadable data for every step In the new SAP HANA era, processes that once took weeks now take days, hours, or even minutes. Truly take advantage of this bold jump forward with this resource for a standalone SAP HANA implementation. Master data loading with SAP Data Services, data modeling in SAP HANA, and then SAP HANA integration with SAP BusinessObjects BI for reporting and analytics. From general concepts to specific implementation steps and a real-world case study, this book offers the practical details about implementing SAP HANA that will shift your system into high gear. Data Storage See how SAP HANA has fundamentally changed data storage with column store tables that improve compression and, consequently, performance. SAP Data Services Avoid fast trash. Preprovision your data using source system analysis, profiling tools, and mapping to load high-quality data into SAP HANA.SAP HANA Studio Dive into SAP HANA-specific data modelling components like the attribute, analytic, and calculation views that produce quality multidimensional models. Connecting SAP HANA with BI Deliver sophisticated data visualization and analysis by integrating SAP BusinessObjects Design Studio, SAP Lumira, SAP Predictive Analysis, and more with SAP HANA. Hands-On Case Study Take SAP HANA for a test drive. Download the data for the fictitious AdventureWorks Cycle Company s implementation and follow along every step of the way. Highlights Source system analysis SAP Data Services Analytic, attribute, and calculation views SAP HANA Studio Columnar database technology Denormalization Information Design Tool SAP Information Steward SAP Predictive Analysis SAP BusinessObjects BI toolset SAP Lumira

The definitive reference for building actionable business intelligence—completely revised for SAP BusinessObjects BI 4.0. Unleash the full potential of business intelligence with fact-based decisions, aligned to business goals, using reports and dashboards that lead from insight to action. SAP BusinessObjects BI 4.0: The Complete Reference offers completely updated coverage of the latest BI platform. Find out how to work with the new Information Design Tool to create universes that access multiple data sources and SAP BW. See how to translate complex business questions into highly efficient Web Intelligence queries and publish your results to the BI Launchpad. Learn how to create dashboards from data sourced through a universe or spreadsheet. The most important concepts for universe designers, report and dashboard authors, and business analysts are fully explained and illustrated by screenshots, diagrams, and step-by-step instructions. Establish and evolve BI goals Maximize your BI investments by offering the right module to the right user Create robust universes with the Information Design Tool, leveraging multiple data sources, derived tables, aggregate awareness, and parameters Develop a security plan that is scalable and flexible Design Web Intelligence reports from basic to advanced Create sophisticated calculations and advanced formatting to highlight critical business trends Build powerful dashboards to embed in PowerPoint or the BI Launchpad Use Explorer to visually navigate large data sets and uncover patterns

Take a detailed look at the internal architecture of T-SQL--and unveil the power of set-based querying--with comprehensive reference and advice from the experts. Database developers and administrators get best practices, sample databases, and code to master the intricacies of the programming language--solving complex problems with real-world solutions. Discover how to: Understand logical and physical query processing Apply a methodology to optimize query tuning Solve relational division problems Use CTEs and ranking functions to simplify and optimize solutions Aggregate data with various techniques, including tiebreakers, pivoting, histograms, and grouping factors Use the TOP option in a query to modify data Query specialized data structures with recursive logic, materialized path, or nested sets solutions PLUS--Improve your logic and get to the heart of querying problems with logic puzzles Get code and database samples on the Web

All-in-One is all you need! This authoritative reference offers complete coverage of all material on all three Crystal Reports Certified Professional exams, including content for each of the three electives. You’ll find exam objectives at the beginning of each chapter, helpful exam tips, and end-of-chapter practice questions. The bonus CD-ROM contains a testing engine with questions found only on the CD. This comprehensive guide not only helps you pass the challenging CRCP exam, but will also serve as an invaluable on-the-job reference.

Enter the fast-paced world of SAP HANA 2.0 with this introductory guide. Begin with an exploration of the technological backbone of SAP HANA as a database and platform. Then, step into key SAP HANA user roles and discover core capabilities for administration, application development, advanced analytics, security, data integration, and more. No matter how SAP HANA 2.0 fits into your business, this book is your starting point. In this book, you'll learn about: a. Technology Discover what makes an in-memory database platform. Learn about SAP HANA's journey from version 1.0 to 2.0, take a tour of your technology options, and walk through deployment scenarios and implementation requirements. b. Tools Unpack your SAP HANA toolkit. See essential tools in action, from SAP HANA cockpit and SAP HANA studio, to the SAP HANA Predictive Analytics Library and SAP HANA smart data integration. c. Key Roles Understand how to use SAP HANA as a developer, administrator, data scientist, data center architect, and more. Explore key tasks like backend programming with SQLScript, security setup with roles and authorizations, data integration with the SAP HANA Data Management Suite, and more. Highlights include: 1) Architecture 2) Administration 3) Application development 4) Analytics 5) Security 6) Data integration 7) Data architecture 8) Data center