1
00:00:00,390 --> 00:00:06,480
One of the most important and difficult task in any data analytics project is titta confirmation and

2
00:00:06,480 --> 00:00:07,290
data cleaning.

3
00:00:08,110 --> 00:00:15,210
We need to prepare the data to make it suitable for analysis, to retrieve useful insights and develop

4
00:00:15,210 --> 00:00:18,990
our PR if we have power query like an ETF for data warehouse.

5
00:00:19,830 --> 00:00:27,360
Whenever we perform any operation on the data security, Rafe's and Core, which is a formula language

6
00:00:28,140 --> 00:00:33,960
in formula language, contains a rich set of different functions for data transformation and cleaning

7
00:00:35,250 --> 00:00:35,770
in power.

8
00:00:35,790 --> 00:00:41,030
Be able to have graphical user interface that we use to perform different operations on the data.

9
00:00:41,550 --> 00:00:44,430
But unfortunately this interface is very limited.

10
00:00:45,030 --> 00:00:51,000
We cannot perform all the data related operations on it by using graphical user interface.

11
00:00:51,390 --> 00:00:59,070
In almost every month, Microsoft releases new versions of eight, which have new graphical tools in

12
00:00:59,190 --> 00:01:00,090
our beribboned.

13
00:01:00,480 --> 00:01:05,270
But still, we have dependent on the new features of our current graphical user interface.

14
00:01:06,230 --> 00:01:12,230
We can overcome this dependency by learning poverty, language and language is much more powerful than

15
00:01:12,230 --> 00:01:19,820
the poverty because the entire underlying genetic code will be in our hand in the schools who will learn

16
00:01:19,820 --> 00:01:24,980
all the building blocks of poverty and language so that you can master it by your own.

17
00:01:25,100 --> 00:01:32,390
This course will give you a clear path about language that how to implement any available function for

18
00:01:32,390 --> 00:01:33,530
data transformation.

19
00:01:34,160 --> 00:01:38,300
New upcoming features and functions will be added in discourse time to time.

20
00:01:39,140 --> 00:01:42,890
My name is Muhammad Osip and I will be your instructor in the schools.

21
00:01:43,280 --> 00:01:49,930
I have more than 10 years of experience in data and analytics with one of the world's leading organization.

22
00:01:50,360 --> 00:01:55,810
I am a Microsoft Certified Solutions expert in data analytics and management.

23
00:01:55,880 --> 00:02:01,220
I have a number of data models, dashboards and reports for different line of services.

24
00:02:01,940 --> 00:02:06,420
You can learn from my experience and I will share each and everything in a simple way.

25
00:02:06,980 --> 00:02:10,850
My aim is to spread the knowledge by simplifying hard concepts.

26
00:02:11,540 --> 00:02:16,370
I wish you all the best for your journey in power and formula language.