Your guide to quickly turn data into results. Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint®

SAS Server Pages have been used by SAS developers as a way of creating custom user interfaces for Web-based applications. This enhanced book offers information on how to create SAS Server Pages using the SAS 9.3 experimental procedure PROC STREAM, providing users with a foundation technology that greatly expands the capabilities of SAS for dynamic and rich content generation. By combining PROC STREAM and the Macro facility, SAS can now more easily generate any type of markup or text-based content such as HTML, XML, and CSV.

Exclusively available in electronic format, this book provides more extensive and flexible ways to develop applications using video examples of a wide range of PROC STREAM and SAS Server Pages techniques, including both Web applications and Base SAS implementations. Users can see results immediately and can access additional content and information online through embedded links. It also offers basic how-to documentation on PROC STREAM and an overview of a Portal Reporting Framework that illustrates creating custom user interfaces for stored processes within the SAS Portal.

Ideal for SAS programmers who have some knowledge of the Macro facility as well as BI users, SAS Server Pages: Generating Dynamic Content removes the difficulties associated with HTML-based content creation while providing a resource on using PROC STREAM in a dynamic, enhanced format.

Competition is becoming more intense and decision makers are encountering increasing complexity, rapid change, and higher levels of risk. In many situations, the solution is more and better computerized decision support, especially analytics and business intelligence. Today managers need to learn about and understand computerized decision support. If a business is to succeed, managers must know much more about information technology solutions. This second edition of a powerful introductory book is targeted at busy managers and MBA students who need to grasp the basics of computerized decision support, including the following: What are analytics? What is a decision support system? How can managers identify opportunities to create innovative computerized support? Inside, the author addresses these questions and some 60 more fundamental questions that are key to understanding the rapidly changing realm of computerized decision support. In a short period of time, you’ll “get up to speed” on decision support, analytics, and business intelligence.

A visual approach to data mining. Data mining has been defined as the search for useful and previously unknown patterns in large datasets, yet when faced with the task of mining a large dataset, it is not always obvious where to start and how to proceed. This book introduces a visual methodology for data mining demonstrating the application of methodology along with a sequence of exercises using VisMiner. VisMiner has been developed by the author and provides a powerful visual data mining tool enabling the reader to see the data that they are working on and to visually evaluate the models created from the data. Key features: Presents visual support for all phases of data mining including dataset preparation. Provides a comprehensive set of non-trivial datasets and problems with accompanying software. Features 3-D visualizations of multi-dimensional datasets. Gives support for spatial data analysis with GIS like features. Describes data mining algorithms with guidance on when and how to use. Accompanied by VisMiner, a visual software tool for data mining, developed specifically to bridge the gap between theory and practice. Visual Data Mining: The VisMiner Approach is designed as a hands-on work book to introduce the methodologies to students in data mining, advanced statistics, and business intelligence courses. This book provides a set of tutorials, exercises, and case studies that support students in learning data mining processes. In praise of the VisMiner approach: "What we discovered among students was that the visualization concepts and tools brought the analysis alive in a way that was broadly understood and could be used to make sound decisions with greater certainty about the outcomes"—Dr. James V. Hansen, J. Owen Cherrington Professor, Marriott School, Brigham Young University, USA "Students learn best when they are able to visualize relationships between data and results during the data mining process. VisMiner is easy to learn and yet offers great visualization capabilities throughout the data mining process. My students liked it very much and so did I." —Dr. Douglas Dean, Assoc. Professor of Information Systems, Marriott School, Brigham Young University, USA

Open Source BI solutions have many advantages over traditional proprietary software, from offering lower initial costs to more flexible support and integration options; but, until now, there has been no comprehensive guide to the complete offerings of the OS BI market. Writing for IT managers and business analysts without bias toward any BI suite, industry insider Lyndsay Wise covers the benefits and challenges of all available open source BI systems and tools, enabling readers to identify the solutions and technologies that best meet their business needs. Wise compares and contrasts types of OS BI and proprietary tools on the market, including Pentaho, Jaspersoft, RapidMiner, SpagoBI, BIRT, and many more. Real-world case studies and project templates clarify the steps involved in implementing open source BI, saving new users the time and trouble of developing their own solutions from scratch. For business managers who are hard pressed to indentify the best BI solutions and software for their companies, this book provides a practical guide to evaluating the ROI of open source versus traditional BI deployments. The only book to provide complete coverage of all open source BI systems and tools specifically for business managers, without bias toward any OS BI suite A practical, step-by-step guide to implementing OS BI solutions that maximize ROI Comprehensive coverage of all open source systems and tools, including architectures, data integration, support, optimization, data mining, data warehousing, and interoperability Case studies and project templates enable readers to evaluate the benefits and tradeoffs of all OS BI options without having to spend time developing their own solutions from scratch

