Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Microsoft Power BI Quick Start Guide Build dashboards and visualizations to make your data come to life

Product type Paperback

Published in Jul 2018

Publisher Packt

ISBN-13 9781789138221

Length 202 pages

Edition 1st Edition

Languages

DAX

Tools

Power BI

Concepts

Business Intelligence

Authors (4):

Manuel Quintana

Mitchell Pearson

Devin Knight

Brian Knight

View More author details

Table of Contents (10) Chapters

Preface

1. Getting Started with Importing Data Options

2. Data Transformation Strategies FREE CHAPTER

3. Building the Data Model

4. Leveraging DAX

5. Visualizing Data

6. Digital Storytelling with Power BI

7. Using a Cloud Deployment with the Power BI Service

8. On-Premises Solutions with Power BI Report Server

9. Other Books You May Enjoy

Leave a review - let other readers know what you think

Leveraging DAX

Data analysis expressions (DAX) is a formula language that made its debut back in 2010 with the release of Power Pivot within Excel. Much of DAX is similar to Excel's functions, and therefore learning DAX is an easy transition for Excel users and power users. In fact, DAX is so similar to Excel that I have seen new students become comfortable with the language and begin writing DAX within minutes.

The goal of this chapter is to introduce you to DAX and give you the confidence to start exploring this language on your own. Because of the brevity of this chapter, there will not be any discussions on in-depth DAX concepts and theory. There are, of course, many other books that are dedicated to just that.

Now, let's take a look at what is covered in this chapter:

Building calculated columns
Calculated measures – the basics
Calculated measures –...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (4)

Knight

Brian Knight is the owner and founder of Pragmatic Works, and is a serial entrepreneur, starting up other companies. Brian is a contributing columnist at several technical magazines. He is the author of 16 technical books. Brian has spoken at conferences like PASS Summit, SQL Connections, TechEd, SQLSaturdays, and Code Camps. He has received a number of awards from the State of Florida, governor, and press, including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). His blog can be found at Pragmatic Works website.

See other products by Knight

Manuel Quintana

Manuel Quintana is a Training Content Manager at Pragmatic Works. Previously he was senior manager working in the hotel industry. He joined the Pragmatic Works team in 2014 with no knowledge in the Business Intelligence space but now speaks at SQL Saturday's and SQL Server User Groups locally and virtually. He also teaches various BI technologies to many different fortune 500 companies on behalf of Pragmatic Works. Since 2014 he has called Jacksonville home and before that Orlando but he was born on the island of Puerto Rico and loves to go back and visit his family. When he isn't working on creating new content for Pragmatic Works you can probably find him playing board games or watching competitive soccer matches.

See other products by Manuel Quintana

Mitchell Pearson

Mitchell Pearson has worked as a Data Platform Consultant and Trainer for the last 8 years. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure. Mitchell is very active in the community: Running the local Power BI User Group, presenting at user groups locally and virtually, and creating YouTube videos for MitchellSQL

See other products by Mitchell Pearson

Devin Knight

Devin Knight a Microsoft Data Platform MVP and the President at Pragmatic Works Training. At Pragmatic Works, Devin determines which courses are created, delivered, and updated for customers, including 15+ Power BI courses. This is the tenth SQL Server and Business Intelligence book that he has authored. Devin often speaks at conferences such as PASS Summit, PASS Business Analytics Conference, SQL Saturdays, and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is a contributor at the local Power BI User Group.

See other products by Devin Knight