Amazon AWS Certified SysOps Administrator Associate – Databases for SysOps
1. [SAA/DVA] RDS Overview So let’s get started with an overview of AWS RDS. RDS stands for relational database service. And what it means is that it’s a managed database service for database that use SQL as a query language. So SQL is a structured language to query a database. It’s very well adapted and… Read More »
Amazon AWS Certified SysOps Administrator Associate – CloudFront Part 2
4. CloudFront Caching – Deep Dive So here is a deep dive lecture on CloudFront caching. And on CloudFront you can cache based on multiple things and we’ll do a deep dive on all those. So headers, session cookies, query string parameters, and based on the combinations of what you set for these parameters, the… Read More »
Amazon AWS Certified SysOps Administrator Associate – CloudFront
1. [SAA/DVA] CloudFront Overview Now we’re getting into content delivery and we’ll start by CloudFront. So CloudFront is a content delivery network or CDN, and what it does is it improves read performance because the content is going to be distributed and cached at the edge locations. And edge locations are all around the world… Read More »
PL-300 – Section 38: Part 4 Section 7 – Other Power BI Service Topics
281. Create a PivotTable from a Power BI Dataset in Excel Now, suppose you didn’t actually want to export the data, you just wanted to do an analysis in Excel, namely a pivot chart. So that’s equivalent of a matrix in Power BI. Well, you can do this in Excel fairly easily. But you might… Read More »
PL-300 – Section 37: Part 4 Section 6 – Create and Manage Workspaces Part 2
278. Promote or Certify Power BI Report or App Now, that we’ve created an app, how can we say how good an app this is? You’ll remember that a few videos ago, we were able to promote or certify or endorse datasets. Well, as of around October 2020, Power BI now allows you to endorse… Read More »
PL-300 – Section 37: Part 4 Section 6 – Create and Manage Workspaces
274. Create and Configure a Workspace Hello. Now, up till now we’ve been using the private workspace called My Workspace. You can share items from it, but it’s not really designed to have a big solution being there. However, workspaces, which can hold data sources, datasets, reports, and dashboards can be more than just My… Read More »
PL-300 – Section 36: Part 4 Section 5 – Manage Datasets Part 2
271. Configure a Dataset Scheduled Refresh In the previous video, we installed a gateway connection, which will allow Power BI Service to connect to my computer. In this video, we’ll have a look at how we can refresh the data automatically. Now, your data source cannot be refreshed because your credentials are invalid. Okay, let’s… Read More »
PL-300 – Section 36: Part 4 Section 5 – Manage Datasets
267. Analyze in Excel Hello. And in this section, we’re going to be looking at managing databases. So again, we will have a video for each of the DA-100 exam requirements. And we’re going to start off with Analyse in Excel. So, you’ve got your datasets and also reports, open the Power of BI Service… Read More »
PL-300 – Section 35: Part 4 Section 4 – Dashboards Part 2
264. Add a Dashboard Theme In this video, we’re going to have a look at Dashboard Themes. And we’ve already had a look at themes in Power BI. When we were going into the themes, we were able to say, well actually, I want my page to be of a particular theme. And that alters… Read More »
PL-300 – Section 35: Part 4 Section 4 – Dashboards
258. Differences Between Dashboards and Reports Hello. In this section, we’re going to have a look at Dashboards in the Power BI Service. Now, dashboards and reports sound similar. So, what we’re going to do first of all, in this video is look at the differences between dashboards and reports. Then we’re going to look… Read More »
