Career Path - IT Consultant
Become IT Consultant with mastery over trending in-demand technologies starting from MS Excel & Google Sheets to Business Intelligence to SQL & Azure.Preview Career Path - IT Consultant course
Price Match Guarantee Full Lifetime Access Access on any Device Technical Support Secure Checkout   Course Completion Certificate- 80% Started a new career
BUY THIS COURSE (
USD 45 USD 139 ) - 93% Got a pay increase and promotion
Students also bought -
- Career Path - Product Owner
- 100 Hours
- USD 45
- 416 Learners
- Bundle Course - Programming Languages
- 250 Hours
- USD 31
- 2454 Learners
- Premium Career Track - Chief Technology Officer (CTO)
- 1000 Hours
- USD 55
- 5214 Learners
Courses included in IT Consultant Career Path Program are:
1).Project Management Fundamentals
2).Microsoft Project
3).MS Excel
4).Google Sheets
5).Business Intelligence & Analytics
6).Tableau
7).Power BI
8).SQL Programming
9).API Design
10).Microsoft Azure
The IT Consultant experts are required to know exactly how everything works and what is going on in the world of IT and telecommunications. They make sure that companies have the correct IT systems to meet their business needs and when inevitable glitches or mistakes occur, they know what needs to be done to allow businesses to get back on track.
The specialist advice that IT management consultants provide can focus on anything from software provision, systems design and analysis, to resolving information security needs, application architecture, or hardware implementation. However, in order to provide solutions to any IT issue, a huge bank of specialist information is required. That’s why most consultants specialize in certain aspects of IT consultancy and become industry experts in those specific areas.
IT consulting careers are heavily focused on the technical side of working with computers, networks, and IT systems. However, these careers also require people to have an in-depth understanding of the business side of things too. With this in mind, you will need to have a broad range of skills in order to assist your clients as accurately and effectively as possible.
This IT Consultant career path program by Uplatz is a great step towards becoming an IT Consultant gaining solid knowledge in technology and software engineering along with project management skills.
Course/Topic 1 - Project Management Fundamentals - all lectures
-
In this first video tutorial on Project Management, you will learn an Introduction to Project Management, its history, benefits, an illustration to Gantt Chart, a view on some of the International standards of practicing Project Management, an overview of what exactly is a project, its relationship with General Project Management practices, Triple Constraints Theory and the role of a Project Manager and its characteristics in Project Management.
-
In this second session of Project Management, you will understand what is Process Oriented Project Management, Project Processes and its categories, what is Project Management and Product Oriented processes and an overview of different process groups and its knowledge areas.
-
In this lecture, you will learn what is a process in Project Management and its different stages in a Project Life cycle, how a process is linked to different process groups. Also, you will learn about the different Knowledge Areas related to a Process in Project Management.
-
In this video, you will learn about the Project Planning Process and Group Processes and the different processes involved in managing the Scope and Scheduled Constraints.
-
In this last session on Project Management Fundamentals, you will learn about the different constraints involved like Cost, Quality, Resources, Risks, etc. in a Process Group and how it helps in managing the entire project in Project Management.
Course/Topic 2 - Microsoft Project - all topics
-
Lecture 1 - Getting Started with Microsoft Project
-
Lecture 2 - Backstage
-
Lecture 3 - Modifying Project Information
-
Lecture 4 - Views and Tables
-
Lecture 5 - Preparation
-
Lecture 6 - Tasks
-
Lecture 7 - Task Notes
-
Lecture 8 - Work Resources
-
Lecture 9 - Material and Cost Resources
-
10 - Calendar Work Resource
Course/Topic 3 - Microsoft Project (basic to advanced) - all lectures
-
Lecture 1 - Overview of Microsoft Project
-
Lecture 2 - The Stage
-
Lecture 3 - The Back Stage
-
Lecture 4 - Views and Tables in MSP
-
Lecture 5 - Project Initiation - part 1
-
Lecture 6 - Project Initiation - part 2
-
Lecture 7 - Tasks and Milestones
-
Lecture 8 - Linking Tasks
-
Lecture 9 - More on Linking Tasks
-
Lecture 10 - Creating Resources
-
Lecture 11 - Creating Resources - advanced
-
Lecture 12 - Assigning Resources
-
Lecture 13 - Applying Cost Tables
-
Lecture 14 - Units Work Duration
-
Lecture 15 - Handy Features - revised
-
Lecture 16 - Critical Path Identification
-
Lecture 17 - Resource Leveling
-
Lecture 18 - Baselining
-
Lecture 19 - Updating Project - part 1
-
Lecture 20 - Updating Project - part 2
-
Lecture 21 - Updating Project - part 3
-
Lecture 22 - Monitoring
-
Lecture 23 - Controlling - part 1
-
Lecture 24 - Controlling - part 2
-
Lecture 25 - Reports Pack
-
Lecture 26 - Support EVM
Course/Topic 4 - Microsoft Excel - all lectures
-
Lecture 1 - Introduction to Microsoft Excel
-
Lecture 2 - Key in Data
-
Lecture 3 - Font and Alignment
-
Lecture 4 - Cut Paste and Format Painter
-
Lecture 5 - Control plus Keys
-
Lecture 6 - Home Commands and Clipboard
-
Lecture 7 - File Tab
-
Lecture 8 - Sorting and Filtering
-
Lecture 9.1 - Basic Formulas
-
Lecture 9.2 - Text Formulas
-
Lecture 10.1 - VLookup - part 1
-
Lecture 10.2 - VLookup - part 2
-
Lecture 10.3 - HLookup
-
Lecture 10.4 - This is a bonus session on Vlookup from a different tutor
-
Lecture 10.5 - This is a bonus session on Vlookup from a different tutor
-
Lecture 11.1 - Pivot Tables - part 1
-
Lecture 11.2 - Pivot Tables - part 2
-
Lecture 11.3 - Pivot Tables - part 3
-
Lecture 11.4 - Pivot Tables - part 4
-
Lecture 12.1 - Charts - part 1
-
Lecture 12.2 - Charts - part 2
-
Lecture 12.3 - Column Charts
-
Lecture 12.4 - Bar Charts
-
Lecture 12.5 - Line Charts
Course/Topic 5 - Google Sheets course - all lectures
-
Lesson 1 - Introduction to Google Sheets
-
Lesson 2 - Menu Options - File
-
Lesson 3 - Menu Options - Edit
-
Lesson 4 - Menu Options - View
-
Lesson 5 - Menu Options - Insert
-
Lesson 6 - Menu Options - Format
-
Lesson 7 - Menu Options - Data and more
-
Lesson 8 - Entering Data and Editing
-
Lesson 9 - Functions - Numeric Function
-
Lesson 10 - Functions - Text Function
-
Lesson 11 - Functions - Date Functions
-
Lesson 12 - Charts and Conditional Formatting
-
Lesson 13 - Pivot Tables
-
Lesson 14 - Saving - Sharing
Course/Topic 6 - Business Intelligence Specialization - all lectures
-
In this lecture session we learn about basic introduction to business intelligence and also talk about factors of business intelligence in brief.
-
In this tutorial we learn about business Intelligence, as a technological concept, which began shortly after the 1988 international conference, The Multiway Data Analysis Consortium, held in Rome. The conclusions reached at this conference jump-started efforts for simplifying BI analysis, while making it more user-friendly.
-
In this lecture session we learn about The general process of business intelligence is as follows: Gathering data and organizing it through reporting. Turning it into meaningful information through analysis. Making actionable decisions aimed at fulfilling a strategic goal.
-
In this lecture session we learn that Data Warehousing may be defined as a collection of corporate information and data derived from operational systems and external data sources and also talk about features of data warehousing.
-
In this lecture session we learn about Business intelligence (BI) combines business analytics, data mining, data visualization, data tools and infrastructure, and best practices to help organizations to make more data-driven decisions.
-
In this tutorial we learn about Apache HTTP Server is a free and open-source web server that delivers web content through the internet. It is commonly referred to as Apache and after development, it quickly became the most popular HTTP client on the web.
-
In this lecture session we learn about NoSQL is an approach to database management that can accommodate a wide variety of data models, including key-value, document, columnar and graph formats. A NoSQL database generally means that it is non-relational, distributed, flexible and scalable.
-