Nearpeer | Pakistan’s Most Trusted Online Education Platform

Rs. 15000

Need promo code?

This course includes

Videos : 38

Mod 0 Introduction and orientations

1 - Orientation

Ai & Data Analytics HOC Orientation
12 min

2 - FAQs

AI&Data Analytics Model Paper & Exam Pattren Explained
9 min

Mod 1 Introduction to Power BI and Basic Visuals

1 - Videos

Video 1 Why Power BI and How to Install
7 min
Video 2 Start, Load and Go (Making Table and Matrix)
20 min
Video 3 Visual Formattings, Numbers formatting, Cards Visuals, AI in BI via QA
22 min
Video 4 Bar Charts (All variations) and Slicers Basics
24 min
Video 5 Line Charts Area Charts Multiple Axis and
25 min
Video 6 Ribbon, Pie, Donut, Treemap and Filled maps
24 min
Video 7 Power Platform, Basic Data Transformation, waterfell, funnel and scatter chart
21 min

Mod 2 Data Loading and Transformation in Power Query

1 - Video

Video 1 Loading Data from Different Sources
14 min
Video 2 Data Transformation Colum Split and Merge
26 min
Video 3 Replace, Text based , Unpivot and Practice Example
27 min
Video 4 Merging sheets from a Workbook
19 min
Video 5 Merging Workbooks in same folders and append rule
18 min
Video 6 Adding New Columns and time date functions
18 min
Video 7 Group by Function in Power query Basic and Advance
22 min
Video 8 Merge Queries (Full outer, Left Outer, Right outer, Inner and antis joins) & Fuzzy Matching
27 min
Video 9 Add Columns (index, Duplicate, Custom Column)
24 min
Video 10 Column from Example and Date issues
19 min

Mod 3 Data Modelling in Powrer BI

1 - Video

Video 1 Data Modeling and why we do it (DB Basics, Quantum of data, Normalized vs Denormalized)
19 min
Video 2 Data Modeling and building relationship in Star Schema
21 min
Video 3 Auto Detect Relation and Introduction to DAX
25 min
Video 4 DAX Multiline, Double operators, IF and Nested IF
30 min
Video 5 Adding Calculated Tables
25 min
Video 6 Introduction to the Measures
22 min

1 - Videos

Video 1 Time Intelligence MTD, WTD, DTD, YTD and SameperiodLastYear
26 min
Video 2 Time Intelligence Comparatives, ParallelPeriods, SOM,EOM, previous period and next period
20 min
Video 3 Applying filters in calculate Function and ignoring other filters (HD)
20 min
Video 4 Adding Tables with filters and conditional counts (HD)
16 min
Video 5 SWITCH, SELECTEDVALE, ISINSCOPE and Excluding totals from measures (HD)
30 min
Video 6 SWITCH SELECTEDVALUE and external slicers
17 min
Video 7 Add Tables using ADDCOLUMNS with FILTER function and SUMMARIZE
23 min

1- Videos

Video 1 Field Parameters ( X and Y axis, Ordering, Drill Through and Exand all)
22 min
Video 2 Conditional Formatting 1(Table Gradient, Font colors, Bars & Sparklines)
16 min
Video 3 Conditional Formatting 2 (Heatmap, Icons based on rules)
15 min
Video 4 Drill through and Updating sources of Data
16 min

Mod 7 Python for Data Description

1 - videos

Video 1 Why we need to study PYTHON and what is it
9 min
Video 2 Starting the PYTHON in Jupyter Notebook
9 min

Videos : 38

HOW TO PAY ?

Course Content

46+ students are Recommending this Course

Frequently Asked Questions

Nearpeer is an online education platform (Ed-Tech) that offers wide varaitey of online courses. These courses range from Fsc, MDCAT, ECAT, SAT, CA, ACCA, CSS, and many others. Nearpeer is the best online course offering platform in Pakistan.

Nearpeer offers wide variety of online courses including: Fsc, MDCAT, CSS, SAT, and CA. These courses are being offered as full-fledge programs that ensures students’ success. These programs are designed by experienced educators with the help of the best instructors available in the market.

