【2024年】十大Power Pivot課程熱門排行推薦與優惠精選!

 

【2024年】十大Power Pivot課程熱門排行推薦與優惠精選!

本文章推薦「Microsoft Excel: Business Intelligence w/ Power Query & DAX」、「DAX Power Pivot – 10 Easy Steps for Beginners」、「Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)」等相關LinkedIn線上課程,讓您滿足學習的慾望。
你是否想透過線上學習得到更多的技能,增加自己的技能樹?現在是學生的您,透過線上學習可以將更多專業知識用在課業學習上更加強所學。還是您是朝九晚五的上班族,尋找可以為工作上帶來更上一層樓的技能?或您是因為興趣或想培養其他興趣?
線上課程不受地理位置影響,不受時間早晚影響,老師來自世界各地,也不受學習程度影響的特色,讓您無時無刻想學都可以,想多看幾次增加熟悉度也可以。不同領域的老師將針對不同主題滿足您的學習目的,推薦的課程項目會陸續更新,絕對提供您最熱門人氣高的線上課程。

廣告 – 往下繼續閱讀本文


目錄

  1. Power Pivot課程總覽
  2. Power Pivot課程介紹
  1. Microsoft Excel: Business Intelligence w/ Power Query & DAX
  2. DAX Power Pivot – 10 Easy Steps for Beginners
  3. Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)
  4. Complete Introduction to Excel Power Pivot
  5. DAX Power Pivot Time Intelligence – 10 Easy Steps
  6. Excel 2013 PowerPivot & Advanced Business Intelligence Tools
  7. DAX Power Pivot 10 Easy Steps for Advanced Users
  8. Power Pivot Workshop Complete Bundle
  9. DAX Dashboard Design – 10 Easy Steps
  10. The Power Pivot, Power Query in Excel and Power BI Bundle
廣告 – 往下繼續閱讀本文


Power Pivot課程總覽

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

}

課程資訊
1
2
3
4
5
6
7
8
9
10
評價 4.7 分
(14,528 個評分)
4.7 分
(918 個評分)
4.5 分
(422 個評分)
4.5 分
(560 個評分)
4.8 分
(233 個評分)
4.1 分
(159 個評分)
5.0 分
(168 個評分)
4.5 分
(186 個評分)
4.5 分
(103 個評分)
4.6 分
(89 個評分)
學生 68,562 人人 3,660 人人 2,884 人人 2,191 人人 1,802 人人 1,657 人人 1,125 人人 1,031 人人 866 人人 586 人人
課程描述Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)Learn how to build DAX functions in PowerPivot with Excel 2016. Reinforce and embed with practice exercises/solutionsVisualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool.Concise, yet effective course on Excel DAX, Data Models & Relationships and working with enormous data volumesSupport the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.Enter the very hot world of BI, Power Pivot, DAX, and big data. This investment of your time is a no brainer.Learn advanced Data Modeling techniques, Variables and Budget PatternsLearn to master Power Pivot for Excel and DAX. This bundle includes three courses: Beginner, Intermediate, and Advanced.How to Create Interactive Business Intelligence Dashboard Reports with DAX Power PivotLearn how to analyze millions of rows of data in Excel and Power BI in this two-course bundle

廣告 – 往下繼續閱讀本文


Power Pivot課程列表

您可以從下面資訊進一步瞭解Power Pivot課程的價錢與最優惠的折扣、Power Pivot課程的特色以及Power Pivot課程介紹,發掘其他人同樣有興趣的產品還有哪些,期望您能找到滿意的!
1

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)

點擊前往 Udemy

課程老師Maven Analytics
課程評價4.7 分(14,528 個評分)
學生人數68,562 人

課程介紹

Hear why this is one of the TOP-RATED Excel courses on Udemy, and the #1 Excel Power Query + Excel Power Pivot course:

“I am a self-taught Excel Power Query user and it took me a while to understand what each tool does and how it interacts with othe

[更多細節]

哪些人適合這堂課?

  • Excel users who want to learn advanced data modeling & business intelligence tools
  • Students looking for a comprehensive, engaging, and highly interactive approach to Excel training
  • Anyone looking to become an Excel POWER USER and supercharge their analytics skillset
  • Students looking to pursue a career in data analysis or business intelligence

學習目標

  • Get up & running with Excel’s game changing data modeling & business intelligence tools
  • Learn how to use Power Query, Power Pivot & DAX to absolutely revolutionize your workflow in Excel
  • Master unique tips, tools and case studies that you won’t find in ANY other course, guaranteed
  • Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor
  • Get LIFETIME access to project files, quizzes and homework exercises, and 1-on-1 expert support
  • Build pro-quality business intelligence solutions to blend and analyze data from multiple sources




廣告 – 往下繼續閱讀本文


2

DAX Power Pivot – 10 Easy Steps for Beginners

Learn how to build DAX functions in PowerPivot with Excel 2016. Reinforce and embed with practice exercises/solutions

點擊前往 Udemy

課程老師Gilly Dow
課程評價4.7 分(918 個評分)
學生人數3,660 人

