Produkt

KlappentextA comprehensive and fully visual guide to Microsoft Power BI

Teach Yourself VISUALLY Power BI collects all the resources you need to master the everyday use of Microsoft's powerful data visualization software and delivers them in a single, easy-to-use volume. Fully illustrated, step-by-step instructions are combined with crystal-clear screenshots that walk you through the basic and advanced functions of Microsoft Power BI.

Teach Yourself VISUALLY Power BI offers the best visual learning techniques with complete source material about the interface and substance of Power BI, as well as:
Stepwise guidance on working with, transforming, and processing data sources
Instructions for customizing data visualizations to create informative and presentation-ready charts and graphs
Full-color, two-page tutorials on the more advanced features of Power BI, including app integrations and data access with DAX

The fastest, easiest way for visual learners to get a handle on Microsoft Power BI, Teach Yourself VISUALLY Power BI is a can't-miss resource, loaded with useful tips for newbies and experts alike.

Details

Weitere ISBN/GTIN9781119903796

ProduktartE-Book

EinbandartE-Book

FormatEPUB

Format Hinweis2 - DRM Adobe / EPUB

FormatFormat mit automatischem Seitenumbruch (reflowable)

Verlag

John Wiley & Sons

Erscheinungsjahr2023

Erscheinungsdatum05.04.2023

Auflage1. Auflage

ReiheTeach Yourself VISUALLY

Seiten256 Seiten

SpracheEnglisch

Dateigrösse51671 Kbytes

Artikel-Nr.11470126

Rubriken

Genre9201

Verwandte Artikel

ReiheTeach Yourself VISUALLY

Teach Yourself VISUALLY Power BI

Teach Yourself VISUALLY HTML and CSS

Teach Yourself VISUALLY MacBook Pro & MacBook Air

Inhalt/Kritik

Leseprobe

CHAPTER 1

Getting Started with Power BI

Power BI enables you to create visual analytics from data, allowing you to understand even complex data structures and effectively communicate insights gained. You need neither special mathematical skills nor programming experience to understand and acquire Power BI skills.

What Is Power BI?

Understanding the Different Components of Power BI

Understanding Power BI as Part of the Power Platform

Install Power BI Desktop

Start and Pin Power BI Desktop

Explore the Power BI Workspace

What Is Power BI?

Power BI is a data-visualization app that enables you to analyze data without technical expertise or programming knowledge. BI is a standard abbreviation for business intelligence. Instead of needing to type in complex data queries, you can create your queries by clicking and dragging items in Power BI s graphical interface. This ease of use allows you to quickly find insights in your data and to share them with others.

You do not have to know from the start what you are looking for or how you want to present the results. Rather, Power BI takes you on a journey through your data and helps you discover relationships you did not expect to exist through visual analysis. This approach is fundamentally different from other tools, whose use requires that you already know at the beginning of your analysis which data you want to present in which form.

Power Query, an Essential Part of Power BI

Power BI also offers complex techniques of data cleansing, data modeling, and data preparation with Power Query. Power Query is a data transformation and data preparation engine. Power Query has a graphical user interface for retrieving data from sources and a Power Query editor for applying transformations. You can use Power Query to perform ETL processing on data. Extract, Transform, Load, or ETL, is a process that unifies data from multiple, possibly differently structured, data sources.

Power BI s Vast Variety of Data Sources

Power BI Desktop enables you to connect to a wide variety of data sources. You can use data stored in Excel workbooks or in text files in the comma-separated values format, CSV. You can use data from databases such as Access or SQL Server. You can access data in data cubes, which are multidimensional arrays containing values. You can also connect to data warehouses, clusters of computers running the Apache Hadoop computing framework, or various cloud services such as Google Analytics.

After connecting to the appropriate data source, you interact with the Power BI user interface to query the data with a few mouse clicks and display the results in various charts and maps. You can then arrange these visualizations into dashboards to put them into meaningful context.

When communicating key insights, you have a variety of options depending on the product you use, from sharing interactive dashboards to embedding them in web pages. Power BI facilitates both the presentation of insights from data and the communication process, that is, data storytelling and interactive dashboards, without requiring any programming skills.

Data Analysis and Excel

Data analysis and visualization have always been an important topic in the professional environment and a fundamental tool for business decision-making. In this environment, Microsoft Excel quickly became popular and established itself as one of the most important tools for data analysis. However, with the exponential growth of data in the world, often referred to as big data, and the growth of the culture of analytics and data science, Excel is reaching its limits and is being replaced by more efficient tools for data analysis such as Power BI.

Power BI, the Big Leap from Excel

