Day #2 - Data Management Course Notes

Link
Module #4 - Master Data Management
Key Notes

• Master data, agreed and shared across Enterprise (Customer, Employee)
• Reference data is a subset of master data (Country Code, Industry Classification)
• Data Representation differences - MM/DD/YYYY, DD/MM/YY, Identify potential matches, apply business rules and merge records
• MDM creates master records with consistent data representation
• Have a lookup to reference table with possible different representations, Update sources with valid state names

Module #5 - Data Integration

• Scenarios  - ETL, ELT, Batch, and Real-time Integration
• Data Source -> Integration -> Target Systems
• Source -> staging -> DW
• Calculations, Aggregations during ETL
• Batch Processing, Real-time integration

Module #6 - Analytics

• Reporting and Analytics
• Monitor, Understand and improve business
• Cross-Selling, Upselling
• Marketing Insights
• Promotional Campaigns
• Dashboards, Visualization, Alerts, Conditional Reports
• Data mining, Stats, Text Analysis

Module #7 - Data Architecture
Models, Rules, Policies that govern definition, storage

Module #8 - Privacy

• Protect Sensitive data
• Unauthorized Access
• SSN, DOB, CreditCard, SalesPlan
• Governance - Rules, Privacy - Protect Rules
• Email Protection, Antivirus, Firewalls, WIFI encryption, Cloud data storage systems, Secured Network Access   

Happy Learning!!!