Djoni Darmawikarta, "Dimensional Data Warehousing with MySQL: A Tutorial"
BrainySoftware | ISBN 0975212826 | April 1, 2007 | 423 Pages | PDF | 4.2 MB
Data warehousing with MySQL, a free and popular database, has never been made easier with this step-by-step tutorial on building dimensional data warehouses. Topics include star-schema modeling, populating (Extract, Transform, and Load: ETL), testing, and dimensional querying. It comes complete with a hands-on case—scaled-down from a real project—as well as an electronic copy of all MySQL scripts and sample data available for download. Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style.
Download Here:
Rapidshare | Easy-Share | Uploading | MegaUpload | FileFactory | Others
Gavin JT Powell "Oracle Data Warehouse Tuning for 10g"
Digital Press | 2005-08-30 | ISBN: 1555583350 | 504 pages | PDF | 10,8 MB
"This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience."
- Tim Donar, Author and Systems Architect
for Enterprise Data Warehouses
Tuning a data warehouse database focuses on large
transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network
and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame.
A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
* Takes users beyond basics to critical issues in running most efficient data warehouse applications
* Illustrates how to keep data going in and out in the most productive way possible
* Focus is placed on Data Warehouse performance tuning
Download Here:
Rapidshare | Easy-Share | Uploading | MegaUpload | FileFactory | Others
Professional Microsoft SQL Server 2008 Reporting Services (Wrox Programmer to Programmer)
Wrox | ISBN: 0470242019 | December 22, 2008 | PDF | 15 Mb | 816 Pages
* Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions
* Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
* Includes programming examples focused on specific, scenario-based solutions
* Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques
Download Here:
Rapidshare | Easy-Share | Uploading |
John C. Hancock, Roger Toren, «Practical Business Intelligence with SQL Server 2005»
Addison Wesley | ISBN: 0321356985 | 2006 | CHM | 432 pages | 12.2 MB
In this book, two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft’s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.
Download Here: Original Location | Mirror1 | Mirror2
McGraw-Hill Osborne Media | 2007-11-16 | ISBN: 0071494243 | 444 pages | PDF | 37,4 MB
This authoritative volume is a practical guide to the powerful new collaborative Business Intelligence tools available in Office 2007. Using real-world examples and clear explanations, Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop shows you how to use Excel, Excel Services, SharePoint, and PerformancePoint with a wide range of stand-alone and external data in today's networked office. You will learn how to analyze data and generate reports, scorecards, and dashboards with the Office tools you're already using to help you in your everyday work.
• Create Excel PivotTables and PivotCharts and apply Conditional Formatting
• Convert Excel spreadsheets into Excel Tables with Conditional Formatting and Charting
• Connect external data to Excel using Office Data Connections and SharePoint
• Create SharePoint dashboards that display data from multiple sources
• Add Key Performance Indicators and Excel Services reports to your dashboards
• Harness advanced SQL Server 2005 data analysis tools with the Excel Data Mining Add-In and Visio Cluster Diagrams
• Generate integrated PerformancePoint Scorecards
• Create Visio PivotDiagrams and Windows Mobile spreadsheets
Download Here: Original Location | Mirror1 | Mirror2
559 pages | World Scientific Publishing Company (June 2004) | 9812388273 | PDF | 28 Mb
This review volume introduces the novel intelligent Web theory called computational Web intelligence (CWI) based on computational intelligence (CI) and Web technology (WT). It takes an in-depth look at hybrid Web intelligence (HWI), which is based on artificial biological and computational intelligence with Web technology and is used to build hybrid intelligent Web systems that serve wired and wireless users more efficiently. The basic principles of CWI and various e-applications of CWI and HWI are discussed. For completeness, six major CWI techniques — fuzzy Web intelligence, neural Web intelligence, evolutionary Web intelligence, granular Web intelligence, rough Web Intelligence and probabilistic Web intelligence — are described. With the huge potential for intelligent e-business applications of CWI and HWI, these techniques represent the future of intelligent Web applications.
Download Here: Original Location | Mirror1 | Mirror2 | Mirror3
McGraw-Hill Osborne Media | 2008-11-19 | ISBN: 0071549447 | 792 pages | PDF | 13 MB
Maximize the Business Intelligence Tools in Microsoft SQL Server 2008
Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.
Understand the goals and benefits of business intelligence
Design and create relational data marts and OLAP cubes
Manage Analysis Services databases using BI Development Studio
Cleanse data and populate data marts with SQL Server Integration Services
Take advantage of the flexibility of the Unified Dimensional Model
Manipulate and analyze data using MDX scripts and queries
Use data mining to identify data patterns, correlations, and clustering
Develop and distribute interactive reports with SQL Server 2008 Reporting Services
Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control
Download Here: Original Location | Mirror1 | Mirror2 | Mirror3