In 'QlikView 11 for Developers', you will learn how to leverage QlikView to create robust, insightful business intelligence applications. By following the case study of HighCloud Airlines, this book offers a practical, step-by-step guide to developing and mastering QlikView to address real-world data analysis needs. What this Book will help me do Build comprehensive QlikView dashboards with advanced techniques. Understand how to create associative data models by integrating different data sources. Design interactive user interfaces to enable insightful analysis. Apply best practices in QlikView scripting to transform and prepare data. Master QlikView's built-in functions for calculations and analyses. Author(s) The authors of 'QlikView 11 for Developers' bring extensive experience in business intelligence and QlikView application development. With backgrounds in software engineering and data visualization, they combine technical rigor with practical insights. Their teaching approach ensures concepts are accessible and actionable for a wide range of learners. Who is it for? This book is ideal for software developers and data analysts who want to harness QlikView to build business intelligence applications. It is tailored for those with a basic understanding of business intelligence looking to deepen their expertise in QlikView. The content is also valuable for power users seeking efficiency through advanced features. Readers will gain practical, hands-on knowledge by following this guide.

IBM® Cognos® Business Intelligence (BI) provides a proven enterprise BI platform with an open data strategy, providing customers with the ability to leverage data from any source, package it into a business model, and make it available to consumers in various interfaces that are tailored to the task. IBM Cognos Dynamic Cubes complements the existing Cognos BI capabilities and continues the tradition of an open data model. It focuses on extending the scalability of the IBM Cognos platform to enable speed-of-thought analytics over terabytes of enterprise data, without having to invest in a new data warehouse appliance. This capability adds a new level of query intelligence so you can unleash the power of your enterprise data warehouse. This IBM Redbooks® publication addresses IBM Cognos Business Intelligence V10.2 and specifically, the IBM Cognos Dynamic Cubes capabilities. This book can help you in the following ways: Understand core features of the Dynamic Cubes capabilities of IBM Cognos BI V10.2 Learn by example with practical scenarios using the IBM Cognos samples

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

Fundamentals of Predictive Analytics with JMP bridges the gap between courses on basic statistics, which focus on univariate and bivariate analysis, and courses on data mining/predictive analytics. This book provides the technical knowledge and problem-solving skills needed to perform real data multivariate analysis. Utilizing JMP 10 and JMP Pro, this book offers new and enhanced resources, including an add-in to Microsoft Excel, Graph Builder, and data mining capabilities.

Written for students in undergraduate and graduate statistics courses, this book first teaches students to recognize when it is appropriate to use the tool, to understand what variables and data are required, and to know what the results might be. Second, it teaches them how to interpret the results, followed by step-by-step instructions on how and where to perform and evaluate the analysis in JMP.

With the new emphasis on business intelligence, business analytics and predictive analytics, this book is invaluable to everyone who needs to expand their knowledge of statistics and apply real problem-solving analysis.

This book is part of the SAS Press program.

Practical Text Mining and Statistical Analysis for Non-structured Text Data Applications brings together all the information, tools and methods a professional will need to efficiently use text mining applications and statistical analysis. Winner of a 2012 PROSE Award in Computing and Information Sciences from the Association of American Publishers, this book presents a comprehensive how-to reference that shows the user how to conduct text mining and statistically analyze results. In addition to providing an in-depth examination of core text mining and link detection tools, methods and operations, the book examines advanced preprocessing techniques, knowledge representation considerations, and visualization approaches. Finally, the book explores current real-world, mission-critical applications of text mining and link detection using real world example tutorials in such varied fields as corporate, finance, business intelligence, genomics research, and counterterrorism activities. The world contains an unimaginably vast amount of digital information which is getting ever vaster ever more rapidly. This makes it possible to do many things that previously could not be done: spot business trends, prevent diseases, combat crime and so on. Managed well, the textual data can be used to unlock new sources of economic value, provide fresh insights into science and hold governments to account. As the Internet expands and our natural capacity to process the unstructured text that it contains diminishes, the value of text mining for information retrieval and search will increase dramatically. Extensive case studies, most in a tutorial format, allow the reader to 'click through' the example using a software program, thus learning to conduct text mining analyses in the most rapid manner of learning possible Numerous examples, tutorials, power points and datasets available via companion website on Elsevierdirect.com Glossary of text mining terms provided in the appendix

