Data Modeling Courses

1. Beginners Data Analysis Bootcamp with SQL

Beginners Data Analysis Bootcamp with SQL

Learn the four key pillars of Data Analysis: Databases , Data Modeling , SQL and Data Visualization.
Content:
- 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

2. Microsoft Power BI Desktop for Business Intelligence

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
Content:
- 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

3. Microsoft Excel: Business Intelligence w/ Power Query & DAX

Microsoft Excel: Business Intelligence w/ Power Query & DAX

Learn advanced Excel for data analysis & business intelligence (Power Query, Power Pivot & DAX language. Excel 2013+)
Content:
- 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

4. Mastering Data Modeling Fundamentals

Mastering Data Modeling Fundamentals

Entity-Relationship Techniques and Best Practices
Content:
- 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.

5. Data Modeling and Relational Database Design using ERwin

Data Modeling and Relational Database Design using ERwin

Course that teaches how ERwin Data modeler can help you create & maintain sound relational database designs
Content:
- 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

6. The Complete Database Design & Modeling Beginners Tutorial

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.
Content:
- 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

7. Learning Data Modeling

Learning Data Modeling

A step by step guide to data modeling concepts and best practices underpinning sound database design.
Content:
- conceptually plan a coherent data model to plan and design enterprise-quality databases.
- differentiate between UML and IE data models.
- create databases with SQL and Microsoft Access.

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

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.
Content:
- 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.

9. OBIEE 12c Data Modeling Course

OBIEE 12c Data Modeling Course

Data Modeling, RPD, Physical, BMM, and Presentation layer, Logical Dimensions and Hierarchies, Measures, Analysis
Content:
- 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.

10. Database design using ER modelling & Normalization technique

Database design using ER modelling & Normalization technique

Learn Database design using examples in a very short period of time.
Content:
- E-R Modelling and Physical database design

11. Comprehensive Course on MongoDB and Data Modeling

Comprehensive Course on MongoDB and Data Modeling

Gain complete proficiency in mongoDB and NoSql with perfect expertise and knowledge.
Content:
- Have in depth understanding of NoSql
- JSON and BSON.
- Have a brief idea about MongoDB.
- Get familiar with CRUD operations.

12. Microsoft 70-466:Implementing Data Models & Reports

Microsoft 70-466:Implementing Data Models & Reports

Implementing Data Models & Reports with MSSQL Server 2012
Content:
- 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.

13. Mediation, Moderation, and Conditional Process Analysis

Mediation, Moderation, and Conditional Process Analysis

How to estimate detailed direct, indirect, and total effects for complex, intertwined mediating and moderating effects.
Content:
- 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.

14. Learning DAX in Easy Steps

Learning DAX in Easy Steps

Best of Data Analysis Expressions (DAX) for Beginners in 90 mins. Especially created for those who gave up learning DAX.
Content:
- Essential DAX Concepts
- Powerful DAX Functions
- Creating Data Models

15. Data Modelling For Beginners

Data Modelling For Beginners

Hands -on Data Modelling from scratch
Content:
- Connect to Microsoft Access Database
- Install Power BI Desktop
- Create and manage data relationship

16. Introduction to information and data modeling

Introduction to information and data modeling

Using multiple data modeling techniques in Sparx Enterprise Architect
Content:
- Create information and data models at conceptual
- logical and physical level
- Use Sparx Enterprise Architect as a data modeling tool
- Practice the various modeling techniques in a case based assignment