[FREE EBOOK]Beginning Big Data with Power BI and Excel 2013-Neil Dunlop - KING OF EXCEL

Tuesday, January 28, 2020

[FREE EBOOK]Beginning Big Data with Power BI and Excel 2013-Neil Dunlop

[FREE EBOOK]Beginning Big Data with Power BI and Excel 2013-Neil Dunlop


DOWNLOAD

Description

Product Description

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).

From the Back Cover

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).


About the Author

Neil Dunlop is Professor of Business and Computer Information Systems, Berkeley City College, Berkeley, CA. The author has served as chair of the Business and Computer Information Systems Departments for many years. He has over thirty-five years experience as a computer programmer and software designer and is the author of three books on database management. He is listed in Marquis Who’s Who in America and Who’s Who in the World.

Features & details

Product Details

  • Publication date: October 4, 2015
  • Publisher: Apress
  • Language: English
  • ASIN: B01HXLWHJA
  • Amazon.com Sales Rank: 4126110

About the author

Follow the author to get new release updates and improved recommendations.
Neil Dunlop
I served for many years as Department Chair of the Business and Computer Information Systems Department at Berkeley City College in Berkeley, CA. I also do consulting specializing in converting legacy database management systems to more current technologies. I am currently working with big data and Power BI.
#evba #etipfree #kingexcel

📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1

Popular Posts