Business Analytics

This path is designed to help you harness the full power of Power BI in combination with R and Python. You will learn how to conduct advanced analyses and gain insight into complex business questions.

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 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 and modeling, focusing on Filter and Row Contexts for data computations, and the use of functions like SUM, SUMX, and Calculate.

This path is the most in-depth and rigorous on the list, designed to provide you expert-level skills in all of the key pillars of 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 path is designed to help you become an expert in data visualization, data storytelling, and report design. You will learn how to create advanced custom visualizations using bespoke visualization languages.

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.

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

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

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

Advanced course using Power BI & DAX to solve complex but common business problems and scenarios you'll face everyday

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.

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

Learn all about DAX calculations in Power BI. Learn introductory theory as well as how to put it into practice when developing Power BI models. 

Learn how to transfer your knowledge of SQL to DAX and vice versa

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

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

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

Use Power Query/ M effectively to prepare data for analysis

It  provides visibility to a wide range of insights to the performance of a typical call centre operation.

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

The different admin roles related to Power BI

What should you consider when putting your carefully-researched data together for an audience? Get the tips for using the right tools for each job.

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.

Use the data documenter tool to create an effective report template 

Showcase a report that compares the trends of two different sets of data over time. The report will specifically highlight any divergences in the trends, allowing the reader to easily see any discrepancies in the data.

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

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

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

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.