Nearpeer is the best online education platfrom in Pakistan. If you want to pass your exams with amazing grades, you should study from Nearpeer. The amazing tools like MDCAT score predictor, AI Chat Bot, and AI assignments are very helpful for giving you a necessary edge to out-perform in any exam.

There are more than 500,000+ students studying at Nearpeer with total enrollments above 3 Million at the end of 2023. This large student body is a sufficient proof of the quality content and trustworthiness of Nearpeer as an established Ed-Tech Platform.

Nearpeer courses are priced anywhere between 2000 Rs to maximum of 15000 RS. You get acccess to a course till your exam date and all of the relevant material is acessible by paying the course price. There are numerous scholarships and discounts available for deserving students. So, feel free to contact to our couselors for more details.

Yes, Nearpeer courses are offered as complete preparation program and they are sufficient for your preparation. These courses are being offered by the best instructors of the market. These courses are very comprehensive and designed to focus on the exam preparation.

You can download (offline store) Nearpeer videos in your android and iOS Applications. Simply, go to any course module or video and click on the download icon. Once downloaded, your videos will appear in the “Download Section” of the application.

Nearpeer accepts all commonly used payment methods like Easypassia, Jazzcash, Debit/Credit cards, and direct bank payments. You can find more details on the payment page. We are even offering Buy-now-pay-later services to our students.

Nearpeer has been rated the best online education Platfrom in Pakistan. This rating is a result of our hardwork to provide quality education at an extreme low price. We are always pushing ourselves to offer better services to our students.

Student can access Nearpeer through internet anywhere, but our head office is in Lahore, Punjab. We recommend our students to get in contact with us at 03111444734 before visiting the office so that we can arrange the relevant personals for their assistance.

If you follow Nearpeer’s recommended study plan, your success is guaranteed. We have seen students improving their scores by whopping 60% only when they followed our recommended plan. We have knowledge and experties in Test Preparations and our plan always work for our students. Our recipe includes: Smart Preparation plan, Hardwork, and focus on Practice.

Yes. Nearpeer has incorporated AI at its core. Our services like MDCAT Score Predictor, AI Chat BOT, AI Assignemnts, and AI Quizzes are few of the amazing educational AI tools that we have developed. Nearpeer strongly believes in utilizing the power of AI in making educational accessible and scalable for students across the globe.

00 AI AND DATA ANALYTICS HOC BY SIR JAHANZAIB

By Muhammad Jahanzaib Khan

Enrollments : 46 Students

Rs. 15000

Need promo code?

This course includes

Videos : 38

Mod 0 Introduction and orientations

1 - Orientation

Ai & Data Analytics HOC Orientation
12 min

2 - FAQs

AI&Data Analytics Model Paper & Exam Pattren Explained
9 min

Mod 1 Introduction to Power BI and Basic Visuals

1 - Videos

Video 1 Why Power BI and How to Install
7 min
Video 2 Start, Load and Go (Making Table and Matrix)
20 min
Video 3 Visual Formattings, Numbers formatting, Cards Visuals, AI in BI via QA
22 min
Video 4 Bar Charts (All variations) and Slicers Basics
24 min
Video 5 Line Charts Area Charts Multiple Axis and
25 min
Video 6 Ribbon, Pie, Donut, Treemap and Filled maps
24 min
Video 7 Power Platform, Basic Data Transformation, waterfell, funnel and scatter chart
21 min

Mod 2 Data Loading and Transformation in Power Query

1 - Video

Video 1 Loading Data from Different Sources
14 min
Video 2 Data Transformation Colum Split and Merge
26 min
Video 3 Replace, Text based , Unpivot and Practice Example
27 min
Video 4 Merging sheets from a Workbook
19 min
Video 5 Merging Workbooks in same folders and append rule
18 min
Video 6 Adding New Columns and time date functions
18 min
Video 7 Group by Function in Power query Basic and Advance
22 min
Video 8 Merge Queries (Full outer, Left Outer, Right outer, Inner and antis joins) & Fuzzy Matching
27 min
Video 9 Add Columns (index, Duplicate, Custom Column)
24 min
Video 10 Column from Example and Date issues
19 min

Mod 3 Data Modelling in Powrer BI

