Business Analytics

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 delves into data manipulation and analysis using SQL and DAX. It covers techniques and practical code examples.

This path is focused on developing expert level skills in data cleaning, data transformation and data modeling. You will learn to maximize the capabilities of the Power Query UI, and also write M code.

This path is similar to the Data Analyst learning path above, but is geared to building a strong and broad foundation of data analysis skills, as compared to being more specifically focused on passing the PL 300 exam.

This path is designed to provide you the necessary skills to build full enterprise apps by integrating Power BI , Power Automate and Power Apps. 

This Learning Path delves into data analysis techniques, focusing on Power BI functions. It guides learners to enhance their data insight extraction skills.

This Learning Path delves into data analysis and modeling, focusing on Filter and Row Contexts for data computations, and the use of functions like SUM, SUMX, and Calculate.

This path will provide you in-depth knowledge of the full range of Power BI best practices, with particular emphasis on building data models specifically optimized for Power BI.

A detailed step-by-step process of creating high-quality Power BI reports that satisfy the requirements of real-world scenarios

Build a strong foundation on your MS Excel skills as you progress to advanced level

Implement advanced & practical analytical techniques inside of Power BI and find insights you never thought possible in an intuitive way

This module discusses the different features of the Analyst Hub platform and the tips to maximize the use of tools to enhance Power BI development.

Master the ultimate tool for executing and analyzing DAX queries against various sources including Power BI and SSAS

Learn how to predict and optimize for results in the future, by utilizing 'what if' parameters and scenario analysis techniques

Disclose the unexpected' by expertly incorporating geospatial data into your analyses and visualizations

Become a better data storyteller by learning techniques to create reports that inspire and have an impact.

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

Combining the power of the data model with high level analysis

Learn how to use the Dataverse, Power Apps, Power Automate in Power BI

Use DAX ranking techniques in your analysis

Discover sample DAX techniques that enhance business insights and explore DAX formulas to leverage conditional formatting options

In this session, Ken will show you how he can build a complex Excel BI model leveraging Power Query and Power Pivot very quickly. 

View Replays of the August 2022 Business Intelligence Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more...

Check the Replays of the Feb 2022 Analytics Summit Event for Analysts, Excel Users, Database Professionals, Data Enthusiasts and more.

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

Identify trends and patterns in a variety of factors that influence the cost of living in different regions around the world by using statistical analysis techniques and visualization tools.

Analyze data from marketing campaigns and initiatives, using visualization tools and statistical analysis techniques to identify trends and patterns, and use these insights to inform marketing strategy and decision-making.

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

Show off your impressive financial report! We are confident that your financial report is a testament to your skills and expertise. We would love to see how you've structured it and how you've made it visually appealing.

Challenge yourself to produce a report which gives HR insight into the consultation process. 

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

Enhance your development skills by creating a supplier insights report