Python data analysis practical examples (Query database, ReadExcel, Sort, Groupby, plot, Matplotlib)

Published: 22 March 2021
on channel: BI Insights Inc

1,035

This video covers some of the basic techniques of data analysis using Python. It will help you improve your data analysis skills using Pandas, Numpy and Matplotlib. We define questions and answer them with data analysis solution in Python. Data used in the video comes from Adventureworks database.

Q1. Highlight compnay performance by major KPIs?
Q2. What is the overall sales trend?
Q3. What are the Top 10 products by sales?
Q4. What is the overall month over month and year over year growth?
Q5. What's the sales breakdown by category?

Github repo link for the code along with data and scripts.
https://github.com/hnawaz007/pythonda...

How to install and get started with Jypter Notebook
• Install Anaconda Python, Jupyter Note...

How to video on Jypter Notebook
• Jupyter Notebook Tutorial: Introducti...

GitHub link for AdventureWorks2012 database file
https://www.youtube.com/redirect?even...

Link for stacked chart percentage calculation.
https://www.geeksforgeeks.org/stacked...

#Adventureworks #dataanalysis #python #coding

Python libraries install script...with PIP
pip install pyodbc
pip install install pandas
pip install numpy
pip install matplotlib
pip install voila

In case you are using Anaconda..
conda install -c anaconda pyodbc
conda install -c anaconda pandas
conda install -c anaconda numpy
conda install -c conda-forge matplotlib
conda install -c conda-forge voila

Thanks for watching friends!
Happy coding! :)

#Python #Coding #DataScience #Pandas #PythonPandas #Python #PythonTutorial #PythonTraining #PythonBeginners #Anaconda #JupyterNotebook

Topics covered in this video:
0:00 - Introduction
0:11 - Import libraries
1:11 - Database connection & read data from db
1:55 - Import data from Excel
2:31 - Loading the data & data sampling
3:02 - Line Chart : 1 - Data preparation
5:28 - Top Ten Product report
7:56 - Bar Chart - Month over Month
11:34 - 100% Stacked Chart
16:48 - Build KPIs
17:43 Use Viola to display visualizations

On this page of the site you can watch the video online Python data analysis practical examples (Query database, ReadExcel, Sort, Groupby, plot, Matplotlib) with a duration of hours minute second in good quality, which was uploaded by the user BI Insights Inc 22 March 2021, share the link with friends and acquaintances, this video has already been watched 1,035 times on youtube and it was liked by 25 viewers. Enjoy your viewing!