DATA WAREHOUSING - TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP


 DATA WAREHOUSING

TECHNICAL TALK- WORKSHOP 



Agenda:


Technologies Focused :  Data Warehousing

Number of Students : 80

Date of the Programme : 27-02-2018

Location of the Programme :Chennai KaaShiv InfoTech

Programme Mission :

1. Social activities in spreading Microsoft Technologies to the students.
2. Awareness on Microsoft SQL Servers  and security.
3. Practical demos on Microsoft SQL Servers
4.Micosoft Today: Advanced SQL Server Applications in Azure.
5.Talk on SQL Applications and Its features.


Overview of Data Warehousing:




What is Data Warehousing-How Data warehouse helps to the business Stockholder-:



Features of Data Warehousing:


Terminology of Building Data Warehouse-Dimensions,Measures and Related Concepts-Additive measures-Semi-additive measures-Non-additive measures-Hierarchy-Data Mart -Member:



 Terminology of Building Data WarehouseFacts -and Dimension Tables:



 Terminology of Building Data Warehouse-Star and Snow Flake Schema:



Terminology of Building Data Warehouse-Indexing Considerations:



 Terminology of Building Data Warehouse-Slowly Changing Dimensions:



 Terminology of Building Data Warehouse-Extraction,Transformation and Loading:


Additional Information About Datawarehousing:




Comments

Post a Comment

Popular posts from this blog

IMPLEMENT GEO-DISTRIBUTED DATABASE IN SQL- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
IMPLEMENT GEO-DISTRIBUTED DATABASE IN SQL TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused :Implement Geo-Distributed data base in SQL Number of Students : 50 Date of the Programme : 07-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Implement Geo-Distributed data base in SQL: How to create a Data base users and how to grant them permission: how to create a server level fire -wall: Set-up a Data base level fire-wall group: Why we need a Geo-Distributed data base:  vital  role of Geo-distributed Database: what is a replication: Capability  ...
Read more

SQL SERVER MANAGEMENT ISSUES- TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL SERVER MANAGEMENT ISSUES TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server Management Issues Number of Students : 50 Date of the Programme : 13-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. Overview of SQL  Server Management Issues: Troubleshoot the problem using query analyser: What is in the SQL Server Error log and  Various types of tuning:  E xceptions in  SQL Server Management Objects: What is SQL Server Crash-What  is response time: Focus on Response time and  Solutions for the Issues: Review for performance Count...
Read more

SQL SERVER BUSINESS INTELLIGENCE DATA MODELING -TECHNICAL TALK - WORKSHOP - By Microsoft Awarded Azure MVP

Image
SQL SERVER BUSINESS INTELLIGENCE DATA MODELING TECHNICAL TALK- WORKSHOP   Agenda: Technologies Focused : SQL Server Business Intelligence Data Modeling. Number of Students : 80 Date of the Programme :08-03-2018 Location of the Programme :Chennai KaaShiv InfoTech Programme Mission : 1. Social activities in spreading Microsoft Technologies to the students. 2. Awareness on Microsoft SQL Servers  and security. 3. Practical demos on Microsoft SQL Servers 4.Micosoft Today: Advanced SQL Server Applications in Azure. 5.Talk on SQL Applications and Its features. SQL Server Business Intelligence overview: What is Data Modeling-Data Modeling a Warehouse: Understanding the data-Building the Data model: Conceptual of Data Model:  Usage of Data Modeling: How to Implement the table in Data Base system: Create Tables Using Designer Tools:
Read more