Beginning Big Data with Power BI and Excel 2013 : Big Data Processing and Analysis Using PowerBI in Excel 2013 / by Neil Dunlop.

Format:

Book

Author/Creator:

Dunlop, Neil, Author.

Series:

Expert's Voice in Big Data

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Microsoft PowerPivot (Computer file).

Microsoft software.

Microsoft .NET Framework.

Computers.

Microsoft and .NET.

Information Systems and Communication Service.

Local Subjects:

Microsoft and .NET.

Information Systems and Communication Service.

Physical Description:

1 online resource (258 p.)

Edition:

1st ed. 2015.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2015.

Language Note:

English

System Details:

text file

Summary:

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. Through instruction, insight, advice, and case studies, Beginning Big Data with Power BI and Excel 2013 will show you how to: Import and mash up data from web pages, SQL and NoSQL databases, the Azure Marketplace and other sources. Tap into the analytical power of PivotTables and PivotCharts and develop relational data models to track trends and make predictions based on a wide range of data. Understand basic statistics and use Excel with PowerBI to do sophisticated statistical analysis—including identifying trends and correlations. Use SQL within Excel to do sophisticated queries across multiple tables, including NoSQL databases. Create complex formulas to solve real-world business problems using Data Analysis Expressions (DAX).

Contents:

Contents at a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Big Data; Big Data As the Fourth Factor of Production; Big Data As Natural Resource; Data As Middle Manager; Early Data Analysis; First Time Line; First Bar Chart and Time Series; Cholera Map; Modern Data Analytics; Google Flu Trends; Google Earth; Tracking Malaria; Big Data Cost Savings; Big Data and Governments; Predictive Policing; A Cost-Saving Success Story; Internet of Things or Industrial Internet; Cutting Energy Costs at MIT

The Big Data Revolution and Health Care The Medicalized Smartphone; Improving Reliability of Industrial Equipment; Big Data and Agriculture; Cheap Storage; Personal Computers and the Cost of Storage; Review of File Sizes; Data Keeps Expanding; Relational Databases; Normalization; Database Software for Personal Computers; The Birth of Big Data and NoSQL; Hadoop Distributed File System (HDFS); Big Data; The Three V's; The Data Life Cycle; Apache Hadoop; MapReduce Algorithm; Hadoop Distributed File System (HDFS); Commercial Implementations of Hadoop; CAP Theorem; NoSQL

Characteristics of NoSQL DataImplementations of NoSQL; Spark; Microsoft Self-Service BI; Summary; Chapter 2: Excel As Database and Data Aggregator; From Spreadsheet to Database; Interpreting File Extensions; Using Excel As a Database; Importing from Other Formats; Opening Text Files in Excel; Importing Data from XML; Importing XML with Attributes; Importing JSON Format; Using the Data Tab to Import Data; Importing Data from Tables on a Web Site; Data Wrangling and Data Scrubbing; Correcting Capitalization; Splitting Delimited Fields; Splitting Complex, Delimited Fields

Removing Duplicates Input Validation; Working with Data Forms; Selecting Records; Summary; Chapter 3: Pivot Tables and Pivot Charts; Recommended Pivot Tables in Excel 2013; Defining a Pivot Table; Defining Questions; Creating a Pivot Table; Changing the Pivot Table; Creating a Breakdown of Sales by Salesperson for Each Day; Showing Sales by Month; Creating a Pivot Chart; Adjusting Subtotals and Grand Totals; Analyzing Sales by Day of Week; Creating a Pivot Chart of Sales by Day of Week; Using Slicers; Adding a Time Line; Importing Pivot Table Data from the Azure Marketplace

SummaryChapter 4: Building a Data Model; Enabling PowerPivot; Relational Databases; Database Terminology; Creating a Data Model from Excel Tables; Loading Data Directly into the Data Model; Creating a Pivot Table from Two Tables; Creating a Pivot Table from Multiple Tables; Adding Calculated Columns; Adding Calculated Fields to the Data Model; Summary; Chapter 5: Using SQL in Excel; History of SQL ; NoSQL ; NewSQL ; SQL++ ; SQL Syntax ; SQL Aggregate Functions; Subtotals ; Joining Tables; Importing an External Database; Specifying a JOIN Condition and Selected Fields

Using SQL to Extract Summary Statistics

Notes:

Includes index.

ISBN:

9781484205297

1484205294

OCLC:

934650464