Setting up your Microsoft BI environment
  • Downloading the right file for installation
  • Installation guide for SQL Server Management Studio 2014
  • Installing Visual Studio SSDT-BI
  • Setup Adventure Works DW 2012 for Analytic Services Practice
  • Create a new database and a new table in ssms
  • How to Insert, truncate and drop a table?
SSIS Control Flow Tasks
  • FTP Server File download using SSIS
  • Creating new package and a look around the interface
  • Move files using a File System Task
  • Creating a table in SSMS using a Execute SQL Task
  • Inserting into the new table and truncate the old table using Execute SQL Task
  • Take Backup of Database using the Backup Database Task
  • Variables: Create a new user defined variable
  • Variables: Create a new file system task
  • Variables: Establishing a logical connection between Variables and File Sys Task
  • Copy 'n' number of files using the Foreach Loop container
SSIS Data Flow Tasks
  • Introduction to Data Flow Tasks and its components
  • Transfer Data from a Flat File Source to an OLE-DB Destination
  • Performing Aggregates.
  • Storing aggregated data in a table using OLEDB Destination
  • Performing a Conditional Split
  • Sorting data in ascending or descending order
  • Creating a Derived column
  • Performing data merge with two ways to sort the data
SSAS : Designing Cubes for Analysis
  • Creating a new project and configuring a Data source for SSAS Cube
  • Creating and Understanding the Data Source View
  • Creating a Cube by assigning Dimensions, Measures and changing column names
  • Deploying and viewing the cube
  • Browse the cube before Deployment
  • Dimension Designing 1: Gathering required columns and renaming them
  • Dimension Designing 2: Creating Named calculated columns
  • Dimension Designing 3: Named Column-Getting underlyinng data of a key
  • Dimension Desingning 4: Grouping dimensions into logical categories
  • Creating a Hierarchy
SSRS: Understanding report creation, management and deployment
  • What is SSRS?
  • Life Cycle of a Report
  • Getting started and looking at the Reporting Services interface
  • Connecting to a Data Source using Embedded Connection