facebook
FavouritesAdd to Wish List
FavouritesAdd to Wish List
from11.46GBP/ h

Data Analysis and Visualization Classes with Power BI

Translated by Google. Click to view original.
*Query Editor: Connecting our data to Power BI, cleaning and transforming our data, Exploring the different data sources in Power BI.
*Connections to data sources, Transformations with Power Query, Data Modeling and Visual Objects
*Data Modeling, Cross Filter Detail and Hierarchies - tooltips in visuals, Types of visuals and their properties.
*Visuals, Report Details, Tool Information
*DAX Functions - Measurements, Calculated Columns
*Folder Read, Combine queries with double column, Additional DAX functions
*Scatter Plot, Choropleth Map, Main Menu, Insert Buttons
*Visualization (Indicator Meter), Measurement Summary (Minimum, Maximum, Median, Average), Mobile Design, Import Visual Object
*Power BI Service Licenses License Comparison, Dashboard Publishing
*Connection, Power Query, Transformation, Calculated Fields, Measures, Visualizations, Bookmarks

Location

At student's location: Around Medellín, Colombia
Online via webcam

|
Use ⊞+wheel to zoom!
+

General info

Age:
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level:
Beginner
Intermediate
Advanced
Duration:
60 minutes
The class is taught in:Spanish, English

About Me

Translated by Google. Click to view original.
I am a Production Engineer with knowledge of Excel, SQL and Power Bi, the latter being a tool that tells us where the company is and what its areas of improvement are.

Basic, Intermediate and Advanced Excel classes and jobs, Power BI and SQL Server, Power Query, Power Pivot

Education

Translated by Google. Click to view original.
EAFIT University, University of Medellín, UPB

Basic Excel: Concepts, Data, Spreadsheets, Data Types, Insert, Cell Format, Basic Formulas, Print Design, Images, Hierarchy of Operations, Basic Statistical Functions, AutoFilters, etc.
Intermediate Excel: Basic Operations, Mathematical and Statistical Functions, Date and Time Functions, Logical Tests, If Function, Special and Advanced Functions, Advanced Filters, Data Validation, Conditional Formatting, Subtotals, Dynamic Tables and Charts, etc.
Advanced Excel: Logical and Nested Functions, Search and Reference Functions, Logical and Nested Search Functions, Set Functions, Data Tables, etc.

Experience / Qualifications

Translated by Google. Click to view original.
Information about Power BI classes:
*Query Editor: Connecting our data to Power BI, cleaning and transforming our data, Exploring the different data sources in Power BI.
*Connections to data sources, Transformations with Power Query, Data Modeling and Visual Objects
*Data Modeling, Cross Filter Detail and Hierarchies - tooltips in visuals, Types of visuals and their properties.
*Visuals, Report Details, Tool Information
*DAX Functions - Measurements, Calculated Columns
*Folder Read, Combine queries with double column, Additional DAX functions
*Scatter Plot, Choropleth Map, Main Menu, Insert Buttons
*Visualization (Indicator Meter), Measurement Summary (Minimum, Maximum, Median, Average), Mobile Design, Import Visual Object
*Power BI Service Licenses License Comparison, Dashboard Publishing
*Connection, Power Query, Transformation, Calculated Fields, Measures, Visualizations, Bookmarks

Information about SQL Server classes:
*When Excel is sometimes insufficient for managing Databases, it is necessary to use other types of programs such as SQL Server to carry out processes from both applications and speed up information transformations.
*Databases in Excel
*Database theory
*Databases in SQL Server

Reviews (1)

Patient and very good at explaining things as plainly as possible.
Translated by Google. Click to view original.
Basic Excel: Concepts, Data, Spreadsheets, Data Types, Insert, Cell Format, Basic Formulas, Print Design, Images, Hierarchy of Operations, Basic Statistical Functions, AutoFilters, etc. Intermediate Excel: Basic Operations, Mathematical and Statistical Functions, Date and Time Functions, Logical Tests, If Function, Special and Advanced Functions, Advanced Filters, Data Validation, Conditional Formatting, Subtotals, Dynamic Tables and Charts, etc. Advanced Excel: Logical and Nested Functions, Search and Reference Functions, Logical and Nested Search Functions, Set Functions, Data Tables, etc. Medellin Colombia

Ask a question

Send a message explaining your needs and Cristian will reply soon:
The more detail, the better.
Ex. "Hi, when are you available to meet for a lesson?"

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6              
7              
8              
9              
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12            Saturday at 12:00  Sunday at 12:00
13            Saturday at 13:00  Sunday at 13:00
14            Saturday at 14:00  Sunday at 14:00
15            Saturday at 15:00  Sunday at 15:00
16            Saturday at 16:00  Sunday at 16:00
17            Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday at 21:00  Saturday at 21:00  Sunday at 21:00
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23              
from £11.46Online via webcam
from £11.46At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Online reputation

  • Instructor since May 2021
  • Phone number verified
  • Google connected

Availability of a typical week

(GMT -05:00) New York
MonTueWedThuFriSatSun
0              
1              
2              
3              
4              
5              
6              
7              
8              
9              
10            Saturday at 10:00  Sunday at 10:00
11            Saturday at 11:00  Sunday at 11:00
12            Saturday at 12:00  Sunday at 12:00
13            Saturday at 13:00  Sunday at 13:00
14            Saturday at 14:00  Sunday at 14:00
15            Saturday at 15:00  Sunday at 15:00
16            Saturday at 16:00  Sunday at 16:00
17            Saturday at 17:00  Sunday at 17:00
18  Monday at 18:00  Tuesday at 18:00  Wednesday at 18:00  Thursday at 18:00  Friday at 18:00  Saturday at 18:00  Sunday at 18:00
19  Monday at 19:00  Tuesday at 19:00  Wednesday at 19:00  Thursday at 19:00  Friday at 19:00  Saturday at 19:00  Sunday at 19:00
20  Monday at 20:00  Tuesday at 20:00  Wednesday at 20:00  Thursday at 20:00  Friday at 20:00  Saturday at 20:00  Sunday at 20:00
21  Monday at 21:00  Tuesday at 21:00  Wednesday at 21:00  Thursday at 21:00  Friday at 21:00  Saturday at 21:00  Sunday at 21:00
22  Monday at 22:00  Tuesday at 22:00  Wednesday at 22:00  Thursday at 22:00  Friday at 22:00  Saturday at 22:00  Sunday at 22:00
23              
from £11.46Online via webcam
from £11.46At student's home

Good-fit Instructor Guarantee


If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.

Share

You are here


Anas
SAP Introduction Training (hands-on training) / Remote training
_*IMPORTANT*_ It will depend on how fast you learn, but you should allow at least 3 hours for a quick start. Here is the proposed program: I) What is SAP? * Introduction to SAP (ECC) * The main functions of SAP * SAP architecture * Structure and organizational data * Overview of SAP functional modules (FI, SD, MM, PP etc.) II) SAP : Getting Started * Navigating the SAP system * Logging in and out * Presentation of the home screen * Organization of SAP screen (fields, tabs, tables...) * Use of the data search functions * How to navigate in SAP * Transaction system * Examples of flows

David
Training and assistance in IT and use of personal computers
Using a computer and these applications can be complicated for some and I therefore offer training to those who need it. This training includes basic and advanced use of Windows computers and/or Mac OS (Apple) multiple applications such as the MS-Office suite (Word, Powerpoint, Excel etc.), Teams, Outlook etc... Being a graduate with more than 20 years of experience at different levels in the field, it is possible to approach different levels of complexity from beginner to expert in Microsoft/Windows and/or Apple/MacOS/IOS environments. Do not hesitate to contact me and I will be happy to answer your questions. David

Stepan
Information Technology, System/Business Analytics and Programming
We can work on one or more following topics: Information Systems and classes Business and System Analytics Business Process Modeling, gathering Requirements, Test Plans, Architecture and other IT documentation\ IT Infrastructure Databases C#, Java, SQL for beginners Python for beginners: syntax, simple algorithms, file processing, game dev for beginners

Miriam
Cours de Comptabilité & Gestion & Cost accounting , Économie (Micro & Macro) et Informatique (IT): 1er cours gratuit
Passionate bachelor student offering expert tutoring in accounting, economics, and IT on Apprentus.com. Unlock the complexities of these subjects with my advanced knowledge, tailored to help you succeed. Elevate your understanding and excel in your coursework with personalized guidance from a dedicated and knowledgeable tutor. Book a session now to embark on a journey of academic excellence! The initial 45-minute session comes at no charge!

Carlos Andrés Medina
Cambridge IGCSE ICT 0417 Preparation - Information and Communication Technology
Cambridge IGCSE Information and Communication Technologies (0417) Curriculum Summary: Students develop an understanding of the implications of technology on society and the ways in which Information and Communication Technologies (ICT) can help at home, at work and in the wider world. Through practical and theoretical studies, students solve problems using a variety of common software such as word processors and interactive presentation software. Students will analyze, design, implement, test and evaluate ICT systems, ensuring they are fit for purpose. Emphasis is placed on developing lifelong skills, which are essential throughout the curriculum and in your future career. Cambridge IGCSE Information and Communication Technology (0417) Syllabus overview Students develop an understanding of the implications of technology in society and the ways Information and Communication Technology (ICT) can help at home, work and the wider world. Through practical and theoretical studies, students solve problems using a variety of common software such as word processors and interactive presentation software. Learners will analyze, design, implement, test and evaluate ICT systems, making sure that they are fit for purpose. There is an emphasis on developing lifelong skills, which are essential across the curriculum and their future career.

