One of the main methods technical professionals shows their understanding of a subject has been through an intense exam and certification process. Microsoft is changing their exam renewal system to keep up and make renewals easier and cheaper to help you keep up to date.
The key to certification success is to make sure you have the current requirements and training sites to have the best chance of passing the exam. This guide reviews the Microsoft exam structure, the program’s role-based nature, and the material provided.
As with many exams, Microsoft certifications are not all that difficult if you are well prepared. Having had to write a few over the last couple of years, seven to be exact, which shows that anyone can do this if you prepare. This article presents my five most essential tips that have helped me in my certification journey.
In this Learning Path for the Azure Synapse (Formerly Azure SQL Data Warehouse), you are provided with various online resources in a structured learning format. Each level contains the objectives delivered through articles, labs and tutorials.
As of June 21, 2019 the exams, Exam DP-200: Implementing an Azure Data Solution and Exam DP-201: Designing an Azure Data Solution have changed. The exams look to be more focused in order to differentiate between a data engineer role from a database administrator role.
For those DBAs are using SQL for data discovery, the move to data science can involve a brand-new set of varied tools and technologies. This article is a walkthrough of setting up the tooling to do some data discovery using Python. By setting up your workflow using, GitHub, VSCode and Python you will have the basic architecture set up for Data Exploration.
You are writing and come across a word that just does not look right. This article covers one of my pet peeves, “Productionalization”. As I looked at various sources, I realized that perhaps I have to open my mind to the new english.
It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.
The best place to start when learning to develop Power BI solutions is to review the logical architecture your Data Visualization projects will have. There are many moving parts and pieces to a Power BI solution, especially when looking at the varied data sources you can use. From on-premises to web-based, from public to confidential, you must make sure you expose your data securely. Having a good clear architecture will help you achieve a not only a good solution but also a secure one. The following article will show you how you can architect your own solution.
One of the challenges for users with Power BI is being able to use a data source that you can update and flow those changes to your Power BI dashboards and reports. Using an Excel file in OneDrive for Business allows you to have multiple users update data, connect to a data source and schedule an automated refresh without having a lot of infrastructure. The following walkthrough will show you how you can leverage this feature for your own solution.