Hi,
I am an experienced MS BI developer, skilled in SSAS, SSRS and SSIS, and have built projects for several clients based on these technologies, from the very small 2 day projects, to large, 6month + enterprise BI solutions.
I can give clear examples and training scenarios, working to your learning needs.
Depending on your existing level of experience - I can walk through the following topics:
- SQL interpretation - understanding data structures, relationships, performance characteristics
- Data Warehouse - designing a data warehouse
- SSIS - designing table/data migrations, fast performance
- SSAS - basics of dimensions, measures, calculations
- Advanced - relationships, handling NULL/duplicate key errors, advanced calculations, hierarchies and more
I would propose that there would be a series of several 3 or 4 small evening online training sessions, after which you would undertake some self-exploration, learning and then feedback questions in our next session.
I'm based in the UK and have worked in the enterprise solution architecture industry for over 15 years, so have good experience with all aspects of a solution, from turning business requirements into a clear spec, designing the solution, and delivering end user training.
I would need to obtain some further information about what your existing skillset is, and if you have an existing dataset/requirements, or are happy learning from a generic dataset that I will provide..