Advanced Power BI Training

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have been supporting organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that will accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to enhance your employees' competencies in the IT field.

The training is intended for individuals who deal with processing and analyzing large amounts of data. The scope of the training includes data preparation using PowerQuery and utilizing it for visualization with Microsoft Power BI. The training covers the use of the DAX library. Topics related to storytelling with data will also be discussed.

• For analysts, marketers, and anyone working with data.
• For individuals involved in processing and analyzing large amounts of data.

Acquire advanced skills in data processing and analysis using Power Query and Power BI, utilizing the DAX library, M language, query parameterization, creating custom functions, and working with SQL databases as data sources. Learn to secure reports (RLS), create data visualizations using AI, use variables in measures, and utilize DirectQuery for the Power BI model.

You will learn to use additional tools such as DAX Studio and Tabular Editor, as well as advanced report publishing features, including embedding reports on websites and using URL parameters. You will gain skills in using Power Automate to automate work with Power BI, allowing for more efficient data management and presentation. You will master techniques for using Python in Power BI, including configuring Python for Power BI Desktop, using Python scripts to fetch data and create visualizations.

• Advanced Techniques in Power Query

  • Introduction to M Language – Advanced Editor

  • Data Preparation Using M Language Functions

  • Query Parameterization

  • Creating Custom Functions

• Working with SQL Database as Data Source

  • Import and DirectQuery Connections

  • Fetching Data from SQL Database

  • Query Folding – What It Is and How to Use It

  • Using Custom SQL Queries

  • SQL Query Parameterization

  • Best Practices for Working with SQL Database as Data Source

• DirectQuery Connection – Optimization Methods

• Python Language in Power BI

  • Configuring Python for Power BI Desktop

  • Limitations of Using Python in Power BI

  • Using Python Scripts to Fetch Data (Python Connector)

  • Creating Visualizations Using Python

• Advanced Power BI Functions

  • Securing Reports – RLS

  • Data Visualizations Using AI

  • DirectQuery for Power BI Model

  • Using Variables in Measures

  • Additional Tools (DAX Studio and Tabular Editor)

• Advanced Report Publishing Features

  • Embedding Report on Existing Page

  • Using URL Parameters

• Using Power Automate to Automate Work with Power BI

16 h/2 days

• Certificate of Completion
• Monthly Access to Training Recording (for online format)
• Customization of Training Program to Client's Needs