Data Visualization with Python and Power BI Course


Introduction

Python is one of the most popular and advanced programming language used in various domains such as machine learning and data science. Python helps you reduce the lines of code into as short as possible while keeping it in a readable format so that anyone can easily understand the implication of python code. In this course you will learn about some of the libraries in python and some methods used to create data visualization charts and data science projects. Here, you will learn about creating data visualization charts using python and Power BI business intelligence software. Power BI is an advanced software used for wide range of application areas such as Data Science, Machine Learning, Enterprise Resource Planning, Data Analysis and much more. And it makes the process of data cleaning, modelling and visualization very interactive and easy.

Although we could create various kinds of charts in Power Bi even without writing a single line of code. But there are various complex problems in data science that can be solved with the help of python libraries such as matplotlib and seaborn. In this course you will learn to create some of the advanced charts in power bi by writing python programs to create data visualizations for driving insights and finding outliers that may not be done by using default charts, one such example could be Violin chart. By creating a Violin chart you could easily spot the distribution range or concentration of values based on a certain category. This chart would make it intuitive to spot any segregation of values, and uniformity of distribution. It would be very difficult to represent such insights using any other default charts. Moreover, you would be learning many of such advanced custom charts in power bi that can be created by writing python codes.

The skills you learn in this course can be used in various domains related to data science and data analytics to business intelligence and machine learning.

 

Duration

15 Days

Who Should Attend

  • Anyone who is curious to learn Data Science and Data Visualization
  • Students, Developers and professionals interested in learning Power BI and python
  • Interested to create custom charts using matplotlib and seaborn in python

Course Objectives

At the end of this IRES training course, participants will learn:

  • You will learn to create various visualization charts in Power BI.
  • You will also learn to create advanced charts by writing python code using seaborn and matplotlib.
  • You will learn to create Line chart, Scatterplot, and Violin chart.
  • You will also learn to create Strip plot, box plot and Lmplot chart.

Course Outline

Module 1

  • Key differences between Python and Power BI in basic data processing steps

Module 2: Introduction to Phython

  • Installing python packages and defining path
  • Installation Setup and Overview
  • IDEs and Course Resources
  • iPython/Jupyter Notebook Overview

Module 3

  • Creating a Line chart with matplotlib
  • Putting labels and creating dashed scatterplot
  • Violin chart with seaborn

Module 4

  • More on Violin chart
  • Stripplot
  • Boxplot

Module 5

  • Lmplot or align plot
  • Ribbon Chart
  • Table and Matrix
  • Drill Down Table and Matrix

Module 6

  • Donut Ring chart
  • Simple Map and modes
  • Slicer- Basics

Module 7

  • Slicers- Date Slicer
  • Setup the integrated environment
  • Import data using Python script

Module 8

  • Using Power Query to transform data
  • Using Python’s statistical capabilities within Power BI
  • Generating analytical reports

Module 9; Designing a Data Model in Power BI .

  • Introduction to Data Modeling.
  • Working with Tables.
  • Dimensions and Hierarchies.

 Module 10; Create Reports.

  • Design a Report.
  • Enhance the Report.

 Module 11: Create Dashboards.

  • Create a Dashboard.
  • Real-time Dashboards.
  • Enhance a Dashboard.

Module 12: Heat maps and Correlation Coefficients

  • correlation coefficient in Calculating the Power BI and Python.

 Module 13: Create Paginated Reports in Power BI .

  • Paginated Report Overview.
  • Creating Paginated reports.

Module 14: Big Data and Spark with Python

  •  Welcome to the Big Data Section
  • Big Data Overview
  • Spark Overview
  • Local Spark Set-Up
  • AWS Account Set-Up
  • Quick Note on AWS Security
  •  EC2 Instance Set-Up
  • SSH with Mac or Linux
  • PySpark Setup
  • Introduction to Spark and Python

Module 15: Data Visualization

  • Installing Seaborn
  • Histograms
  • Kernel Density Estimate Plots
  • Combining Plot Styles
  • Box and Violin Plots
  • Regression Plots
  • Heatmaps and Clustered Matrices

Enroll for this Course

We are proud to offer this course in a variety of training formats to suit your needs.

IRES

Enroll for a Face-to-Face (In-Person) Class

We use the highest quality learning facilities to make sure your experience is as comfortable as possible.

Register Here
IRES

Enroll for a Virtual (Zoom) Class

Join a scheduled class with a live instructor and other delegates.

Register Here
IRES

Enroll for an Online Self-Paced Class

Keep track of your own progression throughout your course and ensure continuous improvement.

Register Here

Benefits of Taking a Course at IRES

LEARN

Our courses are carefully curated to keep you abreast of latest industry trends, technological advancements, and best practices. We employ a variety of teaching methodologies, including hands-on workshops, case studies, and interactive sessions, all aimed at fostering an engaging and effective learning environment. Our expert instructors bring a wealth of knowledge and real-world experience, providing our clients with insights that can be immediately applied in their professional lives.

NETWORK

Our courses serve as a vibrant platform for professionals to connect and engage with a diverse community of peers, industry leaders, and experts. By participating in our programs, you gain access to an invaluable network that spans across various sectors and geographical boundaries. This networking aspect is not just about forming professional relationships; it's about creating a supportive ecosystem where ideas, opportunities, and collaborations can flourish.

GROW

Our courses are designed to challenge and inspire professionals to step out of their comfort zones and explore new horizons. Through a combination of theoretical knowledge and practical application, our programs help professionals refine their existing skills and acquire new ones, making them more versatile and competitive.

FAQs & Course Administration Details:

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location. For further inquiries, please contact us on Phone: +254 715 077 817 or Email: [email protected].
The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
Upon successful completion of this training, participants will be issued with an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).
Payment should be transferred to IRES account through bank on or before start of the course. Send proof of payment to [email protected].
Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer. Email: [email protected] Phone: +254 715 077 817.