Business and data problem solving with Excel data manipulation, Tableau dashboarding and Power BI data modeling — a comprehensive analytics course with real-world tools.
Business and data problem solving with Excel data manipulation, Tableau dashboarding and Power BI data modeling — a comprehensive analytics course with real-world tools.
Business & Data Problem-Solving Frameworks Understanding Business vs Data Problems Types of Analytical Approaches Descriptive, Diagnostic, Predictive, Prescriptive Structured Problem-Solving Frameworks Building Analytical Roadmaps Defining KPIs & Success Metrics Data Manipulation & Cleaning using Excel Advanced Data Cleaning Tools Remove Duplicates, Flash Fill, Text to Columns Data Preparation Functions: TEXT, DATE, FIND, MID, TRIM, CLEAN Logical & Lookup Functions: IF, IFS, AND, OR VLOOKUP, XLOOKUP, INDEX + MATCH Data Aggregation Functions: SUMIFS, COUNTIFS, AVERAGEIFS PivotTables & PivotCharts What-If Analysis Tools: Goal Seek & Scenario Manager Data Analysis & Dashboarding using Tableau Tableau Interface & Data Connections Data Cleaning & Joins Dimensions vs Measures Calculated Fields (Basic & Advanced) Essential Chart Types: Bar, Line, Scatter, Maps Dual Axis Charts & Advanced Visuals Filters, Parameters & Actions Dashboard Design Principles Data Analysis & Visualization using Power BI Power BI Interface & Workflow Power Query, Data Model & Report View Connecting Multiple Data Sources Data Modeling Fundamentals DAX Basics for Analysis