Intro

  • PowerBI - Data Visitations, analyzation, and transformation tool

  • Data Analysis Expressions (DAX) - PowerBI programming language that allows you to perform data modeling and powers all your calculations (i.e. analytics), the language originates from Excel queries

  • Report View - This is where you will see visualization options

    • Pages - This is where you will have different data visuals

    • Each PowerBI Desktop will only have one report view just like Microsoft Word only has one document open

  • Power Query - Data transformation tool integrated with PowerBI where you can clean the data to the way you like

  • Data Source Connectors - access data from various sources like Excel, not an API

    • Web Data Source Connector - allows you to use a web API endpoint to get data from a server

  • Blank vs. Null Data Cells - Blank data makes it hard to transform data so you should change blank cells to null so that you can use data transformations commands like fill

API

  • API - way for applications to communicate with one another

  • Representation State Transfer (REST) - an industry standardize way for API’s to be created and communicate

  • REST API - scalable and stateless API

  • Stateless API - An API where the call from the client has to contain all the necessary information for the server to execute the request independently of any past calls or request, it also the job of the client to know the current state of server.

    • Ex. When you (i.e. the client) order food at a restaurant it is not the job of the chef (i.e. the server) to know your allergies, or anything else related to your order or past orders. the waiter (i.e. the API) must gather all that information before submitting the order to the chef, as well as knowing what food is out of stock.

  • RESTFUL - services that use REST API’s to communicate

  • REST API - scalable and stateless API

  • Create, Read, Update, Delete (CRUD) - actions that you want to do with an http API the equivalent are Post, Get, Put, Delete

  • Example REST API’s that I have used

    • AWS S3 Bucket API to reference images inside a Flutter Application

    • Angular API for Unit Testing

    • Gemini API for prompting

Skills mentioned during the interview

  • PowerApps

  • API’s

  • Splunk