【2022年】十大DAX課程熱門排行推薦與優惠精選!

 

本文章推薦「Advanced DAX for Microsoft Power BI Desktop」、「Excel Power Query, Power Pivot, Power Map & DAX Masterclass」、「Master DAX fundamentals : Power BI, Power Pivot & SSAS」等相關DAX線上課程,讓您滿足學習的慾望。

你是否想透過線上學習得到更多的技能,增加自己的技能樹?現在是學生的您,透過線上學習可以將更多專業知識用在課業學習上更加強所學。還是您是朝九晚五的上班族,尋找可以為工作上帶來更上一層樓的技能?或您是因為興趣或想培養其他興趣?

線上課程不受地理位置影響,不受時間早晚影響,老師來自世界各地,也不受學習程度影響的特色,讓您無時無刻想學都可以,想多看幾次增加熟悉度也可以。不同領域的老師將針對不同主題滿足您的學習目的,推薦的課程項目會陸續更新,絕對提供您最熱門人氣高的線上課程。

  • 線上課程老師來自於全球,文章推薦的熱門課程除了繁中課程以外還會有機會看到簡中和英文課程,可以針對自己喜好挑選。
  • 呈現的價錢會因為一些活動而有折扣,但折扣有可能一段時間後結束而調整回原價,最終價錢煩請到課程頁面進行確認。





DAX課程總覽

為了節省您的時間,本列表整理每個課程精要,讓您可以快速瀏覽這文章所提供的課程是否是您所需要的,點選您有興趣課程的「課程名稱」或「課程圖示」可以進一步跳到文章所屬課程的介紹區塊瞭解更多資訊。

課程名稱Microsoft Power BI DAX from ScratchAdvanced DAX for Microsoft Power BI DesktopExcel Power Query, Power Pivot, Power Map & DAX MasterclassDAX – Mastering DAX Foundations for Power BIMaster DAX fundamentals : Power BI, Power Pivot & SSASDAX Power Pivot – 10 Easy Steps for IntermediatesDAX Power Pivot Time Intelligence – 10 Easy StepsWriting DAX QueriesMastering DAX StudioThe DAX Workshop – Part 1
課程圖示
1

Microsoft Power BI DAX from Scratch

2

Advanced DAX for Microsoft Power BI Desktop

3

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

4

DAX - Mastering DAX Foundations for Power BI

5

Master DAX fundamentals : Power BI, Power Pivot & SSAS

6

DAX Power Pivot - 10 Easy Steps for Intermediates

7

DAX Power Pivot Time Intelligence - 10 Easy Steps

8

Writing DAX Queries

9

Mastering DAX Studio

10

The DAX Workshop - Part 1

課程原價NT$ 2,990NT$ 2,990NT$ 2,990NT$ 590NT$ 2,990NT$ 2,990NT$ 2,990NT$ 790NT$ 790NT$ 790
課程售價NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 430NT$ 390NT$ 390NT$ 390NT$ 390
課程評價(人數)4.3 分(415 個評分)4.6 分(2,364 個評分)4.4 分(1,447 個評分)4.5 分(229 個評分)4.5 分(832 個評分)4.6 分(558 個評分)4.8 分(226 個評分)4.6 分(147 個評分)4.2 分(145 個評分)4.7 分(148 個評分)
課程時長3 小時11.5 小時7 小時4 小時3 小時7.5 小時6 小時3.5 小時2 小時5 小時
學生人數38,806 人13,813 人7,881 人4,250 人4,070 人2,745 人1,758 人1,010 人778 人702 人
課程特色Hands-on guide to Microsoft Power BI DAXMaster the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructorLearn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019Demystifying DAX for Advanced Power BI ReportingThe Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis ServicesBuild Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next levelSupport the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.DAX is much more than a language for writing measures. It’s also a powerful and full-featured query languageDAX Studio is the productivity tool every DAX, Power BI and Power Pivot developer should be usingLearn DAX by working through real-world business scenarios via 45 exercises and tutorials
連結UdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemy



DAX課程介紹

推薦的課程以倒序的方式呈現,越往下查看會看到越熱門的,期望您能找到滿意的學習主題!

10

The DAX Workshop – Part 1

Learn DAX by working through real-world business scenarios via 45 exercises and tutorials
NT$ 790
NT$ 390

點擊看Udemy

課程老師Randy Minder
課程評價4.7 分(148 個評分)
課程時長5 小時
學生人數702 人

課程介紹

The DAX Workshop is a course that allows the student to get proficient in the DAX language by practicing on all sorts of common business scenarios. Approximately 45 practice exercises, and a half-dozen tutorials, exist covering most of the important

瞭解更多細節

哪些人適合這堂課?

  • All levels of Power BI and Excel Power Pivot users

