Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop

✍ Scribed by Dan Clark (auth.)

Publisher: Apress
Year: 2017
Tongue: English
Leaves: 353
Edition: 2
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

Analyze your company’s data quickly and easily using Microsoft’s latest tools. Build scalable and robust data models to work from. Learn to clean and combine different data sources effectively. Create compelling visualizations and share them with your colleagues.

Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This second edition includes new material on advanced uses of Power Query, along with the latest user guidance on the evolving Power BI platform. Beginning Power BI is your hands-on guide to quick, reliable, and valuable data insight.

What You Will Learn

Simplify data discovery, association, and cleansing
Create solid analytical data models
Create robust interactive data presentations
Combine analytical and geographic data in map-based visualizations
Publish and share dashboards and reports

Who This Book Is For

Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data.

✦ Table of Contents

Front Matter....Pages i-xvii
Front Matter....Pages 1-1
Introducing Power Pivot....Pages 3-18
Importing Data into Power Pivot....Pages 19-54
Data Munging with Power Query....Pages 55-75
Creating the Data Model....Pages 77-99
Creating Calculations with DAX....Pages 101-117
Creating Measures with DAX....Pages 119-143
Incorporating Time Intelligence....Pages 145-164
Data Analysis with Pivot Tables and Charts....Pages 165-189
Front Matter....Pages 191-191
Introducing Power BI Desktop....Pages 193-216
Creating Reports with Power BI Desktop....Pages 217-249
Publishing Reports and Creating Dashboards in the Power BI Portal....Pages 251-281
Creating a Complete Solution....Pages 283-300
Advanced Topics in Power Query....Pages 301-318
Advanced Topics in Power BI....Pages 319-342
Back Matter....Pages 343-348

✦ Subjects

Big Data/Analytics;Knowledge Management;Information Systems and Communication Service

📜 SIMILAR VOLUMES

Beginning Microsoft Power Bi: A Practica

📁 Beginning Microsoft Power Bi: A Practical Guide to Self-Service Data Analytics

✍ Dan Clark 📂 Library 📅 2020 🏛 Apress 🌐 English

<p></p><p>Analyze company data quickly and easily using Microsoft's powerful data tools. Learn to build scalable and robust data models, clean and combine different data sources effectively, and create compelling and professional visuals.</p> <p><i><b>Beginning Power BI</b> </i>is a hands-on, activi

Beginning Big Data with Power BI and Exc

📁 Beginning Big Data with Power BI and Excel 2013

✍ Dunlop, Neil 📂 Library 📅 2015 🏛 Apress 🌐 English

In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsofts 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 dashbo

Beginning Big Data with Power BI and Exc

📁 Beginning Big Data with Power BI and Excel 2013

✍ Neil Dunlop (auth.) 📂 Library 📅 2015 🏛 Apress 🌐 English

Beginning Big Data with Power BI and Exc

📁 Beginning Big Data with Power BI and Excel 2013

✍ Neil Dunlop 📂 Library 📅 2015 🏛 Apress 🌐 English

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 dashb

Pro Power Bi Desktop: Self-service Analy

📁 Pro Power Bi Desktop: Self-service Analytics and Data Visualization for the Power User

✍ Adam Aspin 📂 Library 📅 2020 🏛 Apress 🌐 English

<p></p><p></p><div><div><div>Deliver eye-catching and insightful business intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features of Microsofts continually evolving visualization product. New in this edition is help with storytellingadapted

Data Modeling with Microsoft Power BI: S

📁 Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouses with Power BI

✍ Markus Ehrenmueller-Jensen 📂 Library 📅 2024 🌐 English

Data modeling is the single most overlooked feature in Power BI Desktop, yet it's what sets Power BI apart from other tools on the market. This practical book serves as your fast-forward button for data modeling with Power BI, Analysis Services tabular, and SQL databases. It serves as a starting poi