Smiley face

Google
در فروشگاه اينترنتي داتيس   در كل اينترنت

تقويم و مناسبتها

رهگيري مرسولات پستي

كاربرگرامي شما مي توانيد پس از دريافت باركد پســتي از طريق دكمه رهگيري سفارشـات ، بوسيله دكمه رهگيري مرسوله پستي ، مرسـوله خود را از طريق وب سايت اداره پســت رديابي نماييد.

Datissoftware

Datissoftware

نماد ها

logo-samandehi

عناوين علمي و آموزشي

نرم افزارهاي مورد نياز

IDM دانلود Internet Download Manager
Chrome دانلود Google Chrome
Firefox دانلود Mozilla Firefox
Winrar دانلود Winrar
FlashPlayer دانلود Flash Player
Adobe Reader دانلود Adobe Reader
Mp4 Codec دانلود Mp4 Codec

آمار و اطلاعات

جهت عضــويت در خبرنامه فروشــگاه اينترنتي داتيــس ايميل صحيح خود را وارد نماييد.

عنوان : كتاب Beginning Big Data with Power BI and Excel 2013

1394/11/14 - 15:35:57
اين كتاب كار با Big Data را با استفاده از اكسل و هوش تجاري به شما خواهد آموخت. برای حل مشکلات کسب و کار با تكيه به قدرت مایکروسافت اکسل و قدرت هوش تجاري برای وارد کردن داده ازNoSQL و پایگاه داده SQL و منابع دیگر استفاده مي شود. ایجاد مدل داده های رابطه ای و تجزیه و تحلیل مشکلات کسب و کار از طریق داشبوردهاي پیچیده و نقشه هاي داده محور استفاده مي شود. در حالی که آغاز داده بزرگ با قدرت هوش و اکسل 2013 را پوشش می دهد ابزار برجسته مانند Hadoop و پایگاه های داده های NoSQL، برروي آن صحه می گذارد که کسب و کارهای کوچک و متوسط انجام پردازش نیاز دارد. همچنين داده بزرگ از یک Netflix، هدف، و یا فیس بوک وارد مي شود.


Beginning Big Data
with Power BI and
Excel 2013

Neil Dunlop

دانلود كتاب Beginning Big Data with Power BI and Excel 2013


آموزش ASP .net 2013

آموزش Visual C# 2013

آموزش SQL Server 2014

آموزش Excel 2013

Book Description:

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft's Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards and data-driven maps.

While Beginning Big Data with Power BI and Excel 2013 covers prominent tools such as Hadoop and the NoSQL databases, it recognizes that most small and medium-sized businesses don't have the Big Data processing needs of a Netflix, Target, or Facebook. Instead, it shows how to import data and use the self-service analytics available in Excel with Power BI. As you'll see through the book's numerous case examples, these tools - which you already know how to use - can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects.


Book Details :

Publisher:    Apress
By:           Neil Dunlop
ISBN:         978-1-484205-30-3
Year:         2015
Pages:        268
Language:     English
File size:    17 MB
File format:  PDF

Introduction :

This book is intended for anyone with a basic knowledge of Excel who wants to analyze and visualize
data in order to get results. It focuses on understanding the underlying structure of data, so that the most
appropriate tools can be used to analyze it. The early working title of this book was “Big Data for the Masses,”
implying that these tools make Business Intelligence (BI) more accessible to the average person who wants
to leverage his or her Excel skills to analyze large datasets.
As discussed in Chapter 1, big data is more about volume and velocity than inherent complexity. This
book works from the premise that many small- to medium-sized organizations can meet most of their data
needs with Excel and Power BI. The book demonstrates how to import big data file formats such as JSON,
XML, and HDFS and how to filter larger datasets down to thousands or millions of rows instead of billions.
This book starts out by showing how to import various data formats into Excel (Chapter 2) and how to
use Pivot Tables to extract summary data from a single table (Chapter 3). Chapter 5 demonstrates how to use
Structured Query Language (SQL) in Excel. Chapter 10 offers a brief introduction to statistical analysis in Excel.
This book primarily covers Power BI—Microsoft’s self-service BI tool—which includes the following
Excel add-ins:
1.    PowerPivot. This provides the repository for the data (see Chapter 4) and the
DAX formula language (see Chapter 7). Chapter 4 provides an example of
processing millions of rows in multiple tables.
2.    Power View. A reporting tool for extracting meaningful reports and creating some
of the elements of dashboards (see Chapter 6).
3.    Power Query. A tool to Extract, Transform, and Load (ETL) data from a wide
variety of sources (see Chapter 8).
4.    Power Map. A visualization tool for mapping data (see Chapter 9).
Chapter 11 demonstrates how to use HDInsight (Microsoft’s implementation of Hadoop that runs on its
Azure cloud platform) to import big data into Excel.
This book is written for Excel 2013, but most of the examples it includes will work with Excel 2010,
if the PowerPivot, Power View, Power Query, and Power Map add-ins are downloaded from Microsoft.
Simply search on download and the add-in name to find the download link.


: CONTENTS

About the Author ................................................................................................... xiii
About the Technical Reviewer .................................................................................xv
Acknowledgments .................................................................................................xvii
Introduction ............................................................................................................xix
■■Chapter 1: Big Data ............................................................................................... 1
■■Chapter 2: Excel As Database and Data Aggregator ............................................ 15
■■Chapter 3: Pivot Tables and Pivot Charts ............................................................ 35
■■Chapter 4: Building a Data Model ........................................................................ 55
■■Chapter 5: Using SQL in Excel .............................................................................. 77
■■Chapter 6: Designing Reports with Power View .................................................. 99
■■Chapter 7: Calculating with Data Analysis Expressions (DAX) .......................... 127
■■Chapter 8: Power Query ..................................................................................... 145
■■Chapter 9: Power Map ....................................................................................... 173
■■Chapter 10: Statistical Calculations .................................................................. 203
■■Chapter 11: HDInsight ....................................................................................... 225
Index ..................................................................................................................... 243

 

1394/11/14 - 15:35:57
برچسب هاي مطلب :



شما اولين نفري باشيد كه نظر ارسال مي كند.

فرم ثبت نظر

نام و نام خانوادگی
ایمیل
وبلاگ
نظر و کامنت
كد امنيتي