Data Analysts Toolbox: Excel, Python, Power BI, PivotTables [Udemy Coupon Code]

"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Limited offer hurry up

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables is a top-rated Udemy course taught by Simon Sez IT — with over 17427+ students enrolled since it launched.

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

Don’t wait! This special offer won’t last long.

Click the button below to Get up to 100% OFF the regular price.

(The discount will be applied automatically at checkout — no code needed!)

Hurry — this discount on Data Analysts Toolbox: Excel, Python, Power BI, PivotTables won’t be around forever. Take action now!

100% off Udemy coupon code

Why enroll in the Data Analysts Toolbox: Excel, Python, Power BI, PivotTables Udemy Course?

  • Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
  • Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
  • Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
  • Udemy offers online coupons, promo codes and voucher for the majority of its courses.

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables Udemy Promotion code

Course Sections
Advanced PivotTables: Introduction
Advanced PivotTable: Importing Data
Advanced PivotTable: Preparing Data for Analysis
Advanced PivotTable: Creating and Manipulating PivotTables
Advanced PivotTables: Formatting PivotTables
Advanced PivotTables: Value Field Settings
Advanced PivotTables: Sorting and Filtering
Advanced PivotTables: Interacting with PivotTables
Advanced PivotTables: Calculations
Advanced PivotTables: Pivot Charts
Advanced PivotTables: Conditional Formatting
Advanced PivotTables: Dashboards
Course Close
Introduction to PowerPivot and PowerQuery
Getting Started with Power Query
Useful Power Query Features
Creating the Data Model
Introduction to DAX
More DAX Measures
Using PivotTables and Slicers
PowerPivot, PowerQuery and Dax: Closing
Introduction to Power BI
PowerBI: Getting and Transforming Data
Power BI: Data Modelling
Introduction to DAX Measures
Power BI: Adding Visualizations to your Report
Power BI: Report Design
Power BI: Editing Interactions and Filters
Power BI Service
Closing
Python: The Workplace Tech Divide
Introduction to Python
Python: Basic Data Types
Python Built-In Functions
Variables and Functions
Errors and Debugging
Python Keywords
If-Else Statements
Storing Complex Data
Python Modules
Installing Python and Modules
Project: Automate Data Updates For a Spreadsheet
Course Close
Introduction to Alteryx for Beginners
Alteryx: Data Blend & Prep
Alteryx: Data Parsing
Reporting
Alteryx: Analytic Apps
Alteryx: Spatial Data Analysis
Alteryx: Analytics
Course Close
Additional Training
Course Description
Requirements
You’ll need a copy of Microsoft Excel that is compatible with the Power Pivot tool.
A good understanding of MS Excel. This is an advanced level course.
Power BI Desktop installed on your machine is required to take the practice exercises
A good knowledge of MS Excel is advised but not necessary

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:

21+ hours of video tutorials

200+ individual video lectures

Exercise files to practice what you learned

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