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 Deepa Sharma I'm one of the lead instructor for this course now talking about today's agenda guys today we will talk about why powerbi what is powerbi 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 why powerbi uh before we talk about you know what exactly is powerbi let's just talk about you know I mean uh why powerbi I mean why we need it what is the importance of having it you know in other words why powerbi now powerbi 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 all such 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 CA 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 has 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 which you can automated integrate that stuff plus the customization is easy and it's more of a user friendly talking about what is powerbi powerbi 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 they can analyze in if you want to analyze data from various sources various formats you can do it very easily third is visual 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 subnodes you will be able to do it now having said that talking about python guys you know what is a python um python is a general purpose high level interpreted language uh the good thing is that it has a very easy uh syntax plus it's based on oops oops is objectoriented programming um language where you have going to you know inherit or you're 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 as 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 want 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++ to be embedded into it so that certain functions can be performed which is going to make python even more powerful next is interpreted the tasks of CPU and memory management are handled by python itself next is a huge libraries python has a huge set of libraries like Matt plot ktic learn numpy which will help you to solve the problem very easier next is oop you know which is objectoriented 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 powerb desktop you need to install python on the local machine now the powerbi python integration requires installation of two packages which is pandas and Matt plot having said that if you want to use a python script to import data I mean uh 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 edit Rea guys if you're are 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 and in detail then in that case you can join the course and take advantage of it now in terms of structural learning guys you're going to start with uh powerbi you know I mean you going to learn about what exactly is powerbi different code components on it with the Practical handson um uh then after that in second class we going to learn about powerbi desktop and data transformation with a practical handson in the third class you're going to learn about data analystics uh and expressions with the Practical handson in the fourth class you're going to learn about data visualization with the handson in the fifth class we going to learn about introduction to power BS service q& in quick insights with the Practical handson in the sixth class uh we will learn about contivity modes with the Practical handson in the seventh class we're going to learn about powerbi report service with the handson in the eighth class we going to learn about using in Python powerbi with the handson in the ninth class you're going to learn about Advanced analytics in powerbi with the handson in the last class you're going to learn about in-class project where you are going to be assigned a project and you going to perform a handson on it with a practical handson 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 uh 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 you know python power B usually is the data size limitation I mean there is a limmit on data size that you can have a data of that 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 a major limitation you have and next is a relationship like where you are going to have you know I mean compact data plus there's no cross highlighting which is going to be available and the limitation thank you everyone guys thank you so much for joining today session wishing all of you a great day head bye-bye take care