Business Analytics

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

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 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.

This Learning Path provides a deep dive into Power BI and DAX, focusing on data analysis techniques and visualization. It equips learners with skills to craft dynamic visualizations.

This path is designed to help you build expert level skills in the implementation, monitoring and governance of Power BI, including making optimal use of the Service through dataflows, datasets, thin reports, etc.

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.

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

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

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.

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

Learn the basics of SharePoint to increase productivity and collaboration, organize your data, and automate business processes

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

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

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

Learn simple yet effective techniques which can be used by anyone in your organization to discover valuable insights from their data sets

Incorporate multiple variables within function using List.Generate

Learn necessary elements to resolve granularities mismatches in different ways

In this session, you will learn how to manage Banking Transactions Directly Through Your Excel-VBA model

Use DAX ranking techniques in your analysis

Create reusable, templatized offset measures to further simplify and speed DAX analyses

Perform dynamic analysis of data through context transition in DAX

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

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

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.

Enhance your development skills by creating a supplier insights report

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.

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

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

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