Beginning big data with Power BI and Excel 2013. ([2015])
- Record Type:
- Book
- Title:
- Beginning big data with Power BI and Excel 2013. ([2015])
- Main Title:
- Beginning big data with Power BI and Excel 2013
- Further Information:
- Note: Neil Dunlop.
- Other Names:
- Dunlop, Neil
- 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;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. … (more)
- Publisher Details:
- New York, NY : Apress
- Publication Date:
- 2015
- Copyright Date:
- 2015
- Extent:
- 1 online resource
- Subjects:
- 658/.05
Computer science
Big data
Business -- Data processing
Microsoft software
Microsoft .NET Framework
Information systems
BUSINESS & ECONOMICS -- Industrial Management
BUSINESS & ECONOMICS -- Management
BUSINESS & ECONOMICS -- Management Science
BUSINESS & ECONOMICS -- Organizational Behavior
Big data
Business -- Data processing
Computer science
Computers -- Online Services -- General
Computer networking & communications
Computers -- Programming -- Microsoft Programming
Microsoft programming
Electronic books - Languages:
- English
- ISBNs:
- 9781484205297
1484205294 - Related ISBNs:
- 9781484205303
1484205308 - Notes:
- Note: Vendor-supplied metadata.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.359693
- Ingest File:
- 03_016.xml