SSIS | SSAS | Cubes | SSRS شرح ذكاء الأعمال

About SSIS | SSAS | Cubes | SSRS شرح ذكاء الأعمال

​يعتبر هذا الكورس من الكورسات القليلة باللغة العربية المتخصصة فى تعلم ذكاء الأعمال وتحليل البيانات بإستخدام أدوات مايكروسوفت الرائعة

شرح ذكاء الأعمال

SSIS شرح

SSAS شرح

Cubes شرح

SSRS شرح

Business Intelligence terms

(BI – ETL – Fact – Dimension – Measure – Cube – OLAP – OLTP - Star schema – Snow Flake schema - RDL/RDLC – MDX – DAX – Paginated reports)

Business Intelligence (BI developer)

Business intelligence comprises the strategies and technologies used by enterprises for the data analysis and management of business information. Common functions of business intelligence technologies include reporting, online analytical processing, analytics, dashboard development, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics, and prescriptive analytics.

Business Intelligence topics

SSIS

SQL Server Integration Services is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading

SSAS

Microsoft SQL Server Analysis Services is an online analytical processing and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files

SSRS

SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.