Best Online IT Courses in Delaware | Online IT Training | Cyber Ascent

MSBI

Introduction to MS - BI: • What is MS-BI • BI/DWH life cycle • ETL and OLAP Tools • Features of MS-BI Introduction to SSIS: • Package • Tasks • SSIS installation • SSIS Architecture • SSIS Wizard • Control Flow Tasks • Data Flow Task • Variables and Expressions • Errors and Debugging SSIS • Data viewers • Deployment • Manually Executing SSIS Package • Scheduling SSIS Package • Importing and Exporting Packages • Monitoring and Optimizing Packages Introduction to SQL Server Reporting Services: • Reporting Services Architecture • Reporting Services Terminology Creating Reports: • Deconstructing Reporting Services • Shared Data Sources • Creating Reports from Scratch Calculations and Formatting: • Creating Expressions • Using the Global Collection Grouping and Sorting: • Creating Groups and Calculating Totals and Percentages • Interactive Sorting, Creating Drill-Down Reports Report Parameters • Creating Report Parameters • Creating Drop-Down Parameters • Multi-Valued Parameters • Debugging Parameter Issues Creating Matrix Reports and Charts: • Creating a Basic Matrix Report • Matrix Subtotals • Creating a Basic Chart • Exploring the Charting Possibilities Reporting Services Security: • Two Parts to Reporting Services Security • Securing Access to Reports • Data Source Security OLAP Modeling: • Modeling source schemas—stars and snowflakes • Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing • Understanding fact (measures) and cube modeling Intermediate SSAS: • KPIs • Perspectives • Translations – cube metadata and currency localization • Actions – regular, drill-through and reporting Advanced SSAS: • Using multiple fact tables • Modeling intermediate fact tables • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions • Modeling changing dimensions – Dimension Intelligence w/ Wizard • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence Cube Storage and Aggregation: • Storage topics – basic aggregations, MOLAP • Advanced Storage Design – MOLAP, ROLAP, HOLAP • Partitions – relational and Analysis Services partitions • Customizing Aggregation Design - Processing Design • Rapidly changing dimensions / ROLAP dimensions • Welcome to the Real Time – Proactive Caching • Cube processing options Beginning MDX: • Basic syntax • Using the MDX query editor in SQL Server Management Studio • Most-used Functions & Common tasks • New MDX functions
Quick Enroll