Master BI, SSIS, SSRS, SSAS & MDX – Zero to Hero (2024)

سرفصل های دوره

Mastering Data Engineering: From SSIS Foundations to Advanced MSBI Techniques

1. Introduction and Welcome to the Course

1. Course Intro

2. 1.Introduction to Business Intelligence

2. System Setup-Software Installation

1.1 SQL Server ODBC driver 18.zip

1. System Setup-Software Installation

2. 2.SQL server and SSMS

3. 3.Installing Visual Studio and SSDT tools

4. 4.DQS (Data Quality Services) - Installation and configuration

5. 5.SSRS-Install SQL Server Reporting Services

6. 6.Browse GitHub for Project Files

3. (SSIS-SQL Server) ETL-Dataflow Introduction

1.1 CustFile-1.csv

1.2 Git Hub.html

1.3 SSIS-intro-project(1-7) with files.zip

1. 3.(SSIS-SQL Server) ETL-Dataflow-Introduction

4. (SSIS-SQL Server) Conditional Split and Data Conversion

1.1 Git Hub.html

1. 1.Conditional Split and Data Conversion

5. (SSIS-SQL Server) Setting Pipeline Dynamic - Loops - Debugging

1.1 Git Hub.html

1. 5.1.For Each Loop

2.1 Git Hub.html

2. 5.2.Variable Creation - Control Flow

3.1 Git Hub.html

3. 5.3.Debugging

6. (SSIS-SQL Server) Parameters

1.1 Git Hub.html

1. 6.1.Parameters

7. (SSIS-SQL Server) Production Server Deployment Types

1.1 Git Hub.html

1. 7.1.Deployment Types

2.1 Git Hub.html

2. 7.2.Project Deployment

3.1 Git Hub.html

3. 7.3.Package Execution

4.1 Git Hub.html

4. 7.4.SSIS Package Automation

5.1 Git Hub.html

5. 7.5.Global Parameters

6.1 Git Hub.html

6. 7.6.Package Deployment

8. (SSIS-SQL Server) Different Type of Joins, Sort and Merge

1.1 Git Hub Join.html

1. 8.1 Sort And Merge

2.1 Git Hub Join.html

2. 8.2.InnerJoin

3.1 Git Hub Join.html

3. 8.3.LeftOuter Joint

4.1 Git Hub Join.html

4. 8.4.FullOuterJoin

9. (SSIS-SQL Server) Pivot Unpivot and Aggregate

1.1 GitHub - Pivot and Unpivot.html

1. 9.1.Pivot and Aggregation

2.1 GitHub - Pivot and Unpivot.html

2. 9.2.Unpivot

10. (SSIS-SQL Server) Schema Design and Database Relationship Diagram

1. 10.1.Different Schemas, Fact Table, Dimension Table Introduction.

2. 10.2.Tabel Creation and Relationship Diagram

3.1 10.Schema Design and Database Relationship Diagram.zip

3. 10.3.SSIS Project Setup

11. (SSIS-SQL Server) SCD Unicode and Lookup Concepts with Project

1.1 Scd-country.zip

1.2 SCD-Type2-Complete.zip

1. 11.1.SCD Introduction

2. 11.2.Unicode and Non-Unicode Introduction

3. 11.3.SCD Type 1

4.1 SCD-Type2-Complete.zip

4. 11.4.SCD Type 2 (Part-1) - Without Audit Trail

5.1 SCD-Type2-Complete.zip

5. 11.4.1.SCD Type 2 (Part-2) - With Audit Trail

6. 11.5.Lookup - Fact Table Loading into the SQL Server

12. (SSIS-SQL Server) Transactional Grouping and Checkpoints Logging

1.1 Schema.zip

1. 12.1.Transaction Options (Grouping of Activities)

2.1 Schema.zip

2. 12.2.Logging your runs (Checkpoints)

13. (SSIS-SQL Server) Data Quality Check Using Profiling Component

1.1 GitHub - Data Profiling Task.html

1. 13.1.Data Profiling Task

14. (SSIS-SQL Server) Instrumentation at Production Server - Debugging

1.1 GitHub - Instrumentation.html

1. 14.1.nstrumentation at Production Server

15. (SSIS-SQL Server) SQL Execute Task - Store Procedure Creation

1.1 Git SQL Execute - Direct Input.html

