Читать книгу Excel Power Pivot & Power Query For Dummies - Michael Alexander - Страница 11

IN THIS CHAPTER

Examining traditional Excel limitations

Keeping up with database terminology

Looking into relationships

With the introduction of business intelligence (BI) tools such as Power Pivot and Power Query, it’s becoming increasingly important for Excel analysts to understand core database principles. Unlike traditional Excel concepts, where the approach to developing solutions is relatively intuitive, you need to have a basic understanding of database terminology and architecture in order to get the most benefit from Power Pivot and Power Query. This chapter introduces you to a handful of fundamental concepts that you should know before taking on the rest of this book.