Sii Poland

SII UKRAINE

SII SWEDEN

  • Trainings
  • Career
Join us Contact us
Back

Sii Poland

SII UKRAINE

SII SWEDEN

Back

Become a Data Analyst

Language Polish

  • Level Foundation
  • The number of participants 3-8 people
  • Duration 4 days

Who is this training for

If you want to gain solid, concrete, and essential tool-based knowledge needed to start working as a Data Analyst and successfully pass the recruitment process, this training is for you.

You will learn popular analytical tools such as Power BI and Management Studio, and master the DAX language and basic SQL formulas. After the training, you will be able to independently prepare reports presenting key business information.

What you will learn

  • Prepare professional reports presenting business information.
  • Acquire and transform data using Power Query.
  • Create a data model and relationships between tables (star schema, facts, and dimensions).
  • Apply various types of visualizations, including filters, slicers, and conditional formatting.
  • Use bookmarks for multi-dimensional analysis and changing data context.
  • Implement the DAX language to create calculations, calculated columns, and calculated tables.
  • Introduce variables and create complex DAX measures for dynamic filtering.
  • Utilize Power BI Services to create dashboards, and for data distribution and refresh.
  • Understand the SSMS structure and create basic SQL queries, including joining tables (Join, Union) and creating Views.

Who should attend

This training is designed for people involved in data analysis, report creation, and for those who wish to start a career as a Data Analyst.

 

Certificate and Exam

  • Upon completion of the training, you will receive a certificate confirming your competencies.
  • There is no final exam—active participation in the classes is sufficient.

Training Scope

1. Introduction to Data Analysis and Power BI

  • Power BI Desktop and Power BI Service (online).
  • Key elements and structure of the Power BI desktop as a reporting tool.
  • Relationships between tables – star schema / facts and dimensions.

2. Power Query

  • Key functions and operations in Power Query.
  • Acquiring and transforming data.
  • Formatting, creating, and connecting to sources.
  • Creating a data model.
  • Grouping, referencing, and duplicates.

3. Data Visualization

  • Types of visualizations and their application based on data type (Standard and Custom).
  • Filters and slicers.
  • Formatting visualizations.
  • Conditional formatting.
  • Multi-dimensional Data Analysis
  • Interactions between visualizations.
  • Using bookmarks to change data context and visualization changes.

4. DAX Language – Basics

  • Creating calculations for visualizations.
  • Calculated tables and columns.
  • The most popular DAX expressions.

5. Power BI Services

  • Basic functions and structure.
  • Creating a dashboard.
  • Basic operations: editing, distribution, data refresh.

6. DAX for Tables and Columns

  • The most popular table operations in DAX.
  • Creating calculated columns – operations on text and numerical columns.
  • Ranking and sorting data.
  • Creating summary tables and tables in the form of filters.

7. Complex Cases of the DAX Language in Measures

  • Introducing variables.
  • Measures as dynamic filters for visualizations.
  • Ranking and sorting using measures.
  • Active and inactive relationships triggered by a measure.
  • Different time dimensions on one page.

8. Introduction to SSMS Structure and Functionality

  • Basic navigation and functions.
  • Types of tasks that can be performed.
  • Connecting to a data source and creating queries.

9. Creating SQL Queries – Basics

  • Filtering/searching data.
  • Joining tables (Join, Union).
  • Creating “Views” – virtual tables.

Have questions about this training?

Anna Karauda Sales and Delivery Operations Specialist
Contact me
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 Karauda

Sales and Delivery Operations Specialist

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?