1. 15.1.SqlExecute - Direct Input

2.1 GitHub.html

2. 15.2.SQLExecute-Directinput-Parametrizing-ProjectDeployment

3.1 github.html

3. 15.3.SQlExecuteTask-Direct input-Store Procedure

4.1 github.html

4. 15.4.SqlExecute-Variable-FileConnection

16. (SSIS-SQL Server) Data Quality Services and DQS Component

1. 16.1.DQS (Data Quality Services) - Installation and configuration

2. 16.2.Data Quality Concepts and Process

3.1 Git DQS.html

3. 16.3.DQS Client UI and Project

4.1 Git DQS.html

4. 16.4.DQS Component in SSIS Project - with error

17. (SSIS-SQL Server) CDC (Change Data Capture)-Enabling CDC on SQL Server Database

1. 17.1.Enable CDC on Database and Table

2. 17.2.CDC introduction and Concepts

3.1 GitHub CDC Bulk.html

3. 17.3.CDC Bulk Load

4.1 GitHub CDC incremental.html

4. 17.4.CDC (Change Data Capture) - Incremental Load

18. (SSIS-SQL Server) Script Component-Data Transformation

1.1 GitHub Script.html

1. 18.1.Script Component-Transfrom Data using Scripting

19. (SSIS-SQL Server) Buffer Size Optimization and Component Types

1. 19.1.Component Types (Blocking - Not Blocking - Semi Blocking)

2.1 GitHub BufferSize.html

2. 19.2.Buffer Size Basic Concepts

3.1 GitHub BufferSize.html

3. 19.3.Buffer Size Calculation and Optimization

20. (SSIS-SQL Server) Sequential and Parallel Processing (Multithreading)

1. 20.1.Introduction to Sequential and Parallel Processing

2.1 adventureworks2022.zip

2.2 github parallel processing at component level.html

2. 20.2.Parallel Processing at Component Level

3.1 git parallel processing using select.html

3. 20.3.Parallel Processing using Select Query

4.1 git parallel processing at control flow.html

4. 20.4.Parallel Processing-Multithreading at Control Flow

5. 20.5.Partitioning Table SQL Server for Parallel Processing

21. (SSIS-SQL Server) Pages Indexes and Reducing Page Splits for improved ETL Load

1. 21.1.(SQL Pages) SQL Server internal Data Storage Structure

2. 21.2.Indexes for query performance

3. 21.3.Page Splits Monitor for Windows

4.1 github pagesplits.html

4. 21.4.Improving ETL Load by Dropping Indexes

22. (SSAS-SQL Server) Setting Up Cube from Scratch

1. 22.1.SSAS Introduction

2. 22.2.Data Sources and Data Views

3.1 22.Setting up a Cube.zip

3. 22.3.Defining Cube and Introduction

4. 22.4.Working with Cube

5. 22.5.Browser Tab UI-Named Query

6. 22.6.SSAS-SQL selection Decision for BI

23. (SSAS-SQL Server) Time Intelligence for SSAS and External BI tools Connection

1.1 Schema.zip

1. 23.1.Creating Time intelligent Query inside the Cube

2. 23.2.Connecting Cube with External Business Intelligence Tools

24. (SSAS-SQL Server) Key Performance Indicator Setup (KPIs) and Dimension Relations

1.1 github kpi.html

1. 24.1.Key Performance Indicator Setup (KPIs)

2.1 git refrence.html

2. 24.2.Dimention Relationship (Reference ) inside Cube

25. (SSAS-SQL Server) Partitions and Storage Modes (MOLAP-ROLAP)

1. 25.1. SSRS Partition Concepts

2.1 git partition.html

2. 25.2. Partitioning the Data in Cube (Hands-ON)

3.1 git rolap.html

3. 25.3.Setting up Different Storage Modes (MOLAP-ROLAP-HOLAP)

26. (SSAS-SQL Server) Perspectives and Reginal Language Creation

1.1 git prespective.html

1. 26.1.Prespectives in Cube

2.1 git translations.html

2. 26.2.Regional Language in Cube(Translations)

27. (SSAS-SQL Server) Measure Formula Types - Processing Cube in Production

1. 27.1.Measure Formula Types(Addition, Semi-Addition, Non-Addition)

2. 27.2.Processing SSAS Cube in Production Environment (Automation)

