Python Integration for Power BI and Predictive Analytics | Power BI Training | Edureka

Key Takeaways

hi guys very good morning very good afternoon very good evening everyone I hope that all of you guys are doing well and I hope that all of you guys are doing great let's just kick off the session before we start uh let me introduce myself my name is Deepak my full name is uh Deepu Sharma I'm one of the lead instructor for this course now talking about today's agenda guys today we will talk about why power bi what is power bi introduction to python how to use Python script to import data how to use Python script to create visualization now talking about uh you know y power bi uh before we talk about you know what exactly is power bi and let's just talk about you know I mean uh y power bi I mean why we need it what is the importance of having it you know in other words y power bi Now power bi has certain advantages guys like a machine learning I mean where you can automate the uh stuff I mean you can have your own algorithms uh that you can integrate with the existing platform and you can you know perform an automation next is the mobility if you want to move the device from one place to another you know also this kind of stuff you can perform the mobility as well next is Advanced analytics like if you want to have advanced analytics you know Advanced diagrams and all it's going to be possible next is Cortana integration wherein uh you want to have a kind of a chatbot stuff you know that something can be created as well plus it has a lower upfront cost so it's not like that you have to pay a lot of money uh you know I mean uh creating building it is a very extreme lower upfront cost at the same time there are very uh you know various apis which are being available for integration with the help of you can automated integrate desktop plus the customization is easy and it's more of a user friendly talking about what is power bi power bi is a free intelligence cloud service given by Microsoft which actually provides you know non-technical business users various tools for aggregating where you can combine data from various sources in different formats and you can have a customized data taken analyzing if you want to analyze data from various sources various formats you can do it very easily third is visualizing where you want to have a visualization of a data available for you you can do that and sharing data like if you want to share the data within the subnauts you will be able to do it now having said that talking about python guys you know what is a python python is a general purpose high level interpreted language uh the good thing is that it has a very easy syntax plus it's based on oops oopsy's object oriented programming language where you are going to you know inherit or you are going to adapt the concepts from The Real World like inheritance encapsulation data hiding all such kind of stuff um the name why we have given the name is python because it was inspired by his favorite show which is Flying Service uh you know which the Creator was Monty Python wherein uh if we talk about some of the different features of python it's simple it's extremely simple the python is designed such that you can think more of a code and less of the syntax uh second is open source being an open source is awesome which means that python is free for everyone to use third is portability python code can be written in one computer and you can execute in another one without making any kind of a hassle which is going to make the code sharing easier the next is embeddable and extensible so python allow code of other languages such as C C plus plus 2mb embedded into it so that certain functions can be performed which is going to make python even more powerful next is interpreted the task of CPU and memory management are handled by python itself next is a huge libraries python has a huge set of libraries like matplotab kitikulon numpy which will help you to solve the problem very easier next is oop you know which is object oriented orientation which is going to help you to break down the complex problems of the world into code and which is going to help you to provide security into it to have better Solutions talking about some of the prerequisite guys in order to run python script in power via desktop you need to install python on the local machine now the power bi python integration requires installation of two packages which is pandas and matplot having said that if you want to use a python script to import data I mean it's going to be easier for you I mean you just have to you know download the package and you will be able to use it at the sake of ease now talking about structured learning editor maker guys if you're highly interested to learn everything end to end in detail because in the webinar we pick up a topic and then we dive in more detail however if you have that core interest that you want to learn each and everything end to end in detail then in that case you can join the course and take advantage of it now in terms of social learning guys you are going to start with uh Power bi you know I mean you're going to learn about what exactly is power bi different core components on it with a practical Hands-On um uh then after that in second class you're going to learn about power bi desktop and data transformation with a practical Hands-On in the third class you're going to learn about data analysis and expressions with the critical Hands-On in the fourth class you're going to learn about data visualization with the Hands-On in the fifth class you want to learn about introduction to power BS service qn and quick insights with the Practical Hands-On in the sixth class we will learn about connectivity modes with the Practical Hands-On in the the seventh class we're going to learn about power bi report servers with the Hands-On in the eighth class we're going to learn about using RN Python and power bi with the Hands-On in the ninth class you want to learn about Advanced analytics in power bi with the Hands-On in the last class you want to learn about in class project where you are going to be assigned a project and you are going to perform a hands on it with a practical Hands-On now if you want to use a python script to create visualization guys I mean one of the biggest problem that you're going to have is that you should have the code programming knowledge that's something you are going to learn in the course end to end now if we talk about certain drawbacks uh the the biggest drawbacks of uh you know python power bih visual is the data size limitation I mean there is a limit on data size that you can have a data out at limited size only next is resolution I mean you cannot have that advanced resolution next is calculation time limitation I mean in order to calculate the time that is the major limitation you have next is the relationship like where you are going to have you know I mean compact data plus there is no cross highlighting which is going to be available and the limitations thank everyone guys thank you so much for joining the rotation wishing all of you a great day ahead bye bye here