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

Data Analysts Toolbox: Excel, Python, Power BI, PivotTables, available at $94.99, has an average rating of 4.57, with 262 lectures, 34 quizzes, based on 2221 reviews, and has 13947 subscribers.

You will learn about 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 This course is ideal for individuals who are Advanced Excel Users or People looking to learn the Python Programming Language It is particularly useful for Advanced Excel Users or People looking to learn the Python Programming Language.

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

Summary

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

Price: $94.99

Average Rating: 4.57

Number of Lectures: 262

Number of Quizzes: 34

Number of Published Lectures: 262

Number of Published Quizzes: 34

Number of Curriculum Items: 296

Number of Published Curriculum Objects: 296

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

Advanced Excel Users
People looking to learn the Python Programming Language

Target Audiences

Advanced Excel Users
People looking to learn the Python Programming Language

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

Course Curriculum

Chapter 1: Advanced PivotTables: Introduction

Lecture 1: Introduction to Advanced PivotTables

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Course Exercise Files

Lecture 4: DOWNLOAD ME: Course Support Files

Lecture 5: PivotTables Recap

Chapter 2: Advanced PivotTable: Importing Data

Lecture 1: Importing data from a text file

Lecture 2: Importing data from Access

Lecture 3: Exercise 01

Chapter 3: Advanced PivotTable: Preparing Data for Analysis

Lecture 1: Cleaning Data

Lecture 2: Tabular Data

Lecture 3: Exercise 02

Chapter 4: Advanced PivotTable: Creating and Manipulating PivotTables

Lecture 1: Creating and Manipulating a PivotTable

Lecture 2: Combining Data from Multiple Worksheets

Lecture 3: Grouping and Ungrouping

Lecture 4: Report Layouts

Lecture 5: Formatting Error Values and Empty Cells

Lecture 6: Exercise 03

Chapter 5: Advanced PivotTables: Formatting PivotTables

Lecture 1: PivotTable Styles

Lecture 2: Custom Number Formatting

Lecture 3: Exercise 04

Chapter 6: Advanced PivotTables: Value Field Settings

Lecture 1: Summarizing Values

Lecture 2: Show Values As

Lecture 3: Exercise 05

Chapter 7: Advanced PivotTables: Sorting and Filtering

Lecture 1: Advanced Sorting

Lecture 2: Advanced Filtering

Lecture 3: Exercise 06

Chapter 8: Advanced PivotTables: Interacting with PivotTables

Lecture 1: Inserting and formatting Slicers

Lecture 2: Inserting and formatting Timelines

Lecture 3: Connecting Slicers to multiple PivotTables

Lecture 4: Using Slicers in Protected Workbooks

Lecture 5: Exercise 07

Chapter 9: Advanced PivotTables: Calculations

Lecture 1: Creating a Calculated Field

Lecture 2: Creating a Calculated Item

Lecture 3: Solve Order and List Formulas

Lecture 4: GETPIVOTDATA

Lecture 5: Exercise 08

Chapter 10: Advanced PivotTables: Pivot Charts

Lecture 1: Creating a Pivot Chart

Lecture 2: Formatting a Pivot Chart – Part 1

Lecture 3: Formatting a Pivot Chart – Part 2

Lecture 4: Creating a Map Chart using Pivot Data

Lecture 5: Dynamic Chart Titles

Lecture 6: Include a Sparkline with your PivotTable

Lecture 7: Exercise 09

Chapter 11: Advanced PivotTables: Conditional Formatting

Lecture 1: Highlighting Cell Rules

Lecture 2: Graphical Conditional Formats

Lecture 3: Conditional Formatting and Slicers

Lecture 4: Exercise 10

Chapter 12: Advanced PivotTables: Dashboards

Lecture 1: Creating an Interactive Dashboard – Part 1

Lecture 2: Creating an Interactive Dashboard – Part 2

Lecture 3: Updating Pivot Charts and PivotTables

Lecture 4: Exercise 11

Chapter 13: Course Close

Lecture 1: Course Close

Chapter 14: Introduction to PowerPivot and PowerQuery

Lecture 1: Welcome and Overview

Lecture 2: WATCH ME: Essential Information for a Successful Training Experience

Lecture 3: DOWNLOAD ME: Course Exercise Files

Lecture 4: DOWNLOAD ME: Course Demo Files

Lecture 5: What is Power Query?

Lecture 6: What is Power Pivot?

Chapter 15: Getting Started with Power Query

Lecture 1: Exploring the Power Query Editor

Lecture 2: Common Power Query Transformations

Lecture 3: Editing an Existing Query

Lecture 4: Import Multiple Files from a Folder

Lecture 5: Connect to Data in Another Excel Workbook

Lecture 6: IMPORTANT: Checking the Location of your Query's Source

Lecture 7: Get Data From the Web

Lecture 8: Practise Exercise

Chapter 16: Useful Power Query Features

Lecture 1: Unpivoting Columns

Lecture 2: Combine Data from Multiple Tables with Merge Queries

Lecture 3: Use Merge Queries to Compare Two Tables

Lecture 4: Stack Data into One Table with Append Queries

Lecture 5: Duplicating and Referencing Queries

Instructors

Simon Sez IT
870,000+ Students, 260+ Courses, Learners in 180+ Countries

Rating Distribution

1 stars: 17 votes
2 stars: 23 votes
3 stars: 158 votes
4 stars: 779 votes
5 stars: 1244 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu