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.
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.
Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI.
• Understand the goals and components of successful BI
• Build data marts, OLAP cubes, and Tabular models
• Load and cleanse data with SQL Server Integration Services
• Manipulate and analyze data using MDX and DAX scripts and queries
• Work with SQL Server Analysis Services and the BI Semantic Model
• Author interactive reports using SQL Server Data Tools
• Create KPIs and digital dashboards
• Implement time-based analytics
• Embed data model content in custom applications using ADOMD.NET
• Use Power BI to gather, model, and visualize data in a self-service environment
Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource.Build SSIS packages using the Import and Export Wizard and Business Intelligence Development Studio Create Loop and Task Host Containers with Control Flow Designer Administer SSIS from SQL Server Management Studio and dutil Secure packages using encryption, roles, signatures, and permissions Build-in memory lookups and transformations using the Data Flow Engine Extend functionality using custom scripts and ActiveX components Use SCD transformations to load data warehouses and data marts Learn to build a Star Schema and Parallel Data Warehouse Migrate Data Transformation Services 2000 and SSIS 2005 packages
Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities.Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface
Build, publish, and maintain paginated and mobile reports using the expert tips and best practices contained in this hands-on guide. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2016 Reporting Services, Fifth Edition, fully explains the process of creating and distributing reports and shows how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are featured in this practical resource.
• Plan for, install, configure, and customize SQL Server 2016 Reporting Services
• Design and generate feature-rich reports using the Report Wizard
• Work with Report Designer in Visual Studio, Report Builder, and the Mobile Report Publisher
• Incorporate charts, images, gauges, and maps
• Enhance your reports through summarizing, totaling, and interactivity
• Build reusable report templates
• Embed Visual Basic .NET functions and subreports
• Enable end-user access via the Report Server and its web portal interface
• Integrate SSRS reports with your own websites and custom applications
• Follow along with sample reports from the book’s case study
In this book, Certified Tableau trainer and bestselling BI author George Peck teaches you how to build meaningful data visualizations and dashboards using Tableau 8. Complete with training videos, Tableau 8: The Official Guide provides comprehensive coverage of the latest version of Tableau, the BI software designed for faster data analysis and better business dashboards.Electronic content features original Camtasia videos that bring all examples to life Shows how to build dashboards and analytics in minutes and hours, not days and weeks Enables informed business decision-making based on real data discovery
Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.