Home

All courses

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

Data Analysis

Business

Business Analytics & Intelligence

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.5

(3134)

19120 enrolled on this course

Last updated 11/2021

Simon Sez IT

₹ 3499.0

₹ 4999.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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:
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
Who this course is for:
Advanced Excel Users
People looking to learn the Python Programming Language

What you'll 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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Advanced PivotTables: Introduction

1.1-Introduction to Advanced PivotTables

1.2-WATCH ME: Essential Information for a Successful Training Experience

1.3-DOWNLOAD ME: Course Exercise Files

1.4-DOWNLOAD ME: Course Support Files

1.5-PivotTables Recap

1.6-Section Quiz

2-Advanced PivotTable: Importing Data

2.1-Importing data from a text file

2.2-Importing data from Access

2.3-Exercise 01

2.4-Section Quiz

3-Advanced PivotTable: Preparing Data for Analysis

3.1-Cleaning Data

3.2-Tabular Data

3.3-Exercise 02

3.4-Section Quiz

4-Advanced PivotTable: Creating and Manipulating PivotTables

4.1-Creating and Manipulating a PivotTable

4.2-Combining Data from Multiple Worksheets

4.3-Grouping and Ungrouping

4.4-Report Layouts

4.5-Formatting Error Values and Empty Cells

4.6-Exercise 03

4.7-Section Quiz

5-Advanced PivotTables: Formatting PivotTables

5.1-PivotTable Styles

5.2-Custom Number Formatting

5.3-Exercise 04

5.4-Section Quiz

6-Advanced PivotTables: Value Field Settings

6.1-Summarizing Values

6.2-Show Values As

6.3-Exercise 05

6.4-Section Quiz

7-Advanced PivotTables: Sorting and Filtering

7.1-Advanced Sorting

7.2-Advanced Filtering

7.3-Exercise 06

7.4-Section Quiz

8-Advanced PivotTables: Interacting with PivotTables

8.1-Inserting and formatting Slicers

8.2-Inserting and formatting Timelines

8.3-Connecting Slicers to multiple PivotTables

8.4-Using Slicers in Protected Workbooks

8.5-Exercise 07

8.6-Section Quiz

9-Advanced PivotTables: Calculations

9.1-Creating a Calculated Field

9.2-Creating a Calculated Item

9.3-Solve Order and List Formulas

9.4-GETPIVOTDATA

9.5-Exercise 08

9.6-Section Quiz

10-Advanced PivotTables: Pivot Charts

10.1-Creating a Pivot Chart

10.2-Formatting a Pivot Chart - Part 1

10.3-Formatting a Pivot Chart - Part 2

10.4-Creating a Map Chart using Pivot Data

10.5-Dynamic Chart Titles

10.6-Include a Sparkline with your PivotTable

10.7-Exercise 09

10.8-Section Quiz

11-Advanced PivotTables: Conditional Formatting

11.1-Highlighting Cell Rules

11.2-Graphical Conditional Formats

11.3-Conditional Formatting and Slicers

11.4-Exercise 10

11.5-Section Quiz

12-Advanced PivotTables: Dashboards

12.1-Creating an Interactive Dashboard - Part 1

12.2-Creating an Interactive Dashboard - Part 2

12.3-Updating Pivot Charts and PivotTables

12.4-Exercise 11

13-Course Close

13.1-Course Close

14-Introduction to PowerPivot and PowerQuery

14.1-Welcome and Overview

14.2-WATCH ME: Essential Information for a Successful Training Experience

14.3-DOWNLOAD ME: Course Exercise Files

14.4-DOWNLOAD ME: Course Demo Files

14.5-What is Power Query?

14.6-What is Power Pivot?

14.7-Section Quiz

15-Getting Started with Power Query

15.1-Exploring the Power Query Editor

15.2-Common Power Query Transformations

15.3-Editing an Existing Query

15.4-Import Multiple Files from a Folder

15.5-Connect to Data in Another Excel Workbook

15.6-IMPORTANT: Checking the Location of your Query's Source

15.7-Get Data From the Web

15.8-Practise Exercise

15.9-Section Quiz

16-Useful Power Query Features

16.1-Unpivoting Columns

16.2-Combine Data from Multiple Tables with Merge Queries

16.3-Use Merge Queries to Compare Two Tables

16.4-Stack Data into One Table with Append Queries

16.5-Duplicating and Referencing Queries

16.6-Grouping and Aggregating Data

16.7-Conditional Columns in Power Query

16.8-Practise Exercise

16.9-Section Quiz

17-Creating the Data Model

17.1-Enable the Power Pivot Add-In

17.2-Understanding the Power Pivot Window

