Data Modeling Courses

  1. Home
  2. Data Modeling Courses

    3. 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