Business Intelligence & Analytics

Power Query Fundamentals Case Study

Power Query Challenges Overview Test your Power Query problem-solving skills with this short challenge-based case study. From easy table manipulations, through to more complex challenges that require dynamic solutions, this case study will test a range of skills and approaches. Each challenge is introduced with a set of requirements, followed by a guided walkthrough of…

Continue reading

Intermediate DAX & Time Intelligence

Intermediate DAX & Time Intelligence Overview DAX is essential for working with data and data models in Excel and Power BI. Many analysts start building complex DAX formulas, without a solid grounding in DAX basics, context manipulation, and time intelligence. In this course, we’ll quickly review the basics of DAX formulas for creating Measures and…

Continue reading

Fundamentals of Data Analysis in Excel – Case Study

Data Analysis in Excel Case Study Overview This case study takes you deep into Excel data analysis through seven challenges. Each challenge has different tasks that progressively increase in difficulty. It’s a hands-on way to practice your Excel skills—solving problems you might face in real-world scenarios. For each challenge, you’ll get a unique dataset. Your…

Continue reading

Python Fundamentals Case Study

Python Fundamentals Case Study In this case study, you’ll be placed into the role of a data analyst at a clothing retail company. You’ll be helping them to understand their sales patterns, transactions, and information about their products by exploring multiple data frames. Through this case, you’ll answer business questions and develop visualizations to take…

Continue reading

Tableau Fundamentals Case Study

Tableau Fundamentals Case Study – Calwest E-Commerce Overview In this course, you’ll act as a data visualization analyst for Calwest E-commerce. In that role, you’ll be fulfilling a set of business requirements to build several visuals and dashboards in Tableau. Using what you learned in Tableau Fundamentals, you’ll build basic visuals, apply formatting, and create interactive functionality….

Continue reading

SQL Case Study – WOWI Sales Analysis

SQL Case Study – WOWI Sales Analysis Course Overview You’ve recently joined World Wide Importers as a Business Intelligence Analyst. They are a novelty goods distributor and are keen to get you involved in helping make some key business decisions. You’ll be exploring the database, responding to questions from the product and marketing teams, and…

Continue reading

Power BI Case Study – CFI Capital Partners

Power BI Case Study – CFI Capital Partners Overview In this case study, you’ll take on the role of a business intelligence analyst in an investment bank. The sales and trading team at CFI Capital Partners needs you to develop a customized Power BI report to help with bespoke market analysis You will need to connect…

Continue reading

Data Prep for Machine Learning in Python

Data Prep for Machine Learning in Python Course Overview Machine learning models rely on good data to produce meaningful insights. For that reason, data prep is one of the most critical skills for machine learning.  In this course, you’ll learn how to import and clean data before populating missing values using imputation. You’ll learn how to…

Continue reading

R Fundamentals

R Fundamentals Course Overview Start your hands-on data science journey by coding in R programming language. In this course, you’ll progress from coding with Base R to creating a full data science project with Tidyverse packages in RStudio. You’ll begin this course by exploring the foundations of Base R to generate outputs, create variables, and…

Continue reading

Enterprise Deployment & Governance: Power BI Edition

Enterprise Deployment & Governance: Power BI Edition Overview This course will give you a walkthrough of all the processes, systems, and divisions of responsibility that help us develop, test, deploy and share BI reports in team environments. From small, flexible teams to large teams that rely on operational stability and central sources of truth, there…

Continue reading
0 search results for ‘