Strategic Business IT Planning, Deployment & Management Courses


Designing Business Intelligence Solutions with Microsoft SQL Server

Introduction:

During this five-day instructor-led (MS) Microsoft SQL Server business intelligence (BI) training course, participants will learn how to use the Microsoft data platform to develop self-service business intelligence (BI) and big data analysis solutions.

The (MS) Microsoft SQL Server business intelligence (BI) training course covers the benefits of self-service BI and how to build self-service data models and reports using Microsoft Office 365 Power BI, Microsoft Excel, Microsoft SharePoint Server, and Microsoft SQL Server Reporting Services. It covers analyzing big data with Windows Azure HDInsight.

Exploring SQL Server Business Intelligence Tools:

Understanding SQL Servers' role in business intelligence is essential in today's data-driven world. SQL Server Business Intelligence (BI) tools are integral to the Microsoft BI stack, offering data analysis and reporting solutions.

By completing this course, participants will gain the skills to leverage SQL Server Business Intelligence Development and utilize SQL Server Business Intelligence Certification knowledge to build and maintain robust self-service BI solutions.

The practical details of using Microsoft SQL Server Data Tools for Business Intelligence will be covered, preparing attendees for successful project implementations and facilitating in-depth learning through hands-on SQL Server Business Intelligence Training.

Targeted Groups:

The target audience of the (MS) Microsoft SQL Server business intelligence (BI) training course consists of database and business intelligence (BI) specialists familiar with data warehouses and enterprise BI solutions created with SQL Server technologies.

Attending this (MS) Microsoft SQL Server business intelligence (BI) training course will also benefit seasoned data analysts who wish to understand how to use Microsoft technologies for self-service analysis and reporting.

Targeted Competencies:

Upon the end of this (MS) Microsoft SQL Server business intelligence (BI) training, the target competencies will be able to:

  • Understand data modeling and data warehousing principles.
  • Know with Microsoft SharePoint Server 2013 and Excel 2013.

Course Objectives:

At the end of this (MS) Microsoft SQL Server business intelligence (BI) course, the participants will be able to:

  • Identify the main attributes and advantages of self-service BI.
  • To implement a self-service reporting solution, use SQL Server Reporting Services.
  • Excel PowerPivot can be used to build analytical data models.
  • To import data into a data model, using Power Query in Microsoft Excel.
  • Microsoft Excel Power View may be used to make interactive data visualizations.
  • Excel Power Maps may be used to create visualizations of geographic data.
  • Collaborative self-service BI solutions can be implemented using Microsoft SharePoint Server.
  • The Windows Azure Marketplace has public data that you may find and use.
  • Cloud-based self-service BI solutions can be implemented using Microsoft Office 365 Power BI.
  • For Big Data analysis, create and use a Windows Azure HDInsight cluster.
  • To analyze huge amounts of data in Windows Azure HDInsight, use Pig and Hive.
  • To support self-service BI, and create and implement big data workflows.

Course Content:

Unit 1: Planning a BI Solution:

  • Elements of a BI Solution.
  • Plan a BI Project.
  • The Microsoft BI Platform.

Unit 2: Planning SQL Server Business Intelligence Infrastructure:

  • Considerations of BI Infrastructure.
  • Plan Data Warehouse Hardware.

Unit 3: Designing a Data Warehouse:

  • Data Warehouse Design Overview.
  • Design Dimension Tables.
  • Design Facts tables.

Unit 4: Designing an ETL Solution:

  • ETL Overview.
  • Plan for Data Extraction.
  • Plan for Data Transformations.
  • Learn about the plan for data loading.

Unit 5: Designing Analytical Data Models:

  • Introduction to Analytical Data Models.
  • Design Analytical Data Models.

Unit 6: Planning a BI Delivery Solution:

  • Considerations for BI Delivery.
  • Common Reporting Scenarios.
  • Choose a Reporting Tool.

Unit 7: Designing a Reporting Services Solution:

  • Plan a Reporting Solution.
  • Design Reports.
  • Plan Report Consistency.

