DAX - Data Analytics Expressions

GENERAL CONTENT TUITION FEE TRAINERS PHOTOS

Overview

DAX - Data Analytics Expressions is the main language that can be used with Power BI Desktop, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. Also, DAX is known as the native language of Power BI, Power Pivot in Excel and Tabular Models created in Microsoft SQL Server Analysis Services.

Moreover, if you are coping with some business problems, DAX will be your best priority. Indeed, DAX helps simplify many complex multidimensionally mathematical problems, especially in Data Analytics (Analyzing the growth percentage among product types for different day ranges or calculating the annual growth rate compared with the market trends...)

The DAX training course at BAC will help the learners become proficient in the DAX language. By that, it will be much easier for analysts to figure out the related data that is helpful for decision-making strategies for the time being and in the future as well. Besides, learners can also solve complex business problems, thanks to their mastering common calculation formulas.

Who are entirely suitable for the training course?

The course is made for learners who are using Power BI, Power Pivot for Excel and Analysis Services and want to learn and master DAX language. The course is suitable for many students:

Data professionals who are desperate to find a way to master the best BI tools on the market.
Analysts or BI analysts who want to build an expert level of DAX and Power BI skills.
Power BI users who are tasked with solving unique and complex analytics use cases.
Students who are looking for an overall, engaging, and interactive training method
Students who are passionate about Microsoft products.
Admin Executive, Administrator, Marketer: Know how to use MS Excel, Power BI to use and design reports

Why should I take the course?

What is the goal of the course?

To convey all the features of the DAX, the concept of the DAX.
To provide the knowledge of writing formulas to solve the problems and make reports for specific business scenarios.
To provide skills of writing common and advanced formulas for business situations.

Why take part in the course "DAX - Data Analytics Expressions" at BAC?

The DAX training course at BAC will help students become proficient in DAX language. By that, it will be much easier for analysts to figure out the related data that is helpful for decision-making strategies for the time being and in the future as well. Besides, learners can also solve complex business problems, thanks to their mastering common calculation formulas.

Standing out from places where concentrate on function training only, the DAX course at BAC is designed mainly focused on important formulas to serve the purpose of creating reports in each specific industry such as:

Insurance
Banking
Telecommunications
Human resource
Hospitality
Commodity
Education
Real estate

After the course, you will be able to become more proficient in solving complex multidimensional problems. Your DAX skills will become much more flexible in data decomposition, optimizing system performance. You will know whether to use DAX for Measure or Calculated (How to calculate the productivity when creating DAX function). Taking the course is a great advantage for you, especially for those of you who have mastered Excel formulas, this stands a good chance of acquiring DAX more easily.

What should you get after the course?

Understand DAX formulas and know how to apply them to your reports.
Apply useful tips for error handling and DAX variables usage.
Explore popular scalar DAX functions emcompassing round functions, transfer functions, logical functions.
Create calculated columns, tables and measures, review popular DAX filter functions, create new data, etc.
Understand relationships of datasheets and know how to manipulate those relationships in DAX functions.
Build date tables with DAX, compare custom time periods, manage financial calendars, etc.
Be introduced to DAX Studio, Power BI performance analyzer, and popular DAX optimization techniques.

How are courses designed?

The DAX course by BAC, together with top-rated specialists, is made for not only beginners but also advanced learners.

For the learners who want to take their Power BI skills to the advanced level, mastering Data Analytics Expressions (DAX) is a MUST.

In this project-based, hands-on course, you will have a chance to experience your DAX skills and apply what you learn to some of the difficult real-world examples of business intelligence.

Main Data Analytics Expressions (DAX) for Power BI Desktop
Analyze the real-world projects and business information use cases
Learn the tools used by top Bas
Test your skills with your work and exercises (Step-by-step solutions)

Prerequisites:

You need to download Microsoft Power BI Desktop (Download for free)
This course is designed for PC users only (Currently not available for Mac)
Experience with DAX and Power BI is strongly recommended
You should attend our training course “Installing and running with Power BI Desktop” prior to taking this course.

Class Information

Place: 6th Floor, Thien Phuoc 01 Building, 244 Cong Quynh Street, Pham Ngu Lao, District 1, HCM.
Teaching Language: Vietnamese
Materials: English
Issued Materials: Hard-copy (NO Softcopy), BAC/IIBA Practical Templates

Student Requirements

Join course at right place, on time and right schedule.
Comply with class rules.
Spirit of cooperation, working in group with members of the class and trainers.

Contact detail

Điện thoại tư vấn If you have any question, please feel free to contact us via:
Phone: (84) 909 310 768 | (84) 903 746 294
Email: info@bacs.vn | bac.trainingba@gmail.com

COURSE CONTENT:

Session 1:

Introduction to DAX
Basic introduction to tables and filters and tables functions
Understanding the evaluation contexts in DAX

Session 2 - Session 3 – Session 4:

Useful functions for common reports and how to create them in any specific industry:

Reports by:

last n days
last n weeks
last n months
last n years

Convert statistics by currency. Report current figures:

Annually
Quarterly
Monthly
Weekly
Daily

Report the prior-year figures & compare with the current year by:

Year
Quarter
Month
Week
Date

