LiveZilla Live Chat Software
Register/Login Login Contact UsContacts BlogBlog
Cart Items : 0 | Cart Total : R0
Books > Computers & Technology > Databases & Big Data > Access > B008SY7DAA
  1. Data Analysis and Data Mining using Microsoft Business Intelligence Tools: Excel, Access, and Report Builder with SQL Server
    Image(s) provided for illustrative purposes and may differ from the actual product
  2. Data Analysis and Data Mining using Microsoft Business Intelligence Tools: Excel, Access, and Report Builder with SQL Server

    Delivery: 10-20 Working Days
    Not Available / Digital Item

Additional Information

Data Analysis and Data Mining using Microsoft Business Intelligence Tools enables analysts, power users, and business decision makers to utilize the power of Microsoft Excel, Access, and Report Builder in conjunction with SQL Server to analyze and mine rich and complex data; to prepare, publish, and distribute ad hoc and standard reports; and to create dashboards and scorecards. At first glance data analysis and data mining can be intimidating. This book takes an easy to understand, guided tour approach to using the tools to get things done. Readers will gain expertise to immediately utilize the tools to extract valuable information from their data. The book describes:
•Business intelligence outputs and processes, data warehousing, and Online Analytical; Processing.
•How to create reports using Report Builder to publish on and distribute with the SQL Server Report Server.
•How to use Excel for data acquisition, inspection and cleaning, and transformation in preparation for data analysis and how to perform data analysis using Excel tables, pivot tables and pivot charts, Online Analytical Processing Cubes, statistical inference, and regression and correlation analysis.
•Acquisition of data from external sources, using advanced query features, employing pivot tables and charts in Access, database management, and Access Data Projects as front-ends to SQL Server databases.
•Time series forecasting fundamentals; smoothing, time series linear regression, decomposition, time series linear regression, and autoregression in Excel; and the Microsoft Time Series algorithm.
•How to use the Table Analysis Tools included in the Microsoft SQL Server Data Mining Add-ins for Microsoft Office. The Table Analysis tools are a subset of Excel’s data mining tools and are used for quick and easy data mining. The tools include Analyze Key Influencers, Detect Categories, Scenario Analysis, the Prediction Calculator, and Shopping Basket Analysis.
•How to exploit Analysis Services’ data mining capabilities with Excel. Topics include an expanded description of Microsoft’s data mining algorithms, using the data modeling tools, accuracy and validation, model usage and management, and prediction queries.
The book also includes six appendixes that contain complementary, supplementary, and ancillary material such as the “Up to Speed” short tutorials on queries, Excel, and Access and an introduction to the Data Mining Advance Query Editor and DMX Language.


Robert Bussom
Kindle Edition
Kindle eBook
Please Note

The authorised South African distributor of this product is under no obligation to honour the manufacture's guarantees/warranties or to provide after-sales service.

Please note that this product is based in the USA, and is designed and labelled to be used in the USA. In addition, if the unit is powered it will come with a US plug and an adapter/transformer may be required. Please click here for more information on power requirements, or check with us if you are unsure or need any assistance!

Please also note that certain items cannot be imported, these include Alcohol, Agricultural Remedies, Animals, Batteries, Flammable Materials, Farm Feeds, Currency, Food, Furs, Chemicals, Explosives, Medications, Plants, Poinsons, Seeds, Supplements, Nutrients, Pressurized Cans, Tactical Equipment, Vitamins, Weaponry and Weaponry Accessories. In these cases, information displayed above is for reference/informational purposes only and the item will not be imported. All content is generated and displayed from an automated USA product feed, and if the item cannot be imported for any reason, including carrier restrictions and/or import or sales restrictions under South African or American law, we do reserve the right to cancel and refund the order in full. If you are not sure if we are permitted to bring in an item, please send us an e-mail with a link to the item to confirm.

Please also ensure that you are ordering the correct item for your particular application as returns to the USA are costly. Product reviews are also provided for most of our items, which can give you a good idea for possible things to look out for and the quality of the item. By clicking Add to Cart, you are confirming that the item is correct and you accept the conditions listed here.