Data Analysis Course using Power BI and Excel

Reviews:

Training Program Description The Training Course

Join Now

Price :

AED 1800

Number of Students:

300 Students

Number of Hours:

65 Hour

Number of Lessons:

21 Lesson

Data Analysis in Excel

  • Module 1: Getting started with data analysis using Microsoft Excel and Power BI
  • Module 2: Data analysis using main functions and analysis tools
  • Module 3: Importing data from various data sources
  • Module 4: Cleaning, transforming, and loading data using Power Query
  • Module 5: Designing a data model and creating relationships between tables
  • Module 6: Using DAX functions for calculated columns and measures in Excel
  • Module 7: Designing interactive charts and dashboards in Excel

Power BI Program

  • Module 8: Preparing data and creating relationships in Power BI.
  • Module 9: Creating interactive data visualizations for effective analysis in Power BI.
  • Module 10: Building and managing data models in Power BI.
  • Module 11: Optimizing data models and advanced DAX functions in Power BI.
  • Module 12: Designing reports for data-driven decision making in Power BI.
  • Module 13: Leveraging artificial intelligence in Power BI for advanced data insights.
  • Module 14: Advanced analytics, performance optimization, and configuration in Power BI.
  • Module 15: Publishing and sharing reports, managing dashboards, workspaces, and security in the Power BI service.

Business Skills (Business Value)

  • Module 16: Focusing on actual business value.
  • Module 17: Identifying key performance indicators (KPIs) and transforming company goals into measurable metrics.
  • Module 18: Understanding the problem and the data, and developing the ability to read and analyze different datasets.
  • Module 19: Developing the analyst mindset, asking the right questions, and extracting insights from data.
  • Module 20: Improving performance and increasing efficiency, and building reports and dashboards.

Effective Presentation Using PowerPoint

  • Module 21: Effectively presenting data analysis results using PowerPoint.
  • Module 22: Visual storytelling: presenting data insights using PowerPoint.

Unite 2 :

3.Elements and Principles of Interior Design:

  • Elements of Interior Design
  • Principles of Interior Design
  • Steps of Interior Design

4.Principles of Interior Design:

  • Principles of Interior Design
  • How to Apply the Principles of Interior Design

5. Placement of Core Elements:

  • Concept of Residential and Commercial Layout
  • How to Read Residential and Commercial Layouts
  • How to Draw Residential and Commercial Layouts
  • How to Distribute the Foundation on Residential and Commercial Layouts

6.Color Theories:

  • Color Theories
  • Methods for Choosing the Appropriate Color Scheme for Each Design
  • How to Use the Color Wheel

7.Furniture Styles:

ChatGPT said:
  • Furniture Styles
  • How to Choose Furniture
  • How to Mix Between Furniture Styles

8.Floors and Walls:

  • Floor and wall materials How to distinguish between different floor and wall materials How to classify floor and wall materials by quality and best choice

9. Mood Board:

  • Concept of the Mood Board Importance of the Mood Board Applications of the Mood Board Skill development targeted by the unit First Training Workshop: Practical workshop where participants learn how to use the Mood Board efficiently and effectively on a project Each group follows the training workshop method

Autodesk AutoCAD

Autodesk AutoCAD

  • دورة أوتوديسك أوتوكا  هي بداية دخولك في مجال رسم وإعداد اللوحات الهندسية لكافة المجالات وستعرف في هذه الدورة على كيفية الرسم والتعديل والأبعاد والبلوكات وكيفية طباعة اللوحات.
  • المرحلة الأولي واجهة البرنامج:
  • التعرف على واجهة التطبيق أو ال INTERFACE
    الخاص بالبرنامج .
  • شرح لل TOOLS COMMON ACCESSبما يحتوية من اوامر- OPEN
    .SAVE EXPORT - DRAWING UTILITIES
  •  التعرف على الـ BAR STANDARD بما يحتوية
    NEW - OPEN - CUT - PASTE - COPYمن اوامر
  • شرح ال SNAP OBJECT بما يحتويه من أوامر
    END POINT-MID POINT - CENTER - QUADRANT
    شرح لكيفية رسم الخطوط الـ EXTENSION - PARALLEL
    شرح لكيفية استخدام الـ POINT TRACK TEMPORARY Activate
  • التعرف علي استخدام الأدوات المساعدةGo to set الSNAP والGRID

AUTODESK 3D Max

Training Course:

