Excel

Deep Dive into Pivot Table Functionalities

Power BI

Importing Data

Connecting to and importing data from Excel (normal and Power Query approach)
Importing data from online services (e.g. Mailchimp, Salesforce, and Google Analytics)

Formatting Data

Visualizing Data

Maintaining Reports and Dashboards

Introduction to Pandas, Numpy and Matplotlib

Importing Data

Formatting and Filtering Data

Exploratory data analysis

Plotting with Pandas: line, scatter, box plots, histograms, probability density functions
Visualization with Matplotlib and Seaborn (.heatmap, .pairplot, .FacetGrid)

Time Series Manipulation