Data analysis course: Power BI, Excel, Python and Tableau

Learn to clean, analyze and visualize data with four tools: Python and Jupyter, Power BI, Excel Power Pivot and Power Query, and Tableau.
Get the project files and follow along: https://allgoodtutorials.com/supporters/videos/analyze-and-visualize-data-with-four-tools
What you will learn:
Set up Jupyter Notebook and clean data with pandas in Python
Shape, merge and append data in the Power BI Power Query Editor
Build Power BI reports and publish them to the Power BI service
Model data in Excel with Power Pivot and Power Query
Analyze it with PivotTables and PivotCharts that refresh with your data
Join, clean and present data with stories in Tableau
Chapters:
00:00 Course overview
00:42 What is Python
06:01 What is Jupyter Notebook
07:19 Install Anaconda and Jupyter
14:04 Start Jupyter Notebook
22:49 Useful Jupyter commands
30:18 Notebook components and dashboard
39:04 Notebook user interface
44:50 Create a new notebook
51:36 Find free datasets
54:43 Dataset structure
1:02:41 Explore a pandas DataFrame
1:05:02 Manipulate a DataFrame
1:17:58 What is data cleaning
1:21:29 Basic data cleaning
1:40:03 What is data visualization
1:46:45 Visualize qualitative data
1:58:48 Visualize quantitative data
2:12:34 What is Power BI
2:18:24 What Power BI Desktop does
2:22:05 Install Power BI Desktop
2:29:43 Power BI Desktop tour
2:35:44 Power BI service overview
2:49:11 Power BI components and building blocks
2:58:26 Power BI Desktop interface
3:07:17 Power BI service elements
3:12:12 Apps in Power BI
3:16:11 Connect to web data
3:21:16 Shape the web data
3:38:12 Combine two tables
3:46:11 Create visuals
3:52:25 Create visuals, part 2
3:57:49 Publish and share a report
4:02:33 Prepare to import Access data
4:15:29 Change regional settings
4:17:23 Connect to an Access database
4:24:26 Power Query Editor basics
4:30:53 Query groups and renaming
4:40:52 Split columns
4:46:29 Change data types
4:53:43 Remove and reorder columns
5:00:35 Duplicate and add columns
5:04:11 Conditional columns
5:10:29 Connect to a folder of files
5:17:45 Append queries
5:24:44 Merge queries
5:30:18 Query dependencies view
5:34:26 Transform less structured data
5:53:49 Create tables with Enter Data
5:57:42 Parameters
6:07:04 Office 365 E3 free trial
6:20:29 Activate Office apps
6:24:05 Sign in to the admin center
6:29:39 What is Power Pivot
6:30:42 Power Pivot versions and setup
6:33:44 What is Power Query
6:37:15 Connect to a data source
6:41:40 Prepare the query
6:46:32 Cleanse the data
6:54:11 Enhance the query
7:03:31 Analyze with Power Pivot
7:09:33 Link a second data source
7:16:31 Create lookups
7:23:34 PivotTables from the data model
7:32:14 PivotCharts
7:40:27 Refresh source data
7:48:03 Update the query
7:57:21 Create new reports
8:04:41 What is Tableau
8:08:52 Tableau data sources and files
8:14:59 Tableau help menu
8:16:22 Connect and create a visualization
8:19:47 Join data sources
8:28:49 Join with inconsistent field names
8:35:19 Clean data in Tableau
8:41:46 Tableau interface
8:46:34 Reorder fields
8:50:48 Change the summary operation
8:53:41 Split text into columns
8:58:05 Present data with stories
The project files are on the course page, included with All Access (7-day free trial) or with the course ($19).
All Good Tutorials publishes step-by-step video courses for the software you use at work: Microsoft Office, Google Workspace and more.
Start free or try All Access free for 7 days: https://allgoodtutorials.com/supporters/pricing
#PowerBI #DataAnalysis #DataVisualization
