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).
CSS3 for Web Designers
From advanced selectors to generated content, and from gradients, shadows, and rounded corners to full-blown animations, CSS3 is a universe of creative possibilities. No one can better guide you through these galaxies than world-renowned designer, author, and CSS superstar Dan Cederholm. Learn what works, how it works, and how to work around... Blockchain Basics: A Non-Technical Introduction in 25 Steps
In 25 concise steps, you will learn the basics of blockchain technology. No mathematical formulas, program code, or computer science jargon are used. No previous knowledge in computer science, mathematics, programming, or cryptography is required. Terminology is explained through pictures, analogies, and metaphors.
Power Query for Power BI and Excel
Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to...