Business Intelligence (BI) Stack integrating MS Sharepoint & MS SQL Server
Service Times: 9am and 10:30am
6399 North Wells Road, Bigtownville, CO 32748
  • Loading

Business Intelligence (BI) Stack integrating MS Sharepoint & MS SQL Server

Email Print Export to ical format


Academy of Management & Science (AMS)
House # 89/E, Road # 13/C, Block # E, Banani, Dhaka 1213, Bangladesh
Telephone: +880 (2) 9891190, +880 (2) 8836875, Cell No: (88) 01680878839, (88) 01193070284

Resource Person


Md. Anwar Hossain is an Information Technology & Security Professional with M.Sc. in Computer Science & over 12+ years of IT experience in Telecom, Bank ,Multinational & local enterprise , Small medium business and IT Service Provider with notable success in directing IT corporate initiatives while participating in planning, analysis Designing and Lead implementation of Information Technology & security solutions and standards in direct support to business objectives. He is extremely well versed with ITIL v3 & MOF. He served as Technology Specialist for Microsoft Bangladesh part for last 6+years. Presently he is working as freelance consultant to implement IT infrastructure, messaging and collaboration, Unified communication, IT asset management, service desk, business process automation to make business more productive, profitable and competitive as well as security software that drive awareness, decrease exposure and strengthen organizations. He also has hands-on experience in Enterprise regarding various Information technologies including Security application based on Microsoft platform.

He has imparted Information technology including Cisco, Microsoft & security training at various levels in the organizations for Senior Management, implementation team members, end users.

Mr. Anwar has a passion for teaching and learning which is evident from the string of certificates he has obtained and which he also teaches. He conducted classes on MCITP Server admin and enterprise admin , exchange server 2007,2010 CCNA ,CCNP, Microsoft Office . He also conducted ITIL Foundation 3.0 to British High commission, Apollo Hospitals, Sheraton Hotel, NCC Bank, HSBC Bank, Chevron, Singapore Technology, Rajuk, Australia high commission, Banglalink.

ITLI Foundation in IT Service Management: ITIL Foundation V.3
EC Council

Who Can Attend

BI Project managers, BI Developers, I.C.T. Professionals, end-user ombudsman, BI analyst.




Business Intelligence (BI) Stack integrating MS Sharepoint & MS SQL Server


This course is designed to provide students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Reporting Services, Report Builder 3.0, SharePoint 2010 Integration, and the Business Intelligence Center, PerformancePoint Services, Business Connectivity Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining.


Students having concepts bellow are appreciated for better course outcome &


40 Hours

Course Objectives:

This course will expose team members to all aspects of the Microsoft BI stack from the source data through the reporting of the data be it in a subscribed report or through an interactive digital dashboard. The intention of this course is to allow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, and the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.

After completing this course, students will be able to:

  • Describe the entire Microsoft Business Intelligence stack and the role of each component so that a better informed estimate of resources might be made in the BI project.
  • Explain the concept of the Unified Data Model, understand its limitations and practical implementations and when it might be appropriate to use in a fast and low cost BI deployment.
  • Explain what SQL 2008 and the R2 release change in Microsoft BI and how best to leverage these technologies.
  • Gain a good working knowledge of SQL Integration Services and with that knowledge understands why the Extract Transform and Load process may go through 40 percent or more of the entire project budget.
  • Finally get an explanation of Multidimensional space in SQL Server Analysis Services that can be comprehended by us mere mortals and with that knowledge learn how to get the domain experts such as HR or Marketing to communicate what they really need to know about the business.
  • Learn to plan for the on-going maintenance and changing nature of BI projects and then their rapid expansion across the enterprise. Data without visualization is of limited value. In this course you will experience the terrific new
  • Report design interface Report Builder 3.0 and also the PerformancePoint Services one-click application Dashboard designer.
  • You will learn to use these tools to design reports in either ad-hoc mode or for distribution once or scheduled on subscriptions.
  • You will explore the Dashboard designer and see the ease of which you can create scorecards, filters, KPIs and dashboards.
  • Understand the roll of PowerPivot in Microsoft BI. PowerPivot is the big development with Excel 2010 and SQL Server 2008 R2. You will learn where it fits, how to use it and what effect it will have on the present and future of your Microsoft BI investment.
  • Excel rules the land of the MBA! Here we will explore Excel Services 2010 and you will be able to successfully implement a

Course Details:

Module 1: The Business Intelligence Stack Lessons:

  • SQL 2008R2 Business Intelligence Platform
  • SQL Analysis Services
  • SQL Reporting Services
  • Performance Management Tools
  • SharePoint 2010
  • Multidimensional Space
  • MDX
  • Data Mining
  • Understanding the Terminology

Lab: The Business Intelligence Stack:

  • Explore Business Intelligence Development Studio
  • Connect into a SQL Server Analysis Services Cube
  • Use SQL Server Management Studio
  • Explore SharePoint 2010

Module 2: Unified Data Model Lessons:

  • UDM Defined
  • User Experience: Relational vs. UDM
  • Advantages
  • Trouble in River City

