Data Science with Python for Power BI and SQL Server Developers

Although R is the most popular environment and language for statistical analyses, data mining, and machine learning, Python as a more general language might be even more popular. Python is more organized language than R. In last years, many data analytics libraries for Python evolved, and thus Python is catching up with R even in the data science area.

Microsoft added support for Python code in SQL Server in version 2017. Now you can use either R or Python inside the Database Engine for advanced tasks like predictive analytics. Therefore, you can use the language that suits you better. Statisticians and mathematicians might prefer R, while developers tend to be more Python oriented. Both languages are, although with some limitations, supported in Power BI as well.

Attendees of this seminar learn to program with Python from the scratch. Basic Python code is introduced using the Python engine installed with SQL Server and Visual Studio Code. The seminar shows some more advanced data manipulations and statistical analysis together with graphing options. The mathematics behind is briefly explained as well. Then the seminar switches to more advanced data mining and machine learning analyses. Finally, the attendee learn how to use Python inside SQL Server and inside Power BI.