Year after year, companies are focusing more on data and how to get value from it in order to sell more products, attract more customers, and increase the efficiency of the process. In this scenario, a tool that handles a large amount of data and is able to analyze data quickly and easily to present information clearly to businesses becomes essential. To address this need, Microsoft has developed Power BI, a visualization tool that is capable of handling large and complex amounts of data while changing the way you deal with charts or visualizing data.

Excel has excellent features and allows the user to work easily and effectively to analyze data. Excel is the most widespread spreadsheet tool, where it can indisputably show its full power. With the introduction of Pivot Tables in Excel in 1994 and Power Query functions in Excel 2010, Excel gained functions for editing and analyzing data in tables up to 1 million rows. Nevertheless, Excel s strength remains the calculation of complex formulas more than the processing of large amounts of data. Excel also brings good functionalities for analysis and good graphical visualizations. Ultimately, even with smaller data sets, Power BI offers better performance, more comprehensive analytics and visualizations, and the ability to share dashboards or apps across the enterprise for a one-stop solution. In these cases, Power BI proves to be extremely useful with advantages over Excel, making data analysis more agile and efficient.

With a wide range of graphics and widgets, a good ability to handle big data, integration with different platforms and ease of use, and centralization of different data sources, Power BI is proving to be increasingly popular, both among experienced Excel users and beginners new to the world of data.

How This Book Guides You into Power BI

This book is designed to provide you with a step-by-step introduction to creating visual analytics, enabling you to understand even complex data structures and effectively communicate insights gained. Therefore, this book is of interest to a variety of audiences, such as people who have access to and want to understand data, executives who make decisions based on data, analysts and developers who create visualizations and dashboards, and aspiring data scientists.

You need neither special mathematical skills nor programming experience to understand this book and develop skill in using Power BI effectively. The book is suitable for beginners and for users who want to approach the topic of data visualization and analysis in a practical way, without extensive theoretical treatises.

Understanding the Different Components of Power BI

Microsoft groups various software products and services for data analysis under the umbrella name Power BI. For this book s purposes, the three key Power BI components are Power BI Desktop, the Power BI cloud service, and the Power BI Report Server.

Power BI Desktop is a desktop application that you use to create analyses and reports from data sources. You can then make these analyses and reports available to consumers via either the Power BI cloud service or the Power BI Report Server - or indeed both. This section explains how the different Power BI components and licensing models interact with reports.

Power BI Desktop

Power BI Desktop is a free application for Windows that is popular among analysts and business users. On the one hand, Power BI Desktop allows you to connect to local files, such as Excel and CSV, and save report files locally. On the other hand, Power BI Desktop allows you to connect to many external data sources and store them on your own report server or the Power BI cloud service. The focus of this book is Power BI Desktop, which allows you to quickly create advanced analytics and reports and gain data-driven insights.

Power BI Pro

Power BI Pro is a user-based license for the Power BI service that lets you share reports and analytics with other users. You can use collaborative functions and integrate a role and rights concept. You can also embed published reports in other applications such as Microsoft SharePoint, Microsoft Teams, or other Microsoft Power Platform applications. At the time of this writing, the Pro license cost $9.99 per user per month; see powerbi.microsoft.com/en-us/pricing for current pricing. Power BI Pro is already included in the Microsoft 365 Enterprise E5 subscription plan.

Power BI Premium

Power BI is a platform for data analysis and is used by small companies as well as large, publicly traded corporations. Power BI Premium is used to provide company-wide visualizations and dashboards, which can also be operated in the web browser and can also be embedded in the company intranet. As of this writing, Microsoft offers a free 30-day trial for Power BI Premium; go to powerbi.microsoft.com/en-us/power-bi-premium and click Try Power BI for free.

Power BI Embedded

With Power BI Embedded, you can integrate reports and analyses on your website and make them available to your customers without them having to log in to the Power BI service. Power BI Embedded uses a different licensing model: Your company pays for Power BI capacity that you make available for your customers to use, rather than customers needing to have their own Power BI accounts.

Power BI Report Server

The Power BI Report Server is a server platform on which you can publish and view reports in the same way as Power BI Premium. However, this is not a cloud platform but a so-called on-premise solution that you can integrate into your own...

mehr

Bitte warten - die Druckansicht der Seite wird vorbereitet.

Teach Yourself VISUALLY Power BI

Verfügbare Formate

Produkt

Inhalt/Kritik

Autor

KI für Content Creation

Datenvisualisierung mit Power BI

Datenvisualisierung mit Tableau

KI für Content Creation

KI für Content Creation

Services

Infos

Über uns

Leistungen

Newsletter

Zahlung