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.57 (2764 reviews)
17 298
students
29 hours
content
Jan 2024
last update
$109.99
regular price
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
Course Gallery
Loading charts...
Comidoc Review
Our Verdict
As a comprehensive data analytics toolbox, this Udemy bundle offers valuable insights into multiple platforms while providing hands-on experience with real-world projects. Though the Python segment could be further refined, and basic Excel users might not benefit as significantly from the course structure, the overall value remains high for both aspiring and experienced data analysts eager to expand their skill set across various tools.
What We Liked
- The course provides a comprehensive overview of data analysis tools, including PivotTables, Power BI, and Python.
- Instructors demonstrate advanced techniques for creating dynamic dashboards using Power Query, Power Pivot, and DAX.
- Covers essential Python concepts for data analytics, such as data types, built-in functions, and debugging errors.
Potential Drawbacks
- The integration of the Python module within the overall course objectives could be improved in order to provide a more cohesive learning experience.
- Some users have expressed concerns about the pacing and organization of course materials, as well as the lack of exercise solutions.
- Advanced Excel users may find certain sections overly basic or repetitive.
Related Topics
3432302
udemy ID
19/08/2020
course created date
31/08/2020
course indexed date
Bot
course submited by