eBook - ePub
Master Your Data with Excel and Power BI
Leveraging Power Query to Get & Transform Your Task Flow
Miguel Escobar, Ken Puls
This is a test
Partager le livre
- 212 pages
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
eBook - ePub
Master Your Data with Excel and Power BI
Leveraging Power Query to Get & Transform Your Task Flow
Miguel Escobar, Ken Puls
DĂ©tails du livre
Aperçu du livre
Table des matiĂšres
Citations
Ă propos de ce livre
Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day or month after month? Power Query will make it faster to clean your data the first time and a single click to clean your data every time after that. While Power Query is powerful, the interface is subtle - there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book.
Foire aux questions
Comment puis-je résilier mon abonnement ?
Il vous suffit de vous rendre dans la section compte dans paramĂštres et de cliquer sur « RĂ©silier lâabonnement ». Câest aussi simple que cela ! Une fois que vous aurez rĂ©siliĂ© votre abonnement, il restera actif pour le reste de la pĂ©riode pour laquelle vous avez payĂ©. DĂ©couvrez-en plus ici.
Puis-je / comment puis-je télécharger des livres ?
Pour le moment, tous nos livres en format ePub adaptĂ©s aux mobiles peuvent ĂȘtre tĂ©lĂ©chargĂ©s via lâapplication. La plupart de nos PDF sont Ă©galement disponibles en tĂ©lĂ©chargement et les autres seront tĂ©lĂ©chargeables trĂšs prochainement. DĂ©couvrez-en plus ici.
Quelle est la différence entre les formules tarifaires ?
Les deux abonnements vous donnent un accĂšs complet Ă la bibliothĂšque et Ă toutes les fonctionnalitĂ©s de Perlego. Les seules diffĂ©rences sont les tarifs ainsi que la pĂ©riode dâabonnement : avec lâabonnement annuel, vous Ă©conomiserez environ 30 % par rapport Ă 12 mois dâabonnement mensuel.
Quâest-ce que Perlego ?
Nous sommes un service dâabonnement Ă des ouvrages universitaires en ligne, oĂč vous pouvez accĂ©der Ă toute une bibliothĂšque pour un prix infĂ©rieur Ă celui dâun seul livre par mois. Avec plus dâun million de livres sur plus de 1 000 sujets, nous avons ce quâil vous faut ! DĂ©couvrez-en plus ici.
Prenez-vous en charge la synthÚse vocale ?
Recherchez le symbole Ăcouter sur votre prochain livre pour voir si vous pouvez lâĂ©couter. Lâoutil Ăcouter lit le texte Ă haute voix pour vous, en surlignant le passage qui est en cours de lecture. Vous pouvez le mettre sur pause, lâaccĂ©lĂ©rer ou le ralentir. DĂ©couvrez-en plus ici.
Est-ce que Master Your Data with Excel and Power BI est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă Master Your Data with Excel and Power BI par Miguel Escobar, Ken Puls en format PDF et/ou ePUB ainsi quâĂ dâautres livres populaires dans Business et Business Intelligence. Nous disposons de plus dâun million dâouvrages Ă dĂ©couvrir dans notre catalogue.
Informations
Chapter 1 - Power Query Fundamentals
The purpose of Power Query is to collect and reshape data into the desired format, before loading it into tables for consumption by the business analyst. The basic overview of the process, which Power Query will attempt to follow without your intervention, can be visualized as follows:
An overview of the Power Query process
Of course, we can manipulate any part of this process at any time. And indeed, in this book we will do a lot of that. But to begin with it is helpful to walk through and understand the overall method that Power Query is attempting to follow.
Before You Begin
Before you launch into your Power Query journey, there are some defaults that we suggest you change in the Power Query interface. Why? Microsoft turned certain features off to avoid overwhelming you, but unfortunately some of these items are critical in order to use the tool properly. And since you have this book, youâll be guided through the correct use here anyway!
Adjusting Excelâs Default Power Query Properties
To adjust your default settings in Excel:
- Go the Data tab Ă Get Data Ă Query Options
- Under Global Ă Data Load, ensure that Fast Data Load is checked. (This setting will lock Excelâs user interface during a refresh but will ensure that you have up to date data before continuing.)
- Under Global Ă Power Query Editor, ensure that every box here is checked. We especially want to make sure the Formula Bar is showing but checking every box will make sure you have all the options that youâll see throughout this book.
- Click OK
There are other options within this area, but for now the default settings will work just fine.
Adjusting Power BIâs Default Power Query Properties
To adjust your default settings in Power BI Desktop:
- Go the File tab Ă Options & settings Ă Options
- Under Global Ă Power Query Editor, ensure that every box here is checked. We especially want to make sure the Formula Bar is showing but checking every box will make sure you have all the options that youâll see throughout this book.
- Click OK
đ While in the Power BI Desktop options, you may also want to check the Global Ă Preview Features tab to see if any new features look enticing. As features are released to Power BI Desktop first, this is a great place to see what is coming to Power Query in Excel.
Extract
In this chapter, we will look at importing a simple CSV file into Power Query in Excel or Power BI to show just how Power Query approaches the tasks above, how they look in the user interface, and how they are identical between the two programs.
The ETL process all begins with the Extract step. Inside this step are four distinct subtasks as follows:
The four sub-steps of the Extract process
Configure Connector Settings (Choose Your Data)
The first step is to choose and configure the data connector we want to work with. In this case, weâll start by creating a new query that uses the CSV connector in Excel:
- Go to Get Data Ă From File Ă From Text/CSV
This would be equivalent to the following in Power BI Desktop:
- Go to Get Data à More⊠à File à Text/CSV
Connecting to a Text/CSV file in Excel (left) or Power BI Desktop (right)
It is worth recognizing that you could attach to a Text/CSV file in less clicks in either program. As Text/CSV files are a common data source, they surface in the user interface much more quickly than drilling down into the sub-menus. In Excel youâll find this connector right beside the Get Data button on the Data tab. And in Power BI the connector is on the very first level of the menu, with no need to drill down into the More⊠sources. This, however, wonât always be the case as we move into other data sources later in the book, so weâve standardized on the full path to the data source.
đ Power BI Desktop can actually connect to a larger set of data sources than Excel. The intention of the team here is to release beta connectors into Power BI and â once they have passed beta stage â eventually bring them to Excel.
Once weâve selec...