Data Analytics Course with Microsoft Certification

Professional Excel

MODULE 1: BASIC EXCEL FEATURES AND FUNCTIONALITY PART 1
MODULE 2: BASIC AND INTERMEDIATE EXCEL FEATURES AND FUNCTIONALITY PART 2
MODULE 3: NUMBER FUNCTION
MODULE 4: LOGICAL AND SUMPRODUCT FUNCTIONS
MODULE 5: TEXT FUNCTIONS IN EXCEL TO SOLVE COMPLEX TEXT PROBLEMS
MODULE 6: DATE AND TIME FUNCTIONS IN EXCEL, CREATING A DYNAMIC CALENDAR FOR WHOLE MONTHS AND YEARS
MODULE 7: LOOKUP, VLOOKUP, HLOOKUP FUNCTIONS
MODULE 8: INDEX AND OFFSET FUNCTION, USES OF ARRAY IN EXCEL
MODULE 9: INDIRECT AND ADDRESS FUNCTION
MODULE 10: DATA ANALYSIS USING POWER QUERY AND POWER PIVOT IN MICROSOFT EXCEL
MODULE 11: MIS REPORTS AND DASHBOARDS
MODULE 12: CREATING DYNAMIC DASHBOARD ON LIVE DATA

MODULE 1: INTRODUCTION
MODULE 2: PYTHON SCRIPTS EXECUTION
MODULE 3: VARIABLES AND GENERAL DATATYPES IN PYTHON
MODULE 4: TYPE CASTING, LITERALS AND COMMENTS
MODULE 5: ACCEPTING INPUTS
MODULE 6: BREAK, CONTINUE AND PASS KEYWORDS IN LOOP
MODULE 7: INDEXING, SLICING AND SPECIAL DATATYPES
MODULE 8: FUNCTIONS AND MODULES
MODULE 9: PACKAGES AND FILES
MODULE 10: OOPS
MODULE 11: INTERFACES
MODULE 12: INSTALLING PREDEFINED MODULES
MODULE 13: CONSTRUCTORS AND DESTRUCTORS
MODULE 14: GARBAGE COLLECTORS AND EXCEPTIONS
MODULE 15: LAMBDA, MAP, FILTER FUNCTIONS AND COMMAND LINE ARGUMENTS
MODULE 16: DATABASE CONNECTIVITY
MODULE 17: PYTHON AND MYSQL
MODULE 18: MULTI THREADING
MODULE 19: PROJECT WORK

MODULE 1: INTRODUCTION TO RDBMS AND MICROSOFT SQL SERVER
MODULE 2: CREATING TABLES, DATABASES AND IMPORTING AND EXPORTING DATA
MODULE 3: SQL CONSTRAINTS AND DATA TYPES
MODULE 4: SELECT STATEMENT AND WORKING WITH SORTING AND FILTERING DATA
MODULE 5: WORKING WITH MULTIPLE TABLES USING JOIN CONCEPT
MODULE 6: USING DML TO MODIFY DATA
MODULE 7: USING BUILT IN FUNCTIONS
MODULE 8: USING SUBQUERIES CONCEPTS AND TABLE EXPRESSIONS
MODULE 9: USING SET OPERATORS AND WINDOWS RANKING, AND AGGREGATE FUNCTIONS
MODULE 11: WORKING WITH USER DEFINED FUNCTIONS
MODULE 12: APPLYING ERROR HANDLING CONCEPT IN T SQL PROGRAMMING
MODULE 13: CONCEPT OF CURSOR AND INDEX
MODULE 14: PERFORMANCE TUNING

MODULE 1: INTRODUCTION TO POWER BI
MODULE 2: DATA LOADING IN POWER BI
MODULE 3: DATA TRANSFORMATION 1
MODULE 4: DATA TRANSFORMATION 2
MODULE 5: DATA MODELING 1
MODULE 6: DATA MODELING 2
MODULE 7: POWER BI VISUALIZATION 1
MODULE 8: POWER BI VISUALIZATION 3
MODULE 9: POWER BI SERVICE 1
MODULE 10: POWER BI SERVICE 2
MODULE 11: DAX 1
MODULE 12: DAX DATE AND TIME INTELLIGENCE
MODULE 13: PROJECT & DISCUSSION (Q&A)

MODULE 1. EXPLORE CORE DATA CONCEPTS
MODULE 2. EXPLORE RELATIONAL DATA IN AZURE
MODULE 3. EXPLORE NON-RELATIONAL DATA IN AZURE
MODULE 4. EXPLORE MODERN DATA WAREHOUSE ANALYTICS

Upcoming Batches

28-Sep-2024

8:00 PM

Weekend Batch (2 Hours Sat & Sun)

Apply

₹28320 ₹19824 (30% OFF)

Offer Ends in 9 d: 23h : : 34s

Mr. Hussain

Mr Hussain was working in semi technical domain and he wanted to make his career in IT field. He tried many times but due to wrong approach he was not able to get it. Somehow he came to know about our Data Analytics training program. He joined our Data Analytics program. Even he did not finish his training and during training period he got selected in JCI (Johnson & control International) with the package of 16 LPA.

Mr. Amit Bhardwaj

Although he is from non- IT background .After losing his job during Covid pandemic, he has been trying to get it since a long time but unfortunately was not able to get any opportunity. He got to know about Wifi Learning Data Analytics program through internet. He joined this program and fortunately after completion of only 3 modules he cracked two different interviews and he joined E&Y with 11LPA. We as a team Wifi Learning wishing him a great career ahead.

Mr. Mukul

Mr. Mukul was working as a MIS Executive since a long time but his goal was to make his career as a Data Analyst. Due to limited skill sets he was not able to get opportunity. He came to know about Wifi Learning and it’s Data Analytics program through his friend. He joined this program and just after completion of his training, he got placed in Infosys at 20 LPA.

Ms. Bindu

Ms. Bindu was working in Wonderman Thompson at gurgaon location due to some personal reasons she had been trying to relocate to Chennai location but due to market recession and all she could not get any opportunity. She joined our Data Analytics training program in February 2023. Even her training was not completed and she got a very good opportunity in IQ India at her preferred location Chennai with the salary package of 18 LPA.

Our Google Reviews

We are delighted to share our recent Google review, which serves as a testament to the exceptional experiences we provide to our valued customers. This glowing review reflects the dedication and hard work of our entire team. Our commitment to delivering top-notch products/services and outstanding customer service is truly paying off, as evidenced by the kind words and five-star rating we received.

Data Analytics with 100% Assured Placement

Learn from Industry Experts

Weekdays / Weekend batches available

Get 100% placement assistance

Special batches for job seekers

Students

Placement

Start Date

Program Details

Key Features of the Course

Syllabus

Professional Excel

Python

Microsoft SQL Server

Microsoft Power BI

Introduction to Tableau

Microsoft Azure Data Fundamentals

Mentors

Shivam Bhatiya

Shiv

Course Details

FEE:

Online Virtual Class Room

Upcoming Batches

Learning Methodology

Step 1

Step 2

Step 3

Step 4

Step 5

Industry Recognized Certification

Success Stories of our Alumni

Mr. Hussain

Mr. Amit Bhardwaj

Mr. Mukul

Ms. Bindu

Mr Amit Bhardwaj

Mr Mukesh Kumar

Application Process

Step 1

Submit an application

Step 2

Application Review

Step 3

Admission

Our Google Reviews

Reach Out to Us

Fill the form so that we can solve your query or concern

Corporate Training Partners

Our Alumni Work At

Download Brochure

Enter your details to download the brochure

Login

Sign in With Google

Forgot Password

Create an Account

Job Applying