3ds Max and V-Ray course is your entry into the field of 3D architectural design.
Whether you are a university student or a graduate wanting to create a 3D model for your project,
3ds Max will help you build the model, whether it is interior or exterior.
The V-Ray plugin will assist you in producing highly realistic perspective renders.
The 3ds Max and V-Ray course involves working on an interior project and an exterior project,
and rendering both projects using V-Ray.

Course Study Stages:

  • First Stage (Architectural):
    The first stage is the most important in the course, as it forms the foundation for all subsequent stages. In this stage, the program is studied from an architectural perspective based on the principle of knowledge transfer.

Introduction to Autodesk 3ds Max

Applications and projects on building architectural blocks

Introduction to building organic forms

Applications on organic projects

How to build organic blocks

Applications on parametric projects

Building classic decor units

Decorative elements and fabrics

  • Second Stage (Interior Design and Decoration):
    Study of interior decoration for an actual project with hands-on practice during the course.

The project will be either a classic bedroom or a classic living room.

Course Study Stages:

  • Third Stage (Exterior Architectural Visualization):

Study of exterior architectural visualization for a villa, palace, or administrative building projects.

  • Fourth Stage (V-Ray Engine):

The most important stage in achieving realistic project visualization, which is the goal of anyone in this field.

  • Fifth Stage (Rendering Techniques):

Study of rendering techniques in a simple and detailed manner.

  • Sixth Stage (Image Production and Post-Processing):

How to make color adjustments, produce multiple proposals for the client, and add various effects.

Photoshop

Training Program Description:

Undoubtedly, architectural post-production in Photoshop for projects is one of the most important stages that gives the work its distinctive final appearance. Nowadays, many working methods make using Photoshop for architectural purposes not optional but essential in many projects.

Course Study Stages:

  • Displaying floor plans and overall site layout
  • Displaying vertical sections
  • Displaying perspectives
  • Converting daytime scenes to nighttime
  • Best methods for exporting files from AutoCAD (Before, After, Akmam, Ps)
  • Learning professional visualization techniques for all architectural elements
  • Adding all living elements (people, plants, trees, animals, birds)
  • Learning to use render elements in the visualization process
  • Using filters to achieve more realism
  • Using brushes and gradients to add various effects
  • Working with external assets and integrating them into the scene
  • Adjusting lighting and colors in the most efficient and effective way

Introduction

  • Photoshop
  • Introduction
  • Program Interface
  • Panels
  • Character Settings
  • Opening Files and Creating a New File
  • Navigation
  • Preferences Adjustments
  • Importing Images

Selection Methods

  • Selection Tools
  • Marquee Tools
  • Lasso Tools
  • Quick Selection Tools

Layers

  • Create a New Layer
  • Copying and Cutting in Layers
  • Layers Arrangement
  • Blending Modes
  • Layer Styles

Enhancement and Retouching Tools

  • Spot Healing Tool
  • Healing Brush Tool
  • Patch Tool
  • Content-Aware Tool
  • Clone Stamp Tool
  • Applications on Healing and Retouching

Brushes

  • Brushes and Their Usage
  • Applications on Using Brushes

Adjustments

  • Lighting Adjustments
  • Color Adjustments
  • Special Adjustments
  • Pen Tool

Displaying Plans and Sections

  • Exporting Plans from AutoCAD
  • Opening Walls and Selecting the Plan
  • Spaces Coloring
  • Defining Patterns and Models
  • Stairs
  • Section Presentation
  • Poster Making

Quantity Surveying and Pricing Course AutoCAD & Excel

Introduction to Quantity Surveying and Pricing

  • Types of Quantity Surveying and Its Tools
  • Preparing the Bill of Quantities (BOQ)
  • Estimating the Total Cost of Projects
  • Basics of Pricing in the Interior Design Market
  • Presenting Price Quotes to Clients Professionally
  • Using Digital Programs in Quantity Surveying and Pricing
  • Factors Affecting Price Determination
  • Common Errors in Quantity Surveying and Pricing and How to Avoid Them
  • Analyzing Case Studies of Successful Interior Design Projects

Interior Finishes Course

  • Understanding the different stages of architectural finishes, their sequence on-site, common errors during handover, and requirements to ensure finish quality
  • Electrical works setup stage
  • Surface and floor insulation stage for bathrooms and kitchens
  • Gypsum board works stage, types, and various ceiling works
  • Wall painting stage and different wall treatments
  • Masonry works stage, levels used, and opening models for doors and windows
  • Plastering stage, wall treatment, and preparation for painting
  • Installation stage of walls and floors: ceramic and porcelain
  • Plumbing and sewage works setup stage
  • Final installations: electrical and plumbing works