CLCTN
LanguageENG
PublishYear2014
publishCompany
Wiley
EISBN
9781118821558
PISBN
9781118821527
edition
1
- Product Details
- Contents
In the past, Business Intelligence had a tangible line separating the departmental reporting performed by business analysts and the enterprise reporting managed by IT professionals. On the business side of the organization, Microsoft Excel is heavily relied upon by business analysts to provide the mechanism for operational data analysis, reporting and dashboarding. Because of its easy availability, its array of analytical tools, and its presentation and graphing strengths, Excel is a natural choice for business analysts who need to report and manipulate data. On the other side of the organization, IT departments use Microsoft SQL Server and SharePoint to store and manage data in varying capacities. The types of data being handled by SQL Server range from enterprise-level transactional data and data warehouses, to departmental data marts. Traditionally SQL Server tools like Reporting Services and Analysis Services rarely touch the Excel business analyst. That paradigm has shifted and the latest versions of Office, SQL Server and SharePoint have changed the Business Intelligence world. Tools like PowerPivot and Power View have blurred the line between what is a departmental Excel tool and what is an enterprise-level SQL Server/SharePoint tool. Its becoming increasingly important for business analysts to expand their skill-set from the one dimensional spreadsheet to new territories like relational databases, data integration, and multidimensional reporting.
Collected by
- UCLA
- Princeton University
- University of Cambridge
- Yale University
- University of Oxford
- Harvard University
- Stanford University
- Columbia University Library
- MIT
- UCB