Code files uploaded by Packt publishing
This is the code repository for Tabular Modeling with SQL Server 2016 Analysis Services Cookbook,published by Packt.It contains all the supporting project files necessary to work through the book from start to finish.
##About the book The book begins by quickly taking you through the concepts required to model tabular data and set up the necessary tools and services. As you learn to create tabular models using tools such as Excel and Power View, you’ll be shown various strategies to deploy your model on the server and choose a query mode (In-memory or DirectQuery) that best suits your reporting needs.
You’ll also learn how to implement key and newly introduced DAX functions to create calculated columns and measures for your model data. Last but not least, you’ll be shown techniques that will help you administer and secure your BI implementation along with some widely used tips and tricks to optimize your reporting solution.
All of the code is organized into folders.Each folder starts with a number followed by the application name. The commands and instructions will look like the following:
Total_Fatalities_GT2_MajorInjuries := SUMX(
FILTER(CRASH_DATA_T, CRASH_DATA_T[MAJINJURY]>2),
CRASH_DATA_T[FATALITIES]
)
Chapter 01, 02, 06, 08, 11 do not have code files.
- SQL Server Analysis Services 2012 Cube Development Cookbook
- Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
- MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
###Suggestions and Feedback Click here if you have any feedback or suggestions.
If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost.
Simply click on the link to claim your free PDF.