Amy
Lets Get Organised! Unlocking Your Data: Airtable for beginners - discover the magic of databases and project management without the stress!
Discover the Magic of Airtable: A Beginner's Guide to Database Bliss! Hey there! Are you intrigued by the idea of organising your life or business with a database tool but feel overwhelmed by the tech jargon? Don't worry, I've got your back! Join me for a laid-back class where we'll demystify the world of databases, starting with everyone's favourite: Airtable the no-coding needed database platform. I can show you the ropes of Airtable no need for fancy degrees or prior experience - just bring your curiosity and a willingness to learn! What's on the agenda, you ask? Well, we'll kick things off by getting cozy with the Airtable interface, so you can navigate like a pro in no time. Then, it's time to roll up our sleeves and dive into the juicy stuff: creating your own custom databases! Potential uses of Airtable bespoke creation: - Personal Task Management - Event Planning - Inventory Management - Content Calendar - Customer Relationship Management (CRM) - Project Management - Habit Tracking - Budgeting and Expense Tracking But hey, don't sweat it if you're not sure what kind of database you need. Whether you're a freelancer, small business owner, or just someone trying to keep track of your life admin, I'll help you brainstorm ideas and tailor your database to fit your unique needs. From managing contacts to tracking projects or even organizing your collection of cat memes (we don't judge!), Airtable's got you. And the best part? I can show you how to do it all without pulling your hair out in frustration! So, if you're ready to kick your spreadsheet game up a notch and embrace the zen of organized data, grab a spot with a class and let's get this database party started!

Samir
IBM Cognos Report Writer Basics. Creating and Designing reports
Cognos report Studio is a web-based application designed to allow users to easily create complex reports utilizing many different sources of data. The purpose of this training guide is to introduce Report Studio. The course objectives are: • Access Report Studio • Identify key areas in Cognos Consumer • Explore Report Studio • Build and format queries in Report Studio

Hafizou
Certification Audit of Information Systems CISA (Certified Information System Auditor)
The main goal of this training is to prepare you in the best possible conditions to successfully pass the CISA certification. It will give you the skills to lead and control corporate IT and perform an effective security audit on any organization. You gain expertise in the acquisition, development, testing and implementation of information systems and you will learn the guidelines, standards and best practices to protect them.

Professeur
Programming courses for beginners: Introducing young people to the fundamentals of programming
Course description: Title: Programming course for beginners Duration: 8 weeks (16 sessions of 2 hours each) Description: This programming course for beginners is designed for average students who want to learn the solid foundation of programming. Whether you are interested in Python, JavaScript, HTML, CSS or PHP, this course will provide you with the essential knowledge to create your own programs and applications. Through clear explanations, real-world examples and practical exercises, you will develop your understanding of key programming concepts and be able to apply this knowledge in real-world projects. Lesson Plan : Week 1-2: Introduction to programming and fundamental concepts - Presentation of programming languages (Python, JavaScript, HTML, CSS, PHP) - Understand variables, data types and basic operations - Introduction to control structures (loops, conditions) - The functions and organization of the code Week 3-4: Object Oriented Programming - Understand the basic concepts of object-oriented programming - Creation of classes and objects - Using attributes and methods Week 5-6: Web development - Introduction to HTML and CSS - Creation of static web pages - Using JavaScript to interact with page elements Week 7-8: Applications and projects - Using Python, JavaScript, HTML, CSS or PHP to create simple programs and applications - Creation of a final project to put into practice all the skills acquired Each session will include a theoretical part followed by practical exercises to consolidate the concepts covered. You will also be encouraged to ask questions and work on personal projects to reinforce your learning. Join this exciting course and develop your programming skills, you'll be ready to create your own programs and applications in no time!

Dr Zeeshan
Ethical Hacking and Penetration Testing in 4 Weeks
Objective: Equip students with foundational skills in ethical hacking and penetration testing to secure web applications, focusing on open-source tools and DVWA (Damn Vulnerable Web Application). (Capstone Project: Website Penetration Testing Report) Throughout the weeks, students will work on a capstone project where they will perform a comprehensive penetration test on a simulated website using DVWA. They will document their findings, create detailed reports, and suggest mitigation strategies. This project will be their portfolio piece to showcase their skills. 1. Week 1: Introduction to Information Security - Topics covered: Cybersecurity Fundamentals, Introduction to Ethical Hacking, Basic Network Security, Introduction to Cryptography, Practical Cybersecurity Tips 2. Week 2: Introduction to Ethical Hacking - Topics covered: Orientation and Course Overview, Setting Up a Virtual Lab, Key Tools and Software, Network Security Basics, Identifying Common Vulnerabilities, Exploring common network vulnerabilities, Hands-on practice with vulnerability scanning using OpenVAS. 3. Week 3: Website Penetration Testing Fundamentals with DVWA - Topics covered: Website Architecture, Overview of how websites function, Introduction to client-server model and HTTP/HTTPS, Setting Up DVWA, Installing and configuring DVWA, Understanding the purpose and use of DVWA in penetration testing, SQL Injection with DVWA, Understanding SQL injection attacks, Practicing SQL injection techniques and defences using DVWA, Cross-Site Scripting (XSS) with DVWA, Understanding XSS attacks, Practising XSS techniques and defences using DVWA, Hands-on OWASP Top 10 with DVWA, Detailed exploration of the OWASP Top 10 vulnerabilities, Practical exercises to identify and exploit vulnerabilities using DVWA 4. Week 4: Advanced Penetration Testing Techniques - Topics covered: Advanced Exploitation Techniques, Techniques for privilege escalation, Using Metasploit for advanced exploitation, Social Engineering Attack, Understanding social engineering, Practical examples of phishing and other attacks, Reporting and Documenting Findings, Importance of documentation in penetration testing, How to create detailed and professional reports, Ethical Considerations and Legal Aspects, Understanding the ethics of hacking, Legal implications and compliance, Project Presentation and Feedback, Students present their penetration testing report, Personalized feedback and improvement tips. --- At the end of the 4 weeks, • Students will have beginner-to-advanced knowledge about ethical hacking and penetration testing using open-source tools and DVWA. • Students will have enhanced professional writing skills, and technical documentation skills along with research skills. • Students will have a capstone project which will serve as a significant portfolio piece, demonstrating their practical skills and readiness for the cybersecurity job market

Dr. Saeed
Calculus calculus for students of the faculties of computers and information and faculties of artificial intelligence
Explain the lessons of finite and infinite calculus with applications on calculus Explanation of Diff & Integral. Applications on calculus. Are and volume calculations for solids boundaries by curves In an easy and simplified way, with the solution of the examples mentioned in the previous exams and Assignments & Quizzes

Issamo
FORTINET NSE6 fortiweb web application firewall administration
Fortiweb and the FORTINET web application firewall which protects your application against sql injection attacks, cross site script, ... During this course, we will learn the configuration of fortiweb to protect WEB servers either with http or https

Casper
Computer science, Internet security and computer skills
Answer to the many questions related to information technology. Want to know how something works, or how you can prevent something. You have come to the right place, I can teach you in all areas of information technology. Below you see several questions to which I can give you a clear and straightforward answer. I can explain this to you at any level and we can go deep where you want it. Is your question not listed? Let me know. There are simply too many questions to write here. How does the internet work? How does a computer network work? What is a DHCP server and how does DNS work? How do I keep my identity hidden online? What are cookies? What does my computer store? How does the Wehkamp site know that I like those pants? How does Excel work? and Word? and Powerpoint? What is a router? How does WiFi work and can my neighbor on my network? Do I have a strong password? What is hacking? How does a computer virus and ransomware work? How does a firewall work? What is blockchain? I teach at different levels, if you are interested you can always send an email without obligation with your question. We can then make a personal study plan. My specialization is internet security, but I got there by gaining knowledge within all facets of information technology. From system administration, network management and explaining the various functions in Windows or IOS to repairing the hardware of a PC. I studied business informatics at the Hogeschool van Amsterdam. Nowadays I live on Curacao, but I can give great lessons via webcam. And through the possible use of team viewer or G + I can show on your computer how to configure a router, for example. Nothing is impossible ;-)

Peter
Work at home in project form for school or association sharing in Google Drive.
I am very adept at working optimally with Google apps. These are free and ideal for sharing files. In class you will learn to use and share basic apps. The nk to Word and Excel, but from Google which is simpler. Version management and sharing with others is very clear, this is understandable for everyone. During the lesson you carry out the steps and then you organize it further for yourself. In the further sequel you create your own cash book or survey in the spreadsheet. Clearly grouping in your own dashboard is almost automatic, I help you with that. I teach you to use all this on a phone, laptop or tablet.

Antoine
Private course in computer science / programming all levels
I am currently studying computer science, and soon have a DUT in this field. I have a BAC S option Engineering Sciences option physics-chemistry mention ENOUGH WELL. I offer my services to give computer courses at all levels. From the simple basic Windows user to the experienced programmer, I can teach the use of the Windows system for beginners and the following languages for (future) developers: - system languages: Batch, Bash - Languages for PC: C, C #, Java (multi platform). - Web Back languages: PHP5 (procedural and object) - Lanages: HTML5, CSS, Javascript, and Jquery I can also teach the database: Merise Modeling (Conceptual Data Model, Logical Data Model, and Physical Data Model (SQL)). I can teach you UML modeling (Diagram of use cases, sequences, classes), which is useful for a functional specification. I also have a car so I can move around. My availability for lessons is Friday afternoon, Saturday and Sunday all day until July 1, and every day from July 1 to August 31. You can contact me for more information.