1 - Video

Video 1 Data Modeling and why we do it (DB Basics, Quantum of data, Normalized vs Denormalized)
19 min
Video 2 Data Modeling and building relationship in Star Schema
21 min
Video 3 Auto Detect Relation and Introduction to DAX
25 min
Video 4 DAX Multiline, Double operators, IF and Nested IF
30 min
Video 5 Adding Calculated Tables
25 min
Video 6 Introduction to the Measures
22 min

Mod 4 Advanced Data Modeling

1 - Videos

Video 1 Time Intelligence MTD, WTD, DTD, YTD and SameperiodLastYear
26 min
Video 2 Time Intelligence Comparatives, ParallelPeriods, SOM,EOM, previous period and next period
20 min
Video 3 Applying filters in calculate Function and ignoring other filters (HD)
20 min
Video 4 Adding Tables with filters and conditional counts (HD)
16 min
Video 5 SWITCH, SELECTEDVALE, ISINSCOPE and Excluding totals from measures (HD)
30 min
Video 6 SWITCH SELECTEDVALUE and external slicers
17 min
Video 7 Add Tables using ADDCOLUMNS with FILTER function and SUMMARIZE
23 min

Mod 5 Data Dashbording

1- Videos

Video 1 Field Parameters ( X and Y axis, Ordering, Drill Through and Exand all)
22 min
Video 2 Conditional Formatting 1(Table Gradient, Font colors, Bars & Sparklines)
16 min
Video 3 Conditional Formatting 2 (Heatmap, Icons based on rules)
15 min
Video 4 Drill through and Updating sources of Data
16 min

Mod 7 Python for Data Description

1 - videos

Video 1 Why we need to study PYTHON and what is it
9 min
Video 2 Starting the PYTHON in Jupyter Notebook
9 min

Videos : 38

HOW TO PAY ?

Course Content

46+ students are Recommending this Course

00 AI AND DATA ANALYTICS HOC BY SIR JAHANZAIB

00 AI AND DATA ANALYTICS HOC BY SIR JAHANZAIB

Mod 0 Introduction and orientations

1 - Orientation

2 - FAQs

Mod 1 Introduction to Power BI and Basic Visuals

1 - Videos

Mod 2 Data Loading and Transformation in Power Query

1 - Video

Mod 3 Data Modelling in Powrer BI

1 - Video

Mod 4 Advanced Data Modeling

1 - Videos

Mod 5 Data Dashbording

1- Videos

Mod 7 Python for Data Description

1 - videos

Course Content

Frequently Asked Questions

What is Nearpeer?

Which courses are being offered at Nearpeer?

Why should I study from Nearpeer?

Is Nearpeer a trustworthy Platform?

What is the Fee for an online course at Nearpeer?

Is online course sufficient for my preparation?

How to download Nearpeer videos?

How to pay for Nearpeer course?

The best online education Paltform in Pakistan?

Where is Nearpeer located?

Does Nearpeer offer guaranteed success?

Is Nearpeer an AI based educational platform?

00 AI AND DATA ANALYTICS HOC BY SIR JAHANZAIB

00 AI AND DATA ANALYTICS HOC BY SIR JAHANZAIB

Mod 0 Introduction and orientations

1 - Orientation

2 - FAQs

Mod 1 Introduction to Power BI and Basic Visuals

1 - Videos

Mod 2 Data Loading and Transformation in Power Query

1 - Video

Mod 3 Data Modelling in Powrer BI

1 - Video

Mod 4 Advanced Data Modeling

1 - Videos

Mod 5 Data Dashbording

1- Videos

Mod 7 Python for Data Description

1 - videos

Course Content

Frequently Asked Questions

What is Nearpeer?

Which courses are being offered at Nearpeer?

Why should I study from Nearpeer?

Is Nearpeer a trustworthy Platform?

What is the Fee for an online course at Nearpeer?

Is online course sufficient for my preparation?

How to download Nearpeer videos?

How to pay for Nearpeer course?

The best online education Paltform in Pakistan?

Where is Nearpeer located?

Does Nearpeer offer guaranteed success?

Is Nearpeer an AI based educational platform?