logo资料库

Beginning Big Data with Power BI and Excel 2013(Apress,2015).pdf

发布时间：2022-06-24 发布人：admin 分类：说明书 资料大小：20.91M 资料格式：pdf 举报 版权申诉
第1页 / 共258页
第2页 / 共258页
第3页 / 共258页
第4页 / 共258页
第5页 / 共258页
第6页 / 共258页
第7页 / 共258页
第8页 / 共258页
资料共258页，剩余部分请下载后查看
    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 Data
    Implementations 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
    Summary
    Chapter 4: Building a Data Model
    Enabling PowerPivot
    Relational Databases
    Database Terminology
    Creating a Data Model from Excel Tables
    Loading Data Directly into the Data Model
    Creating a Pivot Table from Two Tables
    Creating a Pivot Table from Multiple Tables
    Adding Calculated Columns
    Adding Calculated Fields to the Data Model
    Summary
    Chapter 5: Using SQL in Excel
    History of SQL
    NoSQL
    NewSQL
    SQL++
    SQL Syntax
    SQL Aggregate Functions
    Subtotals
    Joining Tables
    Importing an External Database
    Specifying a JOIN Condition and Selected Fields
    Using SQL to Extract Summary Statistics
    Generating a Report of Total Order Value by Employee
    Using MSQuery
    Summary
    Chapter 6: Designing Reports with Power View
    Elements of the Power View Design Screen
    Considerations When Using Power View
    Types of Fields
    Understanding How Data Is Summarized
    A Single Table Example
    Viewing the Data in Different Ways
    Creating a Bar Chart for a Single Year
    Column Chart
    Displaying Multiple Years
    Adding a Map
    Using Tiles
    Relational Example
    Customer and City Example
    Showing Orders by Employee
    Aggregating Orders by Product
    Summary
    Chapter 7: Calculating with Data Analysis Expressions (DAX)
    Understanding Data Analysis Expressions
    DAX Operators
    Summary of Key DAX Functions Used in This Chapter
    Updating Formula Results
    Creating Measures or Calculated Fields
    Analyzing Profitability
    Using the SUMX Function
    Using the CALCULATE Function
    Calculating the Store Sales for 2009
    Creating a KPI for Profitability
    Creating a Pivot Table Showing Profitability by Product Line
    Summary
    Chapter 8: Power Query
    Installing Power Query
    Key Options on Power Query Ribbon
    Working with the Query Editor
    Key Options on the Query Editor Home Ribbon
    A Simple Population
    Performance of S&P 500 Stock Index
    Importing CSV Files from a Folder
    Group By
    Importing JSON
    Summary
    Chapter 9: Power Map
    Installing Power Map
    Plotting a Map
    Key Power Map Ribbon Options
    Troubleshooting
    Plotting Multiple Statistics
    Adding a 2D Chart
    Showing Two or More Values
    Creating a 2D Chart
    Summary
    Chapter 10: Statistical Calculations
    Recommended Analytical Tools in 2013
    Customizing the Status Bar
    Inferential Statistics
    Review of Descriptive Statistics
    Calculating Descriptive Statistics
    Measures of Dispersion
    Excel Statistical Functions
    Charting Data
    Excel Analysis ToolPak
    Enabling the Excel Analysis ToolPak
    A Simple Example
    Other Analysis ToolPak Functions
    Using a Pivot Table to Create a Histogram
    Scatter Chart
    Summary
    Chapter 11: HDInsight
    Getting a Free Azure Account
    Importing Hadoop Files into Power Query
    Creating an Azure Storage Account
    Provisioning a Hadoop Cluster
    Importing into Excel
    Creating a Pivot Table
    Creating a Map in Power Map
    Summary
    Index
    分享到：
    赞 收藏

    相关推荐

    资料库

    数据库

    共收录1218份资料，累计14个分类，关注成员有19位，主要包括：NoSQL,MongoDB,Redis,SQLite,Memcached,DB2,Sybase,Informix,PostgreSQL,MySQL,SQLServer,Access,Oracle,其它

    热门标签

    NoSQL MongoDB Redis SQLite Memcached DB2 Sybase Informix PostgreSQL MySQL SQLServer Access Oracle 其它

    最新资料