SSDT

User Friendly Data Models in Power Pivot & Tabular

by

Organization and user friendly data model development in Power Pivot & Tabular environments take precedence over almost all other concerns. We will discuss best practices of creating a data dictionary, naming rules, etc. of Power Pivot & Tabular data models in other, related postings.   In this posting, we will discuss some options of organizing the data.  As stated … Read more

Best Practices of Microsoft BI

by

We have seen several dispersed articles on Power Pivot, SSAS Tabular, and Data Analysis Expressions (DAX) best practices.   Over many articles, we will attempt to consolidate many of these into a single, consolidated location as well as adding new material to the list based on our experiences as well as any missing information we … Read more