The Resource Beginning big data with Power BI and Excel 2013, Neil Dunlop

Beginning big data with Power BI and Excel 2013, Neil Dunlop

Label
Beginning big data with Power BI and Excel 2013
Title
Beginning big data with Power BI and Excel 2013
Statement of responsibility
Neil Dunlop
Creator
Subject
Genre
Language
eng
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)
Member of
Cataloging source
N$T
http://library.link/vocab/creatorName
Dunlop, Neil
Dewey number
658/.05
Index
index present
LC call number
HF5548.2
Literary form
non fiction
Nature of contents
dictionaries
Series statement
Expert's voice in big data
http://library.link/vocab/subjectName
  • Big data
  • Business
  • Computer science
  • BUSINESS & ECONOMICS
  • BUSINESS & ECONOMICS
  • BUSINESS & ECONOMICS
  • BUSINESS & ECONOMICS
  • Big data
  • Business
  • Computer science
  • Computer Science
  • Computer Science, general
  • Computer networking & communications
  • Microsoft programming
Label
Beginning big data with Power BI and Excel 2013, Neil Dunlop
Link
https://ezproxy.lib.ou.edu/login?url=http://link.springer.com/10.1007/978-1-4842-0529-7
Instantiates
Publication
Copyright
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
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
Dimensions
unknown
Extent
1 online resource.
File format
unknown
Form of item
online
Isbn
9781484205297
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Note
SpringerLink
Other control number
10.1007/978-1-4842-0529-7
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • (OCoLC)922925648
  • (OCoLC)ocn922925648
Label
Beginning big data with Power BI and Excel 2013, Neil Dunlop
Link
https://ezproxy.lib.ou.edu/login?url=http://link.springer.com/10.1007/978-1-4842-0529-7
Publication
Copyright
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
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
Dimensions
unknown
Extent
1 online resource.
File format
unknown
Form of item
online
Isbn
9781484205297
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Note
SpringerLink
Other control number
10.1007/978-1-4842-0529-7
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
  • (OCoLC)922925648
  • (OCoLC)ocn922925648

Library Locations

  • Architecture LibraryBorrow it
    Gould Hall 830 Van Vleet Oval Rm. 105, Norman, OK, 73019, US
    35.205706 -97.445050
  • Bizzell Memorial LibraryBorrow it
    401 W. Brooks St., Norman, OK, 73019, US
    35.207487 -97.447906
  • Boorstin CollectionBorrow it
    401 W. Brooks St., Norman, OK, 73019, US
    35.207487 -97.447906
  • Chinese Literature Translation ArchiveBorrow it
    401 W. Brooks St., RM 414, Norman, OK, 73019, US
    35.207487 -97.447906
  • Engineering LibraryBorrow it
    Felgar Hall 865 Asp Avenue, Rm. 222, Norman, OK, 73019, US
    35.205706 -97.445050
  • Fine Arts LibraryBorrow it
    Catlett Music Center 500 West Boyd Street, Rm. 20, Norman, OK, 73019, US
    35.210371 -97.448244
  • Harry W. Bass Business History CollectionBorrow it
    401 W. Brooks St., Rm. 521NW, Norman, OK, 73019, US
    35.207487 -97.447906
  • History of Science CollectionsBorrow it
    401 W. Brooks St., Rm. 521NW, Norman, OK, 73019, US
    35.207487 -97.447906
  • John and Mary Nichols Rare Books and Special CollectionsBorrow it
    401 W. Brooks St., Rm. 509NW, Norman, OK, 73019, US
    35.207487 -97.447906
  • Library Service CenterBorrow it
    2601 Technology Place, Norman, OK, 73019, US
    35.185561 -97.398361
  • Price College Digital LibraryBorrow it
    Adams Hall 102 307 West Brooks St., Norman, OK, 73019, US
    35.210371 -97.448244
  • Western History CollectionsBorrow it
    Monnet Hall 630 Parrington Oval, Rm. 300, Norman, OK, 73019, US
    35.209584 -97.445414
Processing Feedback ...