Delivering Business Intelligence with Microsoft SQL Server 2008: Edition 2

McGraw Hill Professional
4

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
Read more

About the author

Brian Larson, MCSD, served as a member of the Reporting Services development team and contributed to the code base. He is the chief of technology for Superior Consulting Services (SCS), a Microsoft Certified Partner.

Read more
4.2
4 total
Loading...

Additional Information

Publisher
McGraw Hill Professional
Read more
Published on
Dec 31, 2008
Read more
Pages
792
Read more
ISBN
9780071549455
Read more
Language
English
Read more
Genres
Computers / Databases / General
Read more
Content Protection
This content is DRM protected.
Read more

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
T-SQL insiders help you tackle your toughest queries and query-tuning problems
Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012.

Write faster, more efficient T-SQL code:
Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL’s optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs
About This Book
For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics
©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.