學習目標

  • This is a hands on course. You will learn how to work through many common business related problems and scenarios
  • The importance of understanding the current filter context and how it affects your measures is stressed in each exercise
  • By working through many exercises you will understand the CALCULATE function and how understanding “context transition” is essential
  • You will learn how to build “primitive” time intelligence functions and then build higher level time functions on top of them to solve common reporting requirements
  • You will be working with real-world data models based on Contoso, AdventureWorks and a baseball model containing 145 years of data

關注這課程的人也購買了這些…

9

Mastering DAX Studio

DAX Studio is the productivity tool every DAX, Power BI and Power Pivot developer should be using
NT$ 790
NT$ 390

點擊看Udemy

課程老師Randy Minder
課程評價4.2 分(145 個評分)
課程時長2 小時
學生人數778 人

課程介紹

If you are a DAX developer, DAX Studio is a must have tool. This course allows you to get the most of DAX Studio. You’ll learn how to execute queries, export data to CSV and SQL Studio, troubleshoot queries, capture all queries coming from Power BI,

瞭解更多細節

哪些人適合這堂課?

  • DAX developers, of every level, working in the Power BI or Excel Power Pivot space

學習目標

  • How to write queries and export results (or complete tables) to CSV or SQL Server
  • How to use dynamic management views to better understand your data model
  • How to capture all queries generated by your Power BI report and review and execute them in DAX Studio
  • Performance monitoring
  • How to consistently format your DAX code

關注這課程的人也購買了這些…



8

Writing DAX Queries

DAX is much more than a language for writing measures. It’s also a powerful and full-featured query language
NT$ 790
NT$ 390

點擊看Udemy

課程老師Randy Minder
課程評價4.6 分(147 個評分)
課程時長3.5 小時
學生人數1,010 人

課程介紹

As a DAX developer you’ve probably written many measures, expressions and code for calculated columns. But, DAX is also a full featured and powerful query language for retrieving data in a table format, much like SQL. There is much more to being a pr

瞭解更多細節

哪些人適合這堂課?

  • DAX developers

學習目標

  • The difference between a DAX measure and a full DAX query
  • The tools available to write full DAX queries
  • How to construct a DAX query
  • The importance of data lineage and the TREATAS function
  • How to write common T-SQL queries as DAX queries
  • The most common and useful DAX table functions when writing DAX queries
  • How to export the results of your DAX queries to CSV and SQL Server
  • 15 questions and exercises to test your knowledge

關注這課程的人也購買了這些…

7

DAX Power Pivot Time Intelligence – 10 Easy Steps

Support the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Gilly Dow
課程評價4.8 分(226 個評分)
課程時長6 小時
學生人數1,758 人

課程介紹

This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners.

You have already gotten your hands dirty with DAX & Power Pivot and seen how awesome it is. Now you are ready to take your s

瞭解更多細節

哪些人適合這堂課?

  • Anyone who wants to learn DAX Time Intelligence functions with standard or custom calendars
  • All DAX Power Pivot – 10 Easy Steps for Beginners students who want to take their learning to the next level

學習目標

  • Support the needs of Business Intelligence using Time Period Functions in DAX
  • Create running-totals with DATESYTD(), DATESQTD() & DATESMTD()
  • Learn how to use PREVIOUSYEAR() and related DAX functions including PREVIOUSQUARTER(), PREVIOUSMONTH() & PREVIOUSDAY()
  • Customise DAX ready Time Intelligence functions with DATEADD()
  • Learn how to create base measures including FIRSTDATE(), LASTDATE(), ENDOFMONTH() & STARTOFYEAR()
  • Learn how to use CLOSINGBALANCE() family of DAX functions
  • Understand the benefits of FILTER() to super-charge measures in place of CALCULATE()’s “simple” filters
  • Create a 4-4-5 Custom Calendar in Excel and relate to the existing Data Model
  • Learn how to recreate DAX in-built Time Intelligence functions for custom calendars
  • Use DAX Patterns to master navigating the custom calendar
  • Learn how to over-ride the incoming filter context with the ALL() function
  • Suppress totals and subtotals with HASONEVALUE()
  • Create % growth calculations and generate reports to impress

關注這課程的人也購買了這些…



6

DAX Power Pivot – 10 Easy Steps for Intermediates

Build Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next level
NT$ 2,990
NT$ 430

點擊看Udemy

課程老師Gilly Dow
課程評價4.6 分(558 個評分)
課程時長7.5 小時
學生人數2,745 人

課程介紹

This course builds upon the skills learned in the first course in this series DAX Power Pivot – 10 Easy Steps for Beginners.

You have already gotten your hands dirty with Power Pivot and seen how awesome it is. Now you are ready to take your skills

