Buch, Englisch, 246 Seiten, Paperback, Format (B × H): 178 mm x 254 mm, Gewicht: 5091 g
Big Data Processing and Analysis Using PowerBI in Excel 2013
Buch, Englisch, 246 Seiten, Paperback, Format (B × H): 178 mm x 254 mm, Gewicht: 5091 g
ISBN: 978-1-4842-0530-3
Verlag: Apress
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, andcase 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).
Zielgruppe
Popular/general
Autoren/Hrsg.
Fachgebiete
- Mathematik | Informatik EDV | Informatik Angewandte Informatik Wirtschaftsinformatik
- Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel
- Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
- Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management
Weitere Infos & Material
Introduction
Chapter 1: Tools for Big Data Intake, Processing, and Analysis
Chapter 2: Excel as a Database and Data Aggregator
Chapter 3: Pivot Tables and Pivot Charts
Chapter 4: Data Models
Chapter 5: SQL in Excel
Chapter 6: NoSQL Databases in Excel
Chapter 7: Statistical Analysis in Excel
Chapter 8: Data Analysis Expressions
Chapter 9: Reports and Dashboards
Chapter 10: Data Visualizations
Chapter 11: Summary and Review