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.
