Working with data in Six Sigma projects with the help of Power BI and Excel

The Power BI course in Six Sigma projects is focused on the practical integration of modern analysis systems in Six Sigma projects in the Power BI environment using Microsoft Power Query and Power Pivot .
Under the guidance of Rob Klačanský, participants apply the content to their own projects .

Benefits of the course:

Time savings in Six Sigma projects
Effective work with Power Query for data mining and Power Pivot for the analysis phase
Clear dashboards in Power BI in the Control phase
Creating automation in Six Sigma projects

The form of realization of the course is face-to-face or online (or both forms) .
The working methods used in the training programs are chosen in such a way as to ensure interactivity, adapt the content to the needs of the participants and prioritize the transfer of knowledge into practice .

Objectives

addition, enrichment, integration of modern analysis systems in Six Sigma projects in the power BI environment

Course Content

Preparation of the data structure in the measure phase in the power BI environment

-preparation of the Six Sigma project model
-interconnection of modules in the model
-choice of KPI indicators for the improvement project

Time synchronization of databases

– connection of modules
– alignment in the time plane
– addition of input parameters to the module and their linking in the overall model

Creating outputs for the control phase in the BI dashboard environment

– graphic visualization of process output indicators
– graphic visualization of simple causal graphs
– use of AI in the analysis of non-standard fluctuations of process indicators

Who is the Power BI course in Six Sigma projects intended for:

Graduates of Six Sigma Green Belt training

Trainers

Róbert Klačanský

Peter Elbert

Application support from the lecturer in practice

The possibility of subsequent application support in the form of individual consultation with the lecturer is available for course participants. The recommended range is 2-3 consultations.

The price for one application consultation with a lecturer (1 hour) is EUR 150 + VAT.
Application consultations are carried out online.

To order or for more information about subsequent individual consultations, contact us at fbe@fbe.sk or phone number +421 254 418 513.

Cooperation on the preparation of Six Sigma trainings

Dale K. Mize , head of Six Sigma programs

Business Excellence Center, University of St. Thomas and president of Advanced Quality Engineering Inc., Minneapolis, USA. He worked as a Black Belt and Director of Quality Assurance at General Electric Lighting and Wagner Spray Tech Corp. Recently, he led Six Sigma programs in more than 100 companies and was responsible for the FBE instructor development program.

Dan J. Sommers , Six Sigma Master Black Belt (MBB) Certification Program

Founder of The Quality Innovation Institute, USA. He worked for 20 years at GENERAL ELECTRIC Lighting, Cleveland, Ohio in the positions of Black Belt, Master Black Belt and Quality Manager of the company. He later worked at the Six Sigma Academy, USA. He has led multi-country improvement projects for DuPont, Ford Motor Company, Textron, United Health Care, ITC Limited and Arcelor-Mittal Steel. Cooperates with FBE in the MBB certification program.

Find out more

We will provide you with more detailed information about the price, possible dates and training schedule.

We also recommend the following courses