瞭解更多細節

哪些人適合這堂課?

  • I have designed this course for those students who want to take the next step in their DAX Power Pivot journey
  • You will know how to create Measures and have an understanding of building Data Model Relationships
  • Your understanding of CALCULATE(), FILTER() & ALL() will lend itself well to your continuing education in this next step

學習目標

  • You will learn how to create a Data Model using Get & Transform in Excel
  • Learn how to use “Disconnected” tables (Parameter tables) to maximise Insights
  • Expand your understanding of the basic DAX Aggregator and Iterator Functions
  • Understand the Initial Filter Context, Filter Context and Context Transition
  • Gain confidence building measures with multiple functions – advancing your DAX tool-kit
  • Learn how to catalogue your data model functions in Excel

關注這課程的人也購買了這些…

5

Master DAX fundamentals : Power BI, Power Pivot & SSAS

The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Paula Guilfoyle CPA & MVP
課程評價4.5 分(832 個評分)
課程時長3 小時
學生人數4,070 人

課程介紹

Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpr

瞭解更多細節

哪些人適合這堂課?

  • Analysis Services Users
  • Power BI Users
  • Excels Power Pivot Users
  • Those that need to model data using SSAS, Power BI or Power Pivot
  • Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
  • This course is NOT for you if you are already comfortable working with basic and intermediate level DAX

學習目標

  • Explain and use Calculated Columns and Measures
  • Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
  • Explain and use table functions such as Filter and RelatedTable
  • Explain and use iteration pairs such as SUMX and COUNTX
  • Set up Variables
  • Work with IF statements and DAX SWITCH function
  • Describe the fundamentals of how DAX works
  • Explain Row context and nested Row context
  • Explain Filter context
  • Use the ALL function to remove filters
  • Use the Calculate function to modify and replace basic filters
  • Explain and demonstrate how Relationships and DAX work together
  • Discuss the need for a DATE table
  • Use DAX to create a DATE table using CalendarAuto and other DAX functions
  • Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more
  • Calculate Moving totals and Rolling Totals
  • Carry out Basic to Intermediate level DAX analysis

關注這課程的人也購買了這些…



4

DAX – Mastering DAX Foundations for Power BI

Demystifying DAX for Advanced Power BI Reporting
NT$ 590
NT$ 390

點擊看Udemy

課程老師Ahmed Oyelowo
課程評價4.5 分(229 個評分)
課程時長4 小時
學生人數4,250 人

課程介紹

Background

DAX is the formula language of Power BI, Excel Power Pivot and SSAS Tabular. The formula language simply unlocks advanced capabilities for reporting in Power BI.

However, DAX is not an easy language to learn. Mastering it requires a p

瞭解更多細節

哪些人適合這堂課?

  • Beginner to Intermediate Power BI users.

學習目標

  • Understand how the DAX engine works
  • Understand Calculated Tables, Columns, Measures and when to use what
  • Simplified understanding of DAX Evaluation Context, Row, Filter and Context Transition
  • Understand the most used DAX functions
  • Write Time Intelligence formulas
  • Understand when to use Iterator functions

關注這課程的人也購買了這些…

3

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Andreas Exadaktylos
課程評價4.4 分(1,447 個評分)
課程時長7 小時
學生人數7,881 人

課程介紹

COMPLETELY REDONE ON FEB 2021 WITH NEW VIDEOS!

Learn Power Query, Power Pivot, DAX, Power View, Power Map (3D Maps) and Power BI Desktop Business Intelligence Tools that are rarely found on Excel users, and transform to an Excel Star!

These days

瞭解更多細節

哪些人適合這堂課?

  • Everyone who wants to master Excel Dashboards
  • Business analysts
  • Data analysts
  • Students
  • Entrepreneurs

學習目標

  • Learn in depth Power Query, PowerPivot, Power View and Power Map tools
  • Create business intelligence reports and dashboards
  • Quickly turn mass quantities of data into meaningful information using Excel PowerPivot add-in
  • Make amazing interactive sales maps using Excel Power View powerful add-in
  • Analyze huge amounts of data fast and accurate
  • Improve general Excel knowledge
  • Follow along with included Excel project files
  • Learn the most current version of Microsoft Excel (Excel 2019 & Office 365)
  • Course updated regularly
  • Learn from an instructor with over 16 years of experience, teaching thousands of students in his own computer learning school
  • An instructor ready to answer your questions in less than 24 hours
  • Watch high-quality video lectures with lifetime access
  • Certificate of completion

關注這課程的人也購買了這些…



2

Advanced DAX for Microsoft Power BI Desktop

Master the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructor
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Maven Analytics
課程評價4.6 分(2,364 個評分)
課程時長11.5 小時
學生人數13,813 人

課程介紹

