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

By Neil Dunlop

In starting tremendous info with energy BI and Excel 2013, you are going to discover ways to remedy company difficulties by means of tapping the facility of Microsoft's Excel and tool BI to import info from NoSQL and SQL databases and different resources, create relational facts types, and learn company difficulties via refined dashboards and data-driven maps. whereas starting immense information with energy BI and Excel 2013 covers renowned instruments equivalent to Hadoop and the NoSQL databases, it acknowledges that the majority small and medium-sized companies do not have the massive facts processing wishes of a Netflix, aim, or fb. as an alternative, it exhibits how one can import information and use the self-service analytics to be had in Excel with strength BI. As you will see in the course of the book's a variety of case examples, those instruments - that you already understand how to exploit - can practice a number of the similar services because the higher-end Apache instruments many folks think are required to hold out in tremendous facts initiatives.

Show description

Read Online or Download Beginning Big Data with Power BI and Excel 2013 PDF

Best data modeling & design books

Medical Imaging and Augmented Reality Second International Workshop

This scholarly set of well-harmonized volumes presents critical and whole assurance of the interesting and evolving topic of scientific imaging structures. major specialists at the overseas scene take on the newest state-of-the-art innovations and applied sciences in an in-depth yet eminently transparent and readable procedure.


Metaheuristics express fascinating homes like simplicity, effortless parallelizability, and prepared applicability to forms of optimization difficulties. After a entire creation to the sphere, the contributed chapters during this publication comprise motives of the most metaheuristics concepts, together with simulated annealing, tabu seek, evolutionary algorithms, man made ants, and particle swarms, via chapters that show their functions to difficulties corresponding to multiobjective optimization, logistics, car routing, and air site visitors administration.

Extra info for Beginning Big Data with Power BI and Excel 2013

Example text

Clicking the Tables tab at the top right of the Analysis Tool window will result in several suggested Pivot Tables being shown. Hovering over each Pivot Table presents a preview, as shown in Figure 3-2. Figure 3-1. info Chapter 3 ■ Pivot Tables and Pivot Charts Figure 3-2. Pivot Table preview Defining a Pivot Table This section covers how to define a Pivot Table based on a simple transaction table of hypothetical Toyota sales data that lists transactions, including date of sale, model, salesperson, color, and selling price, as shown in Figure 3-3.

Figure 3-20. Azure Marketplace 4. Scroll through the data sources. You may have to go through an additional signup process to use free data. 5. For this example, we will use Real GDP Per Capita By State (1997–2011), as shown in Figure 3-21. If prompted, enter your Microsoft ID and agree to the terms of use.

Data preview of Text to Columns 4. In the next pop-up window, select each column in the Data Preview window and click Text as the format, as shown in Figure 2-17. Enter the destination where you want the results to appear, then click Finish. info Chapter 2 ■ Excel As Database and Data Aggregator Figure 2-17. Last step of Convert Text to Columns Splitting Complex, Delimited Fields More complex cases involving multiple data elements in a single field can often be solved through using Excel’s built-in functions.

Download PDF sample

Rated 4.48 of 5 – based on 7 votes

About the Author