• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/05/2018 11/09/2018
  • VLT
Live Online
12/03/2018 12/07/2018
  • VLT
Live Online
10/22/2018 10/26/2018
  • VLT
  • GTR
Live Online

55045: Microsoft End to End Business Intelligence Boot Camp Course 

55045: Microsoft End to End Business Intelligence Boot Camp seven-day educator drove course is a total abnormal state voyage through the Microsoft Business Intelligence stack. It acquaints understudies with the SQL 2012 Business Intelligence and SharePoint 2013 Business Intelligence administrations including PerformancePoint Service, Excel Services, Business Connectivity Services, Visio Services and the Business Intelligence Center concentrating on their interdependency. 

Each of the modules is remain solitary taking into consideration customization of the course for those groups of onlookers that might not have an enthusiasm for a specific administration. 

Every idea is shown with a video before the activity on that idea, so first you will have the short address at that point see the idea exhibited then do it without anyone else's help. Keep in mind on the off chance that you can't do it you didn't learn it. Each of the recordings, and there are roughly 13 hours of them, is planned as a detract from the class for every understudy. 

55045: Microsoft End to End Business Intelligence Boot Camp Audience Profile

55045: Microsoft End to End Business Intelligence Boot Camp course is planned for Project Managers, Business Intelligence Developers, SQL Server Developers and IT Professionals that will be included with the outline, improvement and support of SharePoint 2013 Business Intelligence arrangements. The course presents each of the administrations and limits or takes out any coding. 

55045: Microsoft End to End Business Intelligence Boot Camp At Course Completion

