Course Database Analyst II.
The Database Analyst II course is intended for Power BI and Power Pivot users in Excel. DAX functions are also part of t...
The Database Analyst II course is intended for Power BI and Power Pivot users in Excel. DAX functions are also part of the course. It is also focused on expanding knowledge in working with databases in SQL. The package consists of the Power BI - 2 and SQL SERVER Working with a Database II courses. Only the start of the course is listed in the date; we will inform you about further dates.
Minimum input knowledge
SQL knowledge at the level of the SQL SERVER Working with a Database course. Knowledge at the level of Power BI - 1.
Course dates Database Analyst II.
Daily courses (4 days): 09:00 - 15:00
Course price: 648.78 / 798.00 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for ZoZ employed applicants.
If you are interested in attending the course free of charge, you can find more information at the following link:
Training syllabus Database Analyst II.
Power BI -2
Calculations in the Data Model
- new column in a table
- calculated field summary calculations for the whole table
- measures
Functions Using Relationships Between Tables
- Related
- RelatedTable
Group of X Functions
Measures, Calculation Context, Filters and Anti-Filters in the DAX Language
Calculate Function
Active and Inactive Relationships in the Data Model and Their Impact on Calculations
Cross Filters
Time Intelligence Functions, Date Table
Functions Whose Result Is a Table
SQL SERVER Working with a Database II
- Quick refresh of knowledge from the Working with a Database course
- Nested functions and SELECTS
- Working with text (LTRIM, RTRIM, UPPER, LOWER, LEN)
- Data cleaning (LEFT, RIGHT, SUBSTRING, REPLACE, CONCAT, CHARINDEX, REPLICATE, STUFF)
- Conversion between individual data formats (CONVERT, CAST, TRY_CAST, TRY_CONVERT)
- Joining tables (UNION, UNION ALL, INTERSECT, EXCEPT, SELF JOIN)
- Temporary tables (Common Table Expression, TEMP Table)
- Searching data using Window Functions (Aggregate Function, Ranking Function, Value Function)
- Query Tuning. And much more...
Output knowledge
After completing the course, you will be able to work with data at the level of a data analyst in the SQL Server environment. You will also master working with data in the Power BI environment at an advanced level
Recommended courses after completing Database Analyst II.
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Database Analyst II.
This course has no published reviews yet.
You can add a review after completing the course.