MS Power BI

DAX (Data Analysis eXpressions) Formulas
(more...)
Indeep the PowerPivot and Power BI courses by addressing the 120 (among 347!) most important functions (formulas) of the DAX formula and query language (Data Analysis eXpressions) to create more complex dynamic Pivot tables with statistical measures or elaborated time intelligence measures, or create DAX queries. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop training.

Foundations
(more...)
In this course you will gain a fundamental understanding of the capabilities of Power BI Desktop. You'll start out with seeing how you can quickly and easily gather data from a variety of sources, and then cleanse and transform that data with just a few clicks. Next, you'll also learn how you can enhance the results by integrating disparate data sources and adding simple calculations. Then, you'll learn how to explore your data with visualizations and simple reports. Finally, you'll learn what steps are necessary to keep your data up-to-date. By the end of this course, you'll have a firm understanding of the basic skills required for using Power BI to acquire and transform data, enhance the data for analysis, and produce reports and dashboards. This training also prepares the attendee for the Power BI 70-778 certification and for the Power Query, DAX, Power BI Service and Power BI Data Viz courses.

M (Munging) Language
(more...)
The purpose of this short training is to learn the specific M-language elements most requested by practitioners (among the 950 functions) and that can not be done at this date through the classic actions available in the Power Query tabs (both in Microsoft Excel or Microsoft Power PI).

Power BI Report Builder
(more...)
This course empowers you as a report author with the technical knowledge required to create, publish, and distribute Power BI paginated reports. This training is based on the micro-training provided by Microsoft: "Microsoft Power BI Report Builder in a day".

Power BI Service
(more...)
In this course, you will gain a basic understanding of the capabilities of Power BI Services for users. You'll begin to see how you can quickly and easily collect data from a variety of sources and share them on the web, and use the Power BI Services specific options and tools for Power BI Desktop. This training prepares participants for Power BI 70-778 certification.

Power BI with R and Python
(more...)
The objective of this short training is to briefly discover the possibilities offered by the use of R and Python in combination with Power BI and in particular the use of artificial intelligence or machine learning. Through simple and complex examples, learners will see how to combine these two tools and the few pitfalls / limitations and good practices relating to them.

Power Query
(more...)
The objective of this training is to acquire the necessary knowledge in Power Query to process, clean or link large amounts of data from different sources for post-analysis in the spreadsheet software as a table or in the PowerPivot model. The trainer will also introduce most common business cases that makes problems to Power Query users in MS Excel or MS Power BI. This training also prepares the attendee for the Power BI 70-778 certification and for the Power BI Desktop and M language training.

Visuals and Charts
(more...)
In this training, participants will learn how to use (creation, drilling, filtering with slicers / drop-down lists, or "what if" sliders and interaction control) and customize the graphics available in Power BI and will focus only on this aspect (no formulas, no data imports, no data cleaning, but only on the use of visuals!) and on the management of some traps. In total about 350 different types of graphics/visuals will be studied, whatevwer they are default graphics, or made with R or Python. This is an advanced training in data visualization for those having to build high added value and state of the art dashboards. This training prepares participants for the Power BI 70-778 certification and also for the Power BI Services training.

Trainings, Courses available in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

Contents