Database modeling and analysis with Power BI - Santiago de Cali

Translated by GoogleSee original

Database modeling and analysis with Power BI

From 14.1 £ /h

The Power BI course begins with a study of data modeling, using Access as a basic reference. Once this is understood, we'll work in Excel to import data sources, generate tables, and develop properties using essential Power Query. We'll also cover the use of Power Pivot. This will help you migrate to Power BI and explain the importance of data modeling to achieve professional-level results.

Once the migration is complete, it is easier to create reports using visualizations (Dash Board) and fundamentally the use of DAX and the R language.

Extra information

It is necessary that the student has installed Office applications such as Access, Excel, Power Point (for graphic design), the Power BI application, and an internet connection.

Location

Use Ctrl + wheel to zoom!

At student's location :

Around Santiago de Cali, Colombia

At teacher's location :

Carrera & Calle, El Jardin, Cali, Valle del Cauca, Colombia

Online from Colombia

About Me

Docente en Análisis y Diseño de Software; Desarrollo de soluciones Web; con capacidad de Analizar, controlar, planificar y crear soluciones a pequeñas, medianas y grandes empresas. Comprometido en la gestión de Administración, Soporte, operatividad y resolución de problemas mediante síntesis y deducción. Con capacidad de Liderazgo y trabajo en equipo, fácil manejo de expresión oral y excelentes relaciones interpersonales, creación, investigación y orientación.

Education

Tecnologo Sena en analisis y diseño de sistemas de informacion Cuento con una gran capacidad de aprendizaje, motivación y flexibilidad y actualmente estoy en busca de oportunidades laborales que me aporten a mi desarrollo profesional. Además, tengo disponibilidad inmediata y movilidad geográfica.

Experience / Qualifications

mas de 20 años en la enseñanza, ademas he participado en diseño de aplicaciones escritorio mobiles y web
Organizar y crear espíritu de investigación a partir de una excelente administración y planificación estratégica e impartir conocimientos que se ajusten a las tendencias actuales; aspectos que permiten crecer en planos profesionales personales y familiares.

Age

Teenagers (13-17 years old)

Adults (18-64 years old)

Seniors (65+ years old)

Student level

Beginner

Intermediate

Advanced

Duration

90 minutes

120 minutes

The class is taught in

Spanish

English

Skills

Microsoft excel

Database

Neuroscience

Availability of a typical week

(GMT -05:00)

New York

At teacher's location and via webcam

At student's home

Mon

Tue

Wed

Thu

Fri

Sat

Sun

00-04

04-08

08-12

12-16

16-20

20-24

Illustrator for illustrators of all levels

8.91 £ /h

Illustrator is a great application that meets today's advertising needs. The focus of this course is carefully crafted, moving away from traditional teaching approaches in this discipline. It is essential to establish a knowledge link between color modes, the products that can be created with this application, integration with other applications, and different formats, such as the use of Excel spreadsheets to create interactive, mass-produced brochures with detailed information connected with markers.

Regarding integration, we will use two sister applications of Illustrator: Photoshop and InDesign for the creation of magazines.

It will be a great experience, below is the thematic content

ILLUSTRATOR THEMATIC CONTENT
- Introduction

 Introduction to vector drawing.

 Differences between a vector image and a bitmap image.
 Concept of vector drawing with ILLUSTRATOR (Characteristics of a vector)
 ILLUSTRATOR Vs ADOBE PHOTOSHOP
 Professional-level tool utilities.
 New features compared to the previous version

 The work environment

 The document window and workspaces
 Tool palettes, panels, and control panels
 Configure the workspace
 Document configuration and adjustment.
 Document navigation.
 Rulers and grids.
 Using guides and smart guides
 Color modes (CMYK color management).
 Image formats.
 Working with PostScript.
 Keyboard customization

- Creating files, the layers panel, and setting up the workspace

 Configure the new file for different modes
 Data to take into account about pixels in the new document
 Pixel grid alignment
 Generate custom document template
 Prepare files for large outdoor advertising

 Design compositions using layers and sublayers

 Layer options.
 Hierarchical layer structure.
 Locking/unlocking elements.
 Selections with layers.
 Layer colors.
 Nested layers.
 Moving objects in layers

- Storage formats, PDF files, export formats
- Operations on Images

 Rasterization concept and rasterization effects settings
 Coupling transparencies
 Selecting unaligned objects in ILLUSTRATOR
 Graphic styles applied to vectors
 Bitmap-based opacity masks
 Pixelated effects on vectors
 Place vs. Open photos (Linked vs. Embedded objects)
 Preview pixels and contour
 Preview of color separations and transparencies coupling

 Quality output for bitmap elements

 Printing bitmap documents
 Print Presets
 Segmentation of large documents
 Boundary marks crop marks
 Overprinting strokes and fills

- Work tools

 Navigation tools

 Hand
 Impression segmentation
 Zoom

 Copy and paste options; duplicating objects

 Selection tools.

 Configure selection and keyboard preferences
 Normal, direct selection and group selection
 Selection of objects in front, middle and back

 Typical selection tools

 Magic wand
 Lasso selection

 Selection by attributes
 Group and ungroup
 Isolation modes
 Resize images and angles
 Transformation Tools / Repeat Transformations
 Reflection and distortion
 Alignment and distribution of objects
 Editing paths and Bézier curves.

 Pen
 Add anchor point
 Delete anchor point
 Anchor point
 Curvature

 Editing and modifying paths

 Join and average paths
 Simplify
 Attributes of a stroke
 Rows and columns
 Compound paths
 Clipping mask
 Outline and move paths
 Draft
 Scissors
 Blade

 The brush and pencil tools, shaper, and adjustments

 Shaper
 Pencil
 Soften
 Stroke eraser

 Brushes and Creation

 Shading effects
 Pattern brush
 Ink strokes
 Special brushes
 Shading pen

 Working with symbols

 Symbol sprinkler
 Move symbol
 Gather and separate symbol
 Change symbol size
 Rotate symbol
 Stain symbol
 Translucent symbols
 Apply styles to symbols

 Color tools

 Fill and stroke.
 The color palette.
 The samples palette.
 Custom color libraries.
 Paint bucket and eyedropper tool.
 Color modification filters.
 Reasons.
 Degraded
 Interactive paint can
 Interactive painting selection

 Drawing geometric figures

 Drawing vector objects and properties

 Main geometric objects in ILLUSTRATOR

 Rectangle
 Ellipse
 Polygon
 Star
 Flash
 Arch
 Spiral
 Rectangular grid
 Polar grid
 Interactive vertices
 Shape Builder Tool

 Sector and perspective tools

 Sector
 Select sector
 Perspective grid
 Perspective selection

 Working with text

 Draw text with color and outline; font style
 Creating text boxes.
 Create text outline
 Custom text paths.
 The text editor.
 Flow text.
 Mask text.
 Use of text and brushes.
 Flattened text.
 Text
 Area text
 Text in path
 Vertical text
 Vertical area text
 Vertical text on path
 Retouch text

 Modification Tools.

 Rotate
 Reflect
 Climb
 Distort
 Reform
 Width
 Deform
 Windlass
 Pucker
 Gain weight
 Scallop
 Crystallize
 Wrinkle
 Free transformation
 Merger

- Effects and Expand

 Expand and Expand Appearance

 From ILLUSTRATOR

 3d
 Path effects (Pathfinder)
 Form conversion
 Stylization
 Applying filters
 Clipping mask

 From Photoshop

- Mesh management, merges and gradients

 Handling rounded meshes.
 Advanced mesh management.
 Mergers.
 Working with mergers: expand, invert, and drop.
 Gradients and gradient meshes.
 Merger examiner.
 Shadows of mergers.
 Unified gradients.

- Transparency and Appearance

 Handling transparencies.
 Opacity masks and coverage controls.
 The Appearance palette.
 Transparent colors.
 Basic flashes.
 Opacity masks.

- Review of pre-print features

 What should be done to design very large advertising works?
 Prepare folder for sending to the contracted printer
 Export as PDF.

Photoshop Editing and development based on mathematics

8.91 £ /h

Photoshop is an application that today sets the standard and will continue in the market thanks to its features. Many tutors may not find a starting point in teaching, but I have the technique of starting at the center of everything and that is photography. from the histogram approach, going through each corresponding adjustment and applying appropriate mathematical theory that prevents the user from having to arbitrarily use the controls in order to obtain a result. For this, it is essential to know about color, its characteristics, the representation of the same in their CMY tones, how each tone is represented with its saturation and luminosity values, this seeks to level a photo that, due to the use of RAW in the cameras or the non-calibration of their white balance, we have to perform manual techniques

Felipe

In my classes you will learn all about marketing strategy, controlling projects and advanced excell

Felipe

In my classes you will learn all about marketing strategy, controlling projects and advanced excell

Good-fit Instructor Guarantee

Contact Julian