Cargando…
Beginning big data with Power BI and Excel 2013 /
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[New York, NY] :
Apress,
[2015]
|
| Colección: | Expert's voice in big data.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.