17.3-Creating Relationships Between Tables

17.4-Managing the Relationships of the Model

17.5-Creating a PivotTable from the Data Model

17.6-Hide Fields from Client Tools

17.7-Grouping Queries

17.8-Practise Exercise

17.9-Section Quiz

18-Introduction to DAX

18.1-Why use DAX?

18.2-Creating Calculated Columns with DAX

18.3-Creating your First DAX Measure

18.4-The COUNTROWS Function

18.5-SUMX and RELATED Functions

18.6-Practise Exercise

18.7-Section Quiz

19-More DAX Measures

19.1-Create a Date Table in Power Pivot

19.2-The CALCULATE Function

19.3-The DIVIDE Function

19.4-Using the DATESYTD Function

19.5-Calculate the Percentage of a Total

19.6-Practise Exercise

19.7-Section Quiz

20-Using PivotTables and Slicers

20.1-Create PivotTables and PivotCharts

20.2-Using Slicers with your PivotTables

20.3-Create a Top 10 PivotTable

20.4-Practise Exercise

20.5-Section Quiz

21-PowerPivot, PowerQuery and Dax: Closing

21.1-Wrap Up

22-Introduction to Power BI

22.1-Welcome and Overview

22.2-WATCH ME: Essential Information for a Successful Training Experience

22.3-DOWNLOAD ME: Course Exercise File

22.4-DOWNLOAD ME: Course Demo Files (Section 2-4)

22.5-DOWNLOAD ME: Course Demo Files (Section 5-8)

22.6-Downloadable Course Transcript

22.7-What is Power BI?

22.8-Install Power BI Desktop

22.9-A Tour of BI Desktop

22.10-Explore Commonly Used Power BI Options

22.11-Section Quiz

23-PowerBI: Getting and Transforming Data

23.1-Import Files from a Folder into Power BI Desktop

23.2-Get Data from Excel and Text Files

23.3-Changing Query Course

23.4-Reference Queries to Create Additional Lookup Tables

23.5-Merge Queries in Power Query

23.6-Prevent Queries from Loading into Power BI Desktop

23.7-Practise Exercise

23.8-Section Quiz

24-Power BI: Data Modelling

24.1-Create Relationships Between Tables

24.2-Create a Dynamic List of Dates

24.3-Create Additional Date Columns for Analysis

24.4-Sort the Month and Weekday Names Correctly

24.5-Mark the Table as a Date Table

24.6-Hide Unnecessary Fields from Report View

24.7-Practise Exercise

24.8-Section Quiz

25-Introduction to DAX Measures

25.1-Calculate the Total Revenue

25.2-Count the Total Rows of a Table

25.3-Use the CALCULATE Function

25.4-Calculate the Total Revenue Last Year

25.5-Difference Compared to Last Year

25.6-Practise Exercise

25.7-Section Quiz

26-Power BI: Adding Visualizations to your Report

26.1-Show Summary Information with Cards

26.2-Columns Charts to Compare Values

26.3-Map Visual to Plot Geographic Data

26.4-Slicers to Filter your Reports

26.5-KPI Card to Measure Performance Against a Goal

26.6-Line Graphs to Visualise Trend

26.7-Show Detail with the Matrix

26.8-Top N Lists with the Table Visualisation

26.9-Practise Exercise

26.10-Section Quiz

27-Power BI: Report Design

27.1-Adding Text Boxes and Shapes

27.2-Use Themes

27.3-Conditional Formatting

27.4-Practise Exercise

27.5-Section Quiz

28-Power BI: Editing Interactions and Filters

28.1-Edit the Interactions between your Visualisations

28.2-The Filter Pane to Filter at Any Level

28.3-Drill Through to More Detail

28.4-Practise Exercise

28.5-Section Quiz

29-Power BI Service

29.1-Publish Your Report to the Power BI Service

29.2-Different Ways to Share your Power BI Report

29.3-Practise Exercise

29.4-Section Quiz

30-Closing

30.1-Wrap Up

31-Python: The Workplace Tech Divide

31.1-Which Side of the Divide Are You On?

31.2-WATCH ME: Essential Information for a Successful Training Experience

31.3-DOWNLOAD ME: Course Exercise Files

31.4-DOWNLOAD ME: Course Project Files

31.5-Downloadable Course Transcripts

31.6-Beginners Are Welcome

31.7-Course Overview

32-Introduction to Python

32.1-What is Python?

32.2-Python's Comparison to Other Programming Languages

32.3-Examples of Python in the Workplace

32.4-The Easiest Place to Practice Python

32.5-Create an Account Online

33-Python: Basic Data Types

33.1-Python Data Types

33.2-Strings

33.3-Integers

33.4-Floats

33.5-Boolean

33.6-Data Types Exercise

33.7-Section Quiz

34-Python Built-In Functions

34.1-What is a Built-In Function?

34.2-Where to Look For Built-In Functions

34.3-Most Common Built In Functions

34.4-Built In Functions Exercise

34.5-Section Quiz

35-Variables and Functions

35.1-Variables and Functions

35.2-Storing Values as Variables

35.3-Comparing Variables with Operators

35.4-Basic Expressions

35.5-Functions

35.6-Commenting

35.7-Variables and Functions Exercise

35.8-Section Quiz

36-Errors and Debugging

36.1-What is an Error?

36.2-Reading a Stack Trace

36.3-Print Function

36.4-Try and Except

36.5-You Are Not Alone

36.6-Errors Exercise

36.7-Section Quiz

37-Python Keywords

37.1-Python Keywords

37.2-Common Keywords

37.3-Global

37.4-Keywords Exercise

37.5-Section Quiz

38-If-Else Statements

38.1-Basic Logic

38.2-Syntax and Inline Evaluation

38.3-Value Evaluation

38.4-Complex If-Else Statements

38.5-If-Else Exercises

38.6-Section Quiz

39-Storing Complex Data

39.1-Advanced Data Types

39.2-Lists

39.3-Dictionaries

39.4-Looping: Lists

39.5-Looping: Dictionaries

39.6-Advanced Data Exercise

39.7-Section Quiz

40-Python Modules

40.1-Python Modules

40.2-Python Built In Modules

40.3-Importing Modules

41-Installing Python and Modules

41.1-Python Environments

41.2-Mac

41.3-Windows

41.4-IDEs

41.5-Python Idle

41.6-Managing files and folders

41.7-Executing Scripts

41.8-PIP

42-Project: Automate Data Updates For a Spreadsheet

42.1-Project Introduction

42.2-Setting Up Project

42.3-Reading and Writing to Excel Files

42.4-Working with CSV Files

42.5-Dynamic File Paths

42.6-Transform and Validate Transactions

42.7-Transfer and Save Transactions

42.8-Clean Up the Code

42.9-Hardening the Script

43-Course Close

43.1-What's Next?

44-Introduction to Alteryx for Beginners

44.1-Introduction

44.2-WATCH ME: Essential Information for a Successful Training Experience

44.3-Course Instructor Files

44.4-Alteryx Essentials

44.5-Data Types 101

44.6-Getting Started with the Alteryx Designer

44.7-Building a Workflow in Designer

44.8-The Favorites Tools

45-Alteryx: Data Blend & Prep

45.1-Data filtering for Beginners

45.2-Intro to Alteryx for Excel Users

45.3-Alteryx for the SQL Analyst

45.4-Introduction to Basic Functions - Part 1

45.5-Introduction to Basic Functions - Part 2

45.6-Introduction to Basic Functions - Part 3

46-Alteryx: Data Parsing

46.1-Basic Parsing Methods

46.2-Basic Parsing Methods w/ Dynamic Renaming

46.3-Basic Vlookup and Append

46.4-Working on Multiple Fields in Alteryx

46.5-Build an Alteryx Workflow

46.6-Basic Tips and Tricks

47-Reporting

47.1-Alteryx Best Practices - Visualizing Data

47.2-Alteryx Best Practices - Visualizing Data with Texts and Charts

47.3-Alteryx Best Practices - Layouts and Rendering

48-Alteryx: Analytic Apps

48.1-Introduction to Analytic Apps

48.2-Introduction to Macros

49-Alteryx: Spatial Data Analysis

49.1-Intro to Data Analysis - Working Spatial Data

49.2-Intro to Data Analysis - Measuring

49.3-Intro to Data Analysis - Spatial Objects

50-Alteryx: Analytics

50.1-Introduction to Analytics

50.2-Introduction to K-Centroid Clustering

50.3-Introduction to K-Nearest Neighbor

50.4-Introduction to Market Basket Analysis

50.5-Introduction to Logistic Regression Analysis

50.6-Introduction to Linear Regression Analysis

50.7-Introduction to Tree-based Models Part 1

50.8-Introduction to Tree-based Models Part 2

51-Course Close

51.1-Course Close

51.2-Course Quiz

52-Additional Training

52.1-READ ME: This Additional Training Is Optional

52.2-Ten Excel Tips and Tricks - Part 1

52.3-Ten Excel Tips and Tricks - Part 2

52.4-Ten Excel Tips and Tricks - Part 3

Course Categories

Popular Courses

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

Description

What you'll learn

Requirements

Course Content

You May Like