Sii Poland

SII UKRAINE

SII SWEDEN

  • Trainings
  • Career
Join us Contact us
Back

Sii Poland

SII UKRAINE

SII SWEDEN

Back

Become a Power BI Developer

Language Polish

  • The number of participants 8-15 people
  • Duration 4 days

Why take this course

If you want to advance your career in data analytics and become an expert in creating reports, this training will provide you with comprehensive knowledge of Power BI. You’ll gain the skills needed to prepare, model, and visualize data, which will allow you to independently create complex and professional business reports.

What you’ll learn

  • Prepare, model, and visualize the data needed to create a report.
  • Create visually rich reports that present information in a way that facilitates business decision-making.
  • Use good development practices, such as code formatting, naming conventions, and the classification of tables and columns.
  • Understand how relationships between tables work and the ability to create them.
  • Independently create complex reports using advanced DAX formulas.
  • Gain information about operations on tables imported into the model, as well as tables and columns created with DAX formulas.
  • Build a solid foundation for further self-development of the acquired knowledge.
  • Handle more complex datasets.

Who is this course for

This training is intended for both beginners who have not previously worked with Power BI data analysis, as well as for those who work as a developer/data analyst or are involved in creating reports and want to consolidate their knowledge.

Training schedule

Day 1

  • Introduction to Power BI
  • Data retrieval, transformation, and formatting
  • Merging, references, duplicates
  • Star schema and assigning functions to tables
  • Creating appropriate relationships
  • Context-based filtering
  • Themes, templates, backgrounds
  • Selecting visualizations for data types
  • Hierarchy, drilling, labels
  • Bookmarks and relationships between objects in the report

Day 2

  • Introduction to measures and the purpose of their use
  • Basic DAX expressions
  • Conditional functions such as If/Switch/True
  • Introduction to variables
  • Creating and using “What If” parameters
  • The most popular DAX expressions related to time
  • Time ranges, calendar periods, points in time
  • Introduction to bookmarks – filtering
  • Homework to be completed in the form of a Power BI report

Day 3

  • Discussion of reports independently completed by participants
  • Principles of human perception
  • Psychology knowledge helps create better reports
  • Storytelling concept
  • Small multiples, decomposition tree
  • Drilling/Tooltips/Labels
  • Bookmarks for organizing the page
  • Non-standard templates and backgrounds
  • Grouping, references, and duplicates
  • Creating custom columns
  • Merging and grouping queries

 

Day 4

  • Popular business problems solved with DAX
  • Measures as filters
  • Using virtual tables
  • Tables without relationships
  • Datasets – refreshing/scheduling
  • Creating applications in Power BI services
  • Row-level security – roles to be assigned
Interested in training?
Contact us to get more information

Contact our expert

Your file

Uploaded file:
  • file_icon Created with Sketch.

Acceptable files: doc, docx, pdf. (max 5MB)
Please submit your file in DOC, DOCX or PDF format
The upload size is limited to 5 MB
File is empty
File was not uploaded

At any time, you may withdraw your consent to the processing of personal data, but such withdrawal shall not affect the legal compliance of any processing of such data, which had occurred before you withdrew your consent. Detailed information on the processing of your personal data is specified in the Privacy Policy.

Anna

Public trainings coordinator

Your message was sent successfully

We will look over your message and get back to you as soon as possible

Sorry, something went wrong and your message was not delivered

Refresh the page and try again. Contact us, if problem occurs again

We’re sorry, but the selected file appears to be damaged and we can't process it.

Please try uploading a different copy or a new version of the file. Contact us, if problem occurs again.

Processing…

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved. AgilePM® is a registered trademark of Agile Business Consortium Limited. All AgilePM® Courses are offered by Sii, an Affiliate of Eraneos Iberia S.L.U., an Accredited Training Organization of The APM Group Ltd. Lean IT® Association is a registered trademark of the Lean IT Association LLC. All rights reserved. Sii is an Affiliate of Accredited Training Organization Eraneos Iberia S.L.U. SIAM™ is a registered trademark of EXIN Holding B.V. All prices presented on the website are net prices. 23% VAT should be added.

Get in touch Find training

Änderungen im Gange

Wir aktualisieren unsere deutsche Website. Wenn Sie die Sprache wechseln, wird Ihnen die vorherige Version angezeigt.

Einige Inhalte sind nicht in deutscher Sprache verfügbar.
Sie werden auf die deutsche Homepage weitergeleitet.

Möchten Sie fortsetzen?