This course is for all of those struggling with data analysis. You will learn: - Overcome data analysis challenges in your work and research - Increase your productivity and make better business decisions - Enhance your data analysis skills using spreadsheets - Learn about advanced spreadsheet possibilities like array formulas and pivottables - Learn about Excel 2013 features like PowerPivot & PowerMap - Learn to organize and test your spreadsheets
This course covers the main tasks required from data analysts today, including importing, summarizing, interpreting, analyzing and visualizing data. It aims to equip you with the tools that will enable you to be an independent data analyst. Most techniques will be taught in Excel with add-ons and free tools available online. You will learn: - How to make data come to life with well-known types of visualizations such as line and bar graphs and new types of visualizations such as spark lines, contour plots and population pyramids. - How to create dashboards in Excel based on live data that can meet managerial and business needs. - How to connect data from different sources, such as the web and exports from your CRM, ERP, SAP or data warehouse. - Some hands-on data science and how to use actionable analysis tools. - Deep dive into known tools like PivotTables and introduce new ones like the analysis toolpak
Are you ready to leave the sandbox and go for the real deal? Have you followed Data Analysis: Take It to the MAX() and Data Analysis: Visualization and Dashboard Design and are ready to carry out more robust data analysis? In this project-based course you will engage in a real data analysis project that simulates the complexity and challenges of data analysts at work. Testing, data wrangling, Pivot Tables, sparklines? Now that you have mastered them you are ready to apply them all and carry out an independent data analysis. For your project, you will pick one raw dataset out of several options, which you will turn into a dashboard. You will begin with a business question that is related to the dataset that you choose. The datasets will touch upon different business domains, such as revenue management, call-center management, investment, etc.