Home Data Microsoft Power BI Quick Start Guide - Third Edition

Microsoft Power BI Quick Start Guide - Third Edition

By Devin Knight , Erin Ostrowsky , Mitchell Pearson and 1 more
ai-assist-svg-icon Book + AI Assistant
eBook + AI Assistant $29.99
Print $36.99
Subscription $15.99
ai-assist-svg-icon NEW: AI Assistant (beta) Available with eBook, Print, and Subscription.
ai-assist-svg-icon NEW: AI Assistant (beta) Available with eBook, Print, and Subscription. $10 p/m for first 3 months. $15.99 p/m after that. Cancel Anytime! ai-assist-svg-icon NEW: AI Assistant (beta) Available with eBook, Print, and Subscription.
What do you get with a Packt Subscription?
Gain access to our AI Assistant (beta) for an exclusive selection of 500 books, available during your subscription period. Enjoy a personalized, interactive, and narrative experience to engage with the book content on a deeper level.
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook + Subscription?
Download this book in EPUB and PDF formats, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
Gain access to our AI Assistant (beta) for an exclusive selection of 500 books, available during your subscription period. Enjoy a personalized, interactive, and narrative experience to engage with the book content on a deeper level.
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Along with your eBook purchase, enjoy AI Assistant (beta) access in our online reader for a personalized, interactive reading experience.
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
ai-assist-svg-icon NEW: AI Assistant (beta) Available with eBook, Print, and Subscription. ai-assist-svg-icon NEW: AI Assistant (beta) Available with eBook, Print, and Subscription. BUY NOW $10 p/m for first 3 months. $15.99 p/m after that. Cancel Anytime! ai-assist-svg-icon NEW: AI Assistant (beta) Available with eBook, Print, and Subscription.
eBook + AI Assistant $29.99
Print $36.99
Subscription $15.99
What do you get with a Packt Subscription?
Gain access to our AI Assistant (beta) for an exclusive selection of 500 books, available during your subscription period. Enjoy a personalized, interactive, and narrative experience to engage with the book content on a deeper level.
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook + Subscription?
Download this book in EPUB and PDF formats, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
Gain access to our AI Assistant (beta) for an exclusive selection of 500 books, available during your subscription period. Enjoy a personalized, interactive, and narrative experience to engage with the book content on a deeper level.
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Along with your eBook purchase, enjoy AI Assistant (beta) access in our online reader for a personalized, interactive reading experience.
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
  1. Free Chapter
    Gaining Data Literacy with Power BI
About this book
Updated with the latest features and improvements in Power BI, this fast-paced yet comprehensive guide will help you master the core concepts of data visualization quickly. You’ll learn how to install Power BI, design effective data models, and build basic dashboards and visualizations to help you make better business decisions. This new edition will also help you bridge the gap between MS Excel and Power BI. Throughout this book, you’ll learn how to obtain data from a variety of sources and clean it using the Power Query Editor. You’ll also start designing data models to navigate and explore relationships within your data and building DAX formulas to make data easier to work with. Visualizing data is a key element of this book, so there’s an emphasis on helping you get to grips with data visualization styles and enhanced digital storytelling. As you progress, you’ll start building your own dataflows, gain an understanding of the Common Data Model, and automate dataflow refreshes to eradicate data cleaning inefficiency. You’ll learn how to administer your organization's Power BI environment so that deployment can be made seamless, data refreshes can run properly, and security can be fully implemented. By the end of this Power BI book, you’ll know how to get the most out of Power BI for better business intelligence.
Publication date:
November 2022
Publisher
Packt
Pages
330
ISBN
9781804613498

 

Gaining Data Literacy with Power BI