The only official guide to building effective business solutions with TM1 from IBM Cognos IBM Cognos TM1: The Official Guide offers complete coverage of the 64-bit in-memory online analytical processing (OLAP) engine. Based on the newest release, TM1 10, this official guide offers an advanced tutorial for TM1 concepts from a technical and a business point of view. The authors, members of the TM1 team, provide typical business examples and technical insights for building practical solutions, based on their own experiences. Emphasis is placed on teaching best practices and expanding skills to learn the more powerful capabilities of TM1. The book covers analytical processing, data entry, simulation, workflow components, and more. : IBM Cognos TM1: The Official Guide The first and only officially endorsed book on IBM Cognos TM1 Written by members of IBM Cognos TM1 team with combined experience of 50 years with the product Provides working solutions for relevant business problems Offers deep insights into the most powerful and undocumented capabilities of TM1 Explains how to build actionable business intelligence

IBM Cognos 10 is the next generation off the leading performance management, analysis, and reporting standard for mid- to large-sized companies. One of the most exciting and useful aspects of IBM Cognos software is its powerful custom report creation capabilities. After learning the basics, report authors in the enterprise need to apply the technology to reports in their actual, complex work environment. This book provides that advanced know how. Using practical examples based on years of teaching experiences as IBM Cognos instructors, the authors provide you with examples of typical advanced reporting designs and complex queries in reports. The reporting solutions in this book can be directly used in a variety of real-world scenarios to provide answers to your business problems today. The complexity of the queries and the application of design principles go well beyond basic course content or introductory books. IBM Cognos 10 Report Studio: Practical Examples will help you find the answers to specific questions based on your data and your business model. It will use a combination tutorial and cookbook approach to show real-world IBM Cognos 10 Report Studio solutions. If you are still using IBM Cognos 8 BI Report Studio, many of the examples have been tested against this platform as well. The final chapter has been dedicated to showing those features that are unique to the latest version of this powerful reporting solution.

The world-wide developer community has downloaded over ten million copies of BIRT (Business Intelligence and Reporting Tools). Built on the open-source Eclipse platform, BIRT is a powerful reporting system that provides an end-to-end solution from creating and deploying reports to integrating report capabilities in enterprise applications. introduces programmers to BIRT architecture and the reporting framework. BIRT technology makes it possible for programmers to build customized reports using scripting and BIRT APIs. This book also includes extensive examples of how to use the Eclipse Plug-in Development Environment to build plug-ins to extend the features of the BIRT framework. The source code for these examples is available for download at www.eclipse.org/birt. Integrating and Extending BIRT, Third Edition, Key topics covered include Installing and deploying BIRT Deploying a BIRT report to an application server Understanding BIRT architecture Scripting in a BIRT report design Integrating BIRT functionality into applications Working with the BIRT extension framework This revised and expanded third edition features the following new content Updated architectural diagrams Expanded scripting examples Debugging event handlers Developing an advanced report item with data binding Developing a data extraction extension Developing a charting extension Readers may also be interested in this book’s companion volume. BIRT: A Field Guide, Third Edition, is the authoritative guide to using BIRT Report Designer, the graphical tool that enables users of all levels to build reports, from simple to complex, without programming.

This unique book-and-video package introduces SharePoint® 2010 Business Intelligence Learn to build and deliver SharePoint BI applications Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book-and-video package shows you how to successfully build and deliver BI applications using SharePoint 2010. Assuming no previous SharePoint experience, the authors deliver a clear explanation of what SharePoint will do for your BI and information management capabilities. Each lesson in the book is reinforced with a helpful tutorial on the video and cover topics such as interactive reporting with Excel, document sharing for collaborative reporting, and controlling data sources. As you learn best practices for configuring and securing SharePoint 2010 BI applications and planning and implementing your SharePoint BI project plan, you'll be well on your way to gaining a solid foundation of understanding and working with SharePoint 2010 and BI. Provides an invaluable training book-and-video package that takes you through building and delivering BI applications using SharePoint 2010 Features an accompanying video tutorial for each lesson covered in the book, along with a "Try It" section at the end of each lesson Covers interactive reporting with excel Covers Power Pivot advanced analytics Details report and document sharing for collaborative reportingShows how to use SharePoint lists and libraries for data sources repositories in your BI projects Explains how to control data sources, reports and business intelligence content with permissions and workflow approvals. With this unique book-and-video combo, you'll be well on your way to successfully building and delivering BI applications using SharePoint 2010.

More than seven million people have downloaded BIRT (Business Intelligence and Reporting Tools) from the Eclipse web site, and more than one million developers are estimated to be using BIRT. Built on the open source Eclipse platform, BIRT is a powerful report development system that provides an end-to-end solution–from creating and deploying reports to integrating report capabilities in enterprise applications. The first in a two-book series about this exciting technology, is the authoritative guide to using BIRT Report Designer, the graphical tool that enables users of all levels to build reports, from simple to complex, without programming. BIRT: A Field Guide to Reporting, Third Edition, This book is an essential resource for users who want to create presentation-quality reports quickly. The extensive examples, step-by-step instructions, and abundant illustrations help new users develop report design skills. Power users can find the information they need to make the most of the product’s rich set of features to build sophisticated and compelling reports. Readers of this book learn how to Design effective corporate reports that convey complex business information using images, charts, tables, and cross tabs Build reports using data from multiple sources, including databases, spreadsheets, web services, and XML documents Enliven reports with interactive features, such as hyperlinks, tooltips, and highlighting Create reports using a consistent style, and, drawing on templates and libraries of reusable elements, collaborate with other report designers Localize reports for an international audience The third edition, newly revised for BIRT 2.6, adds updated examples, contains close to 1,000 new and replacement screenshots, and covers all the new and improved product features, including Result-set sharing to create dashboard-style reports Data collation conforming to local conventions Using cube data in charts, new chart types, and functionality Displaying bidirectional text, used in right-to-left languages Numerous enhancements to cross tabs, page management, and report layout

Tips, techniques, and trends on harnessing dashboard technology to optimize business performance In Performance Dashboards, Second Edition, author Wayne Eckerson explains what dashboards are, where they can be used, and why they are important to measuring and managing performance. As Director of Research for The Data Warehousing Institute, a worldwide association of business intelligence professionals, Eckerson interviewed dozens of organizations that have built various types of performance dashboards in different industries and lines of business. Their practical insights explore how you can effectively turbo-charge performance–management initiatives with dashboard technology. Includes all-new case studies, industry research, news chapters on "Architecting Performance Dashboards" and "Launching and Managing the Project" and updated information on designing KPIs, designing dashboard displays, integrating dashboards, and types of dashboards. Provides a solid foundation for understanding performance dashboards, business intelligence, and performance management Addresses the next generation of performance dashboards, such as Mashboards and Visual Discovery tools, and including new techniques for designing dashboards and developing key performance indicators Offers guidance on how to incorporate predictive analytics, what-if modeling, collaboration, and advanced visualization techniques This updated book, which is 75% rewritten, provides a foundation for understanding performance dashboards, business intelligence, and performance management to optimize performance and accelerate results.

Data Mining for Business Intelligence, Second Edition uses real data and actual cases to illustrate the applicability of data mining (DM) intelligence in the development of successful business models. Featuring complimentary access to XLMiner®, the Microsoft Office Excel® add-in, this book allows readers to follow along and implement algorithms at their own speed, with a minimal learning curve. In addition, students and practitioners of DM techniques are presented with hands-on, business-oriented applications. An abundant amount of exercises and examples, now doubled in number in the second edition, are provided to motivate learning and understanding. This book helps readers understand the beneficial relationship that can be established between DM and smart business practices, and is an excellent learning tool for creating valuable strategies and making wiser business decisions. New topics include detailed coverage of visualization (enhanced by Spotfire subroutines) and time series forecasting, among a host of other subject matter.

IBM® Cognos® Business Intelligence (BI) helps organizations meet This IBM Redbooks® publication addresses IBM Cognos Business Intelligence V10.1. You can use this book to: This book uses a fictional business scenario to demonstrate the power of IBM Cognos BI. The book is primarily focused on the roles of Advanced Business User, Professional Report Author, Modeler, Administrator, and IT Architect.

This book introduces PowerPivot in Excel 2010 to power users and data analysts who want to use Excel as a business intelligence tool.

A book-and-video introduction to Microsoft's Business Intelligence tools If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book and accompanying video provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the book and videos on the accompanying Video on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint. Integrates instructional videos with each of the lessons found in the book to enhance your learning experience Explores the Microsoft Business Intelligence (BI) toolset as well as the new BI features of Office 2010 Encourages you to practice what you've learned in "Try It Out" sections Contains video demonstrations that walk you through how to tackle each lesson featured in the book With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book-and-video package so that you can get started working with the BI toolset immediately!