28. (SSAS-SQL Server) Aggregations in Cube

1. 28.1 Aggregations Concepts

2. 28.2.Storage Mode Concepts(MOLAP-ROLAP-HOLAP)

3. 28.3.Aggregations -Understanding SQL Profiler (Pinpoint the Cube Performance)

4.1 git aggregations.html

4. 28.4. Create Default Aggregations

5.1 git aggregations.html

5. 28.5.Aggregation Types-Options (Error Resolving While Creating Aggregations)

6.1 git aggregations.html

6. 28.6.Aggregations Design Using Query Log

29. (SSAS-SQL Server) Multidimension expressions (MDX) Query Language

1.1 MDX Basic Concepts - Difference between SQL and MDX.docx

1. 29.1.MDX Concepts

2.1 productTable.csv

2.2 sales fact.csv

2. 29.2.MDX Datasets Used

3.1 Important MDX queries with syntax and examples.docx

3. 29.3.MDX Basics

4.1 Important MDX queries with syntax and examples.docx

4. 29.4.(MDX) Hierarchy and Siblings Navigation Functions

5.1 Important MDX queries with syntax and examples.docx

5. 29.5.MDX Level Navigation Functions

6.1 Important MDX queries with syntax and examples.docx

6. 29.6.MDX Set Based Functions

7.1 Important MDX queries with syntax and examples.docx

7. 29.7.MDX Axis and Position Functions

8. 29.8.MDX Time-Intelligence Functions

9.1 Important MDX queries with syntax and examples.docx

9. 29.9.MDX Statistical Functions

10.1 Important MDX queries with syntax and examples.docx

10. 29.10.MDX String Functions

30. (SSAS-SQL Server) Tabular Cube Setup and Difference between Tabular and MultiDim

1. 30.1.Key Concept Query Language (MDX, DAX) , Tablular and Multidimension Models

2. 30.2.Introduction to Tabular (Tabular vs Multidimension)

3.1 git deploy tabular.html

3. 30.3.Basics of Creating and Deploy Tabular Model (Multidimension vs Tabular)

4.1 git tabular prespective.html

4. 30.4.Creating KPI in Tabular Model

5.1 git tabular prespective.html

5. 30.5.Creating Perspective in Tabular Model

31. (SSRS-SQL Server) Introduction to Report Building and SSRS

1. 31.1.SSRS introduction

2.1 git report.html

2. 31.2.Report Setup SSRS

3.1 git report.html

3. 31.3.Report Basic Structure and Report Data with MDX Query Language

4.1 git report.html

4. 31.4.Report Parameters (MDX Query Language)

5.1 git report expression.html

5. 31.5.Report Expression and Conditional Formating using Expressions

6.1 git sorting.html

6. 31.6.Sorting and Intractive Sorting

7.1 git manual report.html

7. 31.7.Manual Report Builder with SQL Server

8.1 git report sql.html

8. 31.8.Report Parameters (SQL Query Language)

9.1 git drill down.html

9. Drill Down Report Building

32. (SSRS-SQL Server)-Deploying Reports in Production Environment

1. 32.1.SSRS-Creating Report Server Database

2.1 git report in production.html

2. 32.2.SSRS-Deploy Reports in Production Enviornment

33. (SSRS-SQL Server) Creating Simple Dashboard in SSRS

1.1 git report bar chart.html

1. 33.1.SSRS-Simple DashBoard - Creating Charts

2.1 git report guage.html

2. 33.2.SSRS-Simple Dashboard - Guage Visual

3.1 git report indicator.html

3. 33.3.SSRS-Simple Dashboard - Inserting Indicator

34. Error Encounters

1.1 youtube channel for errors and more.html

1. 1.Error-SQL Analysis Server-Multidimension mode

2.1 youtube channel for errors and more.html

2. 2.Error- Microsoft Windows (11,10) Account Login problem in creating Cube for SS

3.1 youtube channel for errors and more.html

3. 3.windows microsoft Account Login for SSAS Cube

4.1 youtube channel for errors and more.html

4. 4.DQS-InvalidProgramException Common Language Runtime detected an invalid progr

5.1 youtube channel for errors and more.html

5. 5.CDC-Error Could not load file or assembly Microsoft.SqlServer.DtsMsg

6.1 youtube channel for errors and more.html

6. 6.Error Resolved LCID (8192)

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy