Power BI

This path is designed to build the broad range of expert-level knowledge necessary to confidently pass the PL-300 Data Analyst certification exam (replacement for DA-100).

This learning path provides a thorough understanding of SQL, emphasizing key commands for data manipulation and querying. 

This learning path offers a deep dive into data management and analysis, emphasizing the hands-on use of Python and Scala languages for manipulating CSV and JSON files, and the application of SQL for data querying. 

This Learning Path delves into advanced data analytics, focusing on implementing role-level security and measure-level security in data models. Participants will learn to manage joins, and pivot tables, and utilize calculation groups for dynamic data access and visualization.

This Learning Path delves into advanced data modeling techniques, focusing on Power BI and Enterprise DNA tools. Participants will learn to automate financial reports, utilize dynamic grouping formulas, and integrate various data sources for comprehensive analysis.

This Learning Path delves into data analysis and visualization using both R and Python, covering data cleaning, data frames, and the use of packages like dplyr, tidyverse, skim R, and seaborn. It offers hands-on examples, such as creating various plots, performing group-based operations, and utilizing descriptive statistics for effective data interpretation.

This Learning Path delves into creating external tools for Power BI, emphasizing JSON integration and the Microsoft Analysis Services Tabular API. Participants will explore UI development challenges and gain insights into open-source perspectives in tool development.

This Learning path delves into transformative data visualization techniques. Elevate your presentations, ensuring clarity and swift comprehension for your audience.

Unlock limitless visualization possibilities with Vega languages. Master custom graphic creation and elevate your data storytelling like never before!

Unlock the full potential of Power BI by mastering API integration to access a broader range of data. Enhance your analytics with our focused training!

Bridge the gap between GIS software and Power BI with our targeted training! Transform your mapping visuals and elevate your data storytelling skills.

Start building intelligent apps with ChatGPT and integrate it into your daily workflows to boost productivity. Learn the skills to revolutionize how you work!

Learn how to develop complete Power BI solutions that look compelling and deeply engage your consumers in your insights

Dominate the Microsoft Power Platform (PL-900) Certification exam with our comprehensive training guide. Gain the knowledge and confidence to excel!

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI

Bridge your SQL expertise to DAX and back seamlessly with our specialized course. Maximize your data skills and thrive in any analytics environment!

Sam McKay talks to Paul Lucassen, one of our Enterprise DNA experts, about the role of geospatial data analytics in the transportation and logistics industry

Join Sam McKay and Anuj Kapoor as they talk about how data analytics is helping the healthcare industry save lives. Anuj also discusses the importance of establishing a problem statement and having quality data to work with

Listen as Jarrett Moore talks to Sam McKay on how he scaled a data analytics system for his own company and built a separate data product on top of it

Listen as Sam McKay talks to Shiv Misra on why companies need to have an appetite for change and embrace data analytics

Sam McKay talks to Brian Julius on how to integrate data culture in one’s own organization. Brian is an Enterprise DNA expert who has a thriving career as a project management lead for Power Platforms in the public sector, where he uses data to improve government processes.

Learn how to clean, optimize and model data tables to develop effective, insightful and actionable Power BI reports

Explore possibilities for supercharging Power BI with R’s modeling and visualization capabilities.

Instructor-led training and tips for successful Power BI visualization

Challenge your data skills in creating an analysis report on substance

Practice your data skills and learn from what is a typical scenario faced by many businesses in various industries

Analyze the data of a large insurance company who are due to undergo an internal audit with regard to its complaint’s procedure

Create a summary report, a task that for many data analysts will always find its way across the desk every so often

Provide a business solution by creating an intelligence tool to use by large opticians

In this challenge, participants are encouraged to dive deep, explore, and come up with unique insights and visualizations.

Work on one of the most significant measures for manufacturing productivity - OEE

Take a deep dive into the world of utilisation and timesheet data

Make sure you're using the right chart type for your data with this easy-to-use tool. It's completely interactive and follows the latest best practices and IBCS guidelines.

This is focused on one of the key functionalities of Power Query M – the 'Group By' or 'Table Group' operation.

Need help deciding what Power BI license is right for you and your organization? We've simplified everything you need to know into one document, making it easy for you to quickly assess what fits with your Power BI deployment.

Dive into the world of data visualization and business intelligence in Power BI. This comprehensive resource is tailored for newcomers eager to understand the fundamentals of Microsoft's leading BI tool.

This offers techniques to retrieve and manipulate data based on specific row indexes or key matches, enhancing the flexibility and precision of data analysis.

Learn how to effectively use this function in various real-world scenarios. It also demonstrates how this function can handle different types of whitespace characters

The Power Query M language constructs lists, which are ordered sequences of comma-delimited values enclosed in curly brackets, capable of holding any type of value, and are lazily evaluated, potentially supporting infinite elements.

The DAX Formula Reference Guide is a must-have resource for any Power BI user looking to master DAX functions.