課程介紹

If your goal is to enter the world of BI, Data Mining and or Data Analysis you have to take this course. All of these environments and roles demand the skills you are about to learn

Microsoft PowerPivot is an add on for Excel that provides Business

[更多細節]

哪些人適合這堂課?

  • For all Excel enthusiasts who consolidate or manipulate data repetitively OR use VLOOKUP a lot!
  • For all those who want to be at the forefront of the Big Data, Business Intelligence concept
  • For all those who want to adapt a report in seconds when stakeholders objectives change
  • Students may have an understanding of Power Pivot but want to consolidate their knowledge with practical examples and practice exercises
  • For all those who want super-hero status amongst their colleagues

學習目標

  • Import data into the Power Pivot Data Model using Excel 2016
  • Import and edit data from Microsoft Access and Microsoft Excel
  • Build Relationships between Data Tables
  • Create Hierarchies for end-user filtering convenience
  • Shape the Data Model with Calculated Columns & Measures
  • Create DAX Expressions including: SUM(), RELATED(), RELATEDTABLE(), COUNT(), DISTINCTCOUNT(), MONTH(), DATE(), CALCULATE(), ALL()
  • Build custom DAX Expressions to drop into any pivot
  • Create Dashboard worthy reports with Slicers and Presentation tips
  • Download the step-by-step user guide with practice exercises and solutions
  • Import existing Excel data and Link Excel data into the Data Model
  • Create Calculated Columns and Measures in the Data Model
  • Create Measures in Excel
  • Create Calculated Columns with RELATED() & RELATEDTABLE() DAX Functions
  • Create Measures using the COUNT() & DISTINCTCOUNT DAX Functions
  • Create Measures using the CALCULATE() DAX Function to modify the Filter Context of Pivot Tables
  • Create static values for Ratio creation with CALCULATE() & ALL() DAX Functions
  • Create a Date Table (Calendar) in Excel and Relate to the Data Model for Time Intelligence functionality




廣告 – 往下繼續閱讀本文


3

Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)

Visualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool.

點擊前往 Udemy

課程老師Phillip Burton
課程評價4.5 分(422 個評分)
學生人數2,884 人

課程介紹

Reviews:

“In just the first few lessons, I have already been able to apply what I have learned at my job. Thank you for this course!” — Cynthia Smith

“The Instructor is easy to understand and he gives exercises to test your understanding which is

[更多細節]

哪些人適合這堂課?

  • This course is for people who want to create analyses.
  • You either want to do this in Excel, or you want to learn about SQL Server Analytical Services (Tabular edition).
  • This course isn’t for you if you want to learn SSAS (MDX version) – there are other courses for this.

學習目標

  • Extract data from multiple tables.
  • Create connections between the tables.
  • Develop the model using DAX functions.
  • Create analyses in Excel.




廣告 – 往下繼續閱讀本文


4

Complete Introduction to Excel Power Pivot

Concise, yet effective course on Excel DAX, Data Models & Relationships and working with enormous data volumes

點擊前往 Udemy

課程老師Ian Littlejohn
課程評價4.5 分(560 個評分)
學生人數2,191 人

課程介紹

With Excel’s impressive Power Pivot, you can import millions of rows of data, create mashups from different data sources and build sophisticated data models with ease.  This allows you to analyse your data and share insights with just a few clicks of

[更多細節]

哪些人適合這堂課?

  • Excel users who want to learn how to use the Power Pivot Data Model
  • Excel users who want to learn how to use the DAX formula language

學習目標

  • Quickly learn to use Power Pivot in Excel for powerful data analysis
  • Work with millions of rows of data, create relationships between tables and learn the DAX formula language
  • Have a COMPREHENSIVE understanding of creating data models in Excel
  • Create calculated fields and calculated measures using DAX in Excel
  • Perform SOPHISTICATED calculations such as Time Intelligence, Filtered Data and Segmentation
  • Create RELATIONSHIPS between tables of data
  • Analyze data using Pivot Tables and Pivot Charts




廣告 – 往下繼續閱讀本文


5

DAX Power Pivot Time Intelligence – 10 Easy Steps

Support the Needs of Business Intelligence Using Custom Calendars and Time Period Functions in DAX.

點擊前往 Udemy

課程老師Gilly Dow
課程評價4.8 分(233 個評分)
學生人數1,802 人

課程介紹

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

Excel 2013 PowerPivot & Advanced Business Intelligence Tools

Enter the very hot world of BI, Power Pivot, DAX, and big data. This investment of your time is a no brainer.

點擊前往 Udemy

課程老師Optima Train
課程評價4.1 分(159 個評分)
學生人數1,657 人

課程介紹

This course takes up where the Optima Train Excel 2013 Pivot Tables and Pivot Charts course leaves off. It has two primary themes, each ultimately related to data analysis with pivot tables. First, it teaches you a number of methods for importing ext

[更多細節]

哪些人適合這堂課?

  • Any competent Excel users who want to be on the leading edge with Excel’s latest and most powerful data analysis tools

學習目標

  • Import external data for analysis in PowerPivot




