O'Reilly logo

Practical PowerPivot & Dax Formulas For Excel® 2010 by Art Tennick

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix ASQL Queries for PowerPivot

This is a short appendix. It’s aimed at those readers who need a brief introduction to SQL, with some basic syntax examples. We also discuss the reasons for writing your own queries to import data into PowerPivot, rather than simply importing complete tables. A few query fundamentals are covered: filtering, sorting, grouping, and denormalizing data with joins and self-joins. There are also examples of using a stored procedure and writing SQL queries against Excel.

image Key concepts SQL, selecting columns, calculated columns, filtering data, sorting data, grouping data, denormalizing data with joins and self-joins, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required