Kids Library Home

Welcome to the Kids' Library!

Search for books, movies, music, magazines, and more.

     
Available items only
Record 7 of 146
Previous Record Next Record
E-Books/E-Docs
Author Dunlop, Neil.

Title Beginning big data with Power BI and Excel 2013 / Neil Dunlop.

Publication Info. [New York, NY] : Apress, [2015]
2015

Copies

Location Call No. OPAC Message Status
 Axe Books 24x7 IT E-Book  Electronic Book    ---  Available
Description 1 online resource.
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
text file PDF rda
Series Expert's voice in big data
Expert's voice in big data.
Note Includes index.
Vendor-supplied metadata.
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 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.
Subject Microsoft Excel (Computer file)
Microsoft PowerPivot (Computer file)
Microsoft Excel (Computer file) (OCoLC)fst01366659
Microsoft PowerPivot (Computer file) (OCoLC)fst01915392
Big data.
Business -- Data processing.
Computer science.
BUSINESS & ECONOMICS -- Industrial Management.
BUSINESS & ECONOMICS -- Management.
BUSINESS & ECONOMICS -- Management Science.
BUSINESS & ECONOMICS -- Organizational Behavior.
Computer networking & communications.
Microsoft programming.
Big data. (OCoLC)fst01892965
Business -- Data processing. (OCoLC)fst00842293
Computer science. (OCoLC)fst00872451
Genre/Form Electronic books.
Other Form: Print version: Dunlop, Neil. Beginning big data with Power BI and Excel 2013. [New York, NY] : Apress, [2015] 1484205308 9781484205303 (OCoLC)921191514
ISBN 9781484205297 (electronic bk.)
1484205294 (electronic bk.)
9781484205303
1484205308
Standard No. 10.1007/978-1-4842-0529-7 doi
AU@ 000056994456
CHNEW 000893559
CHVBK 374527164
DEBBG BV043626772
DEBBG BV043967906
DEBSZ 453692869
DEBSZ 485783940
GBVCP 882745484
UKMGB 019139830

 
    
Available items only