Beginning Big Data with Power BI and Excel 2013: Big Data by Neil Dunlop

By Neil Dunlop

In Beginning sizeable info with energy BI and Excel 2013, you are going to learn how to remedy company difficulties by means of tapping the ability of Microsoft’s Excel and tool BI to import information from NoSQL and SQL databases and different resources, create relational facts versions, and study company difficulties via refined dashboards and data-driven maps.

While Beginning large info with strength BI and Excel 2013 covers well-known instruments comparable to Hadoop and the NoSQL databases, it acknowledges that almost all small and medium-sized companies don’t have the large facts processing wishes of a Netflix, goal, or fb. in its place, it indicates easy methods to import info and use the self-service analytics to be had in Excel with strength BI. As you’ll see in the course of the book’s a variety of case examples, those tools—which you know how one can use—can practice a few of the comparable features because the higher-end Apache instruments many folks think are required to hold out in large facts projects.

Through guide, perception, recommendation, and case reviews, Beginning colossal facts with energy BI and Excel 2013 will convey you the way to:

  • Import and mash up info from web content, SQL and NoSQL databases, the Azure market and different sources.
  • Tap
    into the analytical strength of PivotTables and PivotCharts and improve
    relational information types to trace tendencies and make predictions in accordance with a
    wide diversity of data.
  • Understand simple records and use Excel
    with PowerBI to do refined statistical analysis—including
    identifying developments and correlations.
  • Use SQL inside Excel to do subtle queries throughout a number of tables, together with NoSQL databases.
  • Create advanced formulation to resolve real-world company difficulties utilizing facts research Expressions (DAX).

Show description

Read or Download Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013 PDF

Similar microsoft programming books

Windows 8 App Projects - XAML and C# Edition (Expert's Voice in Windows 8)

Develop into a number one home windows eight app developer through the use of home windows eight App initiatives - XAML and C# variation to profit suggestions, instruments, and concepts to create profitable, 5-star apps. home windows eight App initiatives - XAML and C# Edition shows you the nuts and bolts of the home windows eight improvement atmosphere. Then, via a chain of instance pushed chapters, you are going to discover how to leverage the platform’s certain beneficial properties.

Memory Dump Analysis Anthology, Volume 1

This complete colour reference quantity contains revised, edited, cross-referenced, and thematically equipped articles from software program Diagnostics Institute (DumpAnalysis. org) and software program Diagnostics Library (former Crash sell off research weblog, DumpAnalysis. org/blog) written in August 2006 - December 2007.

C# 6.0 in a Nutshell: The Definitive Reference

In case you have questions on C# 6. zero or the . internet CLR and its middle Framework assemblies, this bestselling consultant has the solutions you wish. C# has turn into a language of bizarre flexibility and breadth on account that its foremost in 2000, yet this continuous development potential there’s nonetheless even more to profit. prepared round ideas and use circumstances, this completely up to date 6th variation offers intermediate and complicated programmers with a concise map of C# and .

MVVM in Delphi: Architecting and Building Model View ViewModel Applications

Dive into the realm of MVVM, construct glossy home windows functions, and get ready for cross-platform improvement. This ebook introduces you to the fitting frame of mind and demonstrates appropriate methodologies that permit for fast knowing of the MVVM paradigm. MVVM in Delphi exhibits you the way to take advantage of a brief and effective MVVM framework that permits for scalability, is of doable complexity, and offers robust potency.

Extra info for Beginning Big Data with Power BI and Excel 2013: Big Data Processing and Analysis Using PowerBI in Excel 2013

Example text

Download PDF sample

Rated 4.98 of 5 – based on 4 votes