Interactive Data Analytics Dashboard using Excel

Scope of works:

• Cleaning Raw Data

• Macro Creation (VBA)

• Creation of Pivot Tables

• Creation of Slicers

• Data Visualization

• Creation of Interactive Dashboard

Creating Data Base and Querying Data as needed

Scope of works:

• Creation of Data Base from raw files or tables

• Basic Querying with Logical Conditions

• Querying with Aggregate Functions

• Intermediate Querying Functions (Group By, Order By, Having)

• Advance Querying Functions (Inner Join, Outer Join, Case)

Power Query, Data Cleaning, Visualization and Dashboard

Scope of works:

• Querying to Database or Raw Files

• Data Cleaning

• DAX Functions and Measures

• Data Visualization

• Dashboard Creation

PANDAS, API connection to BigQuery and Google Sheets

Scope of works:

• Creating Code for Automated Data Collection

• Data Cleaning

• PANDAS

• API Connection to Update BigQuery Table

• API Connection to Create Automated Report in Google Sheets