The book Power Query and dashboard pivot with Excel has been released for the new techniques: working on data in a new way with autonomy, efficiency, speed, written by Marilena D’Onofrio.

In any business sector, those who receive data to be analysed must first carry out various actions of disposition and preparation of the same and are forced to repeat them to every change.

With Excel Power Query these actions are automated when they are performed, so when the data changes, just press a button to update the situation analysed.

Power Query can therefore improve the efficiency of anyone using Excel to compare, calculate parameters, and compile data reports. From logistics to marketing, from production to sales, anyone can benefit from it and, above all, without the need for programming knowledge.

Who is the author Marilena D’Onofrio is an Office company trainer since 2000, specializing in Microsoft Power BI (Business Intelligence); in the previous twenty years it has been: consultant, administrative manager, financial controller, external audit On the website of Marilena D’Onofrio, you can download the files used in the text.

With a succession of guided exercises tested in numerous sessions in the classroom, the book gives way to master the use of Power Query and to realize interactive dashboards of tables and pivot graphics.

The concepts are displayed step by step and the text is accompanied by screens that exemplify the steps to be performed.

In addition to being instantly useful in Excel, Power Query knowledge is basic to work with Microsoft Power BI.

The version used by Marilena D’Onofrio is Excel 365 with references to Excel 2016

From the introduction to the book written by Marilena D’Onofrio we grasp the formative scope of this work.

Why Power Query?

In the company, management systems collect data and make them available to the various offices where checks, comparisons, cross-references are carried out until the necessary reporting is produced.

the decision-making process. Those who are involved in logistics, therefore, or marketing or production or other contribute effectively, albeit with an unstructured approach, to the Decision Support System (DSS). And he does it working in Excel.

Receives data abstractions from SAP or Oracle and in Excel processes them: filters, removes, moves, divides, merges, crosses, queues, groups, synthesizes, calculates, compiles according to conditions, to monitor the situation mainly with A considerable amount of work is then carried out by office.

Every change in data is done and repeated and most of the time is repeated manually because there is no skills to automate it. Who is lacking and normal: who is involved in production and production that must know not about VBA and SQL, and if the sales office are developing software who does the turnover?

It is therefore normal that to automate you must contact the Information Systems or consultants. It is necessary to request the intervention, which will have costs and must be authorized, to expose its needs to those who will technically develop the answers, wait, find that we do not understand exactly: it is inevitable, to re-dispute trying to understand better, wait again,

And he was pissed off at Excel. This is the scenario, until now.

Finally, with Power Query everything changes: the work done a first time and done for

Always, when the data changes just press Instructions and Power Query

to write to her: he writes in code what is done, so who deals with production,

marketing, customer care, must know nothing about programming code. Stop.

I’ll do the job the first time.

Even, it doesn’t even have to write functions like SEARCH.VERT, STRINGA.EXTRAI, IF because in Power Query there are much more intuitive tools that offer even higher options. Learn how to use Power Query and also essential for those who want to work in Microsoft Power BI. The family environment of Excel and the learning process, giving them the opportunity to benefit from it immediately.

Buy the book now

Objectives: Excel Power Query and Pivot

This book is designed to acquire the mastery of Power Query and tables

Excel’s pivot. ♪ You always pass from a pivot! ♪ She exclaimed a girl at some point in the course. Pivot tables are fundamental for understanding data because aggregate them give way to observe them by groups.

The pivot can be illustrated by a graph and in Excel you can create dashboards composed of pivots and pivot graphics. In addition to being very useful in itself, these objects anticipate visual, report and dashboard of Power BI. The creation of pivots with graphics and dashboards is proposed in almost every chapter of the book, so as to get familiar with it and acquire from time to time the knowledge of additional options.

Method tested in years of business courses followed by actual findings of efficiency improvements in office activities, the book methodology and based on step by step guided exercises, with images of the views when the action is presented for the first time.

The arguments are happening in progression by proceeding in degrees. From the first chapter, the automation of updates and an interactive dashboard will be implemented; therefore, practical applications can be immediately grasped in the work. It will continue in the following with the assembly then with the union of tables and growing with the various tools with which to realize the cleaning and arrangement of the data.

In this first phase, consisting of 22 chapters, the source data are in Excel files since most of the data are received in this form in the offices and know how to transform them and priority. Then follow the chapters dedicated specifically to

data recovery from other sources.

Leave a Reply

Your email address will not be published.

You May Also Like