Microsoft Business Intelligence-stack
Varför?
Microsoft BI-kursen är utformad för att ge insikter om olika verktyg i Microsoft Suite (SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services). Den ger också praktisk kunskap om DW-koncept och hur dessa verktyg hjälper till att utveckla en robust heltäckande BI-lösning.
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