What will you learn in this MSBI online training?
- Microsoft Business Intelligence architecture
- Data Modeling, Representation, and Transformation for BI
- Concepts of Multidimensional Modeling, ETL, and Transformations in SSIS
- SSIS, SSAS, and SSRS architecture and their components
- Sample of data flow across components
- Building and creating charts, reports, and dashboards with SSRS
- Concepts of OLAP database and tables in SSAS
- Generating and processing new data sources and new Cubes
- Defining various relationship types in SSAS
- Preparing for MCSE: Business Intelligence Certification Exam
Who should take up this MSBI training course?
- Software Architects, ETL Developers and Data Analysts
- Business Intelligence Professionals and people looking to upskill themselves in MSBI
What are the prerequisites for learning MSBI?
Anybody can take up this online training course and get trained in MSBI.
Why should you learn MSBI online training?
- Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner
- Average US Salary for a Microsoft BI Professional is $107,000 – Indeed
Today, the demand for SQL Server Business Intelligence professionals is increasing, and there is a real need for expertise in SSAS, SSIS and SSRS. Hence, with this tutorial you can take up highly coveted Microsoft BI jobs and pass the MCSE: Business Intelligence Certification for a great future.
What is BI?
Introduction to Business Intelligence, understanding the concept of Data Modeling, Data Cleaning, learning about Data Analysis, Data Representation, Data Transformation.
Introduction to ETL, the various steps involved Extract, Transform, Load, using a user’s email ID to read a flat file, extracting the User ID from email ID, loading the data into a database table.
Working with Connection Managers
Introduction to Connection Managers – logical representation of a connection, the various types of Connection Managers – Flat file, database, understanding how to load faster with OLE DB, comparing the performance of OLE DB and ADO.net, learning about Bulk Insert, working with Excel Connection Managers and identifying the problems.
Learning what is Data Transformation, converting data from one format to another, understanding the concepts of Character Map, Data Column and Copy Column Transformation, import and export column transformation, script and OLEDB Command Transformation, understanding row sampling, aggregate and sort transformation, percentage and row sampling.
Advance Data Transformation
Understanding Pivot and UnPivot Transformation, understanding Audit and Row Count Transformation, working with Split and Join Transformation, studying Lookup and Cache Transformation, Integrating with Azure Analysis Services, elastic nature of MSBI to integrate with the Azure cloud service, scale out deployment option for MSBI, working with cloud-borne data sources and query analysis. Scaling out the SSIS package, deploying for tighter windows, working with larger amount of data sources, SQL Server vNext for enhancing SQL Server features, more choice of development languages and data types both on-premise and in the cloud.
Slowly Changing Dimensions
Understanding data that slowly changes over time, learning the process of how new data is written over old data, best practices. Detail explanation of three types of SCDs –Type1, Type2 and Type3, and their differences.
Overview of Fuzzy Look-up Transformation and Lookup and Term Extraction
Understanding how Fuzzy Lookup Transformation varies from Lookup Transformation, the concept of Fuzzy matching
Concepts of Logging & Configuration
Learning about error rows configuration, package logging, defining package configuration, understanding constraints and event handlers.
Introduction to SSRS
Get introduced to the SSRS Architecture, components of SSRS Report Building tool, learning about the data flow in different components.
Matrix and Tablix Overview
Understanding the concepts of Matrix and Tablix, working with Text Box, learning about formatting, row/column grouping, understanding sorting, formatting, concepts of Header, Footer, Totals, Subtotals and Page Breaks.
Parameters and Expression
Learning about Parameters, filter and visibility expression, understanding drill-through and drill-down, defining variables, custom code
Reports and Charts creation
Introduction to various aspects of Bar Chart, Line Chart, Combination Chart, Shape Chart, Sub Reports,Integration of Power Query and M language with SSRS, working with additional data sources in MSBI, rich transformation capabilities addition to MSBI, reusing M functions build for PBIX in SSRS.
Learn how to build a Dashboard with Sparklines, Data Bars, Map Charts, Gauge Charts and drilling into reports, the basics of ad hoc reporting.
Data Bar, Sparkline, Indicator, Gauge Chart, Map Chart, Report Drilling, What is Ad hoc reporting?
Reports and Authenticity
Understanding Report Cache, Authorization, Authentication and Report Snapshot, learning about Subscriptions and Site Security.
Getting started with SSAS
Understanding the concept of multidimensional analysis, understanding SSAS Architecture and benefits, learn what is Cube, working with Tables and OLAP databases, understanding the concept of Data Sources, working with Dimension Wizard, understanding Dimension Structure, Attribute Relationships, flexible and rigid relationship.
Structures and Processes
Learning about Process Dimension, the Process database, creation of Cube, understanding Cube Structure, Cube browsing, defining the various categories, Product Key and Customer Key, Column Naming, processing and deploying a Cube, Report creation with a Cube.
Hands-on Exercise – Create a Cube and name various columns Deploy a cube after applying keys and other rules Create reports with a cube
Type of Database Relationship
Understanding Data Dimensions and its importance, the various relationships, regular, referenced, many to many, fact, working on Data Partitions, and Data Aggregations.
Learning about SSAS Cube, the various types of Cubes, the scope of Cube and comparison with Data Warehouse.