Data Analysis

Data analysis is a process of inspecting, cleansing, transforming and modeling data with the goal of discovering useful information, informing conclusions and supporting decision-making. Data analysis has multiple facets and approaches, encompassing diverse techniques under a variety of names, and is used in different business, science, and social science domains. In today’s business world, data analysis plays a role in making decisions more scientific and helping businesses operate more effectively.

Course Objectives

Upon completing this Data Analysis Training Certification course successfully, participants will be able to:

  • Learn about data model creation
  • Explore, analyse, and visualise data
  • Sift data using slicers in multiple pivot tables
  • Produce aggregate reports using formula-based techniques
  • Collect and transform data from multiple sources
  • Understand and combine data in mashups
  • Generate flexible data aggregations using pivot tables
  • Exemplify data visually using pivot charts
  • Evaluate margins and other popular ratios using calculation on the pivot table

Who Should Attend?

This Data Analysis Training course  would be suitable for:

  • IT Professionals
  • Testing professionals
  • Programming Developers and System Administrators
  • Business Intelligence, Data Warehousing and Analytics Professionals
  • Data Engineers
  • Data Analysts & Business Intelligence Professionals
  • Database Administrators and other DB professionals
  • Anyone who works with Excel regularly
  • Individuals who want to learn data exploration and analysis
  • Anyone looking to pursue a career in data analysis or business intelligence
  • Participants looking for a comprehensive, engaging, and highly interactive approach to training

Course OutlineMODULE 1: DATA ANALYSIS WITH EXCEL
  • What is Data Analysis?Advanced Excel Formulas & FunctionsStructuring Source Data for Analysis in ExcelExcel tablesAdvantage of Excel tables over regular rangesFilter, sort and see totalsUse tables to add columns to the existing data in the Excel tableRaw data structure in ExcelDesign & formatting optionsSorting, filtering, & grouping toolsCalculated fields, items & valuesInteractive Excel dashboards
  • MODULE 2: PIVOT TABLES
  • Why Pivot Tables?Create pivot tablesData Analysis with Excel PivotTablesUse pivot tables and pivot charts to create dashboardsConnect multiple slicers to the pivot tablesConfiguring pivot table layouts & stylesPivot Table layouts & stylesPivot Charts, slicers & timelines
  • MODULE 3: AGGREGATE DATA
  • Use formulas to aggregate dataAggregate data as an alternative to pivot tablesFlexible reporting layoutsPivot charts using more than one table
  • MODULE 4:
  • Data analysis in Excel using tools:
    • pivot tablespivot charts and slicers
    Excel data modelsPower Pivot add-inMODULE 5: QUERIESWhat are the queries?Excel data model built from a single flat tableImport multiple tables from a SQL databaseCreate an Excel data model using imported dataCreate a collated result with data from text-files and data from a SQL databaseUp & running with Power BI DesktopPublishing to Power BI ServiceSQL database analysis for beginners
  • MODULE 6: DATA FILTERS & MEASURES
  • How to establish measures to calculate each cellFilter context for calculationEnhanced queries to import data from a formatted Excel sheetQueries beyond the standard user interface
  • MODULE 7: DATA VISUALIZATIONS
  • Data visualizations in ExcelCube functions for year-over-year comparisonsCreate timelines, hierarchies, and slicersExcel working together with Power BIExcel workbooks with Power BI serviceExcel on the mobile platform