Write For Us

Designing BI Solutions With Microsoft SQL Server

E-Commerce Solutions SEO Solutions Marketing Solutions
275 Views
Published
Designing BI (Business Intelligence) Solutions with Microsoft SQL Server

If you're a business intelligence (BI) professional, and you'd like some tips and ideas for implementing BI solutions, check out this course. Experts walk BI pros through how to plan and design a BI solution based on SQL Server 2014 and other Microsoft BI technologies. Learn how to plan a data warehouse infrastructure, define an appropriate disaster recovery approach, balance query‐based processing versus filter-based processing, and more.

[00:00:00] Planning SQL Server BI Infrastructures
Learn the importance of gathering requirements and how to plan a data warehouse infrastructure, ETL infrastructure, Analysis Services infrastructure, and Reporting Services infrastructure.

[00:31:42] Designing a BI Infrastructure
Explore design considerations for BI solutions and performance considerations. Find out how to design highly available BI solutions, define an appropriate disaster recovery approach, and learn to design security into a BI solution.

[01:15:34] Designing a BI Infrastructure
Learn to describe an enterprise data warehouse, design a data warehouse schema, and design for partitioning. Hear how to describe relational performance considerations, handle slowly changing data, and integrate DQS and MDS.

[02:13:52] Design an ETL Solution
Get the details on designing a data-acquisition strategy, and learn how to determine SSIS deployment models, optimize data-load processing, define logging, and securely deploy SSIS packages.

[02:55:11] Design BI Data Models
Take a look at how to choose between tabular or multidimensional models, and design partitioning, aggregations, and a processing approach.

[03:35:53] Designing Reporting Services Solutions
Learn to design appropriate data query parameters, balance query‐based processing versus filter-based processing, and manage data sets through the use of stored procedures.

Instructors:
Chris Testa- O'Neill - Claribi Ltd. Principal Consultant
Charley Hanania - QS2 AG Quality Software Solutions Principal Consultant


------
Subscribe: http://goo.gl/gA1NLZ
Facebook: http://goo.gl/oEk624
Group: http://goo.gl/xPdeEX
Google+: http://goo.gl/iGZzZX
Twitter: http://goo.gl/PNRtC8
About & Contact: http://goo.gl/JAolqj
-------

If you feel useful for you and for everyone, please share it!

Source via: Channel9 - MVA
Category
Tech
Sign in or sign up to post comments.
Be the first to comment