Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required!
Authors’ note on using Microsoft Excel 2016: This book’s content was written against Excel 2013, but it is useful and valid for users of Excel 2016 too. Excel 2016 introduces several new DAX functions and an improved editor for DAX without changing any existing behavior. In other words, all of the concepts and examples explained in this book continue to work with Excel 2016.
Alberto Ferrari has achieved Microsoft SQL Server Analysis Services (SSAS) Maestro status and is a consultant and trainer who specializes in developing Microsoft BI solutions. He is the coauthor of Microsoft PowerPivot for Excel 2010 and Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology.
Microsoft Office, the world's leading productivity suite, hasbeen updated with new tools. Veteran Office users as well asnewcomers will need the comprehensive information in thisbestselling All-in-One guide.
With a self-contained minibook devoted to each Officeapplication plus minibooks on how Office works together and how youcan expand its usefulness, Office 2010 All-in-One ForDummies gets you up to speed and answers the questions you'llhave down the road.Microsoft Office is the office productivity suite used aroundthe globe; nearly every business worker encounters it dailyThe 2010 revision will affect all applications in thesuiteEight minibooks cover Word, Excel, PowerPoint, Outlook, Access,Publisher, common Office tools, and ways to expand OfficeproductivityAlso covers the new online versions of Word, Excel, andPowerPoint as well as changes to the interface and new tools andtechniques
Office 2010 All-in-One For Dummies makes it easy to learnto use Office and gets you up and running on all the changes andenhancements in Office 2010.
How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way–like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one!
By reading this book, you will:
• Gain an understanding of the basics of data modeling, including tables, relationships, and keys
• Familiarize yourself with star schemas, snowflakes, and common modeling techniques
• Learn the importance of granularity
• Discover how to use multiple fact tables, like sales and purchases, in a complex data model
• Manage calendar-related calculations by using date tables
• Track historical attributes, like previous addresses of customers or manager assignments
• Use snapshots to compute quantity on hand
• Work with multiple currencies in the most efficient way
• Analyze events that have durations, including overlapping durations
• Learn what data model you need to answer your specific business questions
About This Book
• For Excel and Power BI users who want to exploit the full power of their favorite tools
• For BI professionals seeking new ideas for modeling data
The distinction between departmental reporting done by businessanalysts with Excel and the enterprise reporting done by ITdepartments with SQL Server and SharePoint tools is more blurry nowthan ever before. With the introduction of robust new features likePowerPivot and Power View, it is essential for business analysts toget up to speed with big data tools that in the past have beenreserved for IT professionals. Written by a team of BusinessIntelligence experts, Microsoft Business Intelligence Tools forExcel Analysts introduces business analysts to the rich toolsetand reporting capabilities that can be leveraged to moreeffectively source and incorporate large datasets in theiranalytics while saving them time and simplifying the reportingprocess.Walks you step-by-step through important BI tools likePowerPivot, SQL Server, and SharePoint and shows you how to movedata back and forth between these tools and ExcelShows you how to leverage relational databases, slice data intovarious views to gain different visibility perspectives, createeye-catching visualizations and dashboards, automate SQL Serverdata retrieval and integration, and publish dashboards and reportsto the webDetails how you can use SQL Server’s built-in functionsto analyze large amounts of data, Excel pivot tables to access andreport OLAP data, and PowerPivot to create powerful reportingmechanisms
You’ll get on top of the Microsoft BI stack and all it cando to enhance Excel data analysis with this one-of-a-kind guidewritten for Excel analysts just like you.