Associate Analyst

In this course, we'll explore internal and external analysis frameworks. Internal analysis helps identify an organization's strengths and weaknesses, aiding in resource allocation and performance improvement. External analysis assesses market dynamics, competition, and opportunities, enabling informed decision-making and strategic alignment, essential for sustainable growth, competitiveness, and effective data-driven strategies in business.

This course introduces various important statistical principles that can be applied in other Kubicle courses. This course will be useful for anyone who applies these techniques and wants to understand the principles behind them.

In this course, we'll explore positioning and process analysis frameworks. Positioning frameworks help identify and leverage a company's unique strengths and capabilities within a market, as well as identify potential threats and challenges. Process frameworks allow organizations to drill down into internal systems, analyzing for efficiency and improvement opportunities. Both give organizations a competitive advantage in the medium to long term.

Data models can be used for many purposes, like prediction, classification, and time series analysis. This course explains the principles of these techniques, and will be useful to anyone with an interest in predictive modeling.

Probability is a commonly used, but often misunderstood area of statistics. This course introduces essential probability concepts and teaches you to calculate probabilities correctly.

Hypothesis testing lets you test what messages your data is actually sending you. This course will teach you how to conduct a wide variety of useful hypothesis tests.

Insert, edit, delete and sort data, perform lightning-fast navigation and radically improve your productivity in Excel with this course.

This course introduces the most useful of Excel's built-in arithmetic and logical functions. You also learn how to write, manipulate and audit your own formulas.

Excel is commonly used by finance professionals to evaluate investment returns. This course introduces important finance functions you can use for this purpose, including Internal Rate of Return and Net Present Value.

In this project, you'll help a retailer looking to expand their operations but who isn't sure where to go. You'll use Excel to identify the optimal locations for new stores, helping the company grow stronger and faster.

Excel has a host of functions that help manipulate these 3 data types. In this course, we'll learn how to clean, chop and manipulate text entries and how to perform time-series analysis on a dataset for an online start-up.

Help a startup catering company that has grown quickly in its first year, but can't pinpoint why. You'll use Excel to analyze their cost trends and determine what spending items actually boost revenue - helping the company mature and grow steadily in the future.

Lookup functions help you quickly find records in large datasets. Learn how to use these functions, create dropdown lists, build search panels and much more in this course.

Pivot Tables allow you to search, filter and sort data very quickly, making them an essential data analysis tool in Excel

In this project, you'll help a clothing retailer that has not developed good practices in storing and structuring their data. You'll develop Excel sheets that store the company's data in an organized manner, helping the company derive insights on revenues and profits that are currently being missed.

Simple statistics can be used to increase your understanding of your business, thereby improving performance. They're also much easier than you think!

Creating charts is a very common task in Excel. This course shows you how to create, format and edit charts so that they are easy to understand and look professional.

Dashboards are a very popular business tool for summarising and garnering insights from data. In this course, we'll build a simple sales dashboard from scratch in Excel.

The first step in understanding how powerful PowerPoint can be is learning how to use the basic tools at your disposal. In this course, you'll do just that, discovering how to create slides, add text, shapes and tables to them, and where to go to begin your customization journey. By the end of this course, you should have a strong foundation in what is possible with PowerPoint and know how to begin building your first presentation with the application.

Data analysis can return a wealth of insight and information, but unless you display those findings in an engaging way, you may find it hard to convince your audience. Adding visuals to your presentation will help ensure your messages land. In this course, you'll learn how to add basic visuals to your deck, varying how and when you display your most important data.

Charts are some of the most accessible visual tools we can use when illustrating data, but their impact depends on the type we select. When we use the wrong chart type for our message, we risk confusing our audience and losing their attention. To avoid this, we must understand each chart type and when to apply it.

In this project, you're helping the finance team of Alert Accelerator, a medical tech firm. You've been asked to present a roundup of the company's financial performance to senior management. You'll think about the most sensible way to present information and then present impactful charts to illustrate your findings.

Charts are some of the most accessible visual tools we can use when illustrating data, but their impact depends on the type we select and how well we build it into our presentation. If our charts contain bad design habits, we risk confusing our audience and losing their attention. To avoid this, we must understand how to make an impact with the build of our charts.

Template customization design is crucial when building PowerPoint presentations as it allows the presenter to create a visually appealing and consistent design that aligns with their brand and messaging. A well-designed template can help the audience focus on the content, improve readability, and make the presentation more engaging and memorable.

The presentations that engage their audience are built on a strong structure and comprehensively deliver on intention. How you built your insights into your structure will determine just how impactful your presentation can be. In this course, you'll learn how to determine your audience, intention, structure, content, before stepping back to assess its accessibility and accuracy.

The final step of presenting data-driven insights to an audience is its physical delivery, whether that be virtually or in person. PowerPoint offers many presenting tools and commands that can help maintain presenter credibility from start to finish.