Subsequent to finishing this course, understudies will have the capacity to: 

  • Peruse the information inside the solid shape utilizing SQL Server Management Studio. 
  • Peruse information utilizing Visual Studio 2013. 
  • Associate with an unthinkable source, import tables, and investigate the information. 
  • Effectively Navigate SQL Server Data Tools. 
  • Effectively Navigate SQL Server Management Studio. 
  • Run the Import Export Wizard. 
  • Make a Project. 
  • Add and Configure Connections to the Control Flow. 
  • Include and Configure Execute SQL Tasks. 
  • Associate and Configure Precedence Constraints. 
  • Include and Configure Data Flow Tasks. 
  • Utilize the Destination Assistant. 
  • Duplicate a Package and Reuse Project Connection Managers. 
  • Include and Configure a Data Conversion Transformation. 
  • Include and Configure a Conditional Split Transformation. 
  • Include and Configure a Multicast Transformation. 
  • Include and Configure an Aggregate Transformation. 
  • Include and Configure a Derived Column Transformation. 
  • Include and Configure a Sort Transformation. 
  • Include and Configure a Lookup Transformation. 
  • Effectively Deploy a Project. 
  • Make a Sample or Test Database. 
  • Effectively Navigate and Use Key Objects. 
  • Make a Server Side Time Dimension. 
  • Make a Data Source. 
  • Make a Data View. 
  • Effectively Navigate a Cube. 
  • Effectively Navigate and Configure Partitions. 
  • Utilize the Aggregation Design Wizard. 
  • Make and Configure a Data Profiling Task. 
  • Design Proactive Cache. 
  • Convey and Process a Project. 
  • Fabricate a Cube. 
  • Comprehend the Functionality of MDX. 
  • Compose MDX. 
  • See How to Use MDX to Navigate Hierarchies. 
  • Compose MDX Navigating Hierarchies. 
  • Comprehend Working with Time in MDX. 
  • Compose MDX Working with Time. 
  • Making a Tabular Project. 
  • Import Data Using the Table Import Wizard. 
  • Physically Add a Relationship. 
  • Make Measures. 
  • Make Calculated Columns. 
  • Make Hierarchies. 
  • Make Perspectives. 
  • Make KPIs. 
  • Process Data. 
  • Convey a Solution. 
  • Associate with a Tabular Model Using Excel. 
  • Find, Access and Use Report Manager. 
  • Utilize Report Designer. 
  • Make and Configure Data Sources. 
  • Make and Configure Datasets. 
  • Make and Configure a Basic Report. 
  • Make and Configure Graphics. 
  • Make and Configure Maps 
  • Make and Configure Report Parts. 
  • Make and Configure a Model. 
  • Make and Configure Entities. 
  • Make and Configure Members. 
  • Make and Configure Attributes. 
  • Make a Business Rule. 
  • Convey a Model. 
  • Load Data. 
  • Make a Subscribing View. 
  • Utilize the Data Mining Add-in for Excel. 
  • Investigate the choices and settings accessible inside the new SharePoint 2013 Central Administration. 
  • Make another web application and business knowledge webpage while investigating the components of both. 
  • Make a SharePoint library to hold Excel exercise manuals and investigate trusted record areas. 
  • Use the Power View include for Excel 
  • Make an Excel exercise manual with a parameter and spare it to a SharePoint record library. 
  • Add Web Apps to a site page. 
  • Investigate the Dashboard Designer interface and know how to make and arrange an information source. 
  • Make and arrange a standard KPI and a scorecard. 
  • Make and arrange a leaf KPI and a scorecard. 
  • Make two clear KPI's and afterward move them into a goal KPI. 
  • Make and arrange a logical diagram and a systematic matrix, add them to a dashboard, convey them to SharePoint, and investigate the choices accessible. 
  • Make and arrange a channel, and tie the channel into both the logical diagram and systematic matrix made before. 
  • Make and arrange a falling channel and after that tie it into another scientific graph and lattice. 
  • Make a Time Intelligence information association, a Time Intelligence channel, and make a report utilizing both. 
  • Make four duplicates of the Objective Scorecard, arrange settings in each of the four duplicates, and send them to SharePoint in a dashboard. 
  • Make another leaf KPI and utilize that KPI in two new scorecards, one with a channel designed, and one without. 
  • Make another dashboard with two pages and audit altering choices. 
  • Make a drawing, transfer the record to the Student BI Site reports library, and view the attracting a program. 
  • Make an information associated drawing and transfer the record to the Student BI Site reports library. 
  • Make a target scorecard and coordinating procedure delineate, them in a dashboard, and after that transfer the dashboard to the Student BI Site. 
  • Utilize PowerPivot inside Excel to import a table from SQL Server. 
  • View the connections existing inside the transported in tables from SQL Server and after that import an extra table and design a connection amongst it and the current. 
  • Shroud sections they don't need reflected in the subsequent PivotTable. 
  • Make a PivotTable inside a current worksheet. 
  • Relegate chairmen and consents on the BDC Metadata Store. 
  • Investigate the diverse substance sorts accessible in SharePoint 2013 and figure out how to find them and their relating settings. 
  • Make a record library, arrange it to acknowledge particular substance sorts, and after that figure out how to erase the report library. 
  • Make and design another outer substance sort. 
  • Make an outer rundown related with the new outside substance sort made earlier. 
  • Make another outside substance sort and another host URL, and afterward make an outer rundown and profile page. 
  • Add a custom activity to an outer rundown. 
  • Explore the Report Builder 3.0 interface. 
  • Make an installed information source interfacing into a database. 
  • Make an installed information source interfacing into an OLAP database. 
  • Make a mutual information source utilizing the Report Manager. 
  • Make a mutual dataset utilizing the common association they made in the past exercise. 
  • Make another dashboard and investigate three distinctive approaches to interface the Web Apps. 

55045: Microsoft End to End Business Intelligence Boot Camp Course Outline 

Module 1: Course Overview 

55045: Microsoft End to End Business Intelligence Boot Camp module clarifies how the class will be organized and presents course materials and extra regulatory data. 

Lessons 

  • Presentation 
  • Course Materials 
  • Offices 
  • Essentials 
  • What We'll Be Discussing 

In the wake of finishing this module, understudies will have the capacity to: 

  • Effectively sign into their virtual machine. 
  • Have a full comprehension of what the course expects to cover. 

Module 2: The Business Intelligence Stack 

In this module we will initially take a gander at the three diverse courses in which business insight can be seen. At that point, we will take a gander at the administrations SQL 2012 gives us and how they apply to business insight. We will then move to SharePoint 2013 and take a gander at the SharePoint administrations to analyze their importance and how we can utilize them in business insight to surface information. In this area we will likewise cover the new business insight highlights accessible inside the SharePoint 2013 discharge. At long last, we will investigate PowerPivot, looking at the new components and their noteworthiness. PowerPivot is shrouded in more detail in a later module. 

Lessons 

  • Business Intelligence in Three Ways 
  • SQL 2012 Business Intelligence 
  • New 2013 SharePoint Business Intelligence Features 
  • New 2013 PowerPivot in Excel Features 

Lab : The Business Intelligence Stack 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Peruse the information inside the 3D square utilizing SQL Server Management Studio. 
  • Peruse information utilizing Visual Studio 2013. 
  • Interface with an unthinkable source, import tables, and investigate the information. 

