inquire@insightsmanila.com
0977.103.1800
MS Excel: Data Analytics Tool This training includes a thorough review of the use of MS Excel in connecting and transforming data, performing basic DAX calculations, and presenting in charts. Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365 Part 1. Fundamentals of Data Analytics •Data Analytics Process Flow and Cycle •Types of Data Analytics •Descriptive Analytics •Predictive Analytics •Terminologies in Data Analysis •Types of Data •Structured vs Unstructured •Qualitative vs Quantitative Part 2. Connecting and Preparing Data with Power Query •Connecting with Data Sources •Importing Data Using Folder Approach •Managing Data Source Settings •Using the Power Query Editor •Cleaning Your Data •Structuring Data for Analytics Purposes (Pivoting and Unpivoting) •Number-Specific Tools •Date-Specific Tools •Index Columns •Conditional Columns •Grouping Data •Merging and Appending Queries •Formatting Data Part 3. Data Modeling in PowerPivot •Importing Data to Power Pivot •Creating Calculated Columns •Creating PivotTables from PowerPivot •Introduction to DAX: using SUMX and RELATED Functions Part 4. Maximizing PivotTables to Perform Descriptive Analytics •Calculated Fields •Adding Texts inside Pivot Table Value Area •Calculated Items •Grouping Items •Showing Values Differently (as Percentage and as Different Calculation) •Using Slicers and Timelines •Creating Dashboards using Pivot Charts •Linking Pivot Charts to Create Interactive Dashboards Part 5. Other Data Analytics Tools in MS Excel •Exploring the Analysis Toolpak •Histogram • ANOVA • Performing F-Test • Descriptive Statistics •Using What If Analysis Tools • Goal Seek and Solver • Data Table • Scenario Manager •Performing Predictive Analysis • Regression Analysis using Analysis Toolpak (Identifying the R-Square, P-Value, and Calculating Trend Manually) • Creating a Forecast Sheet (Exponential Smoothing) • Using FORECAST Function Part 6. Data Visualization Overview •Creating Charts •Creating Charts with Functions (INDIRECT and OFFSET) •Creating Waterfall Chart to Show Value Progress |
Related Courses |