Power Query can connect to a wide range of data sources. Databases such as SQL Server, Oracle, Text files, Big data and Hardtop data sources, online searches and Data feeds, Cloud storage, Facebook, SharePoint and many other types of data storage. Power Query extracts the data from sources, and does transformations such as splitting columns, [...]
As data becomes the modern currency, the ability to analyze data quickly and accurately has become of paramount importance. Therefore, data analytics and visualization are two of the most sought-after skills for high paying jobs with strong future growth prospects. This course will help you develop your analytical and visualization skills so that you not [...]
In this course, the participants will be introduced to the more intermediate features of Microsoft Excel. The participant will learn how to generate reports from Excel data. The course also shows the participant how to highlight important data using conditional formats, prevent date entry errors using Data Validation. At the end of the course, the [...]