SQL Server BI (SSIS, SSRS, SSAS & Power BI) Training (Online)

By Abhisek, SQL Server BI Architect!!! (*****)

Course Description

Our Microsoft Business Intelligence (MSBI) training enables you to master MSBI tools like SSIS, SSRS, SSAS, and Power BI using SQL Server. As part of this training, you will learn data integration and creating reports, dashboards, and cubes for faster reports generation.

SSIS: In the SSIS part of the training, you gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. You will learn to transform data among heterogeneous data sources — such as text files, Oracle, Access, XML, ODBC and OLE DB — and effectively and securely managing data migration across various platforms.

SSRS: In the SSSR part of the training, you learn how to implement a SQL Server Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

SSAS: In the SSAS part of the training, you learn how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups.

Power BI: In the Power BI part of the training, you access data from a wide range of data sources and create Reports using the in-built visuals. You will also learn to format those visuals for maximum effect and import custom M visuals to extend your reporting capability. You will gain expertise in DAX languages and then publish your masterpiece to a workspace in the Power BI Service, creating Dashboards, sharing Reports and Dashboards with colleagues, concluding with scheduling a data refresh.

For course details and registration, please get in touch with Daniel at +1 267 718 1533 (Mobile & Whatsapp). We are based in Philadelphia, USA, and host affordable and comprehensive SQL Server/Azure/AWS/DevOps training programs for students around the globe.

Student Demographic

Course Introduction Video

Abhisek's Profile

Abhisek is highly qualified consultant offering close to 16 years of rich & qualitative experience in executing full life-cycle Data Warehouse (DWH) & Business Intelligence Projects for companies within several industries. Major roles and responsibility includes:

  • As a Senior Consultant, he is responsible for end-to-end BI solution architecture, delivery oversight and quality assurance across client verticals. With close to 16 years of experience as a technical architect, he offers competencies across all functional components of data management, including ETL processing, data persistence, data visualization and information distribution.
  • He has designed and developed numerous data applications, delivered enterprise client solutions and served as the principal interface to various business stakeholders. He has worked with some of the major Telecom, Manufacturing and IT firms.
  • He has worked with few critical Business Units like Quality, Supply Chain, Reliability, Finance, HR and Engineering.
  • Aside from conducting activities as a technical architect, he has spent much of his career establishing and facilitating custom developer training programs and mentoring for less experienced team members and consultants.
  • Experience with running workshops and customized training courses for Dimension Modeling and MSBI stack. He has trained more than 2K associates on MSBI stack.

Talk to Abhisek


Live Training Videos

We believe in letting our prospective students to watch recorded videos of our live training classes and decide for themselves. If you would still like to attend a one-on-one live demo session, please give call Daniel @ 267 718 1533 and he can schedule one for you at your convenience.

Course Content

Part 1: Dimension Modeling & Data Ware Housing

  • Dimension Modeling & Data Ware Housing
  • Basic concepts of Business Intelligence
  • Basic concepts of Data Warehousing
  • Designing facts and dimensions
  • Employing key performance indicators
  • Dimensional modeling process to design Data Warehouse

Part 2: MS SQL Server Integration Services (SSIS)

  • Extract, Transform and Load (ETL) data – Covering various transformations
  • Solve data management problems by migrating and processing data
  • Demo on populating data into dimension and fact table using adventure works data warehouse
  • ETL Framework
  • Enhance package functionality with scripting
  • Implementing loops to import multiple files
  • Handling errors and managing exception rows
  • SSIS Package Performance Tuning & Best practices
  • Deploy packages to an SSIS server
  • Administering the storage, security and execution of packages

Part 3: MS SQL Server Reporting Services (SSRS)

  • Producing table and matrix report with drill down and drill through functionality
  • Produce reports with enhanced visualization features such as charts, map and gauge
  • Integrate parameters, filters and interactive components into reports
  • Create reports on SSAS cubes with Report Builder
  • Deploying reports to the Report Server
  • Creating cached instances, snapshots and subscriptions
  • Configuring and testing security on report items
  • Report performance tuning

Part 4: MS SQL Server Analysis Services – Multidimensional Analysis Model (SSAS)

  • Creating and deploying a cube
  • Extend hierarchies and exploit advanced dimension relationships
  • Configuring many-to-many dimension relationships
  • Building aggregations with the Aggregation Design Wizard
  • Implement Key Performance Indicators to monitor business objectives
  • Cube storage mode - MOLAP, ROLAP and HOLAP
  • Implementing an action to open a Reporting Services report or to analyze data using Excel
  • Automating cube processing with an XMLA script

Part 5: MS SQL Server Analysis Services - Tabular Analysis Model (SSAS)

  • Basics of in memory processing
  • Multiple dimensional model vs. tabular analysis model
  • Creating and deploying a tabular analysis cube
  • Building hierarchy and dimension relationship
  • Implement Key Performance Indicators to monitor business objectives
  • Query language DAX

Part 6: MDX Queries

  • Basics of MDX
  • Working with Sets
  • Working with Calculations
  • Working with Hierarchical Calculations
  • Working with Time Intelligence functions like QTD, YTD
  • Deploying calculations

Part 7: Power BI

  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modelling
  • Create a Power BI desktop visualization
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Connect directly to data stores

Course Statistics

16

Years of Experience

3671

Gratified Students

112

Training Batches

9634

Training Hours

Gratified Student Feedback - From Year 2000


Empire Data Systems

Social Links