Data Analysts Toolbox: Excel, Python, Power BI, PivotTables
$0.99
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.
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
Course content
5252 sections • 262 lectures • Total duration 29 h 12 min
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