Oracle has evolved from a simple relational database into one of the most complex e-commerce platforms ever devised. This book presents a compendium of articles from Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators and other Oracle professionals.

Introducing Data Science teaches you how to accomplish the fundamental tasks that occupy data scientists. Using the Python language and common Python libraries, you'll experience firsthand the challenges of dealing with data at scale and gain a solid foundation in data science. About the Technology Many companies need developers with data science skills to work on projects ranging from social media marketing to machine learning. Discovering what you need to learn to begin a career as a data scientist can seem bewildering. This book is designed to help you get started. About the Book Introducing Data Science explains vital data science concepts and teaches you how to accomplish the fundamental tasks that occupy data scientists. You'll explore data visualization, graph databases, the use of NoSQL, and the data science process. You'll use the Python language and common Python libraries as you experience firsthand the challenges of dealing with data at scale. Discover how Python allows you to gain insights from data sets so big that they need to be stored on multiple machines, or from data moving so quickly that no single machine can handle it. This book gives you hands-on experience with the most popular Python data science libraries, Scikit-learn and StatsModels. After reading this book, you'll have the solid foundation you need to start a career in data science. What's Inside Handling large data Introduction to machine learning Using Python to work with data Writing data science algorithms About the Reader This book assumes you're comfortable reading code in Python or a similar language, such as C, Ruby, or JavaScript. No prior experience with data science is required. About the Authors Davy Cielen, Arno D. B. Meysman, and Mohamed Ali are the founders and managing partners of Optimately and Maiton, where they focus on developing data science projects and solutions in various sectors. Quotes Read this book if you want to get a quick overview of data science, with lots of examples to get you started! - Alvin Raj, Oracle The map that will help you navigate the data science oceans. - Marius Butuc, Shopify Covers the processes involved in data science from end to end… A complete overview. - Heather Campbell, Kainos A must-read for anyone who wants to get into the data science world. - Hector Cuesta, Big Data Bootcamp

Beginning R, Second Edition is a hands-on book showing how to use the R language, write and save R scripts, read in data files, and write custom statistical functions as well as use built in functions. This book shows the use of R in specific cases such as one-way ANOVA analysis, linear and logistic regression, data visualization, parallel processing, bootstrapping, and more. It takes a hands-on, example-based approach incorporating best practices with clear explanations of the statistics being done. It has been completely re-written since the first edition to make use of the latest packages and features in R version 3. R is a powerful open-source language and programming environment for statistics and has become the de facto standard for doing, teaching, and learning computational statistics. R is both an object-oriented language and a functional language that is easy to learn, easy to use, and completely free. A large community of dedicated R users and programmers provides an excellent source of R code, functions, and data sets, with a constantly evolving ecosystem of packages providing new functionality for data analysis. R has also become popular in commercial use at companies such as Microsoft, Google, and Oracle. Your investment in learning R is sure to pay off in the long term as R continues to grow into the go to language for data analysis and research.

Beginning R: An Introduction to Statistical Programming is a hands-on book showing how to use the R language, write and save R scripts, build and import data files, and write your own custom statistical functions. R is a powerful open-source implementation of the statistical language S, which was developed by AT&T. R has eclipsed S and the commercially-available S-Plus language, and has become the de facto standard for doing, teaching, and learning computational statistics. R is both an object-oriented language and a functional language that is easy to learn, easy to use, and completely free. A large community of dedicated R users and programmers provides an excellent source of R code, functions, and data sets. R is also becoming adopted into commercial tools such as Oracle Database. Your investment in learning R is sure to pay off in the long term as R continues to grow into the go to language for statistical exploration and research. Covers the freely-available R language for statistics Shows the use of R in specific uses case such as simulations, discrete probability solutions, one-way ANOVA analysis, and more Takes a hands-on and example-based approach incorporating best practices with clear explanations of the statistics being done What you'll learn Acquire and install R Import and export data and scripts Generate basic statistics and graphics Program in R to write custom functions Use R for interactive statistical explorations Implement simulations and other advanced techniques Who this book is for Beginning R: An Introduction to Statistical Programming is an easy-to-read book that serves as an instruction manual and reference for working professionals, professors, and students who want to learn and use R for basic statistics. It is the perfect book for anyone needing a free, capable, and powerful tool for exploring statistics and automating their use.

Design and Deliver Oracle CRM On Demand Dashboards Create custom, interactive dashboards to deliver actionable business intelligence directly to end users with help from this Oracle Press guide. Oracle CRM On Demand Dashboards provides comprehensive coverage of the versatile features available in Oracle Answers On Demand coupled with detailed planning and design strategies for building and deploying reports and dashboards with Oracle CRM On Demand. Real-world examples and time-saving formatting tips are included throughout this practical resource. Configure administrative settings to access report and dashboard development tools Take advantage of built-in dashboards Plan dashboards and reports based on business needs Create, edit, manage, save, and delete custom dashboards Configure dashboard properties and pages Add and configure dashboard objects, such as guided navigation, links, images, and folders Display and arrange reports on dashboards Develop dashboard filter prompts Deploy dashboards to Oracle CRM On Demand end users

ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more. Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help! • Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources • Analyze multiple tables together, without complicated VLOOKUPs • Format, sort, and filter data in the PowerPivot window • Add calculated columns using new DAX functions • Create powerful reports from PowerPivot data–and format them so executives instantly get your point • Discover PivotTable tricks that work even better in PowerPivot • Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers • Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields • Compare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year. • Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months. About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity–saving you 50 hours a year, or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle Performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place. If you’re an IT practioner who appreciates application over mathematical proofs than you’ll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda. This book is a kind of training course. After reading, studying, and practicing the material covered in this book, you to be able to confidently, responsibly, and professionally forecast performance and system capacity in a wide variety of real-life situations. If you are more management-minded (or want to be), you will be delighted with the service level management focus. Forecasting makes good business sense because it maximizes the return on IT investment and minimizes unplanned down time. To those who think forecasting is a waste of money: well...obviously, they’ve never been on the evening news because their company lost millions of dollars in revenue and brand destruction because of poorly performing or unavailable systems. Without a doubt, you will be equipped to deal with the realities of forecasting Oracle performance. But this book gives you more. Not only will you receive a technical and mathematical perspective, but also a communication, a presentation, and a management perspective. This is career building stuff and immensely satisfying! What you'll learn This book is a “how-to” book filled with examples to transform theory and mathematics into something you can practically apply. You will learn how to use a variety of forecasting models, which will enable you to methodically: Help manage service levels from a business value perspective Identify the risk of over utilized resources Predict what component of an architecture is at risk Predict when a system will be at risk Develop multiple risk mitigating strategies to ensure service levels are maintained Characterize a complex Oracle workload Who this book is for IT professionals who must ensure their production Oracle systems are meeting service levels, in part, through forecasting performance, identifying risk, and developing solutions to ensure systems are available without wasting budget. Readers include database administrators, IT managers, developers, capacity planners, systems architects, systems integrators.

Generate detailed reports that will give your company the competitive edge Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10 g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10 g. Set up, configure, and manage Oracle Business Intelligence Discoverer 10 g Perform ad hoc and fixed queries using the Workbook Wizard Integrate sorts, calculations, percentages, and parameters using Discoverer Plus Create reports with graphs, tables, titles, headers, footers, and margins Use Discoverer Viewer to review, format, export, email, and print reports Refine queries using interactive pivoting, drilling, and Hyper Drilling Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager Establish access and sharing rights, and scheduling privileges with Discoverer Administrator Set up and use Portal using Discoverer Portlet Provider and Portlets Implement query shortcuts, cascading parameters and advanced analytic calculations using templates