Free ebook: Introducing Microsoft Power BI

We’re happy to announce the availability of our newest free ebook, Introducing Microsoft Power BI (ISBN 9781509302284), by Alberto Ferrari and Marco Russo. Enjoy!

20

From the MVPs: End of Excel VLOOKUPS – Power Pivot Relationships

This is the 55th in our series of guest posts by Microsoft Most Valued Professionals (MVPs). You can click here to see all past MVP articles. Since the early 1990s, Microsoft has recognized technology champions around the world with the MVP Award. MVPs freely share their knowledge, real-world experience, and impartial and objective feedback to…

0

Sample chapter: The VertiPaq Engine in DAX

This chapter from The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI covers the internal architecture of the VertiPaq engine: the in-memory columnar database that stores and hosts your model. At this point in the book, you have a solid understanding of the DAX language. The next…

0

Sample chapter: Understanding Evaluation Contexts in DAX

This chapter from The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI covers evaluation contexts, which are the basis of all of the advanced features of DAX. At this point in the book, you have learned the basics of the DAX language. You know how to create…

0

New book: The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI

We’re pleased to announce the availability of The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (ISBN 9780735698352), by Marco Russo and Alberto Ferrari. Purchase from these online retailers: Microsoft Press Store Amazon.com Barnes & Noble Independent booksellers – Shop local This comprehensive and authoritative guide will…

0

Sample chapter: T-SQL Querying: TOP and OFFSET-FETCH

This chapter from T-SQL Querying starts with the logical design aspects of the filters. It then uses a paging scenario to demonstrate their optimization. The chapter also covers the use of TOP with modification statements. Finally, the chapter demonstrates the use of TOP and OFFSET-FETCH in solving practical problems like top N per group and…

0

New book: T-SQL Querying

We’re pleased to announce the availability of T-SQL Querying (ISBN 9780735685048), by Itzik Ben-Gan, Adam Machanic, Dejan Sarka, and Kevin Farlee. Purchase from these online retailers: Microsoft Press Store Amazon.com Barnes & Noble Independent booksellers – Shop local T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from…

3

Event: Accelerate Your Insights

Drive your business in real-time, from apps to insights, using all your data, big and small. Hear from CEO Satya Nadella, COO Kevin Turner, and CVP Quentin Clark on how to transform data into action by combining the power of SQL Server 2014 with the familiarity of Power BI for Office 365. Mark your calendar…

0

New book: Business Intelligence in Microsoft SharePoint 2010

We’re pleased to announce the availability of the Microsoft Press book Business Intelligence in Microsoft SharePoint 2010 (416 pages; ISBN: 978-0-7356-4340-6).  This book gives business intelligence (BI) developers, SharePoint administrators, and business users a view into SharePoint Server 2010 as a platform for providing BI for their organizations, teams, and individuals as a self-service option….

1