دوره آموزش Business Intelligence

1. Introduction
2. Roadmap of project tasks
3. Program/Project Planning and Management
4. Readiness factors
5. Risk assessment and mitigation plans
6. Scoping and business justification
7. Team roles and responsibilities
8. Project plan development and maintenance
9. Program management
10. Business Requirements Definition
11. Program versus project requirements preparation
12. Requirements gathering participants
13. Techniques for gathering requirements and handling obstacles
14. Program/project requirements deliverables
15. Requirements prioritization
16. Dimensional Modeling
17. Role of dimensional modeling in Project, Corporate Information Factory (CIF) and hybrid architectures
18. Fact and dimension table characteristics
19. 4-step process for designing dimensional models
20. Transaction fact tables
21. Fact table granularity
22. DE Normalizing dimension table hierarchies
23. Degenerate dimensions
24. Date and time-of-day dimension considerations
25. Dealing with nulls
26. Surrogate key for dimensions
27. Star versus snowflake schemas
28. Centipede fact tables with too many dimensions
29. Fact-less fact tables
30. Additive, semi-additive, and non-additive facts
31. Workshop: Converting requirements and source data realities into dimensional model
32. Consolidated fact tables
33. Dimension table role-playing
34. Allocated facts at different levels of detail
35. Complications with operational header/line data
36. Multiple currencies
37. Junk dimensions for miscellaneous transaction indicators
38. Periodic and accumulating snapshot fact tables
39. Implications of business processes on data architecture
40. Enterprise Data Warehouse Bus Architecture and matrix for master data and integration
41. Conformed dimensions – identical and shrunken roll-ups
42. Exercise: Translate business requirements into DW Bus Matrix
43. Slowly changing dimensions – type 1, 2, 3 and hybrid techniques for current and point-in-time attribute values
44. Mini-dimensions for large, rapidly changing dimensions
45. Exercise: Design review to identify common dimensional modeling flaws
46. Design review dos and don’ts and mistakes to avoid
47. Dimensional modeling process, tasks, and deliverables
48. Exercise: Design enhancements to embellish existing design
49. Mature DW/BI System Check-ups
50. Symptoms of sponsorship, data, infrastructure, and business acceptance disorders
51. Prescribed treatment plans for common maturity problems
52. Technical Architecture Design
53. Architecture concepts
54. Topology options – independent data marts, enterprise data warehouse, and conformed data warehouse
55. Common components and functionality
56. ETL system
57. Exercise: Processing slowing changing dimensions type 2
58. Presentation servers (RDBMS/OLAP)
59. Real time options – direct to source, ODS, and real time layer
60. BI application types and services
61. Creating the architecture plan
62. Exercise: Translating requirements into architecture implications
63. Product Selection and System Setup
64. Architecture-based evaluation approach and matrices
65. Infrastructure considerations
66. Metadata management
67. Securing the system
68. Physical Database Design
69. Standards and naming conventions
70. Physical model development
71. Initial aggregation, indexing and storage plans
72. Column-oriented database alternative
73. Usage monitoring
74. Extract, Transformation and Load
75. Design the ETL system
76. Determine design patterns and implement key subsystems
77. Quality assurance and data validation system
78. Warehouse operations system
79. ETL development workflow
80. Create high-level and detailed ETL schematics
81. Extract to create, filter and transfer source data
82. Cleaning and conforming dimensions and facts
83. ETL development workflow continued
84. Preparing and delivering dimensions and facts
85. Data integration and master data management
86. Dealing with data quality issues
87. Aggregate management
88. Load cycle management
89. Exercise: “High-level ETL schematic” case study
90. BI Applications
91. BI application types (ad hoc, standard reporting, analytic applications, dashboards) and audiences
92. Specification of templates, applications and navigation framework
93. Development of applications and BI portal
94. DW/BI System Deployment and Support
95. System deployment
96. Communication and documentation
97. Training and support
98. On-going user, data and system maintenance
99. DW/BI System Growth
100. Planning for growth

دوران آکادمی زیر مجموعه گروه دوران، مجری برگزاری دوره Business Intelligence در قالب آموزش شبکه به صورت آموزش آنلاین و حضوری با بهره گیری از لابراتور آنلاین اختصاصی بهمراه گواهی معتبر ارائه می‌شود.