SQL Server BI Training (70 Hours)

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

Akshay's Profile

Akshay is highly qualified consultant offering close to 8 years of commercial experience working for variety of companies within several industries. Major roles and responsibility includes;

  • As a Senior Consultant, he is responsible for end-to-end solution architecture, delivery oversight and quality assurance across client verticals. With close to eight 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 banking and insurance firms.
  • He has worked on the consulting assignment with organization Citi Bank, Barclays, Wachovia Corporation, Inter Public Group, C.B.R.E., Kimberly Clark and XL Insurance.
  • Aside from conducting activities as a technical architect, he has spent much of his career establishing and facilitating custom developer training programs for less experienced team members and consultants.
  • Experience with running workshops and customized training courses for Dimension Modeling and MS BI stack. He has trained more than 1000+ associates on MSBI stack.

Talk to Akshay


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