Microsoft Business Intelligence Stack

  • SSIS Basics
solution and projects Two ways to run packages
  • Data Flow Task
Connection managers source and destinations Excel, OLEDB and flat files
  • Data transformations
sorting and aggregating Fully and Partially blocking Sampling Data
  • Data Views
Attaching data viewers Using dead-end destinations
  • Variables
The row count transform System variables changing scope System variables Changing scope
  • Scripting
Script tasks Script components The variable dispenser
  • Fore-each loops
Looping over files Looping over records Other for each loops
  • Expressions
Expression Syntax Data types and casting Conditional split transform Derived column transform
  • Controlling flow
Precedence and Constraints Event Handling
  • Managing Errors
Redirecting and ignoring errors Dealing with truncations SSAS Getting started
  • Multidimensional vs tabular
Separate names instances The development environment
  • Connecting to a data model
Hiding from client tools Renaming tables/columns
  • Relationships
Diagram view Creating Relationships Multi-column relationships Basket analysis
  • Excel Pivot tables
Analyzing data in Excel Connecting from Excel using excel pivot tables
Introduction to SSRS ·       BID and Report manager ·       Solution and projects ·       The 4 main visual studio windows ·       Gauges Creating and formatting gauges gauge panels pointers, scales and ranges Maps ·       Indicators Creating indicators Changing the symbols displayed Stopping indicators ·       Using Report Manager moving and deleting reports creating folders using report manager ·       Subscriptions How subscriptions work creating a new subscription Managing subscriptions
·       Charts The areas of a chat formatting charts creating charts ·       Tables Structure of a table Formatting tables Inserting rows Interactive sorting ·       Grouping Tables using the grouping panes Row and column groups Displaying subtotals Outlining ·       Lists creating and formatting lists Grouping using lists using rectangles in lists
  • Creating a Master-Detail Linking
  • Adding Performance Tile to an Analysis
  • Adding a Simple Trellis to an Analysis
  • Working with Other View Types
  • Creating a Narrative View
  • Creating Column Selector and View Selector Views
  • Building Dashboards
  • Exploring and Editing My Dashboard
  • Creating a Dashboard
  • Editing a Dashboard
  • Saving a Customized Dashboard and Setting Preferences
  • Exporting the Dashboard to Excel Spreadsheet
  • Prompting to Filter Analysis
  • Creating a Named Dashboard Prompt
  • Creating a Column prompt

Creating a Variable Prompt    

Please Fill Up This Form