Building a Data warehouse Purpose & Goals of Data Warehouse Purpose & Goals of Data Warehouse: Focus on fundamentals before delving into details of modeling and implementation. Listen to the Business and understand the goals and current pain points in reporting the business needs. The Data warehouse must make the organizational information readily available and… Continue reading 6. Introduction to DWBI – Goals of Data Warehouse
5. Introduction to DW&BI – ETL Extract Transform and Load
ETL – Extract Transform & Load Extract Transform and Load: ETL means Extract, Transform, and Load. ETL is a process combined with technology. Using this process data is extracted from all sources, and depending on the user requirements the data is transformed for reporting needs, and finally, data loaded into the Data warehouse. ETL is… Continue reading 5. Introduction to DW&BI – ETL Extract Transform and Load
4.Introduction to DW & BI – DWBI Cycle
DWBI Cycle Data Warehousing and Business Intelligence: A real Business Intelligence passes through a Data warehouse and utilizes the data-stored for information, knowledge, and plans that produce effective business actions. So, Business Intelligence is a combination of process, technology, and a tool. Means Business Intelligence encompasses Data warehouse, Tools, and Visual knowledge management. Among all,… Continue reading 4.Introduction to DW & BI – DWBI Cycle
3.Introduction to DW&BI – Kimball or Inmon Model
Data warehouse - Kimball or Inmon model. The following information provides an understanding of the basics of two different approach in Data warehouse modeling: History of Data Warehouse: In 1990 Inmon wrote a book "Building the Data Warehouse." Inmon defines an architecture for the collection of disparate sources into detailed, time variant data store (The… Continue reading 3.Introduction to DW&BI – Kimball or Inmon Model
2.Introduction to DW&BI – Why DWBI?
Why DWBI Executives and Manager managing business challenged for new avenues to improve the business and economic conditions. The challenge is to do more with less and to make better decisions in a competitive industry. DWBI environment provides access to actionable data to act in a short time. The impressive reputation of DWBI in the… Continue reading 2.Introduction to DW&BI – Why DWBI?
1.Introduction to DW & BI – What is Data Warehouse & Business Intelligence
Introduction to Data Warehouse and Business Intelligence What is a Data Warehouse? Defining a Data warehouse is very simple. A data warehouse is a data repository were all relevant Enterprise data is stored and provides as a single source for the Enterprise reports, analysis, and presentation through ad-hoc reports, canned reports, portals, and dashboards. What is… Continue reading 1.Introduction to DW & BI – What is Data Warehouse & Business Intelligence
SSDB – Part 13. ETL – Connecting Foreign Keys to Surrogate Keys
Connecting Foreign Keys to Surrogate Keys
SSDB – Part 12. ETL – Creating Date Lookup Tables
Creating Date Lookup Tables
SSDB – Part 11. ETL – Redefining Nullable Values for Enhanced Reporting
Redefining Nullable Values for Enhanced Reporting: CLICK to Continue Reading.......
SSDB – Part 10. ETL – Combining Data from Multiple Tables
Combining data from multiple tables: CLICK to continue reading....
SSDB – Part 9. ETL – Reformatting Data to Make it More Readable
Reformatting Data to Make it More Readable.....CLICK to Continue reading..........
SSDB – Part 8. ETL – Converting Data types for consistency
Converting Data Types for consistency:......... READ/VIEW VIDEO.................
TSQL – Part 1(d) – Working with NULLS
NULL is used to indicate an unknown or missing value. NULL is not equivalent to zero or an empty string. Arithmetic or string. CLICK to READ ....
TSQL – Part 1(c) – Data Types
Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numeric, approximate numeric, character, date/time, binary, and other. CLICK TO READ...................
TSQL – Part 1(b) – SELECT statement
Use the SELECT statement to retrieve a rowset of data from tables and views in a database.. CLICK TO READ --------------
TSQL – Part 1(a) – Introduction to Transact SQL
Transact-SQL is an essential skill for database professionals and developers working with Microsoft SQL Server. CLICK to READ -----------------
SSDB – Part 4. ETL – Slowly Changing Dimension SCD Type 2 and 3
Extract Transform and Load using SQL server database stored procedure.
DWBI – Part 2-c. Data Warehouse – Architectures
Data Warehouse Architectures
DWBI – Part 2-b. Data Warehouse – Gathering Requirements
Gathering Requirements
DWBI – Part 2-a. Data Warehouse – Planning
Data warehouse planning:
MSBI – SSRS – Create shared data sources and datasets for your reports
Create shared data sources and datasets for your reports:
