Power BI
by Kelly Savage
1. Training
1.1. dax vs query
1.2. data modeling
1.3. how to use visualizations
1.4. create common themes
2. QA
2.1. how to catch bad measures?
2.2. test thru tabular or excel?
2.3. match dax to sql
2.4. automation challenge?
3. Development
3.1. multiple developers
3.2. determine data sources
3.3. report development 1 pbix 1 developer
3.4. approach to gather data with queries
4. Monitoring Report/Dashboard
4.1. DQ Dashboard
4.1.1. improve visualizations
4.1.2. improve needs
4.2. build A3 Dashboard
4.2.1. add A4 Dashboard
4.2.1.1. monitoring
4.2.1.1.1. DQ
4.2.1.1.2. errors
4.2.1.1.3. hd tickets
4.2.1.1.4. overall job performance
4.2.1.2. ssrs/ssas long running
4.2.1.2.1. whos using?
5. Challenges/Pitfalls
5.1. multiple devs merging multiple reports
5.2. different data sets used
5.2.1. how to connect and build shared dataset?
5.3. Visualizations
5.3.1. which visualization to use
5.3.2. how to create meaningful dashboards
6. Cube
6.1. adding measures to the cube
6.2. more cubes tbd
6.2.1. larger datasets
6.2.2. easier to manage
6.2.2.1. 1 dev 1 data model