Azure Reporting & Analytics Analysis & Design: 3-6 Week Assessment

Eide Bailly LLP

Deliver Azure analytics strategy including documentation, milestones, software/ETL stack recommendations (ex Data Warehouse, ETL), reporting plan, & estimates based on your specific business needs

Data architects from Eide Bailly Analytics will hold Analysis & Design sessions (remote or onsite*) with each of your departments to gather information on your specific business processes, needs, current reporting processes, existing Azure/Microsoft-cloud footprint, & data-state/situation. We find a data/analytics champion within your organization & work with them to put together written recommendations & an assessment to begin your Azure data analytics strategy including the items below. This assessment benefits a range of users from mid-market companies who may have limited-to-no analytics, to enterprise companies who need specific guidance on tools or staff augmentation/support. Our team provides this assessment & can provide further support from a full implementation & management team to simple guidance/training.


  • Prioritized milestones
  • Azure software/ETL stack recommendations (ex. Data Factory, Logic Apps, Azure SQL Database, Synapse, Snowflake, DevOps/GitHub, Power BI, etc.)
  • Source-system overview (source prioritization/complexity, data size, automated extraction methods, refresh frequency, etc.)
  • Team implementation recommendations (architect, data engineer, project manager, report writer, etc.)
  • Phase 1 Azure Analytics implementation recommendations & estimates (hardware/software costs, implementation hours, etc.)
  • Reporting plan (software, initial priority reports, users, licensing, etc.)
  • Methodology & process recommendations (Kimball modeling, security, version control, dev/prod environments, etc.)

Resultant Artifacts
  • Business & Technical Requirements Document (BRD)
  • Initial Risk Log
  • Azure Data Flow Diagrams (Current State, Overall Future, & Phase 1)
  • Bus matrix (Facts/Dims for Phase 1)
  • Source prioritization vs complexity matrix (Overall)
  • Maturity Model Placement
  • Initial Data Warehouse ERD outline (high-level)
  • Phase 1 scope & estimations
  • Team role recommendations
  • Software stack recommendations
  • PowerPoint consolidation/presentation (Deliverables above + Business interview results: Pain points, Project Timelines, Design Standards, & other client-specific useful details)

The end result is a plan from Azure experts on how to use Azure in a best-practice way to make your business data-driven whether you are just getting started with Azure & Analytics or extending what you already have.

*Onsite visits determined case-by-case