Microsoft Courses

INTRODUCTION – Dashboard Design and Storytelling   This week, you will dive into a thorough comparison between designing a dashboard and designing a report, exploring the distinct methodologies, tools, and purposes that each entails. This exploration will help you understand the unique features and functionalities of dashboards and reports, and how each serves a different … Read more

INTRODUCTION – Designing Powerful Report Pages This week, you will delve into the principles of cohesive design, exploring the various ways in which well-executed design enhances both user experience and data comprehension. By understanding the foundational elements that contribute to a unified and aesthetically pleasing design, you will learn how to create interfaces and visualizations … Read more

INTRODUCTION – Visualization and Design This week, you will explore the principles of data display and visualization design. The instruction will guide you on how to create a unified report that effectively targets a specific audience. Emphasis will also be placed on the importance of security in data visualization, ensuring that sensitive information is protected … Read more

INTRODUCTION – The right tools for the job This provides an extensive introduction to data management, leading students through the unique aspects of collecting, transforming, and cleaning data. Initiating with presenting the importance of collecting data- accurate, and relevant data out of the numerous sources, businesses and organization pretend. Learners will touch upon the Extract, … Read more

INTRODUCTION – Data analysis in business This module will introduce you to the critical role of Data Analyst in the business setup. Data analysis core theoretical concepts will be covered, highlighting data’s critical importance in helping in the making of enhanced discretionary decisions and strategic plan shapes. Learners will get to know the core liabilities … Read more

Module 4: Final Project and Assessment: Preparing Data for Analysis with Microsoft Excel INTRODUCTION – Final project and assessment: Preparing data for analysis with Microsoft Excel As a trainee, you will be taking a diagnostic assessment in this module so that you can demonstrate mastery-the overall core competences dealt with during your course of study. … Read more

INTRODUCTION – Preparing data for analysis using functions The module ensures that each individual, who fully uses Excel in their data manipulation activities in Power BI with an upper-resourced hefty instrument somewhere, learns how to best put this all into practice. Indeed, this module ventures into primary aspects of what everyone wishes to learn, such … Read more

INTRODUCTION – Formulas and functions An in-depth guide to excel’s formulas and functions-it’s the way into exploring these most powerful tools in excel for data analysis and how they can be used to interpret as well as manipulate data to make more informed decisions. This module illustrates by examples through several business situations, how Excel … Read more

INTRODUCTION – Concepts for Data Modeling Delving deeper into the Data Modeling Module, it discusses the schemata that define the design and construction of a data model. Thus, the learner understands the major tenets and processes of effective data modeling practices. The entirety would detail how each of the cited schema applies to the orderly, … Read more