Module 3: SQL Server Integration Services (SSIS) 2012

In this module we will give a diagram of ETL and talk about two methodologies that ought to be considered preceding execution. We will likewise go over the SQL Server Data Tools application and clarify the idea of Packages, Tasks, and Containers with advance direction on the most proficient method to utilize these apparatuses and others. In the accompanying rundown of themes you will see two subjects that are a piece of SQL Server Integration Services ETL in spite of the fact that not shrouded in this module. They are SQL Server Integration Services Data Profiler and Data purging which are canvassed later in the course.

Lessons 

  • What's New? 
  • Review of Extract, Transform, and Load (ETL) 
  • SSIS Tools 
  • Change Data Capture 
  • SQL Server Integration Services Scripting 
  • Factors, Parameters, and Expressions 
  • Bundle Deployment 

Lab : SQL Server Integration Services (SSIS) 2012 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Effectively Navigate SQL Server Data Tools. 
  • Effectively Navigate SQL Server Management Studio. 
  • Run the Import Export Wizard. 
  • Make a Project. 
  • Add and Configure Connections to the Control Flow. 
  • Include and Configure Execute SQL Tasks. 
  • Associate and Configure Precedence Constraints. 
  • Include and Configure Data Flow Tasks. 
  • Utilize the Destination Assistant. 
  • Duplicate a Package and Reuse Project Connection Managers. 
  • Include and Configure a Data Conversion Transformation. 
  • Include and Configure a Conditional Split Transformation. 
  • Include and Configure a Multicast Transformation. 
  • Include and Configure an Aggregate Transformation. 
  • Include and Configure a Derived Column Transformation. 
  • Include and Configure a Sort Transformation. 
  • Include and Configure a Lookup Transformation. 
  • Effectively Deploy a Project. 

Module 4: SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode) 

In this module we cover the nuts and bolts of utilizing multidimensional mode and the devices accessible. In information warehousing there are two generally recognized ways to deal with building a choice help framework, and you can actualize both utilizing the instruments accessible in SQL Server Analysis Services 2012 multidimensional. We will go over these two methodologies and we will likewise cover key ideas for utilizing multidimensional mode. 

Lessons 

  • The Data Warehouse/Data Mart 
  • The Tools 
  • Key Concepts 
  • Information Sources 
  • Information Views 
  • Solid shapes 
  • Information Profiler 
  • Proactive Cache 
  • Wizards 

Lab : SQL 2012 Business Intelligence Semantic Model (Multidimensional Mode) 

In the wake of finishing this module, understudies will have the capacity to: 

  • Make a Sample or Test Database. 
  • Effectively Navigate and Use Key Objects. 
  • Make a Server Side Time Dimension. 
  • Make a Data Source. 
  • Make a Data View. 
  • Effectively Navigate a Cube. 
  • Effectively Navigate and Configure Partitions. 
  • Utilize the Aggregation Design Wizard. 
  • Make and Configure a Data Profiling Task. 
  • Design Proactive Cache. 
  • Convey and Process a Project. 
  • Fabricate a Cube. 

Module 5: Microsoft Multidimensional Expressions 

There are some striking contrasts amongst SQL and MDX, and you ought to know about these distinctions at a calculated level. The main contrast amongst SQL and MDX is the capacity of MDX to reference numerous measurements. In spite of the fact that it is conceivable to utilize SQL only to inquiry 3D squares, Analysis Services MDX gives orders that are outlined particularly to recover information as multidimensional information structures with any number of measurements. We will go over key ideas in multidimensional space and peruse some essential MDX proclamations with particular scope on exploring chains of importance and working with time. 

Lessons 

  • Ideas in Multidimensional Space 
  • Fundamental MDX Statements 
  • SQL Server Management Studio MDX Query Editor 
  • Exploring Hierarchies 
  • Working with Time 
  • Microsoft Multidimensional Expressions 

Lab : Microsoft Multidimensional Expressions 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Comprehend the Functionality of MDX. 
  • Compose MDX. 
  • See How to Use MDX to Navigate Hierarchies. 
  • Compose MDX Navigating Hierarchies. 
  • Comprehend Working with Time in MDX. 
  • Compose MDX Working with Time. 

Module 6: SQL 2012 Business Intelligence Semantic Model (Tabular Mode) 