Running total by:

Year
Quarter
Month
Week
Date

Rolling/Training (12 months)

In each course, BAC will choose a specific day to focus on one of the following industry depending on a group of students

Insurance industry
Banking industry
Telecommunications industry
Hospitality industry
Education industry
Real estate industry

Session 5 - Session 6:

Other queries
Exercises

FULL TUITION FEE: 5,900,000 VND

The tuition fee includes materials and certification.
Materials are included notebook or/and pen.
Tuition fee IS EXEMPT from value added tax (VAT).

DISCOUNT POLICY

10% discount on tuition fee if the students register for the course and payment is received ten days in advance.

PAYMENT

Students can choose 1 of the following payment methods:

Payment in cash

BAC TRAINING AND CONSULTANCY JOINT STOCK COMPANY

Headquarter: 6th Floor, 244 Cong Quynh Street, Pham Ngu Lao Ward, District 1, HCMC.
Branch: 11th Floor, 39B Truong Son Street, Ward 4, Tan Binh District, HCMC.
Email: info@bacs.vn or bac.trainingba@gmail.com
Hotline: (84) 909 310 768 | (84) 903 746 294

Payment by cards

BAC accepts new payment method: Convenient payment using mPOS device:

Payment by swiping ATM and international cards directly at the BAC office.
Payment by Internet Banking / Mobile Banking / Electronic Wallet (E-Wallet) / QR-code.
Easy payments from anywhere with the payment link.
Payment by credit card, installment with 0% interest.

Fee: card fees MUST BE PAID by the customer when paying by card. The consultant will estimate the card fee according to the fee schedule given by mPOS and provide a concrete estimate for the student to consider before paying. For additional details on how to incorporate the mPOS payment solution, please visit this link.

Payment by Transfer

Account 1: Tien Phong Bank
- Account number: 01236879001
- Account name: CTY CO PHAN DAO TAO VA TU VAN BAC
- Tân Bình Branch

NOTES:

Students shall complete the payment in advance, and not later than the opening session. BAC does not accept any payment after the opening day.
Exceptions: In cases of faulty payment process or students have committed to pay tuition fee after the opening day, BAC will accept as exceptions.

OTHER PROVISIONS

Reserve registered courses

After register and pay the tuition fee for the course, if students can not join the course, they should have an official notification to BAC before the opening session. In this case, students will be reserved tuition and join the next course or switch to another BAC course in suitable requirements.

Opening Schedule Changes

In case of course could not start on schedule, BAC will send an email to inform the student of the expected opening day.
If the new opening schedule is suitable for students' needs, BAC will reserve tuition fee. Students will continue to participate in the course.
If the new opening schedule does not meet students' needs, BAC will refund the tuition fee.

Refund Policy

Tuition fees ARE NOT REFUNDED.
In case of our student cannot join the new class schedule due to a change from BAC in terms of changing the course opening schedule, that student will be refunded the tuition by BAC according to the following process:
- Students can receive a refund by transfer or in cash.
- After the two sides have officially confirmed the cancellation of the course, the entire tuition will be refunded to students by BAC within a maximum of 3 working days.
- Students must return the receipt of tuition to BAC to complete the refund procedure.

Any information or support related to payment - PLEASE CONTACT US VIA:

Hotline: 0903 746 294 or Email: phungtran@bacs.vn.

To Ngoc Van

Ms. To Ngoc Van graduated in Computer Science at Hong Bang University (October 2002). With more than 10 years of experience on ETL, Warehouse, BI; 10 years of experience on database as Analyst and Designer, DBA, T-SQL/PL/SQL developer (SQL Server and Oracle, MySQL). Beside that, she also has experience on programming, analysis and design database.

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Class Assignment

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Group Discussion

Hình ảnh khóa học Phân tích nghiệp vụ của BAC

Nguyen Thi Mai Binh

Business Analyst

For an outsider like me, the topics on "techniques" of BA are very important. Examples include using diagrams to model the requirement, write User Story / Use case, etc.

At the course of Fundamental Business Analysis, I met Mr. Loc, a very enthusiastic and caring person. In addition to sharing practical experiences in class, he also takes the time to advise, support, and comment on my CV. Besides, the Center and Phung also support sending CVs, connecting students to the network of quality partner companies, which helps students like themselves find the most suitable job. Thanks, BAC.
View detail +
Pham Que

Business Analyst

The BAC Product Design course has provided me with a lot of useful knowledge and background. The lecturers are very enthusiastic, infusing us with a flame of passion and enthusiasm in the industry. At the same time, share the necessary knowledge and skills in lectures in a more understandable way. The number of students is not too much, so the quality of teaching is excellent. Instructors correct the exercises 1-1, so the lesson will be more in-depth.
View detail +
Nguyen Van Long

Specialist in accounting mode & Professional solution of Finance and Accounting in IT application - Vietnam Electricity (EVN)

I participated in Fundamental Business Analysis at BAC. At this place, the training material provides a lot of useful content and is easy to understand. The lecturers are very enthusiastic additionally the content of the curriculum, they also share many practical experiences, questions of the students are answered right in the classroom, and with illustrations from real projects. After all, Thanks to BAC and Teacher Thai Son.
View detail +