没有合适的资源?快使用搜索试试~ 我知道了~
首页Pro SQL Server 2012 BI Solutions(Apress,2012)
Pro SQL Server 2012 BI Solutions(Apress,2012)
需积分: 10 20 下载量 106 浏览量
更新于2023-03-16
评论 2
收藏 44.87MB PDF 举报
Pro SQL Server 2012 BI Solutions provides practical examples of cost-effective business intelligence projects. Readers will be guided through several complete projects that build a foundation for real-world solutions. Even with limited experience using Microsoft's SQL Server, Integration Server, Analysis Server, and Reporting Server, you can leverage your existing knowledge of SQL programming and database design to provide users with the business intelligence reports they need.
资源详情
资源评论
资源推荐
v
Contents at a Glance
About the Authors ...................................................................................................... xxiii
About the Technical Reviewers .................................................................................. xxv
Acknowledgments .................................................................................................... xxvii
Chapter 1: Business Intelligence Solutions ■ .................................................................1
Chapter 2: A Big-Picture Overview ■ ............................................................................13
Chapter 3: Planning Solutions ■ ...................................................................................85
Chapter 4: Designing a Data Warehouse ■ .................................................................131
Chapter 5: Creating a Data Warehouse ■ ....................................................................161
Chapter 6: ETL Processing with SQL ■ ........................................................................213
Chapter 7: Beginning the ETL Process with SSIS ■ ....................................................253
Chapter 8: Concluding the ETL Process with SSIS ■ ...................................................301
Chapter 9: Beginning the SSAS Project ■ ...................................................................335
Chapter 10: Configuring Dimensions with SSAS ■ .....................................................389
Chapter 11: Creating and Configuring SSAS Cubes ■ .................................................435
Chapter 12: Additional Cube and Dimension Configurations ■ ...................................483
Chapter 13: Creating Reports with SQL Queries ■ ......................................................529
Chapter 14: Reporting with MDX Queries ■ ................................................................565
Chapter 15: Reporting with Microsoft Excel ■ ............................................................615
Chapter 16: Creating Reports with SSRS ■ .................................................................653
Chapter 17: Configuring Reports with SSRS ■ ............................................................693
www.it-ebooks.info
Index...........................................................................................................................797
■ Contents at a GlanCe
Chapter 18: Testing and Tuning BI Solutions ■ ...........................................................731
Chapter 19: Approve, Release, and Prepare ■ ............................................................767
www.it-ebooks.info
1
Chapter 1
Business Intelligence Solutions
Business intelligence (BI) solutions are all the buzz as of late, and BI developers are highly sought after.
Considering the amount of data that needs to be tracked to run a business successfully, it is no wonder. When an
employee has been with a company for 20 years, how will management be notified? Perhaps staffing is suering
because of vacation trends or sales need to be tracked after targeted advertising. Maybe product preordering for a
sales event needs to be estimated, or who sold what and when needs to be documented for an upcoming contest.
ere is no end to how much data needs to be managed, and countless hours, money, and resources
are wasted in attempts to research the information, often with minimal results, multiple errors, and missed
opportunities in decision making. And when more than one employee needs access to the same information, the
errors are often multiplied.
With a well-designed BI solution, important data can be called up instantly in a user-friendly manner.
Calculations are made with a click of a button, and reports are easily generated. No longer will that 20-year
employee be unrecognized for such a long duration of loyalty and service. Staffing can be more properly
managed, advertising can be better targeted to the proper demographic, and so on.
is book shows how to build a successful BI solution step-by-step. We cover the entire process from initial
preparations and planning to complex layers of designing and configuring your project, and from creating reports
to drafting user instructions, and releasing your project. is book is simple in its approach. If you are new to
BI solutions, you will find the instructions thorough and easy to follow with clear images to demonstrate the
process. Yet, it is fast-paced and rich enough in information for even the most advanced database professional to
learn from.
Who Should Read This Book?
is book is for each professional who works with the many aspects of BI solutions. ese include database
administrators, project managers, testers, support techs, report developers, and many others.
is book is not a sales pitch for the latest features of SQL server. Nor is it focused on technologies designed
only for very large companies. Instead, this book is about how small, medium, and large companies, as well as
departments within those companies, can take advantage of Microsoft SQL Server’s eective and inexpensive BI
software. is book defines the glue that is used to bind all four of Microsoft’s BI servers (MSSS, SSIS, SSAS, and
SSRS) together into a BI solution.
After reading this book and working through the recommended exercises, you will have the tools to build
your own BI solutions, as well as interact with other BI team members with a greater understanding of their roles
within the BI solution process.
www.it-ebooks.info
剩余822页未读,继续阅读
vanridin
- 粉丝: 108
- 资源: 1192
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- ExcelVBA中的Range和Cells用法说明.pdf
- 基于单片机的电梯控制模型设计.doc
- 主成分分析和因子分析.pptx
- 共享笔记服务系统论文.doc
- 基于数据治理体系的数据中台实践分享.pptx
- 变压器的铭牌和额定值.pptx
- 计算机网络课程设计报告--用winsock设计Ping应用程序.doc
- 高电压技术课件:第03章 液体和固体介质的电气特性.pdf
- Oracle商务智能精华介绍.pptx
- 基于单片机的输液滴速控制系统设计文档.doc
- dw考试题 5套.pdf
- 学生档案管理系统详细设计说明书.doc
- 操作系统PPT课件.pptx
- 智慧路边停车管理系统方案.pptx
- 【企业内控系列】企业内部控制之人力资源管理控制(17页).doc
- 温度传感器分类与特点.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0