Business-Intelligence-and-Decision-Support

The course mainly about how to build data mark for data processing and BI.

Lab1 SQL Server Management Studio (SSMS) & SQL Server Integration Services (SSIS)

• SQL Server Management Studio (SSMS) is a tool for administrating and developing SQL Server database. It includes some functions like creating databases, design tables, adding data, updating data and running queries.
• SQL Server Data Tools (SSDT) is a modern development tool for building Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. It is used for creating and maintaining SQL server Integration Services (SSIS) projects. You can use Integration Services for building high performance data integration solutions, including extraction, transformation, and loading (ETL) of data for data warehousing.

Lab2 SQL Server Analysis Services

By using SQL Server Data Tools (SSDT) Analysis Services, you can build a multidimensional model to perform OLAP (online analytical processing) analysis. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

Lab3 Multi-Dimensional Expressions

Multi-Dimensional eXpressions (MDX) is a language that expresses selections, calculations, and some metadata definitions against an Online Analytical Processing (OLAP) database, and provides some capabilities for specifying how query results are to be represented. While SQL is used for relational queries, MDX is used for multidimensional queries. You have learnt how to create a cube with dimensions (e.g. Time, Product, Customer) and measures (e.g. Internet sales amount). In this lab, you will learn how to use MDX queries to extract useful data from the cube.

Lab4 SQL Server Reporting Services (SSRS) and Power BI

Reporting Services has a quite complex architecture. The full Reporting Services architecture includes development tools, administration tools, and report viewers. The following shows a simplified diagram of the main Reporting Services components that will be used.

MinProject

Using a database of NBA and ABA statistics to do OLAP by Microsoft SQL Server and SSDT.

• Data mart schema? star : snowflake ： constellation
• Data data selection and stability analysis
• Building cube and answer the questions.