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

Buy for 199.99$
Course 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 PythonThe basic data types in Python - Strings, Integers, Floats, and BooleanAll about Pythons built-in functionsHow Variables and Functions work in PythonHow to debug errors in PythonAll about Python KeywordsHow to use IF-Else Statements in PythonAll about storing complex data, including Lists and DictionariesAll about Python Modules and how to install themHow to install Python locallyHow to write your first script in PythonTo complete your first Python projectAdvanced PivotTablesHow to do a PivotTable (a quick refresher)How to combine data from multiple worksheets for a PivotTableGrouping, ungrouping and dealing with errorsHow to format a PivotTable, including adjusting stylesHow to use the Value Field SettingsAdvanced Sorting and Filtering in PivotTablesHow to use Slicers, Timelines on multiple tablesHow to create a Calculated FieldAll about GETPIVOTDATAHow to create a Pivot Chart and add sparklines and slicersHow to use 3D Maps from a PivotTableHow to update your data in a PivotTable and Pivot ChartAll about Conditional Formatting in a PivotTableHow to create amazing looking dashboardsPower Pivot, Power Query and DAXHow to get started with Power QueryHow to connect Excel to multiple workbooksHow to get data from the web and other sourcesHow to merge and append queries using Power QueryHow the Power Pivot window worksHow to set up and manage relationships in a data modelHow to create a PivotTable to display your data from the Power Pivot data modelHow to add calculated columns using DAXHow to use functions such as CALCULATE, DIVIDE, DATESYTD in DAXAll about creating Pivot Charts and PivotTables and using your data modelHow to use slicers to adjust the data you displayPower BIWhat 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 tutorials200+ individual video lecturesExercise files to practice what you learnedCertificate of completionHere's what our students are saying…The instructors have explained everything amazing and the resources are super helpful.- OscarThis course is very relevant in my line of work. The facilitators are detailed in their explanation & don't rush through the information.- ThulaniMy 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.- KenvisThank you for such a wonderful teaching. This is a great learning experience for me.- Ankush




We have 62183 courses
0 reviews
0 Rating

Udemy is one of the top online learning platforms founded in 2010 currently offering over 175,000 free and paid courses.

Related topics:

On our aggregator by searching online courses, you are able to take a course Data Analysts Toolbox: Excel, Python, Power BI, PivotTables for a fee: 199.99. This specific training belongs to category Excel from a supplier Udemy, and is a perfect choice at the level of difficulty: any level of expertise. Experienced teacher gladly will help you in achieving new professional horizons. You can check out feedback of other users about this online course or share your review to help other students make a decision!

How to get new skills with Skillcombo?

Explore courses that align with your interests, dive into detailed descriptions, and browse through reviews to confidently choose your next learning path. Easily use our filters for level, duration, language, and price to find the right option for your goals.

  • 15+ popular course providers
  • 60000+ online courses in catalog
  • 1000+ IT subjects