廣告 – 往下繼續閱讀本文


7

DAX Power Pivot 10 Easy Steps for Advanced Users

Learn advanced Data Modeling techniques, Variables and Budget Patterns

點擊前往 Udemy

課程老師Gilly Dow
課程評價5.0 分(168 個評分)
學生人數1,125 人

課程介紹

Are you ready to take your DAX skills to the next level? My new DAX Power Pivot – 10 Easy Steps for Advanced Users follows on from the my previous “10 Easy Steps” series to enable you to increase the complexity of your data models and progress to cre

[更多細節]

哪些人適合這堂課?

  • DAX Power Pivot 10 Easy Steps for Beginners students
  • DAX Power Pivot Time Intelligence 10 Easy Steps students
  • DAX Power Pivot 10 Easy Steps for Intermediate students
  • Business Analysts and/or Intelligence Developers and Data Scientists who are confident with DAX fundamentals

學習目標

  • Work with Multiple Data Tables
  • Build complex calculations with Variables
  • Gain Insights with RANKX() & TOPN()
  • Work with Differing Granularities
  • Use Budget Patterns
  • Budget vs Actuals




廣告 – 往下繼續閱讀本文


8

Power Pivot Workshop Complete Bundle

Learn to master Power Pivot for Excel and DAX. This bundle includes three courses: Beginner, Intermediate, and Advanced.

點擊前往 Udemy

課程老師Marco Russo
課程評價4.5 分(186 個評分)
學生人數1,031 人

課程介紹

This bundle include all the three courses of Power Pivot Workshop: Beginner, Intermediate, and Advanced. The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures tha

[更多細節]

哪些人適合這堂課?

  • Advanced Excel Users
  • Business Analysts
  • Business Intelligence Developers
  • Data Scientists

學習目標

  • By the end of the course, you will master Power Pivot for Excel.
  • You will learn how to create simple models in Power Pivot, loading data from different data sources.
  • You will learn how to write DAX expressions performing calculations such as Ratio-to-Parent, Year-to-Date, Year-Over-Year and so on.
  • You will learn how to use advanced DAX functions and to create complex data models in Power Pivot.
  • You will learn how to solve typical business issues by applying predefined patterns in DAX.




廣告 – 往下繼續閱讀本文


9

DAX Dashboard Design – 10 Easy Steps

How to Create Interactive Business Intelligence Dashboard Reports with DAX Power Pivot

點擊前往 Udemy

課程老師Gilly Dow
課程評價4.5 分(103 個評分)
學生人數866 人

課程介紹

DAX Dashboard Design – 10 Easy Steps will guide you through the entire process of Dashboard creation covering every part of the process – in depth. From creating an element grid system to automating Sparklines with VBA – start to finish

 By learning

[更多細節]

哪些人適合這堂課?

  • If you have a passion MS Excel
  • If you want to test your DAX Power Pivot skills
  • If you want to convey Business Insights and Trends at a glance
  • All workers seeking raises, recognition, promotions and better prospects

學習目標

  • Plan, plot, build fully interactive, dynamic Dashboard Reports
  • Adapt to scenarios where data doesn’t “fit” the brief
  • Create “Negative” Bar & Column Charts
  • Create “Scrollable” tables when space is limited
  • Record a Macro and edit VBA code to automate Sparklines




廣告 – 往下繼續閱讀本文


10

The Power Pivot, Power Query in Excel and Power BI Bundle

Learn how to analyze millions of rows of data in Excel and Power BI in this two-course bundle

點擊前往 Udemy

課程老師Simon Sez IT
課程評價4.6 分(89 個評分)
學生人數586 人

課程介紹

**This course includes practice exercise files**

Learn Microsoft Power BI and Power Pivot, Power Query and DAX in Excel in this two-course bundle from Microsoft experts Simon Sez IT.

We’ve combined two of our best data analysis courses to create

[更多細節]

哪些人適合這堂課?

  • Advanced Excel Users

學習目標

  • Learn to unlock advanced Excel tools Power Query and Power Pivot as well as Power BI in this two-course bundle!
  • Analyze huge buckets of data to make informed business decisions
  • Become confident cleaning, sorting and linking data from various sources
  • Learn via expert instruction and exercises designed to have you performing complex analysis
  • How to create stunning, interactive dashboards with Power BI
  • How to share your analysis and dashboards using Power BI Online
  • To import CSV and Excel files into Power BI Desktop
  • All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
  • All about using the card visual to create summary information
  • How to create amazing visuals, such as clustered column charts, maps, and trend graphs
  • How to use Slicers to filter your reports
  • How to edit the interactions between your visualizations and filter at visualization, page, and report level




廣告 – 往下繼續閱讀本文


從老師查找更多Power Pivot課程

以上推薦的Power Pivot課程都看不到喜歡的嗎?
還是您有熱衷某個老師或某個品牌開的課程呢?嘗試從老師或品牌頁挑選吧!

【2024年】十大Power Pivot課程熱門排行推薦與優惠精選!

參考其他理財工具線上課程

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


Tagged on: