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

 

本文章推薦「Microsoft Power BI Desktop for Business Intelligence」、「Microsoft Excel: Business Intelligence w/ Power Query & DAX」、「Mastering Data Modeling Fundamentals」等相關資料建模線上課程,讓您滿足學習的慾望。

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

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

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





資料建模課程總覽

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

課程名稱Microsoft Power BI Desktop for Business IntelligenceMicrosoft Excel: Business Intelligence w/ Power Query & DAXThe Complete Database Design & Modeling Beginners TutorialMastering Data Modeling FundamentalsData Modeling and Relational Database Design using ERwinMicrosoft Excel: Pivot Tables, Power Query, Power Pivot/DAXMediation, Moderation, and Conditional Process AnalysisOBIEE 12c Data Modeling CourseBeginners Data Analysis Bootcamp with SQLMicrosoft 70-466:Implementing Data Models & Reports
課程圖示
1

Microsoft Power BI Desktop for Business Intelligence

2

Microsoft Excel: Business Intelligence w/ Power Query & DAX

3

The Complete Database Design & Modeling Beginners Tutorial

4

Mastering Data Modeling Fundamentals

5

Data Modeling and Relational Database Design using ERwin

6

Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX

7

Mediation, Moderation, and Conditional Process Analysis

8

OBIEE 12c Data Modeling Course

9

Beginners Data Analysis Bootcamp with SQL

10

Microsoft 70-466:Implementing Data Models & Reports

課程原價NT$ 2,990NT$ 2,990NT$ 2,990NT$ 1,590NT$ 1,790NT$ 2,990NT$ 790NT$ 2,990NT$ 590NT$ 2,990
課程售價NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390
課程評價(人數)4.6 分(40,284 個評分)4.7 分(14,031 個評分)4.4 分(1,950 個評分)4.3 分(2,528 個評分)4.3 分(1,950 個評分)4.6 分(262 個評分)4.3 分(39 個評分)4.2 分(196 個評分)4.6 分(114 個評分)4.1 分(50 個評分)
課程時長10.5 小時7 小時2 小時3 小時3.5 小時16.5 小時3 小時5.5 小時3.5 小時5.5 小時
學生人數141,589 人66,478 人17,991 人10,692 人9,117 人1,667 人1,108 人1,073 人520 人425 人
課程特色Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructorLearn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)Learn Database Design the easy way. Go from simple to complex with a real life example: online store’s DB using MySQL.Entity-Relationship Techniques and Best PracticesCourse that teaches how ERwin Data modeler can help you create & maintain sound relational database designsMicrosoft Excel Pivot Tables, Get and Transform (Power Query) and Power Pivot (DAX) for advanced data analysis. 70-779.How to estimate detailed direct, indirect, and total effects for complex, intertwined mediating and moderating effects.Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, AnalysisLearn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization.Implementing Data Models & Reports with MSSQL Server 2012
連結UdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemy



資料建模課程介紹

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

10

Microsoft 70-466:Implementing Data Models & Reports

Implementing Data Models & Reports with MSSQL Server 2012
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Stone River eLearning
課程評價4.1 分(50 個評分)
課程時長5.5 小時
學生人數425 人

課程介紹

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012. 

This course is designed for BI Developers who mo

瞭解更多細節

哪些人適合這堂課?

  • IT Professionals

學習目標

  • This course will prepare you to pass the exam Microsoft 70-466 Implementing Data Models & Reports with MSSQL Server 2012
  • You will be able to implement data models and reports with Microsoft SQL Server 2012.

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

9

Beginners Data Analysis Bootcamp with SQL

Learn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization.
NT$ 590
NT$ 390

點擊看Udemy

課程老師Adnan Haroon
課程評價4.6 分(114 個評分)
課程時長3.5 小時
學生人數520 人

課程介紹

This course will teach you the four building blocks of data analysis in a very structured way

* We will first learn about databases and database management systems with the focus of data accessibility. Our preferred DBMS will be MYSQL.

* We will th

瞭解更多細節

哪些人適合這堂課?

  • Anyone interested in learning data analysis from ground up using the four keys areas that is database , data modeling , data insight and data visualization for their current or future job needs.
  • Anyone looking to switch careers to focus more on data related jobs
  • Developers who want to learn SQL and Data modeling for their current projects
  • Business analysts who want to better understand their data requirements for key applications
  • Students who want to learn new skills for academic purposes
  • Anyone curious to learn about data and be able to tell a story and gain insight

學習目標

  • Understand the foundation of data analysis and explain the key areas of database, modeling, visualization and insight.
  • Be able to understand and create data models in relational database environment
  • Be able to write simple to complex SQL queries in a production environment
  • Create compelling data visualizations for professional projects
  • Be able to use MYSQL database to interact with data and gain insight

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



8

OBIEE 12c Data Modeling Course

Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, Analysis
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Sanjay Singh
課程評價4.2 分(196 個評分)
課程時長5.5 小時
學生人數1,073 人

課程介紹

Join the most comprehensive and popular Oracle Business Intelligence Enterprise Edition (OBIEE) 12c Data Modeling Course on Udemy, because now is the time to get started!

From basic concepts about Data Modelling, Denormalization, Star Schema Modelli

瞭解更多細節

哪些人適合這堂課?

  • Students who want to get into OBIEE Data Modeling profession.
  • Current IT professionals who want to switch to OBIEE Data Modeling profession.
  • Experience professionals in non IT sectors who want to switch to OBIEE Data Modeling profession.
  • Project Managers, Operation Managers who want to understand OBIEE Data Modeling.

學習目標

  • What is Business Intelligence and how it helps Organizations in this Information Age.
  • OBIEE 12c Architecture. System Development Life Cycle (SDLC) and Roles and Responsibilities in OBIEE implementation project.
  • Oracle Business Intelligence Enterprise Edition (OBIEE) 12c project development life cycle.
  • Data modeling concepts i.e. Data Denormalization, Dimensional Data Modelling, Kimball and Star Schema Modeling.
  • Installing OBIEE 12C Administration tool.
  • Downloading and Uploading RPD.
  • Reviewing and Modifying Physical Layer, Business Mapping Layers and Presentation Layer.
  • Creating Repository (RPD) from scrath.
  • Creating Physical Layer : Connection Pool, Import Metadata, Alias, Keys and Joins, Snowflake Schema
  • Creating Business Model and Mapping Layer: Star Schema, Logical Table, Logical Column, Logical Table Source, Measures, Utilities
  • Creating Presentation Layer: Subject Area, Presentation Tables and Columns.
  • Creating Measures using existing Logical Columns and Functions.
  • Creating Logical Dimensions, Level Based Hierarchy, Ragged, Skipped Hierarchy. Parent Child Hierarchy.
  • Setting up Content Aggregation and Group By.
  • Creating Analysis with Drill Down feature.
  • Initialization Block and Repository Variable.
  • Time Series Functions.

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

7

Mediation, Moderation, and Conditional Process Analysis

How to estimate detailed direct, indirect, and total effects for complex, intertwined mediating and moderating effects.
NT$ 790
NT$ 390

點擊看Udemy

課程老師Geoffrey Hubona, Ph.D.
課程評價4.3 分(39 個評分)
課程時長3 小時
學生人數1,108 人

課程介紹

Mediation, Moderation, and Conditional PROCESS Analysis is a methodological statistical technique developed by Dr. Andrew F. Hayes which is applied to ordinary least squares (OLS) regression. PROCESS simplifies the ‘untangling’ of the analyses of com

瞭解更多細節

哪些人適合這堂課?

  • Anyone who works with ordinary least squares (OLS) regression models will benefit from this course.
  • SAS and SPSS users of PROCESS scripts who wish to transfer these skills over to using R software.
  • Graduate students, faculty and quantitative and data analysis professionals who work with linear modeling will benefit from this course.
  • Persons who work with partial least squares (PLS) path modeling and who wish to apply the PROCESS technique to latent variables in their own PLS path models.
  • People who only have available Mac computers might have problems running the GUI-based RGtk2-written R PROCESS software that accompanies the course materials.

學習目標

  • Apply the PROCESS technique to separately estimate complex, combined direct, indirect and total mediating and moderating effects in OLS models and in PLS path models using their own data and models.
  • Have a wider range of precise analytical tools to more finitely estimate individual direct, indirect and total mediating and moderating effects, as well as the significant differences among them.
  • Install and use our R-based allstatGUI and MEDMOD (PROCESS) software applications on their own data and models.

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



6

Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX

Microsoft Excel Pivot Tables, Get and Transform (Power Query) and Power Pivot (DAX) for advanced data analysis. 70-779.
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Phillip Burton
課程評價4.6 分(262 個評分)
課程時長16.5 小時
學生人數1,667 人

課程介紹

This course covers the visualizations and analysing content required for Microsoft’s 70-779 certification exam. (Note: this exam is no longer available, but the topics are well worth learning!)

Reviews

Nora: “I liked that it went through really fas

瞭解更多細節

哪些人適合這堂課?

  • This reporting course is meant for anyone who has no prior, or only a little experience of Pivot Tables, Get and Transform, and Power Pivot.
  • No prior experience in reporting tools is required.
  • This course is probably not for you if you always know how to how to do the advanced functionality of Get and Transform and Power Pivots, although we will be looking at some more advanced topics, including the M and DAX languages.

學習目標

  • Be able to create PivotTables and PivotCharts, both basic and advanced
  • You will be able to format numbers and dates, and create advanced calculations.
  • You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting.
  • Building and refine models, including adding calculated columns and measures.
  • You will learn the important M and DAX functions, to enable you to build your own formulas.

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

5

Data Modeling and Relational Database Design using ERwin

Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs
NT$ 1,790
NT$ 390

點擊看Udemy

課程老師Haris Kilikotu
課程評價4.3 分(1,950 個評分)
課程時長3.5 小時
學生人數9,117 人

課程介紹

The data model is the one place where you can store all the relevant information about a data asset (definitions, structure, relationships, integration points etc) and deliver it in a visual and contextually appropriate format for stakeholders involv

瞭解更多細節

哪些人適合這堂課?

  • Data Modelers
  • Data Architects
  • Database administrators
  • ETL developers
  • DWH/BI professionals
  • Business Analysts

學習目標

  • Create Entity Relationship Diagrams by identifying entities, attributes, relationships and constraints from a set of requirements
  • Normalize the Entity Relationship Diagram to third Normal form
  • Develop sound database designs by applying proven data modeling techniques
  • Engineer/Re-engineer the data Models into and from relational database designs
  • Optimize the Relational Database Design for various functional/non functional requirements
  • Work with database change requests and maintain existing databases with the help of tools.
  • Develop data models using ERwin Data Modeler

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



4

Mastering Data Modeling Fundamentals

Entity-Relationship Techniques and Best Practices
NT$ 1,590
NT$ 390

點擊看Udemy

課程老師Alan Simon
課程評價4.3 分(2,528 個評分)
課程時長3 小時
學生人數10,692 人

課程介紹

If you are a current or aspiring IT professional in search of sound, practical techniques to analyze and model data as part of the overall data management lifecycle, this is the course for you.

During the course, you’ll put what you learn to work an

瞭解更多細節

哪些人適合這堂課?

  • A business analyst, data engineer, or database designer, currently with little or no exposure to or experience with data modeling, who desires to build a personal toolbox of data modeling best practices and techniques.
  • After completing this course, you will be ready to begin working on real-world data modeling projects, either with expanded responsibilities as part of an existing role or to find a new position involving data modeling. Example positions include database designer, conceptual data modeler, database engineer, and business analyst with an emphasis on data requirements.

學習目標

  • Master the techniques needed to build data models for your organization.
  • Apply key data modeling design principles through both classic entity-relationship notation and the “crow’s foot” notation.
  • Build semantically accurate data models consisting of entities, attributes, relationships, hierarchies, and other modeling constructs.
  • Convert conceptual data models to logical and physical data models through forward engineering.

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

3

The Complete Database Design & Modeling Beginners Tutorial

Learn Database Design the easy way. Go from simple to complex with a real life example: online store’s DB using MySQL.
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Rares Ilea
課程評價4.4 分(1,950 個評分)
課程時長2 小時
學生人數17,991 人

課程介紹

Are you new to Databases and Database Design? Do you feel like you’re left guessing how to properly design the database for your project? ..Or maybe you just want to add this on-demand skill to your CV.

Our Database Design Beginner’s Tutorial is her

瞭解更多細節

哪些人適合這堂課?

  • Aspiring Data Analysts
  • Non-technical Professionals looking to integrate Databases in their projects
  • College Graduates who want to land a new job as Software Developers
  • Developers wanting to learn more about Database Design
  • Entrepreneurs wanting to better use data in their business
  • Students just getting started with databases

學習目標

  • Learn what a database is
  • Learn how databases work and why are they important
  • Learn data modeling and the 3 levels of relational database design
  • Learn what are the steps to create a sound database design
  • Learn what database normalization is and how to apply 1NF, 2NF and 3FN in database design
  • Learn how to build database relationships: one-to-one, many-to-one and many-to-many
  • Understand better every theoretical step by following several concrete examples
  • You will be able to design a relational database from scratch
  • You will be able to answer the most common interview questions about databases
  • You will have a concrete e-commerce database design schema to add to your portofolio

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



2

Microsoft Excel: Business Intelligence w/ Power Query & DAX

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

點擊看Udemy

課程老師Maven Analytics
課程評價4.7 分(14,031 個評分)
課程時長7 小時
學生人數66,478 人

課程介紹

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

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

1

Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructor
NT$ 2,990
NT$ 390

點擊看Udemy

課程老師Maven Analytics
課程評價4.6 分(40,284 個評分)
課程時長10.5 小時
學生人數141,589 人

課程介紹

Hear why this is one of the TOP-RATED Power BI courses on Udemy:

“Instructor is top notch – moves at the right pace and keeps it interesting. Best Power BI course on Udemy!”

-Adam Edwards

“Resources are awesome. Presenter is brilliant. I found thi

瞭解更多細節

哪些人適合這堂課?

  • Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
  • Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
  • Aspiring data professionals looking to master the #1 business intelligence tool on the market
  • Students who want a comprehensive, engaging, and highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence

學習目標

  • Build professional-quality business intelligence reports from the ground up
  • Blend and transform raw data into beautiful interactive dashboards
  • Design and implement the same B.I. tools used by professional analysts and data scientists
  • Showcase your skills with two full-scale course projects (with step-by-step solutions)
  • Understand the business intelligence workflow from end-to-end
  • Learn from a best-selling instructor and professional BI developer

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



資料建模課程總覽

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

課程名稱Microsoft Power BI Desktop for Business IntelligenceMicrosoft Excel: Business Intelligence w/ Power Query & DAXThe Complete Database Design & Modeling Beginners TutorialMastering Data Modeling FundamentalsData Modeling and Relational Database Design using ERwinMicrosoft Excel: Pivot Tables, Power Query, Power Pivot/DAXMediation, Moderation, and Conditional Process AnalysisOBIEE 12c Data Modeling CourseBeginners Data Analysis Bootcamp with SQLMicrosoft 70-466:Implementing Data Models & Reports
課程圖示
1

Microsoft Power BI Desktop for Business Intelligence

2

Microsoft Excel: Business Intelligence w/ Power Query & DAX

3

The Complete Database Design & Modeling Beginners Tutorial

4

Mastering Data Modeling Fundamentals

5

Data Modeling and Relational Database Design using ERwin

6

Microsoft Excel: Pivot Tables, Power Query, Power Pivot/DAX

7

Mediation, Moderation, and Conditional Process Analysis

8

OBIEE 12c Data Modeling Course

9

Beginners Data Analysis Bootcamp with SQL

10

Microsoft 70-466:Implementing Data Models & Reports

課程原價NT$ 2,990NT$ 2,990NT$ 2,990NT$ 1,590NT$ 1,790NT$ 2,990NT$ 790NT$ 2,990NT$ 590NT$ 2,990
課程售價NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390NT$ 390
課程評價(人數)4.6 分(40,284 個評分)4.7 分(14,031 個評分)4.4 分(1,950 個評分)4.3 分(2,528 個評分)4.3 分(1,950 個評分)4.6 分(262 個評分)4.3 分(39 個評分)4.2 分(196 個評分)4.6 分(114 個評分)4.1 分(50 個評分)
課程時長10.5 小時7 小時2 小時3 小時3.5 小時16.5 小時3 小時5.5 小時3.5 小時5.5 小時
學生人數141,589 人66,478 人17,991 人10,692 人9,117 人1,667 人1,108 人1,073 人520 人425 人
課程特色Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructorLearn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)Learn Database Design the easy way. Go from simple to complex with a real life example: online store’s DB using MySQL.Entity-Relationship Techniques and Best PracticesCourse that teaches how ERwin Data modeler can help you create & maintain sound relational database designsMicrosoft Excel Pivot Tables, Get and Transform (Power Query) and Power Pivot (DAX) for advanced data analysis. 70-779.How to estimate detailed direct, indirect, and total effects for complex, intertwined mediating and moderating effects.Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, AnalysisLearn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization.Implementing Data Models & Reports with MSSQL Server 2012
連結UdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemyUdemy



從老師查找更多課程

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



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

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

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


發佈留言

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