No Messages
Data Analysts Toolbox: Advanced Excel, Python, Power BI, PivotTables
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 Data Analysts Toolbox, 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 is aimed at intermediate Excel users who are new to Python and Power BI. The course includes practice exercises so you can put into practice exactly what you learn. Here's what this comprehensive course covers: 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 and timelines on multiple tables How to create a calculated field All about GETPIVOTDATA How to create a PivotChart and add sparklines and slicers How to use 3D maps from a PivotTable How to update your data in a PivotTable and PivotChart All about conditional formatting in a PivotTable How to create amazing looking dashboards PowerPivot, 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 PowerPivot window works How to set up and manage relationships in a data model How to create a PivotTable to display your data from the PowerPivot data model How to add calculated columns using DAX How to use functions such as CALCULATE, DIVIDE, and DATESYTD in DAX All about creating PivotCharts 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 Importing CSV and Excel files into Power BI Desktop How to use merge queries to fetch data from other queries Creating 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 Using other visuals such as clustered column charts, maps, and trend graphs How to use slicers to filter your reports Using themes to format your reports quickly and consistently Editing the interactions between your visualizations and filter at visualization, page, and report level Introduction to Python The basic data types in Python - strings, integers, floats, and Boolean All about Python’s 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