Hear why our Power BI courses are the TOP-RATED on Udemy:

“I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at t

瞭解更多細節

哪些人適合這堂課?

  • Aspiring data professionals looking to master the #1 business intelligence tool on the market
  • Analytics or BI professionals looking to build expert-level DAX + Power BI skills
  • Power BI users tasked with solving unique and complex analytics use cases
  • Students looking for a comprehensive, engaging, and highly interactive approach to training

學習目標

  • Master Data Analysis Expressions (DAX) for Power BI Desktop
  • Analyze real-world projects & business intelligence use cases
  • Learn the same tools used by top analytics & business intelligence professionals
  • Test your skills with hands-on demos & assignments (with step-by-step solutions)

關注這課程的人也購買了這些…

1

Microsoft Power BI DAX from Scratch

Hands-on guide to Microsoft Power BI DAX
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Learnsector LLP
課程評價4.3 分(415 個評分)
課程時長3 小時
學生人數38,806 人

課程介紹

If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights.

DAX or Data Analysis Expression is a library of functions a

瞭解更多細節

哪些人適合這堂課?

  • Anyone dealing with report creation and providing data insights.

學習目標

  • A beginner to intermediate guide on how to create DAX formula
  • Understand the concept of calculated column, measures, and tables in DAX
  • How to solve the problem statement using various DAX function

關注這課程的人也購買了這些…



DAX課程總覽

看完了一連串課程的介紹後,你是否還想要再一次進行課程總比較呢?

課程名稱Microsoft Power BI DAX from ScratchAdvanced DAX for Microsoft Power BI DesktopExcel Power Query, Power Pivot, Power Map & DAX MasterclassDAX – Mastering DAX Foundations for Power BIMaster DAX fundamentals : Power BI, Power Pivot & SSASDAX Power Pivot – 10 Easy Steps for IntermediatesDAX Power Pivot Time Intelligence – 10 Easy StepsWriting DAX QueriesMastering DAX StudioThe DAX Workshop – Part 1
課程圖示
1

Microsoft Power BI DAX from Scratch

2

Advanced DAX for Microsoft Power BI Desktop

3

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

4

DAX - Mastering DAX Foundations for Power BI

5

Master DAX fundamentals : Power BI, Power Pivot & SSAS

6

DAX Power Pivot - 10 Easy Steps for Intermediates

7

DAX Power Pivot Time Intelligence - 10 Easy Steps

8

Writing DAX Queries

9

Mastering DAX Studio

10

The DAX Workshop - Part 1

課程原價NT$ 2,990NT$ 2,990NT$ 2,990NT$ 590NT$ 2,990NT$ 2,990NT$ 2,990NT$ 790NT$ 790NT$ 790
課程售價NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 430NT$ 390NT$ 390NT$ 390NT$ 390
課程評價(人數)4.3 分(415 個評分)4.6 分(2,364 個評分)4.4 分(1,447 個評分)4.5 分(229 個評分)4.5 分(832 個評分)4.6 分(558 個評分)4.8 分(226 個評分)4.6 分(147 個評分)4.2 分(145 個評分)4.7 分(148 個評分)
課程時長3 小時11.5 小時7 小時4 小時3 小時7.5 小時6 小時3.5 小時2 小時5 小時
學生人數38,806 人13,813 人7,881 人4,250 人4,070 人2,745 人1,758 人1,010 人778 人702 人
課程特色Hands-on guide to Microsoft Power BI DAXMaster the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructorLearn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019Demystifying DAX for Advanced Power BI ReportingThe Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis ServicesBuild Power Pivot Data Models with Excel 2016 Power Query – take your DAX Business Intelligence to the next levelSupport the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.DAX is much more than a language for writing measures. It’s also a powerful and full-featured query languageDAX Studio is the productivity tool every DAX, Power BI and Power Pivot developer should be usingLearn DAX by working through real-world business scenarios via 45 exercises and tutorials
連結UdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemy



從老師查找更多課程

以上推薦的課程還沒挑到自己有興趣的嗎?
還是您有熱衷某個老師開的課程呢?
本頁除了提供DAX的課程以外,也列出這些課程所屬的老師的主要資訊頁,您可以從下列選單中了解更多相關介紹或看他們開的其他課程,期望您最終能找到自己想學習的項目。



【2022年】十大DAX課程熱門排行推薦與優惠精選!

參考其他商業分析與智慧線上課程

除了本文介紹的課程種類以外,想要瞭解商業分析與智慧領域還有哪些不同類型的課程值得一探究竟嗎?讓您可以從不同面向更紮實的學習,點擊參考以下其他熱門主題文章。絕對提供您最優惠人氣滿檔的課程,歡迎繼續延伸閱讀。


發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *