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

Deal Score+2
Deal Score+2

Data Analysts Toolbox Excel, Python, Power BI, PivotTables Udemy Coupon

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

Created by Simon Sez IT | 29 hours on-demand video course

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.

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

Recommended Course

Data Analysis with Python: NumPy & Pandas Masterclass

2023 Python Data Analysis & Visualization Masterclass by Colt Steele

Josh Smith
Josh Smith

The Couponos team has over ten years of experience finding free and 100%-off Udemy Coupons. We add over 200 coupons daily and verify them constantly to ensure that we only offer fully working coupon codes. We are experts in finding new offers as soon as they become available. They're usually only offered for a limited usage period, so you must act quickly.

      Udemy Coupon Codes Today - April 2024

      Gain access to over 11,000+ courses for just $16.58 [₹850] per month

      Choose between monthly or annual billing cycles, with the freedom to cancel at any time.

      The future belongs to learners. Udemy online courses as low as $13.99

      New customer offer! Top courses from $14.99 when you first visit Udemy

      Gain the skills you need to reach your next career milestone for as little as $11.99

      Coupons ME