ITI Business Intelligence Track

The internship consisted of 3 basic courses

MS SQL

Power BI

Tableau

Acquired Skills

Microsoft SQL Server

Create Databases using wizards.

Data modeling , database design and create DB diagrams.

Write various SQL queries to retrieve data and answer questions.

Power BI

Create dashboards using Power BI.

Create measures, and create visuals to represent the data.

Dealing with various databases such as CSV files, OLTP database and APIs.

Transform data using Power Query.

Advanced features of Power BI, such as DAX formulas and M language formulas.

Publish projects on Power BI Report Server and Power BI Service.

Tableau

Creating and publishing visualizations on Tableau Public

Working with different data sources

Advanced features of Tableau, such as calculated fields and mapping