کتاب فارسی-جداول و نمودار های محوری در اکسل

این کتاب توسط جناب آقای صمدیان تالیف شده است

برای دانلود به وبلاگ زیر مراجعه کنید.

http://amar80.blogfa.com

در صورتی که لینک دانلود پاک شده بود یا مشکل داشت در قسمت نظرات این وبلاگ بیان کنید تا لینک دانلود قرار داده شود

از اینجا دانلود کنید

کتاب PowerPivot for the Data Analyst: Microsoft Excel 2010

Business intelligence (BI) tools make it possible for companies to gain deep, actionable insights for faster, better decision-making - and greater competitiveness. Until recently, however, access to BI has largely been restricted to experts using complex, specialized tools. With PowerPivot for Excel 2010, Microsoft has changed that. Together with SQL Server 2008 and Microsoft's new SharePoint Analysis Services, PowerPivot makes advanced business intelligence available to any mainstream business user working with Excel 2010. Of course, having the tools isn't enough: you must learn how to use them. That's where PowerPivot for the Data Analyst comes in. In this book, legendary Excel expert and instructor Bill Jelen shows exactly how to use PowerPivot to gain deep, actionable insights for more effective business decision-making. Using concrete examples and real-life scenarios, Jelen walks through setting up PowerPivot and integrating multiple data sources; creating and sharing dynamic dashboards; slicing and dicing to perform fast, interactive, ad hoc analyses; leveraging Excel's familiar features in advanced BI applications; and much more. This book is part of the new MrExcel Library series.

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

کتاب Microsoft PowerPivot for Excel 2010: Give Your Data Meaning By Marco Russo, Alberto Ferrari

Transform your skills, data, and business—with the power user’s guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you’ll learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel. Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required. The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, “self-service” BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint®.

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

کتاب Pivot Table Data Crunching: Microsoft Excel 2010

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes.

Coverage includes:

• Creating PivotTables, customizing them, and changing the way you view them
  
• Performing calculations within PivotTables
  
• Using PivotCharts and other visualizations
  
• Analyzing multiple data sources with PivotTables
  
• Sharing PivotTables with others
  
• Working with and analyzing OLAP data
  
• Making the most of Excel 2010's powerful new PowerPivot feature
  
• Using Excel 2010's Slicer to dynamically filter PivotTables
  
• Enhancing PivotTables with macros and VBA code
  

This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels
Includes proven PivotTable recipes for instant on-the-job results

Helps Excel users avoid common pitfalls and mistakes

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel

کتاب PowerPivot for Business Intelligence Using Excel and SharePoint

PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.

PowerPivot for Business Intelligence Using Excel and SharePoint is your key to mastering PowerPivot. The book takes a scenario-based approach to showing you how to collect data, to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter in the book is focused on a specific challenge that you’ll encounter when using PowerPivot. Each chapter takes you through a solution technique that’s been proven in the real world.

• Covers the leading technology for bringing data analytics to the desktop
• Presents real-world solutions to real-world scenarios
• Written by a Microsoft Virtual Technical Specialist (VTS) for business intelligence

What you’ll learn

• Install and verify the PowerPivot software
• Integrated existing, available data to deliver business intelligence
• Leverage Time Intelligence to report change over time
• Write Data Analysis Expressions (DAX) to create custom measures
• Identify and implement solutions for role-playing dimensions
• Recognize and work-around PowerPivot’s missing features

Who this book is for

PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone

برای تهیه به این لینک مراجعه کنید.

Ebook لاتین Excel