Data Science Bootcamp with Power BI and Python
Data Visualization | Data Analysis | Data Preparation | Data Cleaning | Python custom charts
Python,Microsoft Power BI,Development,Data Science
Lectures -52
Duration -3.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Welcome to this course on Data Science bootcamp with Microsoft Power BI and Python. In this course, you will learn various concepts with hands on examples where you will learn to create powerful BI reports and analytics dashboard. You will learn right from creating data visualization charts in Power BI with and without using python programs. You will learn to create various kinds of charts such as Bar, Pie, Ring, Treemap and more that are available as default charts in Power BI. Moreover you will also learn to create advanced custom charts by writing python programs such as line, scatterplot and violin chart. After that, you will also learn to create slicer filters for categories and date based on which you can filter the data that is visually displayed on the chart. This feature helps in focused decision making based on decided parameter such as region, category or date.
After learning lessons on Data Visualization, you will learn Data Cleaning and Data Preparation by using Power Query Editor. Here, you will learn to perform various kinds of operations on rows, columns or individual cells of the dataset. You will learn to create new custom column or field in a table based on a certain condition such as conditional column, and you will also learn to create index column. You will learn to perform row operations such as row deletion. For columns, you would learn to perform Split, Merge, Extract and other operations in Power Query editor.
You could use the skills learned in this course for various domains such as Data Science, Business Intelligence, Data Analysis, Data Preparation and Data Visualization.
Topics discussed under Data Visualization and Analytics with Python and Power BI-
Bar chart
Line chart
Pie chart
Ring chart
Treemap chart
Table and Matrix
Drill down
Install python libraries
Create line chart with matplotlib
Putting labels and creating a dashed line chart
Violin chart with seaborn
Slicer Filter
Date Slicer
Creating a calculated measure
Using live web data
Topics covered under Data preparation with Power Query-
Row deletion and column Split
Replace column values
Column Merge
Adding Suffix and Prefix
Add and transform column
Extract function
Adding conditional and Index column
Date function in power query
Goals
- You would be able to create various kinds of Visualization charts in Power BI
- You would be able to create Bar, Line, Pie, Ring, Treemap, Table and Matrix
- You could create Advanced custom charts by writing python code for Line chart, Scatterplot and Violin chart
- You could create slicer filters and custom measure
- You could perform Data Preparation and Cleaning using Power Query Editor
- You could perform Split, Merge, Prefix, Suffix, Extract and other functions
Prerequisites
- You should have either a trial or full version of Tableau Desktop or Tableau Online
![Data Science Bootcamp with Power BI and Python Data Science Bootcamp with Power BI and Python](https://d3mxt5v3yxgcsr.cloudfront.net/courses/5144/course_5144_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction 02:27 02:27
Getting Started with Power bi
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Create Visualization charts
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Table and Matrix
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Map Chart
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working with Live Web Data
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Slicer Filter and Calculated Field
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Exporting Report
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Animation Playback
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Adding Custom Buttons
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Visualization with Python
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advanced Python charts
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Getting Started with Power Query
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Updating Data values
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Text Extraction
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Index and Conditional Columns
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Date and Time Functions
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Removing Null values using python script
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Manage Relationship
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Harshit Srivastava](https://www.tutorialspoint.com/assets/profiles/137799/profile/200_82292-1569617773.jpg)
Harshit Srivastava
I am Self-Taught developer who had worked on various platforms using varied languages, and involved in various Projects both Open Source and Proprietary.
I have developed Web and Android Applications, chrome Extension, worked on various frameworks, fixed bugs for some projects, and explored numerous others. I think education and learning should be free and open, not be bound with restrictions like attending classes or going to college, People from all age groups, gender, faith, race, nations, etc must get equal privilege. When entire world would act this way like being a single FAMILY, we would truly realize VALUE of Knowledge and Human Life.
Currently I am teaching more than 152,000 students from 189 countries across the world.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)