/MSBI

Learn MSBI step by step

MSBI

udemy MSBI

Learn MSBI step by step

Technologies: Sql server , Excel , SSIS , SSAS , Mdx , Olap cube , SSRS ,Pivot table

Description

This course will teach you MSBI step by step, helping you integrate with BI family tools, enhance your knowledge in data warehousing, star schema, design data modeling, SSIS, OLAP cubes, SSRS, T-SQL, and more.

Table Of content with evaluation

  • 1 MSBI Fundamentals, Data Flow, Control Flow, ETL, Data Warehouse (SSIS) ★★★★★
  • 1.1 MSBI Installation (Upgrade) ★★★★☆
  • 2 Conditional Split, Data Conversion and Error Handling (SSIS) ★★★☆☆
  • 3 For Loop, Variables, Parameters and Debugging (SSIS) ★★★★☆
  • 4 Packaging and Deployment, File Component and Running SSIS Package ★★★★★
  • 5 Dimensions, Measures, Star Schema, Snowflake, Shared Connection Management ★★☆☆☆
  • 6 SCD, Type 0, Type 1, OLEDB Command and Unicode Conversions (SSIS) ★★★★☆
  • 7 Lookup, Data Conversion Optimization and Updating SSIS Package (SSIS) ★★★☆☆
  • 8 Sort, Merge and Merge Joins (SSIS) ★★☆☆☆
  • 9 Creating SSAS Cube (SSAS) ★★★★★
  • 10 SSAS Time Series and Excel Display (SSAS) ★★★☆☆
  • 11 Transactions and CheckPoints in SSIS (SSIS) ★★★★☆
  • 12 Simple SSRS Report & Implementing Matrix, Tabular, Parameters, Sorting ★★☆☆☆
  • 13 Using Data Profiling Task to Check Data Quality (SSIS) ★★★☆☆
  • 14 Hierarchical Dimensions (SSAS) ★★★★☆
  • 15 Web Services and XML Task (SSIS) ★★☆☆☆
  • 16 DrillDown and Subreports (SSRS) ★★★☆☆
  • 17 SSAS KPI (Key Performance Indicators) (SSAS) ★★★★☆
  • 18 Pivot, UnPivot and Aggregation (SSIS) ★★★★★
  • 19 SSAS Calculation (SSAS) ★★★☆☆
  • 20 SQL Execute Task (SSIS) ★★☆☆☆
  • 21 Reference and Many-to-Many Relationship (SSAS) ★★★★☆
  • 22 Script Task and Send Mail Task (SSIS) ★★★☆☆
  • 23 Script Component (SSIS) ★★☆☆☆
  • 24 Bar Chart, Gauge and Indicators (SSRS) ★★★★★
  • 25 Partitions in SSAS (SSAS) ★★★☆☆
  • 26 CDC (Changed Data Capture) in SSIS (SSIS) ★★★★☆
  • 27 Additive, Semiadditive and Non-additive Measures in SSAS (SSAS) ★★☆☆☆
  • 28 Buffer Size Tuning (SSIS) ★★★☆☆
  • 29 How to Implement Multithreading in SSIS? (SSIS) ★★★★☆
  • 30 Processing SSAS Cube in Background (SSAS) ★★★★★
  • 31 Explain Asynchronous, Synchronous, Full, Semi & Non-blocking Component ★★☆☆☆
  • 32 SSRS Architecture and Deployment (SSRS) ★★★☆☆
  • 33 DQS (Data Quality Services) (SSIS) ★★★★☆
  • 34 Explain Tabular Model and Power Pivot (SSAS) ★★☆☆☆
  • 35 MDX (Multidimensional Expressions) Queries (SSAS) ★★★★★
  • 36 Data Mining (Fundamentals and Time Series Algorithm) (SSAS) ★★★☆☆
  • 37 Page Split and Performance Issues with SSIS (SSIS) ★★☆☆☆
  • 38 Aggregations in SSAS (SSAS) ★★★★☆
  • 39 ROLAP, MOLAP and HOLAP (SSAS) ★★★☆☆
  • 40 Instrumentation using Data Taps (SSIS) ★★☆☆☆
  • 41 Lookup Caching Modes and Cache Transform (SSAS) ★★★★☆
  • 42 Perspectives & Translations (SSAS) ★★★☆☆
  • 43 Tabular Training 1: Installation, Xvelocity, Vertipaq, DAX, Creating ★★★★★
  • => Total Rating (points) 149 => Average Rating (stars) 3.39