Big Data Analytics Analytics Using Microsoft Excel

This training covers in detail advanced tools in Excel, and interesting, powerful features of Power BI to extract, transform and remodel data for statistical analysis, reporting and decision making.

Free

Big Data Analytics Analytics Using Microsoft Excel

2 days
All levels
0 lessons
0 quizzes
0 students

Course Info

This training covers in detail advanced tools in Excel, and interesting, powerful features of Power BI to extract, transform and remodel data for statistical analysis, reporting and decision making.

Course Outline for This Programme​

  • Course structure & course focus
  • The Microsoft Data Platform
  • Self-service tools vs traditional systems structure
  • Flat files, relational files & database structure
  • Creating a Query & Connecting Data Source using Power Query
  • Merging & appending queries, combining data from folders
  • Automating consolidation of files, creating index
  • Changing data types, data format & replacing values
  • Merging columns
  • Unpivoting, pivoting & replacing values in columns
  • Power Pivot & the Data Model
  • Understanding Power Pivot and Importing data into it
  • Understanding Relationships between Tables and Creating Them
  • Power Query Editor screen layout
  • Extracting, Transforming & Loading data
  • Mini project of creating a report from multiple data sources
  • Relational files & the Data Model in Power BI
  • Cardinality, cross-filter direction
  • Understanding & creating data relationships
  • Using the Power BI Desktop & web version
    o Adding visualizations to the Report, Using Data view to sort & format data
  • Designing your dashboard
  • Creating column, graphical charts, matrices, KPIs & tables, maps, ArcGIS maps
  • Inserting slicers into the dashboard & Using inline hierarchies
Curriculum is empty
Julian

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications