Skip to main content

Virtual DAX Boot Camp May 10 @ 9:00 am - May 12 @ 5:00 pm EDT

Boot Camp Details

So you’ve been working with DAX in Power BI but either can’t quite complete the calculations needed or maybe you just want to expand your knowledge and utilize more capabilities of DAX to bring your reports to the next level – this is the course for you! In this in-depth DAX Bootcamp, all of your DAX knowledge will be enhanced to a point where you will have the tools to create any kind of calculation that is possible within the DAX language. You will also be learning about best practices, performance tuning, and much more!

Prerequisites

It is recommended that you have taken an Introduction to Power BI course first

System Requirements

  • Access to Power BI
  • Access to DAX Studio
  • Access to Vertipaq Analyzer (an Excel Power Pivot Workbook)

Course Outline:

  • Module 01 – Understanding and Defining Relationships
  • Module 02 – DAX Fundamentals
  • Module 03 – Creating Calculated Columns
  • Module 04 – Navigation Functions
  • Module 05 – Conditional and Logical Functions
  • Module 06 – Creating Calculated Measures
  • Module 07 – Understanding the Calculate Function
  • Module 08 – Built-in Time Intelligence
  • Module 09 – Interactive Functions
  • Module 10 – Table Functions
  • Module 11 – Working with Variables
  • Module 12 – Understanding Evaluation Context (Filter and Row Context)
  • Module 13 – Nested Row Context
  • Module 14 – Advanced Time Intelligence and Custom Calendars
  • Module 15 – Semi-Additive Measures
  • Module 16 – Error handling
  • Module 17 – Managing Dynamic Security with DAX
  • Module 18 – Dealing with Multiple Relationships Between Tables
  • Module 19 – Advanced Design Patterns with DAX
  • Module 20 – Performance Tuning
  • Module 21 – DAX as a Query Language 

 FEE : $1596 

Tickets : virtual-dax-bootcamp-may2021

Comments

Popular posts from this blog

SSRS INTERVIEW QUESTIONS

Q: What is SSRS? Ø   SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø   It is used for preparing and delivering interactive and variety of reports. Ø   It is administered through an web based interface. Ø   Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø   SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø   SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Failed to execute the package or element. Build errors were encountered

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package