BI ALM with TFS 2017

34 Pages·2017·1.24 MB·English

BI ALM & TFS
Microsoft Business Intelligence Application Life-Cycle Management
with Team Foundation Server.
(Good job there are acronyms)
About me: Dmytro Andriychenko
• Business Intelligence Architect, Developer, Data Scientist, etc.
• SQL Server BI Certified Expert
• Over 10 years data of data integration and analysis experience
• Lately focused on BI architecture, design and delivery
• Dmytro, Dmitriy, Dimitriy or just D – perfectly fine, I do not bite.
• Data United Ltd – all things data
• Integrity
• Performance
• Insight
Why ALM: What can possibly go wrong?
• Knight’s tale: losing $172,222 per minute after a bad deployment
• Gartner: 40% of critical system outages are due to change
management or deployment
• Career-limiting events:
wrong
were ?
• … year-end finance report figures
What is successful ALM?
• Continuous, transparent, reliable integration and deployment
• Dev-Ops cooperation and collaboration
• Productive Agile Development
• Effective, sustainable management of
• Work load/items
• Teams
• Product pipeline
• Infrastructure
Application Life-Cycle Management (ALM)
• Deliver • Deploy
BI &
MsBuild
DB Projects,
Test Manager,
MS Test,
Release
Version
Manager
Control
Dev Sprint Monitor Ops
Backlog
planning,
Sprint Board, Bug Tracking
BurnDown
chart
• Plan • Operate
ALM I: What Planning? We are all Agile, right?
ALM I: Planning: the most important step
• Prior Proper Planning Prevents Poor Performance (Brian Tracy:10/90)
• Organise work into Features, PBIs(User Stories) and Tasks:
• Feature – project level item
• Product Backlog Item (PBI): scrum – level container of work tasks
• Task: individual work item, user story, 2 days effort max
• Assign tasks to developers at the beginning of sprint & set duration
• Monitor and update tasks via task board & burn-down chart
• Facilitate communication by using the task board on agile ceremonies
Task Board
Task
Product
Backlog
Item (PBI)
or
User Story
Burndown chart: progress against sprint plan
ALM 2: Delivery (Development)
• Version Control: TFS VC and/or git repository
• Database projects and dacpac deployments
• Database Unit Test Framework: MS Test
• Link Tasks to Check-Ins/Commits: