Data Analysis and Data Mining using Microsoft Business

Data Analysis and Data Mining using Microsoft Business Intelligence Tools: Excel, Access, and Report Builder with SQL Server

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.

Country	USA
Author	Robert Bussom
Binding	Kindle Edition
Edition	1
EISBN	9780985742805
Format	Kindle eBook
IsAdultProduct
Label	ZeroBits
Manufacturer	ZeroBits
NumberOfPages	648
PublicationDate	2012-08-03
Publisher	ZeroBits
ReleaseDate	2012-08-03
Studio	ZeroBits

Data Analysis and Data Mining using Microsoft Business Intelligence Tools: Excel, Access, and Report Builder with SQL Server

You might also like...