Business Analyst, Developers & DBAs using Power BI.
Power BI is such a powerful tool to develop visualizations. In order to display visuals, the developers of Power BI reports need to understand how data is organized in a data model. The sources vary. So examples of spreadsheets, flat tables or files and relational database tables all have a place in a data model.
The spreadsheet example is great for using the Mashup techniques in Power Query (M Code). The flat table or file can help speed up the development of the report. The relation table involves database design skills which new data modelers usually do not have at the needed level. Most think they do have it because of T-SQL skills developed over their career.
This session will flow from one example to another and demonstrate the best path for a developer of Power BI reports. Power BI users will understand the uses of a relational database to develop in a enterprise or corporate environment. The path will help the attendee have an 'ah ha' moment about data models in Power BI.
Why I Want to Present This Session:
I see to many people start using Power BI without understanding the complications of not getting the data modeling correct. Then, many Power BI reports are developed and released with proper modeling. Then, they say, yes I can do it this way, see!!! Too many times they loss sight of the big picture.