Microsoft Power BI Basic Training

This training is the perfect start for anyone who wants to learn about Power BI and its capabilities. Starting with the basics, you will learn what Power BI is, how to import data from a variety of sources and then create clear and interactive reports. The training focuses on the practical use of Power BI, showing you step-by-step how to use basic visualisations, as well as introducing you to advanced features such as measures, calculated columns and the DAX language. You will also learn how to publish and share your reports so you can share your analysis with others.

• On-site or remote training.

• Training group of up to 10 people.

• Duration: 1 day.

The objective of the training is to provide participants with basic Power BI knowledge and skills to enable them to independently import data, create reports and visualizations, and interpret the results of analysis.

Upon completion of the training, participants will be able to:

• Understand the basic functions and capabilities of Power BI.

• Import data from a variety of sources.

• Create basic visualizations and reports.

• Use the DAX language to create measures and calculation columns.

• Publish and share their reports.

The training aims to prepare participants to effectively use Power BI to analyze data and make better business decisions.

The training is dedicated to anyone who wants to learn the basics of Power BI - business analysts, students, entrepreneurs, marketing and sales staff and anyone who wants to develop their data analytics skills.

Participants should have basic computer skills. Knowledge of spreadsheets (e.g. Microsoft Excel) will be an advantage but is not required.

• Increased work efficiency: Power BI allows you to analyse your data quickly and efficiently, saving you time and making you more efficient.

• Better understanding of your data: The visualisation of data in Power BI makes it easier to interpret and allows for a better understanding of trends and relationships.

• Improved report quality: Power BI enables you to create professional and clear reports that are easier to understand and present.

• Development of analytical skills: The training allows the development of analytical skills, which are increasingly in demand in the job market.

Our trainer is a long-time practitioner and Microsoft Certified Power BI specialist.

Microsoft Certified: Power BI Data Analyst Associate (PL-300).

He has extensive experience in training and implementing Power BI solutions in various industries and corporations on a global scale.

He is passionate about sharing his knowledge and experience, inspiring participants to use Power BI to achieve business success.

1. Introduction to Power BI

• What is Power BI.

• Power BI versus the competition.

• Overview of the user interface.

• Basic features and capabilities.

2. Importing and Combining Data

• Typical data sources supported by Power BI:

  • CSV files,

  • Excel files,

  • SQL databases,

  • Web services,

  • Cloud data (e.g. Azure, Google Big Query).

• Importing data from various local and remote sources.

• Combining and modelling data.

• Power Query.

3. Creating Reports and Visualisations

• Basic visualisations: tables, charts, maps.

• Adding and formatting visual elements.

• Interactivity and filtering in reports.

4. Advanced Power BI Features

• Creating and using measures and calculation columns.

• Introduction to the DAX language.

• Date and time functions.

• Context change functions.

• Aggregating functions.

• Creating and using data hierarchies.

5. Sharing and Publishing Reports

• Publishing reports in Power BI Service.

• Sharing reports with other users.

• Creating dashboards.

6. Q&A Session

• Answering participants' questions.

• AI in BI.

• Practical tips and best practices.

• Training summary.

with these related Microsoft products and solutions.

Find answers to common questions and learn more about how we can support your business.