Unit 8: Designing an Excel-Based Reporting Solution:

  • Use Excel for Data Reporting and Analysis.
  • PowerPivot in Excel.
  • Power View in Excel.

Unit 9: Planning a SharePoint Server BI Solution:

  • Intro to SharePoint Server as a BI Platform.
  • Plan Security for a SharePoint Server BI Solution.
  • Explore Plan Reporting Services Configuration.
  • Plan PowerPivot Configuration.
  • Plan for PerformancePoint Services.

Unit 10: Monitoring and Optimizing a BI Solution:

  • Overview of BI Monitoring.
  • Monitor and Optimize the Data Warehouse.
  • Understand Monitoring and Analyzing Analysis Services.
  • Monitor and Optimizing Reporting Services.

Unit 11: Operating a BI Solution:

  • Overview of BI Operations.
  • ETL OperationsData Warehouse Operations.
  • Analysis Services Operations.
  • Report Services Operations.

Kuala Lumpur (Malaysia)
07 - 11 Jul 2024
4500 Euro
Milan (Italy)
08 - 12 Jul 2024
5500 Euro
Barcelona (Spain)
29 Jul - 02 Aug 2024
5500 Euro
Dubai (UAE)
11 - 15 Aug 2024
4500 Euro
Rome (Italy)
12 - 16 Aug 2024
5500 Euro
Istanbul (Turkey)
18 - 22 Aug 2024
5000 Euro
Lisbon (Portugal)
02 - 06 Sep 2024
5200 Euro
London (UK)
09 - 13 Sep 2024
5800 Euro
Amsterdam (Netherlands)
16 - 20 Sep 2024
5500 Euro
Amman (Jordan)
29 Sep - 03 Oct 2024
3200 Euro
Kuala Lumpur (Malaysia)
06 - 10 Oct 2024
4500 Euro
Cairo (Egypt)
13 - 17 Oct 2024
3500 Euro
Paris (France)
14 - 18 Oct 2024
5500 Euro
Dubai (UAE)
10 - 14 Nov 2024
4500 Euro
Barcelona (Spain)
11 - 15 Nov 2024
5500 Euro
Manama (Bahrain)
01 - 05 Dec 2024
5500 Euro
Cairo (Egypt)
08 - 12 Dec 2024
3500 Euro
Istanbul (Turkey)
08 - 12 Dec 2024
5000 Euro
Amsterdam (Netherlands)
30 Dec 2024 - 03 Jan 2025
5500 Euro
Vienna (Austria)
30 Dec 2024 - 03 Jan 2025
5200 Euro
Online
05 - 09 Jan 2025
2500 Euro
Amman (Jordan)
19 - 23 Jan 2025
3200 Euro
Paris (France)
20 - 24 Jan 2025
5500 Euro
Sharm El-Sheikh (Egypt)
02 - 06 Feb 2025
4500 Euro
Online
02 - 06 Feb 2025
2500 Euro
Geneva (Switzerland)
03 - 07 Feb 2025
5200 Euro
Casablanca (Morocco)
03 - 07 Feb 2025
4000 Euro
Madrid (Spain)
10 - 14 Feb 2025
5500 Euro
Rome (Italy)
10 - 14 Feb 2025
5500 Euro
Online
02 - 06 Mar 2025
2500 Euro
Kuala Lumpur (Malaysia)
02 - 06 Mar 2025
4500 Euro
London (UK)
10 - 14 Mar 2025
5800 Euro
Dubai (UAE)
30 Mar - 20 Apr 2025
4500 Euro
Vienna (Austria)
07 - 20 Apr 2025
5200 Euro
Munich (Germany)
12 - 20 May 2025
5200 Euro
Barcelona (Spain)
12 - 20 May 2025
5500 Euro
Sharm El-Sheikh (Egypt)
18 - 20 May 2025
4500 Euro
Cairo (Egypt)
25 - 20 May 2025
3500 Euro
London (UK)
26 - 20 May 2025
5800 Euro
Boston (USA)
26 - 20 May 2025
9000 Euro

Strategic Business IT Planning, Deployment & Management Courses
Designing Business Intelligence Solutions with Microsoft SQL Server (B)

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.