On the off chance that you are beginning an Analysis Services 2012 venture with no past Multidimensional or OLAP encounter, it is likely that you will discover forbidden significantly less demanding to learn than multidimensional. Not exclusively are the ideas substantially simpler to see, particularly on the off chance that you are accustomed to working with social databases, however the advancement procedure is likewise significantly more direct and there are far less elements to learn. Building your first unthinkable model is significantly speedier and less demanding than building your first multidimensional model. It can likewise be contended that DAX is less demanding to learn than MDX, at any rate with regards to composing essential counts, however actually both MDX and DAX can be similarly befuddling for anybody used to SQL. In this module we cover the nuts and bolts of utilizing forbidden mode and the instruments accessible. 

Lessons 

  • The Tabular Model 
  • Information Analytic Expressions (DAX) 
  • The Editor 
  • Information Connections 
  • Making a Tabular Project 
  • Connections 
  • Measures and Calculated Columns 
  • Chains of command 
  • Points of view 
  • KPIs 
  • Segments 
  • Preparing 
  • Organization 

Lab : SQL 2012 Business Intelligence Semantic Model (Tabular Mode) 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Making a Tabular Project. 
  • Import Data Using the Table Import Wizard. 
  • Physically Add a Relationship. 
  • Make Measures. 
  • Make Calculated Columns. 
  • Make Hierarchies. 
  • Make Perspectives. 
  • Make KPIs. 
  • Process Data. 
  • Convey a Solution. 
  • Associate with a Tabular Model Using Excel. 

Module 7: SQL Server 2012 Reporting Services 

In this module we will cover the new and energizing components accessible in SQL 2012 Reporting Services. Report Lifecycles are examined alongside the devices accessible to make pretty much any sort of report you can consider. Successful revealing is a key component in business insight and this module covers every one of the nuts and bolts. 

Lessons 

  • Report Lifecycles 
  • Establishment Modes 
  • Report Creation Tools 
  • Information Sources 
  • Datasets 
  • Essential Reports 
  • Illustrations 
  • Maps 
  • Report Parts 

Lab : SQL Server 2012 Reporting Services 

  • In the wake of finishing this module, understudies will have the capacity to: 
  • Find, Access and Use Report Manager. 
  • Utilize Report Designer. 
  • Make and Configure Data Sources. 
  • Make and Configure Datasets. 
  • Make and Configure a Basic Report. 
  • Make and Configure Graphics. 
  • Make and Configure Maps 
  • Make and Configure Report Parts. 

Module 8: Master Data Services 

It is frequently said that Master Data Management (MDM) empowers an endeavor to make and utilize a "solitary rendition of reality". Ace information administration applies all ventures and covers a general class of corporate information. This module covers Master Data Management and clarifies what it is and why it is imperative. Alongside covering framework parts and the contrasts between ace information and value-based information, we likewise go over key ideas in Master Data Services and the advantages of legitimate usage. 

Lessons 

  • What is Master Data Management? 
  • Framework Roles 
  • Ace Data versus Value-based Data 
  • Ace Data Services ETL 
  • Ace Data Services Key Concepts 

Lab : Master Data Services 

Subsequent to finishing this module, understudies will have the capacity to: 

  • Make and Configure a Model. 
  • Make and Configure Entities. 
  • Make and Configure Members. 
  • Make and Configure Attributes. 
  • Make a Business Rule. 
  • Convey a Model. 
  • Load Data. 
  • Make a Subscribing View. 

Module 9: Data Mining/Predictive Analytics 

Information Mining utilizing SQL Server 2012 utilizations the idea of a SQL Service not an application. Since it is an administration and not an application the product can scale dissimilar to an application. In this module we clarify the idea of information mining and how it can be an important device in your business knowledge stockpile. 

55045: Microsoft End to End Business Intelligence Boot Camp module is a subset of the course on Data Mining which is being developed. 

Lessons 

  • Definitions for Our Purpose 
  • Issues Addressed 
  • Business Analytics 
  • Fresh DM 
  • Key Concepts 
  • Microsoft Data Mining Process 
  • Information Mining Tasks 
  • Microsoft Algorithms 
  • Coordinating the Tasks to the Algorithm 
  • Information Mining Add-in for Excel 

Lab : Data Mining/Predictive Analytics 

In the wake of finishing this module, understudies will have the capacity to: 

  • Utilize the Data Mining Add-in for Excel 
  • Module 10: SharePoint 2013 Business I

Before going to 55045: Microsoft End to End Business Intelligence Boot Camp course, understudies must have: 

A comprehension of the advantages of business insight.

Awards