Lab: Unified Data Model:

  • Creating a Data Mart using Business Intelligence Development Studio.
  • Enabling Table Compression

This content is the sole property of Academy of Management & Science. Copy or commercial use of the syllabus content is bound under legal copyright proceedings Page 3 of 5

Module 3: SQL Server Integration Services Lessons:

  • Major Components
  • New or Changed Features
  • Script Task
  • SSIS and ETL
  • Transformers
  • Best Practices 1
  • Best Practices 2

Lab: Lab SSIS Projects:

  • Create A SSIS Project
  • Add a Data Source
  • Create A Data Flow
  • Create Another Data Flow
  • Load Data via a SQL Statement
  • Populating the Fact Table
  • Loading Manufacturing Facts
  • Handling Errors
  • Inventory Fact Flow

Module 4: SQL Server Analysis Services Lessons:

  • Key Concepts
  • Schemas
  • Measures
  • Dimensions
  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations

Lab : Lab SQL Server Analysis Services:

  • Define an OLAP Cube
  • Working with Measures and Measure Groups
  • Time and Hierarchies
  • Relating Dimensions
  • Build Deploy and Browse the Cube
  • Multiple Partitions
  • Set Storage
  • Design Aggregations
  • Default Members

This content is the sole property of Academy of Management & Science. Copy or commercial use of the syllabus content is bound under legal copyright proceedings Page 4 of 5

Module 5: SQL Server Reporting Services Lessons:

  • Integration with SharePoint
  • Report Builder 3.0
  • Differences Between Environments
  • Tablix
  • Charts

Lab: Lab SQL Server Reporting Services:

  • SSRS Projects Report Wizard
  • Report Builder 3.0
  • Creating Charts

Module 6: MDX (0ptional)Lessons:

  • What is MDX?
  • MDX Query Editor
  • Select Statement
  • Key Concepts
  • Sets
  • Functions
  • Time Intelligence

Lab: MDX (Optional Module):

  • Understand the Cell
  • Write a Tuple
  • MDX Sets
  • Write a SELECT statement
  • Write a Function
  • Implement Time

Module 7: PerformancePoint Services 2010Lessons:

  • Integration with SharePoint Server 2010
  • Common Service Application Framework
  • New PerformancePoint Features
  • Storage Security
  • Time Intelligence and Dynamic Filters
  • Linking of Web Parts
  • KPI Details Report
  • Retired Features
  • Scorecards in PPS
  • KPI Collections
  • Dashboard Design Guidelines
  • Dashboard Designer Internals
  • Dashboard Designer Interface
  • First Class Objects
  • Main Window

This content is the sole property of Academy of Management & Science. Copy or commercial use of the syllabus content is bound under legal copyright proceedings Page 5 of 5

  • Properties
  • Dashboard Designer Features

Lab: PerformancePoint Services 2010:

  • Use SharePoint to create a site collection
  • Configure Central Administration for PerformancePoint Services
  • Create and Explore a PerformancePoint Business Intelligence Center
  • Create a Basic Dashboard
  • Deploy the Dashboard
  • Explore the Dashboard in PPS

Module 8: Excel Services, Business Connectivity ServicesLessons:

  • Integration with SharePoint Server 2010
  • Storage Security
  • Single version of the truth
  • Excel Web Services
  • New capabilities in Excell Services
  • Business Connectivity Services

Lab: Excel Services 2010:

  • Deploy a Excel spread sheet for a single version of the truth
  • Utilize Excel Web Services
  • Business Connectivity Services

Module 9: Excel PowerPivotLessons:

  • Integration with SharePoint Server 2010
  • Understanding Modeling

Lab : PowerPivot 2010:

  • Explore Excel PowerPivot Module 10: Data MiningLessons
  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithm
  • Excel and The BI Extensions
  • Visio 2010

Lab : Lab Excel 2010 and Data Mining BI:

  • Utilize the Excel Data Mining Tools

Training Calendar

<<  February  2018  >>
 S  M  T  W  T  F  S 
      1  2  3
  4  5  6  7  8  910


AMS Campus Facilities

  • Two Air conditioned seminar halls with projector & audio system [Maximum Capacity up to 50 persons] including video recording capacity.
  • Two different PC Labs (Air conditioned)
  • Centralized server
  • Internet / WIFI facilities
  • Practice facilities in LABS
  • Online Exam Centre
  • Cafeteria & Own cook facility
  • Large lobby with natural surroundings
  • Huge Parking Space
  • Waiting Lounge
  • Distance education facilities
  • Printer, Scanner etc logistics facilities
  • Special Guest Room
  • Registration Booth Arrangement Space
  • 3 Star Accommodation arrangements for foreign guests on demand in walking distance from the center.
    ………and many more

Contact AMS

Academy of Management & Science (AMS)
House #450, Road # 31, New DOHS,Mohakhali, Dhaka-1206, Bangladesh
Cell No: (88) 01616004108
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Academy Location