Data Analysis

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

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

The Learning Path prepares candidates for the Microsoft Power BI Data Analyst certification, covering data preparation, modeling, visualization, analysis, and management of Power BI assets, with hands-on simulations and role-specific insights. It's a comprehensive guide for aspiring data analysts.

This Learning Path equips participants with comprehensive knowledge of Power BI's key features, emphasizing its four pillars: data transformation, modeling, DAX calculations, and visualization. Participants will learn to build analytical solutions, surpassing traditional Excel reporting.

Elevate your Power BI prowess by delving into the confluence of machine learning and Python, two of the most transformative domains in data science. Our learning path, "Advanced Power BI: Harnessing Python and Machine Learning", unravels a structured approach to predictive analytics and advanced data manipulations. Through an immersive hands-on experience, you will journey from the intricacies of predictive modeling in Power BI to harnessing the versatility of Python, ensuring you're well-equipped to tackle complex analytical challenges.

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

Dramatically enhance Power BI's capabilities by incorporating Python's flexible and powerful data wrangling, data analysis and data visualization functionality

PySpark made easy! Learn Pandas and Polars to navigate any dataset, uncover valuable insights, and become a data analysis powerhouse.

Discover the power of Microsoft Fabric and shape your future in data. Learn essential data engineering and analytics, and craft cutting-edge solutions with OneLake and Delta Lake.

Elevate your financial analytics skills with Python for Finance, exploring cutting-edge techniques for data retrieval, time series analysis, and predictive modeling.

Dive into AI transformation with LangChain! Master large language models and take your AI interactions to new heights for limitless possibilities.

Mastering Excel for Comprehensive Data Analysis

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

Advance your analytics capabilities: Transition from basic spreadsheets to Python and explore powerful data analysis techniques with our expert-led course.

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

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

In this episode of ‘The Analytic Mind’ podcast, join us as we delve deep into the transformative power of AI in the data analytics space and its broader implications across various industries.

Join Sam in this thought-provoking episode of ‘The Analytic Mind’, as he delves into the heart of the AI revolution and its transformative impact on data analysis.

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

Implement some creative Row-Level-Security techniques effectively and learn how to dynamically anonymize data

Explore structured columns containing Lists, Records or Tables

Create your most impressive financial report that showcases valuable insight into Power BI

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

Showcase a Power BI report example where you showcase a divergence in trends over time.

Develop an analysis report about the Football/Soccer Players Summer Transfers Season 2022-23

Create a navigation experience that showcases your brand and keeps users coming back for more by prioritizing the user experience and considering the needs and preferences of your target audience.

Use the data documenter tool to create an effective report template 

Create an analysis report on environmental data and potentially impact how this data is visualized and recorded

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

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.

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

This infographic offers a clear and straightforward guide to enhancing your role in your organization through data skills.

Embark on your Power BI journey in 2024 with these expert insights. This guide offers a comprehensive roadmap for both beginners and seasoned professionals.

Here’s your challenge should you choose to accept it

The Microsoft DP-500 exam, formally titled “Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI,” is designed to test your knowledge and skills in using the Azure environment and Power BI for advanced data analytics tasks.

This guide will empower you with insights into various roles, practical experience acquisition, navigating the job market, and upskilling opportunities.

This guide is here to simplify your journey with Excel, offering you the key tools, shortcuts, and techniques at your fingertips, so make sure to save it for future reference.