Data Analysis Boot Camp Using Excel and Power BI
Transights

Data Analysis Boot Camp Using Excel and Power BI For Specialists

                                                                                                                      

Program Overview

Data analytics is a rapidly growing field with high job demand across a variety of industries. With the increasing reliance on data-driven decision-making, companies are seeking professionals who can analyze complex data sets and provide insights to improve business operations. 


Data-related jobs have seen a significant increase in demand over the years, and this trend is expected to continue in the coming years. According to the World Economic Forum, it is estimated that there will be a growth of 65% in data-related jobs by the year 2025.

        

What will you learn in this track? 

        

  • Understanding the DAX formula and storage engines. 
  • DAX Query Evaluation in depth. 
  • VertiPaq Columnar Data Structure. 
  • VertiPaq Relationalar ships. 
  • DAX Scalar Functions. 
  • Advanced CALCULATE. 
  • DAX Evaluation Order. 
  • Writing Clean DAX Code. 
  • Creating and Joining DAX Variables. 
  • Tables & Filters Functions. 
  • Relationships Functions. 
  • Calculated Tables Joins. 
  • Iterator functions. 
  • Advanced Time Intelligence. 
  • Performance Tuning.
Course Outline
Who Should Attend ?
Course Prerequisites
Learning Methodology
Course Duration
Course Outline

Program Agenda

The following proposed agenda is subject to changes by the client for the ultimate benefit of improving the training ROI of delegates and the client organization. The schedule duration can also be lengthened if the client wishes to enable delegates to achieve an even deeper understanding.

Sessions Outline:


Session 1:

    1. VertiPaq Engine introduction. 
    2. Columnar Data Structure. 
    3. Performance Benchmarks. 
    4. DAX Studio. 


Session 2:

    1. DAX Scalar Functions.
    2. DAX filter Functions. 
    3. DAX Advanced CALCULATE function modifiers. 
    4. DAX KEEPFILTER and REMOVEFILTER modifiers. 
    5. DAX Information Functions. 
    6. DAX Aggregation Functions. 
    7. DAX Conversion Functions. 
    8. DAX SWITCH function 
    9. DAX COALEASCE function. 

Session 3:

    1. Common Tables and Filter Functions. 
    2. Calculated Tables. 
    3. DAX DISTINCT 
    4. DAX VALUES. 
    5. DAX SELECTVALUE 
    6. DAX ALLEXCEPT 
    7. DAX ALLSELECTED 
    8. DAX SELECTCOLUMNS 
    9. DAX ADDCOLUMN 
    10. DAX SUMMARIZE 
    11. Data CORSSJOIN 
    12. DATA UNION 
    13. DATA INTERSECT 
    14. DATA EXCEPT. 
Who Should Attend ?

Who Should Attend?

The course is suitable for:

  • Business Analytics Specialists 
  • Business Intelligence Specialists. 
  • Corporate Strategists. 
  • Finance Specialists. 
  • Data Engineers.    
Course Prerequisites

Course Prerequisites

  • DAX advanced Skills. 
  • Power Query and Query Editor 
  • Excellent visualization skills.
Learning Methodology

Learning Methodology

The learning methodology is highly interactive, consisting of a balanced mix of short presentations,  the Course Director’s extensive experience in this specialized field, handouts containing key articles and topic support, dialogue about leading practice, delegates’ own ideas, experiences and Q&A, sharing of knowledge, discussions, feedback, scenarios, case studies, practical examples, individual and group exercises designed to assist the participants to gain a working knowledge of the topics taught and to embed the skills.

Course Duration

Course Duration: 

12 Hours

Session 4:

    1. Introduction to Relationships DAX Functions. 
    2. DAX RELATED function. 
    3. DAX RELATEDTABLE function. 
    4. DAX USERELATIONSSHIPS function. 
    5. DAX CROSSFILTER. 
    6. DAX TREATS function. 
    7. DAX CALENDAR and CALENDARAUTO functions. 
    8. Create a custom Fiscal Year Calendar. 
    9. Advanced Time Intelligence Functions.

Required Tools:

    1. Microsoft Excel 365 or at least Office 2016.
    2. DAX Studio Software.