The amount of data produced and collected in the world daily is growing dramatically. As of a 2017 study (https://www.forbes.com/sites/bernardmarr/2018/05/21/how-much-data-do-we-create-every-day-the-mind-blowing-stats-everyone-should-read/), the best estimates are that 2.5 quintillion bytes of data are generated each day, but that number is only expected to have grown since that study is a number of years old now and, more importantly, with the popularity of Internet of Things (IoT) devices. With such staggering numbers, it produces major problems for organizations trying to ensure their workforce has a high level of data literacy.

Not unlike learning a foreign language, data literacy is the concept of reading, understanding, and communicating with data. In its simplest form, someone with high data literacy skills would know how to take raw data provided to them and convert it into something they can use to drive business decisions. This is a skill that takes time to learn but once an individual masters it, they can become incredibly valuable to an organization. Without high levels of data literacy, organizations can seemingly make decisions on gut feelings without supporting data influencing business plans.

 

The challenge facing organizations with low data literacy

With the amount of data collected, one would assume that every organization treats the data they collect as an incredibly prized resource. However, that’s far from true. Many organizations are struggling to understand the meaning behind key business metrics and how those metrics should serve as indicators for driving timely business decisions.

Many organizations lack the skills required to properly show the value behind their data. Other companies take the approach of having only a select few that specialize in understanding and utilizing their data. While this strategy is better than complete data ignorance, it’s still as if every organization has amassed a collection of the world’s most important books for gaining knowledge but only a small percentage of employees actually know how to read.

More forward-thinking companies realize that data in the hands of just a few experts creates a bottleneck, and the optimal strategy is to democratize data to the masses. As organizations grow, it’s easy to become overwhelmed with these problems, but if companies don’t put an emphasis on treating data as an asset, they will quickly fall behind competitors who put a priority on data literacy.

 

Overcoming low data literacy with a data strategy

So how should organizations facing the challenge of staff with low data literacy respond? The first thing leadership must focus on is developing a data strategy. Data itself has no intrinsic value without a strategy for using it properly. The goal of a data strategy is to provide an organization-wide plan on how data should be collected, stored, protected, and analyzed. Without such a plan, an organization is susceptible to issues like data loss, violating international personal data collection laws, and even data breaches, which you hear about often in the news.

It is important to realize that every organization is different, and each has its own unique set of challenges to working with data. So, you shouldn’t stress out about trying to find the definitive data strategy guide because it doesn’t exist! There is no one-size-fits-all data strategy approach for all organizations. For example, a data strategy for a university would look very different from a data strategy for a Fortune 500 company. The former is focused on the success of their students while the latter is likely focused on overall profitability. During the planning of a data strategy, an evaluation of each segment of data must be completed to determine how the data will be processed, stored, and shared. This process will often uncover that not all organizational data should be treated the same. For example, timecard entry data from two years ago is far less important than financial statements from the same timeframe. The idea is that a data strategy should be more granular and not make large declarations about all data. Some data is more valuable than others and the time and resources spent should not be the same for all data. An organization’s data strategy should be centered around its unique needs, but the point of this chapter is not to give you a step-by-step guide on developing a data strategy. More than anything, this is to stress the importance of simply having one!

The second thing organization leadership should focus on to drive higher data literacy is building a data culture. An organization with a healthy data culture is inclusive, meaning it puts data in the hands of everyone, leaving no one left out. This can be challenging when there is such a skill gap between the typical business user and a professional data analyst or data scientist. So, what do you do to overcome that skill gap?

Anyone can improve their data literacy skills, but the question is: what is your organization doing to foster an environment that encourages engaging with and thinking about data? Many organizations are embracing a positive data culture by promoting data enablement programs, which include ways for individuals to improve their skills with both training and mentoring. An enablement program is far more than sending a group of eager data enthusiasts to a class and hoping they learn enough to be productive. A thoughtful data enablement program is an ongoing exercise over the course of weeks and sometimes months to groom your team into becoming citizen developers.

Gartner defines a citizen developer as:

”An employee who creates applications capabilities for consumption by themselves or others, using tools that are not actively forbidden by IT or business units. A citizen developer is a persona, not a title or targeted role. They report to a business unit or function other than IT.”

Growing a data culture full of citizen developers doesn’t happen all at once. Many organizations often start by building a group of data champions. This group would consist of individuals from multiple departments that are eager to learn and ready to make a commitment to improving their data literacy skills. The primary goal is to grow experts in each department so that way, as new citizen developers emerge, they have a known resource within their department who can help them learn. As you might expect, it’s always easier to bounce ideas off someone who knows the kind of data you work with rather than someone who is unfamiliar with your data

Education in data literacy can vary from broad topics that apply to any data analytics tool or more specific tutorials geared toward a particular technology you want your citizen developers leveraging. An example of tool-agnostic learning would be how to spot trends in your data, how to determine outliers in data, or even how to choose the best visualization for the data you are working with. Any of these topics can apply to every data analytics tool on the market. While there are many great data analytics tools on the market, this book spotlights Power BI.

You might have gravitated toward this book for a number of reasons. Maybe you are completely new to Power BI, and you needed a way to kickstart your learning. Perhaps you have been learning about Power BI for some time now but you’re completely self-taught, so you are hoping to fill in the gaps of things you just haven’t seen yet. This would be the phase of learning where many would say, “I don’t know what I don’t know.” Whatever the case may be for you, the authors of this book hope to give you the essentials necessary for achieving high data literacy within Power BI.

 

Why choose Power BI

By grabbing this book, there’s a bit of an assumption that you have already made the decision that Power BI is the tool you or your organization has chosen. If for some reason you are still on the fence, or perhaps Power BI is one of many business intelligence tools your organization uses, then it’s helpful to have an understanding of why so many have already made Power BI their data analytics tool of choice.

Let’s start with collaboration. One of Power BI’s central goals is to get data in the hands of decision-makers. So even though Power BI does come with a central cloud-based portal that users can visit, it may not make sense to give users a new web page to bookmark in their browser. Collaboration really means bringing Power BI to where your users are rather than forcing them to go somewhere new. The way Power BI does this is with integration into many of the tools you know and love from Microsoft like SharePoint, Excel, PowerPoint, Dynamics, Teams, and even your mobile phone. Within each of these tools, Power BI allows collaboration and discussion to occur around the data visualized on reports. This idea of bringing data to where your users already are is one of the significant ways Power BI helps grow a data culture.

Another reason many are drawn to Power BI is because of its ease of use. As you work your way through this book, you will find that Power BI has a very intuitive interface. It allows you to quickly connect to data, build data cleansing transformations, create relationships between data sources, and visualize your data in minutes. More complex problems can take longer of course, but Power BI tends to follow this 80/20 rule: 80 percent of the problems you encounter in Power BI can be solved with a 20 percent level of Power BI knowledge. The deeper knowledge is important of course, but the times you will actually need it are far rarer.

One of the major considerations when picking a business intelligence tool is price. Fortunately, when comparing many of the other top tools on the market, Power BI wins on cost hands down. The competitor with the closest feature parity is seven times more expensive than Power BI for basic report development.

It is important to note that licensing costs can vary depending on your specific needs so this chapter won’t go into more detail on it here. However, we would recommend reviewing licensing details here: https://powerbi.microsoft.com/en-us/pricing/.

If these reasons aren’t enough, look at the unbiased annual survey performed by Gartner for analytics and BI platforms. Gartner Inc. is a well-recognized technology research firm that conducts research on technologies, which it shares with the public. Power BI continually rates as the highest tool on the market in the categories of “Completeness of Vision” and “Ability to Execute.”

 

Migrating your Excel skills to Power BI

Microsoft Excel is the number one most popular computer program in the world. While Excel is an amazing tool, the millions of users using it to analyze their data are thirsty for more. Fortunately, Power BI was designed with the Excel fanatic in mind. Many of the skills collected over time while designing Excel solutions still apply in Power BI. Concepts like modeling data, writing Excel formulas, and building PivotTables, all have comparable features in Power BI.

Excel was the first self-service business intelligence tool provided by Microsoft. Starting in Excel 2010, features known as Power Pivot and later Power Query were added to enable more advanced data analytics problem solving that traditional Excel could not handle. These two features would later become the core building blocks for what Power BI is today. So much so that even today, any Excel solution developed using Power Pivot and Power Query can be migrated into Power BI via a simple migration wizard.

Having an understanding of these additional Excel features can give someone an incredible head start when learning Power BI. If you are reading this book and feel confident in your Excel skills, pay close attention throughout this book to each tutorial and consider how you would have solved the various use cases in Excel. You will likely find that Power BI is an incredible time saver over how you would have previously solved these problems in Excel.

 

Summary

While low levels of data literacy continue to be a massive challenge for organizations, there remains hope for improvement! Technologies like Power BI are one, but not the only, ingredient for a successful data literacy recipe. A well-thought-out data strategy cannot be overlooked. Without a proper plan for your organization’s data, you are treating one of your biggest assets too nonchalantly. Commitment to a data strategy doesn’t happen without buy-in on a culture change within your organization. A strong data culture leads to enablement that scales throughout your organization.

In the next chapter, you will get your first look at the capabilities of Power BI as you learn about the data connectivity options that are available.

Join our community on Discord

Join our community’s Discord space for discussions with the authors and other readers:

https://packt.link/ips2H

About the Authors
  • 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.

    Browse publications by this author
  • Erin Ostrowsky

    Erin Ostrowsky is a creative and passionate lifelong learner. She began her career as a business journalist and researcher and found herself drawn to the power of beautifully visualized data analysis. After living overseas, Erin returned to the USA looking to marry her communication background with a technical focus and found a life changing opportunity to work as a trainer for Pragmatic Works where she focused on creating new educational materials and delivering Power BI training around the country. Erin focuses on the Power Platform tools and loves working on teams to build business intelligence solutions that businesses use and enjoy.

    Browse publications by this author
  • 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

    Browse publications by this author
  • Bradley Schacht

    Bradley Schacht is a Senior Cloud Solution Architect (Data Platform) on the Microsoft State and Local Government team based in Jacksonville, FL. Bradley has authored 3 other SQL Server books. As a former consultant and trainer, he uses his experience on the Microsoft data platform to help customers architect quality end to end solutions for every business problem encountered. Bradley gives back to the community through speaking at events such as the PASS Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG).

    Browse publications by this author
Microsoft Power BI Quick Start Guide - Third Edition
Unlock this book and the full library FREE for 7 days
Start now