Member section

Training

Training

Looking to expand your Power BI knowledge and skills? If so, we have the perfect solution for you.

Filter

2 trainings

MS Excel

We know that Excel is one of the options for obtaining source data for Power BI.

We will help you connect these 2 worlds.

MS Excel - Data preparation for Power BI

Analyze data in Excel and have at least a basic understanding of Power BI?


In this training, we will guide you through the basic preparation of data up to the creation of an impressive report.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training – Power BI for beginners.

  1. What data volumes to have in Excel (rows, columns, MB)
  2. Does it matter where the Excel files are stored?
  3. Structured vs. unstructured resources
  4. Data types vs. formats
  5. How many files will we want to load?
  6. Are there calculations in the tables?
  7. How will Power BI handle errors?
  8. Will we want historical data in Power BI?
  9. Will the report serve for several years?
  10. Will Excel spreadsheets change?
  11. Is it necessary to limit individual viewers when viewing the report (RLS)?
  12. Older versions of XLS
  13. Locked, password-protected, encrypted files
  14. Have source data in arrays or just classic tables?
  15. Basic philosophy and evolution of Power tools
  16. Why very carefully on Svyhledat, Xlookup, etc.
  17. External add-ins in Excel
  18. When is it better to use macros and when to use Power tools
  19. Basic philosophy and evolution of Power tools
  20. Discussion

1 day (6 hours)

Face-to-face, online, combined

MS Excel - Working with large volumes of data

Do you struggle with large amounts of data and Excel? Large files, lots of rows, lots of sheets… Sound familiar?

This training will teach you how to get the best out of Excel without overloading your device’s memory.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

8 trainings

Power BI

Are you interested in how Power BI works and what it can do?
Are you new to this field or do you just want to deepen your existing knowledge and make your work more efficient?

In addition to Power BI Desktop, we also offer Power BI web service, including deployment and setup or auditing.

We will also be happy to tailor everything for you.

Power BI for beginners

In this training, we will tell you why you should use Power BI, how it works and how it can make your time and save costs more efficient.

We will also teach you how to use it practically and create simple reports.

For all beginners who already work with Excel and they want to take their reporting and knowledge to a completely different level.

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Power BI pro pokročilé

Máte alespoň základní znalosti v Power BI a chcete je prohloubit?

Na tomto školení budeme pracovat více do hloubky s Power Query, datovým modelem a v neposlední řadě s vizualizacemi.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Vizualizace dat v Power BI

Chcete dát svým reportům poutavý design a umět je sladit 
i s korporátní identitou?

Na školení získáte znalosti o aktuálních možnostech i trendech ve vizualizacích.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Tvoříte reporty a potřebujete je publikovat ? 
Nejste si však jisti, zda používáte dostatečné zabezpečení?

Pomůžeme Vám!

Zkušený správce prostředí Vám představí Power BI webovou službu. Naučí Vás vše prakticky nastavit, abyste se zkrátka o svá data již nemuseli bát. 


Power BI webová služba pro začátečníky

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Power BI webová služba pro pokročilé

 

Účastník rozšíří své  získané znalosti ze školení webové služby pro začátečníky. 

Bude schopen řešit pokročilé nastavení a správu od úrovně workspace adminů až po kapacity adminů.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Power BI optimalizace & performance tunning

Jsou Vaše reporty objemné, pomalé a chybové? 

S námi již nebudou!  

Zkušený administrátor webové služby účastníky provede možnostmi optimalizací datových modelů s využitím Externích Power BI nástrojů, simulacemi problematických reportů až po praktické řešení již přetížené kapacity webové služby.    

 

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Power BI (Fabric) administrace

Staňte se administrátorem Power BI, kterého jen tak něco nerozhodí.

Lektor se s účastníky podělí o své praktické mnohaleté zkušenosti s administrací. Dále se bude prakticky věnovat nejčastějším problémům v administraci a jejich efektivnímu řešení.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Krátký popis školení.

Power BI workshop

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

1 školení

MS Fabric

Microsoft Fabric, jednotná analytická platforma slučující Power BI, Azure Synpase a Data Faktory. 

Naučíme Vás rozumět datům novým způsobem. 

MS Fabric

Jste expert na datové sklady či analytický inženýr a jste uživatelem Power BI Premium?

Ukážeme Vám, jak využívat jednu jednotnou platformu pro všechny zdroje Vašich dat.  

Přeměňme společně jejich sílu k rozhodování!  

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

2 školení

Jazyky - M / DAX

Kromě jazyků SQL, MDX, Python nebo R se lze v Power BI setkat s M a DAX.

Jazyk M je perfektní pro získávání, transformaci a očištění dat.
DAX je výborný na datové modelování. 

Naučíme Vás prakticky použivat oba. 

Bez znalosti Power Query, M jazyka lze velmi těžko vytvořit kvalitní report. Určitě záleží na situaci, ale doporučuji mít zde náležité znalosti.

Na kurzu jdeme od jednodušších věcí, které nalezneme na pásu karet atd. až po psaní kódu. Vše se zaměřením na praxi.

M jazyk - Power Query

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

Datové modelování, pro některé jako Excel funkce, najdeme hlavně v Power BI Desktop okně. A pokud se dostaneme k něčemu složitějšímu než je SUM nebo COUNT, tak se znalosti určitě hodí.

Kurz je důležitý pro pochopení filozofie výpočtů v Desktop okně. Co můžeme a jak. Čemu se raději vyhnout atd.

DAX jazyk I.

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

1 školení

Storytelling

Aby data vyprávěla příběhy, aby jsme mohli najít řešení na základě dat. Pěkný a optimalizovaný report je fajn, ale ještě můžeme jít o level výše…

Chcete dát svým starým reportům novodobý šmrc? 

Naučíme Vás, jak vytvořit dashboard, který motivuje k akci a vypráví skutečný příběh Vašich dat. 

Storytelling v Power BI

For everyone with advanced knowledge of MS Excel and a desire to learn.

We then recommend training-

  1. Introduction to working with large volumes of data
  • Excel files over 20MB and what’s wrong with them
  • Excel files over 100K rows and what’s wrong with them
  • Excel files with 100 or more sheets and what’s wrong with them
  1. Work with exports from the system in Excel
  2. Smart tables
  3. Advanced data validation
  4. Data cleaning with functions (advanced text functions)
  5. Excel error handling (advanced informational and logical functions)
  6. Advanced logic and search problems
  7. Formula analysis and evaluation (formula dependencies, evaluation, peephole, cyclic dependencies)
  8. Advanced work with pivot tables (pivot tables over OLAP and PP OLAP)
  9. Creating dashboards in Excel
  10. New types of graphs and visualizations
  11. Security or mostly leaky “helper”
  12. In-depth comparison of two Excel files (we can detect all differences)
  13. When is it better to use macros and when to use Power tools
  14. Basic philosophy and evolution of Power tools
  15. Discussion

1 day (6 hours)

Face-to-face, online, combined.

I am a consultant and admin
Power BI.