IT DATA ANALYST : IT DATA ANALYST CAREER TRAINING
MODULE 1
WELCOME : WELCOME
AGENDA : INTRODUCTIONS
INTRODUCTION TO R.D.B.M.S
DATA ANALYST CAREER PATH
INTRODUCTION TO DATA WAREHOUSING
INTRODUCTION TO ENTERPRISE REPORTING
INTRODUCTION TO CRM DATABASE MARKETING
INTRODUCTION TO MICROSOFT SQL SERVER 2008
INTRODUCTION TO MICROSOFT ACCESS
Q & A AGENDA
CLASS RULES : #1 Please be on Time
#2 Please complete all assignments CLASS RULES
IT DATA ANALYST : IT DATA ANALYST AN INTRODUCTION
DATA : DATA a collection of facts from which conclusions may be drawn information that has been translated into a form that is more convenient to move or process. Data is information, especially information organized for analysis A. B. C. D. all of the above none of the above E.
DATA : DATA a collection of facts from which conclusions may be drawn information that has been translated into a form that is more convenient to move or process. Data is information, especially information organized for analysis A. B. C. D. all of the above none of the above E.
TRADITIONAL DATABASE : TRADITIONAL DATABASE
RELATIONAL DATABASE : an organized body of related information RELATIONAL DATABASE Table
Slide 10 : Repeating Groups
(order items) Example of a De-normalized Database Table
Slide 11 : Example of a De-normalized Database Table Example Tables in 2nd Normal Form
Slide 12 : Example of a De-normalized Database Table Example Tables in 2nd Normal Form Example Tables in 3rd Normal Form
Slide 13 : Example of a Relational Database Management System (RDBMS)
Slide 14 : The information you need is most likely distributed in multiple tables.
Look for all the tables that contain the information you need
Find “Match-Keys” to link the tables together
Aim for a 1:1 relationship as much as possible and where practical.
IT DATA ANALYST : IT DATA ANALYST CAREER PATH
IT DATA ANALYST : IT DATA ANALYST
IT DATA ANALYST : IT DATA ANALYST
IT DATA ANALYST : IT DATA ANALYST
IT DATA ANALYST : IT DATA ANALYST
IT DATA ANALYST : IT DATA ANALYST
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO DATA WAREHOUSES
IT DATA ANALYST : IT DATA ANALYST THE WHAT? Data warehouse is a repository of an organization's electronically stored data Data warehouses are designed to facilitate reporting and analysis Data in a DW is stored in Fact & Dimension Tables
IT DATA ANALYST : IT DATA ANALYST THE WHAT? DATA WAREHOUSE DATAMART OLAP OLTP BUSINESS INTELLIGENCE CUBE DATA MINING ETL
IT DATA ANALYST : IT DATA ANALYST DIFFERENCE BETWEEN DATA WAREHOUSE & DATA MART represents the database of a complete corporate organization. DATA WAREHOUSE represents the database of a specific department DATA MART
IT DATA ANALYST : IT DATA ANALYST DIFFERENCE BETWEEN DATA WAREHOUSE & DATA MART Is built in iterations over a period of time DATA WAREHOUSE Can be built fairly quickly DATA MART
IT DATA ANALYST : IT DATA ANALYST DIFFERENCE BETWEEN DATA WAREHOUSE & DATA MART Finance Data Mart Sales Data Mart Operations Data Mart Enterprise Data Ware House
IT DATA ANALYST : IT DATA ANALYST DIFFERENCE BETWEEN DATA WAREHOUSE & DATA MART
IT DATA ANALYST : IT DATA ANALYST DIFFERENCE BETWEEN OLAP & OLTP Online analytical processing (OLAP) is designed for analysis and decision support, allowing exploration of often hidden relationships in large amounts of data. OLAP Online transactional processing (OLTP) is designed to efficiently process high volumes of transactions, instantly recording business events (such as a sales invoice payment) and reflecting changes as they occur. OLTP
IT DATA ANALYST : IT DATA ANALYST DIFFERENCE BETWEEN OLAP & OLTP OLTP OLAP
IT DATA ANALYST : IT DATA ANALYST OTHER IMPORTANT CONCEPTS Analysis Cube
IT DATA ANALYST : IT DATA ANALYST OTHER IMPORTANT CONCEPTS Analysis Cube Part of O.L.A.P
Created using tools like SQL Server Analysis services
Accessed through MDX queries ( a syntax similar to T-SQL) or programs like Excel / ProClarity etc.
Multi-Dimensional in nature
IT DATA ANALYST : IT DATA ANALYST OTHER IMPORTANT CONCEPTS Data Mining / Business Intelligence
IT DATA ANALYST : IT DATA ANALYST OTHER IMPORTANT CONCEPTS Data Mining / Business Intelligence Complex Business
Needs
Decision Support
IT DATA ANALYST : IT DATA ANALYST OTHER IMPORTANT CONCEPTS Data Mining / Business Intelligence
IT DATA ANALYST : IT DATA ANALYST
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO ENTERPRISE REPORTING
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO ENTERPRISE REPORTING Enterprise Reporting is the process of querying data sources with different logical models to produce a human readable report.
Slide 38 : The information you need is most likely distributed in multiple tables.
Look for all the tables that contain the information you need
Find “Match-Keys” to link the tables together
Aim for a 1:1 relationship as much as possible and where practical.
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO ENTERPRISE REPORTING KEY FEATURES Regular provision of information to decision-makers within an organization to support decision making
Reports can take the form of graphs, text and tables
Disseminated through an intranet as a set of regularly updated web pages (or "enterprise portal") or through refreshable Excel Dashboards
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO ENTERPRISE REPORTING
IT DATA ANALYST : IT DATA ANALYST MS ACCESS 2007
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING Also known as Targeted Marketing
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING DataBase Marketing Database marketing is a form of direct marketing using databases of customers or potential customers to generate personalized communications in order to promote a product or service for marketing purposes. The distinction between direct and database marketing stems primarily from the attention paid to the analysis of data. Database marketing emphasizes the use of statistical techniques to develop models of customer behavior, which are then used to select customers for communications.
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING Client Relationship Management CRM stands for Customer Relationship Management. It is a process or methodology used to learn more about customers' needs and behaviors in order to develop stronger relationships with them. CRM helps businesses use technology and human resources to gain insight into the behavior of customers and the value of those customers.
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING SCENARIO – DIRECT MARKETING PRODUCT – WIDGET X
PRICE PER UNIT: $300
PROFIT PER UNIT - $200
CUSTOMERS IN DATABASE: 50,000
COST OF MAILING PER CUSTOMER - $1.5
TOTAL MAILING COST - $75,000
EXPECTED RESPONSE – 20% (10,000 CUSTOMERS)
TARGET CONVERSION – 10% (1000 CUSTOMERS)
REVENUE TARGET – $300,000
TOTAL PROFIT - $125,000 (after subtracting the cost of direct mailing cost)
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING SCENARIO – DATABASE MARKETING PRODUCT – WIDGET X
PRICE PER UNIT: $300
PROFIT PER UNIT - $200
CUSTOMERS IN DATABASE: 50,000
TOP 30% RESPONDERS / EARLY ADAPTERS – 15,000
COST OF MAILING PER CUSTOMER - $1.5
TOTAL MAILING COST - $22,500
EXPECTED RESPONSE – 20% (3000 CUSTOMERS)
TARGET CONVERSION – 33% (1000 CUSTOMERS)
REVENUE TARGET – $300,000
TOTAL PROFIT - $177,500 (after subtracting the cost of direct mailing cost)
SAVINGS OF OVER $50k
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING
IT DATA ANALYST : IT DATA ANALYST INTRODUCTION TO CRM DATABASE MARKETING
IT DATA ANALYST : IT DATA ANALYST THE BOTTOM LINE
IT DATA ANALYST : IT DATA ANALYST IN THE NEXT CLASS LEARN DATA MODELLING
SSIS PACKAGES IN B.I.D.S
CREATE A MINI DATA MART
IT DATA ANALYST : IT DATA ANALYST CLASS PROCESS
Q&A : Q&A