Big Data Analytics Using Microsoft Excel Course Info
Big Data Analytics 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.
Big Data Analytics Course Outline for This Programme
Module 1: Introduction to Big Data Analytics
- Course structure & course focus
- The Microsoft Data Platform
- Self-service tools vs traditional systems structure
- Flat files, relational files & database structure
Module 2: Excel Power Query
- 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
Module 3: Excel Power Pivot
- Power Pivot & the Data Model
- Understanding Power Pivot and Importing data into it
- Understanding Relationships between Tables and Creating Them
Module 4: Power BI Desktop's Power Query Editor
- Power Query Editor screen layout
- Extracting, Transforming & Loading data
- Mini project of creating a report from multiple data sources
Module 5: Data Modelling in Power BI
- Relational files & the Data Model in Power BI
- Cardinality, cross-filter direction
- Understanding & creating data relationships
Module 6: Creating Visualisation in Power BI
- 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
