Data Analysts Toolbox: Excel, Python, Power BI, PivotTables

Learn Advanced Pivot Tables, Power Query, Power Pivot, Power BI, and Python in this four-course bundle

4.59 (1790 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
11,429
students
29 hours
content
Jan 2024
last update
$94.99
regular price

What you will learn

How to create amazing looking dashboards using Pivot Tables

Advanced data analysis techniques

How to do a PivotTable (a quick refresher)

How to format a PivotTable, including adjusting styles

Advanced Sorting and Filtering in PivotTables

How to use 3D Maps from a PivotTable

How to update your data in a PivotTable and Pivot Chart

Advanced Sorting and Filtering in PivotTables

Analyze huge buckets of data to make informed business decisions

Become confident cleaning, sorting and linking data from various sources

How to create stunning, interactive dashboards with Power BI

How to share your analysis and dashboards using Power BI Online

To import CSV and Excel files into Power BI Desktop

All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions

All about using the card visual to create summary information

How to create amazing visuals, such as clustered column charts, maps, and trend graphs

How to use Slicers to filter your reports

How to edit the interactions between your visualizations and filter at visualization, page, and report level

Put their skills into practice with a real Python project

What is Python and why was it created

How Python fits into the diverse ecosystem of programming languages.

The basic data types in Python - Strings, Integers, Floats, and Boolean

All about Pythons built-in functions

How to debug errors in Python

How Variables and Functions work in Python

How to use IF-Else Statements in Python

All about storing complex data, including Lists and Dictionaries

How to install Python locally

How to write your first script in Python

Description

In business, being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid analysts. It's becoming an essential part of many roles.

If that sounds daunting, don't worry. There is a growing set of tools designed to make data analysis accessible to everyone, in this huge-value, four-course Data Analysts Toolbox bundle we look in detail at three of those tools: Excel, Python, and Power BI.

In isolation Excel, Python, and Power BI are useful and powerful. Learn all three and you are well on your way to gaining a much deeper understanding of how to perform complex data analysis.

This Data Analysts Toolbox bundle is aimed at intermediate Excel users who are new to Python and Power BI. All courses include practice exercises so you can put into practice exactly what you learn.


Here's what each course covers:


Introduction to Python

  • The basic data types in Python - Strings, Integers, Floats, and Boolean

  • All about Pythons built-in functions

  • How Variables and Functions work in Python

  • How to debug errors in Python

  • All about Python Keywords

  • How to use IF-Else Statements in Python

  • All about storing complex data, including Lists and Dictionaries

  • All about Python Modules and how to install them

  • How to install Python locally

  • How to write your first script in Python

  • To complete your first Python project


Advanced PivotTables

  • How to do a PivotTable (a quick refresher)

  • How to combine data from multiple worksheets for a PivotTable

  • Grouping, ungrouping and dealing with errors

  • How to format a PivotTable, including adjusting styles

  • How to use the Value Field Settings

  • Advanced Sorting and Filtering in PivotTables

  • How to use Slicers, Timelines on multiple tables

  • How to create a Calculated Field

  • All about GETPIVOTDATA

  • How to create a Pivot Chart and add sparklines and slicers

  • How to use 3D Maps from a PivotTable

  • How to update your data in a PivotTable and Pivot Chart

  • All about Conditional Formatting in a PivotTable

  • How to create amazing looking dashboards


Power Pivot, Power Query and DAX

  • How to get started with Power Query

  • How to connect Excel to multiple workbooks

  • How to get data from the web and other sources

  • How to merge and append queries using Power Query

  • How the Power Pivot window works

  • How to set up and manage relationships in a data model

  • How to create a PivotTable to display your data from the Power Pivot data model

  • How to add calculated columns using DAX

  • How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX

  • All about creating Pivot Charts and PivotTables and using your data model

  • How to use slicers to adjust the data you display


Power BI

  • What is Power BI and why you should be using it.

  • To import CSV and Excel files into Power BI Desktop.

  • How to use Merge Queries to fetch data from other queries.

  • How to create relationships between the different tables of the data model.

  • All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.

  • All about using the card visual to create summary information.

  • How to use other visuals such as clustered column charts, maps, and trend graphs.

  • How to use Slicers to filter your reports.

  • How to use themes to format your reports quickly and consistently.

  • How to edit the interactions between your visualizations and filter at visualization, page, and report level.


***Exercise and demo files and project files included***

This mega-value bundle includes:

  1. 21+ hours of video tutorials

  2. 200+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion


Here’s what our students are saying…


"The instructors have explained everything amazing and the resources are super helpful."

- Oscar

"This course is very relevant in my line of work. The facilitators are detailed in their explanation & don't rush through the information."

- Thulani

"My name is Kenvis and I have a knowledge in IT but never thought of specializing in Data Analytics before. This was so exciting and I am now anxious to learn more."

- Kenvis

"Thank you for such a wonderful teaching. This is a great learning experience for me."

- Ankush

Content

Advanced PivotTables: Introduction

Introduction to Advanced PivotTables
READ ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Support Files
PivotTables Recap
Section Quiz

Advanced PivotTable: Importing Data

Importing data from a text file
Importing data from Access
Exercise 01
Section Quiz

Advanced PivotTable: Preparing Data for Analysis

Cleaning Data
Tabular Data
Exercise 02
Section Quiz

Advanced PivotTable: Creating and Manipulating PivotTables

Creating and Manipulating a PivotTable
Combining Data from Multiple Worksheets
Grouping and Ungrouping
Report Layouts
Formatting Error Values and Empty Cells
Exercise 03
Section Quiz

Advanced PivotTables: Formatting PivotTables

PivotTable Styles
Custom Number Formatting
Exercise 04
Section Quiz

Advanced PivotTables: Value Field Settings

Summarizing Values
Show Values As
Exercise 05
Section Quiz

Advanced PivotTables: Sorting and Filtering

Advanced Sorting
Advanced Filtering
Exercise 06
Section Quiz

Advanced PivotTables: Interacting with PivotTables

Inserting and formatting Slicers
Inserting and formatting Timelines
Connecting Slicers to multiple PivotTables
Using Slicers in Protected Workbooks
Exercise 07
Section Quiz

Advanced PivotTables: Calculations

Creating a Calculated Field
Creating a Calculated Item
Solve Order and List Formulas
GETPIVOTDATA
Exercise 08
Section Quiz

Advanced PivotTables: Pivot Charts

Creating a Pivot Chart
Formatting a Pivot Chart - Part 1
Formatting a Pivot Chart - Part 2
Creating a Map Chart using Pivot Data
Dynamic Chart Titles
Include a Sparkline with your PivotTable
Exercise 09
Section Quiz

Advanced PivotTables: Conditional Formatting

Highlighting Cell Rules
Graphical Conditional Formats
Conditional Formatting and Slicers
Exercise 10
Section Quiz

Advanced PivotTables: Dashboards

Creating an Interactive Dashboard - Part 1
Creating an Interactive Dashboard - Part 2
Updating Pivot Charts and PivotTables
Exercise 11

Course Close

Course Close

Introduction to PowerPivot and PowerQuery

Welcome and Overview
READ ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Demo Files
What is Power Query?
What is Power Pivot?
Section Quiz

Getting Started with Power Query

Exploring the Power Query Editor
Common Power Query Transformations
Editing an Existing Query
Import Multiple Files from a Folder
Connect to Data in Another Excel Workbook
IMPORTANT: Checking the Location of your Query's Source
Get Data From the Web
Practise Exercise
Section Quiz

Useful Power Query Features

Unpivoting Columns
Combine Data from Multiple Tables with Merge Queries
Use Merge Queries to Compare Two Tables
Stack Data into One Table with Append Queries
Duplicating and Referencing Queries
Grouping and Aggregating Data
Conditional Columns in Power Query
Practise Exercise
Section Quiz

Creating the Data Model

Enable the Power Pivot Add-In
Understanding the Power Pivot Window
Creating Relationships Between tables
Managing the Relationships of the Model
Creating a PivotTable from the Data Model
Hide Fields from Client Tools
Grouping Queries
Practise Exercise
Section Quiz

Introduction to DAX

Why use DAX?
Creating Calculated Columns with DAX
Creating your First DAX Measure
The COUNTROWS Function
SUMX and RELATED Functions
Practise Exercise
Section Quiz

More DAX Measures

Create a Date Table in Power Pivot
The CALCULATE Function
The DIVIDE Function
Using the DATESYTD Function
Calculate the Percentage of a Total
Practise Exercise
Section Quiz

Using PivotTables and Slicers

Create PivotTables and PivotCharts
Using Slicers with your PivotTables
Create a Top 10 PivotTable
Practise Exercise
Section Quiz

PowerPivot, PowerQuery and Dax: Closing

Wrap Up

Introduction to Power BI

Welcome and Overview
READ ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise File
What is Power BI?
Install Power BI Desktop
A Tour of BI Desktop
Explore Commonly Used Power BI Options
Section Quiz

PowerBI: Getting and Transforming Data

Import Files from a Folder into Power BI Desktop
Get Data from Excel and Text Files
Reference Queries to Create Additional Lookup Tables
Merge Queries in Power Query
Prevent Queries from Loading into Power BI Desktop
Practise Exercise
Section Quiz

Power BI: Data Modelling

Create Relationships Between tables
Create a Dynamic List of Dates
Create Additional Date Columns for Analysis
Sort the Month and Weekday Names Correctly
Mark the Table as a Date Table
Hide Unnecessary Fields from Report View
Practise Exercise
Section Quiz

Introduction to DAX Measures

Calculate the Total Revenue
Count the Total Rows of a Table
Use the CALCULATE Function
Calculate the Total Revenue Last Year
Difference Compared to Last Year
Practise Exercise
Section Quiz

Power BI: Adding Visualizations to your Report

Show Summary Information with Cards
Columns Charts to Compare Values
Map Visual to Plot Geographic Data
Slicers to Filter your Reports
KPI Card to Measure Performance Against a Goal
Line Graphs to Visualise Trend
Show Detail with the Matrix
Top N Lists with the Table Visualisation
Practise Exercise
Section Quiz

Power BI: Report Design

Adding Text Boxes and Shapes
Use Themes
Conditional Formatting
Practise Exercise
Section Quiz

Power BI: Editing Interactions and Filters

Edit the Interactions between your Visualisations
The Filter Pane to Filter at Any Level
Drill Through to More Detail
Practise Exercise
Section Quiz

Power BI Service

Publish Your Report to the Power BI Service
Different Ways to Share your Power BI Report
Practise Exercise
Section Quiz

Closing

Wrap Up

Python: The Workplace Tech Divide

Which Side of the Divide Are You On?
READ ME: Essential Information for a Successful Training Experience
DOWNLOAD ME: Course Exercise Files
DOWNLOAD ME: Course Project Files
Beginners Are Welcome
Course Overview

Introduction to Python

What is Python?
Python's Comparison to Other Programming Languages
Examples of Python in the Workplace
The Easiest Place to Practice Python
Create an Account Online

Basic Data Types

Python Data Types
Strings
Integers
Floats
Boolean
Data Types Exercise
Section Quiz

Python Built-In Functions

What is a Built-In Function?
Where to Look For Built-In Functions
Most Common Built In Functions
Built In Functions Exercise
Section Quiz

Variables and Functions

Variables and Functions
Storing Values as Variables
Comparing Variables with Operators
Basic Expressions
Functions
Commenting
Variables and Functions Exercise
Section Quiz

Errors and Debugging

What is an Error?
Reading a Stack Trace
Print Function
Try and Except
You Are Not Alone
Errors Exercise
Section Quiz

Python Keywords

Python Keywords
Common keywords
Global
Keywords Exercise
Section Quiz

If-Else Statements

Basic Logic
Syntax and Inline Evaluation
Value Evaluation
Complex If-Else Statements
If-Else Exercises
Section Quiz

Storing Complex Data

Advanced Data Types
Lists
Dictionaries
Looping: Lists
Looping: Dictionaries
Advanced Data Exercise
Section Quiz

Python Modules

Python Modules
Python Built In Modules
Importing Modules

Installing Python and Modules

Python Environments
Mac
Windows
IDEs
Python Idle
Managing files and folders
Executing Scripts
PIP

Project: Automate Data Updates For a Spreadsheet

Project Introduction
Setting Up Project
Reading and Writing to Excel Files
Working with CSV Files
Dynamic File Paths
Transform and Validate Transactions
Transfer and Save Transactions
Clean Up the Code
Hardening the Script

Course Close

What's Next?

Screenshots

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Screenshot_01Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Screenshot_02Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Screenshot_03Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Screenshot_04

Reviews

Nausheen
August 22, 2023
Very very details and clear instruction throughout the course. I will surely buy more course relevant to data from this instructor.
Gyro
July 22, 2023
The training commenced with a comprehensive discussion of Pivot Tables, Power Query, and Power BI which I found to be quite informative and valuable. However, the Python segment of the course was the low point for me. Although Python is a powerful language for data analytics, I felt that its inclusion in this specific training was not properly integrated with the overall course objectives. In my opinion, the course would have been more effective if the Python application had been showcased within the context of Power BI. This way, it could have demonstrated how Python can enhance data analysis and visualization within a specific tool that aligns with the overall course objectives.
Brendon
June 2, 2023
This has been a great experience so far. It is giving a great foundation into the tools used in Data Science.
Amilcar
May 24, 2023
It is going to be a good experience since I always asked someone else to perform my pivot tables, and I will be able to start doing it myself.
Anna
May 14, 2023
It was an excellent course. Every lesson gave me an insight and useful experience. Perfect course for beginners in the field - everything is explained with a simple and accurate way. 10/10
Renata
April 20, 2023
Adorei a parte de tabelas dinâmicas avançadas e gostei bastante da parte de Power Query, Power Pivot, Dax e Power BI, mas achei que o curso se perdeu quando falou de Python (embora tenha sido legal revisar a parte básica). Confesso que não assisti a parte de Alteryx, por estar mais interessada em Power BI.
Hagop
April 18, 2023
Even tough I learned several new things from the course, overall the course was a disappointment. The Excel & Pivot Tables was average for me, Power BI & Alteryx were the most interesting parts. The Greatest Disappointment was the Python Part. I literally didn't learn anything in this module. The entire course seemed to have been hastily prepared appending several subjects together to give the impression of Value but it fails to deliver. There are much better courses, and It would be best to take a more targeted approach to specific subjects rather than a mashup of several subjects
William
March 17, 2023
Good so far, have just gone through the Pivot Tables Recap. As an intermediate analyst, yes, this recap was just a very beginner introduction in case somebody didn't do PivotTables that much.
Ricardo
March 16, 2023
It's a good course, it was explained step by step for easy understanding. The quality of the videos is excellent in Full HD which helps see all the data on Excel. The Python course is good for beginners, but the final project could be available for download.
Javier
March 10, 2023
Muy buen curso, realmente muestran paso a paso cómo ejecutar los procesos y el por qué de las acciones.
Phetolo
February 17, 2023
Yes it matches what I have been looking for. Everything is clear and understandable. It has a lot of examples which make it easier to learn and understand
Ridzky
January 6, 2023
The whole modules speed are slowed down so it appear that they provide a lot of material. not the best, not the worst content either except the python module, it is one of the worst learning module i have ever seen in my entire life. i dont think the tutor has any intention of sharing the knowledge or teaching python. Yes Jarrett Retz, this is for you. please improve your teaching style and choice of material if you even remotely interested in tutoring people.
arinzechukwu
January 5, 2023
It was okay I understood everything I was taught in this lesson, I love it. And also the instructors are really doing a great job. it very easy to follow up with their step by step explanations, i love it and i pray it grants me a job after completion
ANLIOU
December 24, 2022
Ce cours correspondait très bien à mes attentes. Mon niveau est intermédiaire donc j'ai trouvé la dernière partie un peu trop rapide. Mais c'est clair que chaque enseignant maîtrise son domaine. Merci beaucoup encore pour cette formation.
Farzin
December 15, 2022
Thank you for this part of the course. It's perfect for understanding the basic concepts of the pivot table.

Charts

Price

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Price chart

Rating

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Ratings chart

Enrollment distribution

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables - Distribution chart
3432302
udemy ID
8/19/2020
course created date
8/31/2020
course indexed date
Bot
course submited by