Web Age Solutions Inc
Providing Technology Training and Mentoring For Modern Technology Adoption
Web Age Aniversary Logo
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887

Microsoft Newsletter – January 2020

What is the relationship between Power BI, Power Query, Power Pivot, and Power View?

Power BI is a one-stop self-service BI solution. It combines the features of Power Query, Power Pivot, and Power View that were initially introduced as add-ins for Excel. Power Query allows you to connect to and bring in data from various data sources, such as Dynamics 365, Salesforce, SQL Server, Oracle, CSV, XML, and SharePoint. Power Pivot among other things, lets you use DAX expressions to create calculated columns and shape data. Power View lets you create interactive dashboards. Power BI offers the benefits of all these components and much more.

What can I do with Power BI service as a consumer?

We all live in a data culture where business decisions are based on facts, not opinions. We need data to help us make these decisions.

Related course: 20778 Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. After completing this course, students will be able to:

• Perform Power BI desktop data transformation.
• Describe Power BI desktop modelling.
• Create a Power BI desktop visualization.
• Implement the Power BI service.
• Describe how to connect to Excel data.
• Describe how to collaborate with Power BI data.
• Connect directly to data stores.
• Describe the Power BI developer API.
• Describe the Power BI mobile app.

 

What is the best strategy to deploy applications on Microsoft Azure?

It depends on various factors, such as the application you want to deploy/migrate, development effort required, and budget. If you want quick migration, you can use IaaS solution, such as Virtual Machine — or Virtual Machine Scale Set for better scalability — but it will cost you more in the long run. If you want to cut down on the cost and already have cloud-ready applications, such as Docker Containers and Kubernetes, you can use Azure Container Service (ACS) and Azure Kubernetes Service (AKS). If you have relatively simpler applications — which use a single run-time such as .NET and Java — you can use App Service. Yet another solution is to use serverless computing strategy (Azure Functions) to deploy your applications.

Video: What Microsoft Azure Technologies are Right for You

 

Related course: AZ-900 Microsoft Azure Fundamentals

This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking further Microsoft Azure or Microsoft cloud services courses. The course will cover general cloud computing concepts as well as general cloud computing models and services such as Public, Private and Hybrid cloud and Infrastructure-as-a-Service (IaaS), Platform-as-a-Service(PaaS) and Software-as-a-Service (SaaS). It will also cover some core Azure services and solutions, as well as key Azure pillar services concerning security, privacy, compliance and trust. It will finally cover pricing and support services available with Azure.

Note: There are 2 editions of this course: 1-day and 2-day. The 2-day course (AZ-900T00) provides an Azure pass and time for students to participate in hands-on labs. If you do not need hands-on experience, consider the AZ-900T01: Microsoft Azure Fundamentals (1 day) course. The content for both courses align with the AZ-900 exam objective domain.)

US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887