Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Tabular Modeling Cookbook

You're reading from   Microsoft Tabular Modeling Cookbook No prior knowledgeof tabular modeling is needed to benefit from this brilliant cookbook. This is the total guide to developing and managing analytical models using the Business Intelligence Semantic Models technology.

Arrow left icon
Product type Paperback
Published in Dec 2013
Publisher Packt
ISBN-13 9781782170884
Length 320 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Paul te Braak Paul te Braak
Author Profile Icon Paul te Braak
Paul te Braak
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Getting Started with Excel FREE CHAPTER 2. Importing Data 3. Advanced Browsing Features 4. Time Calculations and Date Functions 5. Applied Modeling 6. Programmatic Access via Excel 7. Enterprise Design and Features 8. Enterprise Management 9. Querying the Tabular Model with DAX 10. Visualizing Data with Power View A. Installing PowerPivot and Sample Databases Index

Creating the database

The SQL Server database used in the prior recipes is available as a backup from the online content for this book on the Packt Publishing website. This backup can be restored to the SQL server instance (running SQL Server 2012).

We do not specify details for the installation of SQL Server (since they are outside the scope of this book). However, a brief overview of the database restore is discussed in this section.

An evaluation version of SQL Server is available for download at the following URL. This license will expire after 180 days. Alternatively, a free edition of SQL Server (SQL Server Express) is also available (with reduced features and no license expiry limit).

http://www.microsoft.com/betaexperience/pd/SQL2012EvalCTA/enus/default.aspx

The online resources contain two files. Firstly, a file named tabular_modelling.bak, which is the database backup. The second is the file that contains the restore script. It is also reproduced as follows:

USE [master]

RESTORE DATABASE...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image