Data Visualization & Business Intelligence

In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.

In this project, you will learn how to analyze data and identify trends using a variety of tools in Microsoft Excel. Conditional formatting and charts are two tools that focus on highlighting and representing data in a visual form. With conditional formatting, you can define rules to highlight cells using a range of color scales and icons and to help you analyze data and identify trends or outliers. You will then use PivotTables to create summaries of the data that focuses on specific relationships which you will represent as a line chart and column chart. Both conditional formatting and charts are two useful ways of visually analyzing data and exploring trends.

In this project, you will learn a few methods on how to make your presentations more engaging and visual so you can captivate your audience’s attention and make them easily remember all of the information you are presenting. This guided project is for students, employees and business owners who are beginner users of Microsoft Powerpoint and want their presentations to be more visual and engaging. Using online Microsoft Powerpoint, you will learn how to customize your slides through changing their backgrounds, how to visualize your data through inserting videos and using SmartArt, and how to animate the slides content. Finally, you will learn how to apply and control the transitions between your slides.

This guided project, "Data Visualization with Power BI: Build Your First Report," is tailored for beginner data analysts who want to harness the power of data storytelling to make more informed decisions and improve decision-making processes. In this 1-hour project-based course, you you will learn how to build a data dashboard using Power BI Desktop software. You will start by exploring various ways to import data into Power BI and familiarize yourself with the Power BI interface. Next, you will learn how to bring in data from Excel and begin the data preparation process. You will observe the data, identify parts that need cleaning, and learn how to transform raw data to fit business needs (e.g., replacing values, fixing data formats, deselecting unnecessary fields, adding relationships, etc.). After cleaning the data, you will learn how to visualize it in a presentable dashboard using various visuals (bar charts, line charts, maps, cards, etc.). You will also enhance the report by applying important formatting and color themes. The final step is to publish the report on the Power BI workspace, enabling you to share it with teammates and future clients. This project is unique because it provides a step-by-step lesson on creating a Power BI dashboard, marking the beginning of your data analytics journey. By learning these steps, you will gain the fundamental knowledge needed to explore additional Power BI functions, such as real-time analytics, reading data from websites, and more. Please note, to be successful in this project, you will need a basic understanding of data, some familiarity with data cleaning and relationships, and a Microsoft account.

In this 2-hour long project-based course, you will learn how to transform date, time, and duration data for analysis in Power BI, merge and clean datasets by handling inconsistencies and outliers, and apply mean imputation and other cleaning techniques to prepare data for predictive modeling. To achieve this, you will create a fully transformed and cleaned dataset by working through a real-world scenario, where you will assist TY77, a travel agency, in preparing their flight data for a pricing model using Excel sheets containing flight information and routes. This Guided Project was created to help mid-level data analysts develop essential skills in data transformation and cleaning using Power BI to prepare datasets for advanced analysis. This project is unique because it offers hands-on experience in tackling real-world data challenges, such as merging multiple datasets and dealing with inconsistencies. In order to be successful in this project, you will need basic familiarity with Power BI and a foundational understanding of data tables, though no prior experience in data transformation is required.

Power BI can feel overwhelming because it has so many different components and endless variety in charts, visualizations and color schemas. That’s why we’ve designed this end-to-end tutorial to help you create your first Power BI dashboard and guide you through visualization techniques and dashboard design principles to be able to transform raw data into compelling visual stories. This guided project was designed for beginner level business analysts and data visualization enthusiasts to help them set foot in their data analysis journey with Power BI. More specifically during the following hour you will learn how to: - Import, analyze data, and define key performance indicators (KPIs) for dashboard tracking - Apply visualization best practices by matching chart types to specific data insights - Design an interactive dashboard that integrates multiple visualizations to tell a cohesive story To achieve this, you will create an interactive sales performance dashboard that showcases key business metrics through various visualizations. This dashboard will include sales trends, regional performance, and product analysis using different chart types and interactive filters. This project is unique because it combines fundamental data visualization principles with hands-on practice, allowing you to learn Power BI's core features while building something practical that resembles real-world business reporting scenarios. In order to be successful in this project, you will need basic understanding of Excel spreadsheets and simple data formats, access to a Windows machine to run Power BI Desktop, and a Microsoft account to download the software and save your work.

Did you know that Metro Bank improved its financial reporting efficiency by 80% using Power BI or that FedEx optimized its logistics operations through data-driven decision-making? Businesses worldwide are leveraging the power of data to drive smarter decisions and gain a competitive edge—now it's your turn!  Unlock the power of data with our comprehensive Power BI course, designed to transform you into a business intelligence expert! Dive deep into the world of data analysis and visualization, where you'll master how to connect to multiple data sources, clean and model data, and craft dynamic, interactive dashboards using advanced DAX expressions and Power BI features. You'll learn how to leverage AI-powered tools like Microsoft Copilot and ChatGPT to automate complex DAX writing, saving hours of work and accelerating your data analysis process. Through hands-on demos and practical scenarios, you’ll learn how to enhance your reports and gain best practices to share insights effectively through the Power BI Service. This course is designed for aspiring data analysts and business intelligence professionals who want to build expertise in data analysis and visualization using Power BI. It is also ideal for finance and business professionals who need to extract insights from data, as well as IT and data professionals looking to enhance their analytics skill set. Entrepreneurs and small business owners will benefit from practical applications of Power BI and AI tools to support data-driven decision-making and streamline business operations. To succeed in this course, learners should have access to Power BI Desktop, which is free to download and includes all required functionalities. A working knowledge of ChatGPT and Microsoft Copilot is recommended, as both tools are used to enhance data analysis and automate complex tasks. Additionally, learners should be familiar with basic data types, enabling them to perform filtering, sorting, and aggregation tasks confidently within Power BI. By the end of this course, learners will be able to describe core Power BI functions such as data connectivity, modeling, and visualization, and differentiate between DAX expressions and DAX Query View. They will apply Power BI tools to connect, clean, and transform data and implement DAX for calculations and measures. Learners will also analyze how ChatGPT and Microsoft Copilot can optimize DAX and evaluate BI tasks for insight-rich reporting. Finally, they will create advanced interactive dashboards using AI visuals, optimized dataflows, and best practices for modeling and reporting performance.

In this course, you will learn how to prepare a dataset for reliable analysis and use Power BI to turn it into a clear, actionable visual. You will start by reviewing and correcting an Excel file so Power BI can interpret categories, numbers, and dates accurately. Then, you will import the validated dataset into Power BI Desktop, build a clean visual, refine it for readability, and publish your report to Power BI Service. You will also learn how to share your report with teammates and observe how they interpret and interact with your visual. By working through this process end to end, you will develop the skills needed to create accurate, trustworthy financial reports that support strong decision-making.

Dynamic Dashboards: Report and Visualize Data is an intermediate course for financial analysts and business professionals who need to transform raw data into powerful, self-service reporting tools. In a world of static spreadsheets, this course teaches you how to build truly interactive dashboards in Excel that empower stakeholders to explore data and discover insights on their own. You will move beyond basic charts to construct a full-fledged dashboard, connecting to data and using PivotTables, PivotCharts, and slicers to create a dynamic, user-driven experience. But building a dashboard is only half the battle. You will also learn the art of effective data communication by mastering design principles from experts like Stephen Few. Through hands-on activities, you will learn to critically evaluate visuals, eliminate "chart junk" by maximizing the data–ink ratio, and ensure your designs meet high standards of readability and clarity. By the end of this course, you will not only be able to build automated, interactive dashboards but also refine them to deliver clear, unambiguous, and actionable insights that drive confident decision-making.

This course builds essential data visualization foundations for any professional who needs to present data clearly. You'll move from guessing which chart to use to confidently selecting the right one for your message. Through practical examples and hands-on exercises, you will learn to identify the core chart families—comparison, composition, distribution, and relationship—and match them to the perfect chart type, like a bar chart or scatter plot. But choosing the right chart is only half the battle. You'll also master the art of refinement, learning to apply universal design principles to transform cluttered, confusing graphs into clean, impactful visuals. We'll cover how to write descriptive titles, use color effectively, and remove "chart junk" to make your data's story shine. By the end of this course, you won't just make charts; you'll design compelling visual stories that your audience can understand at a glance, a critical skill for any data-driven role.

In this intermediate-level course, you’ll learn how to model and secure financial data in Power BI using real-world business scenarios. You’ll start by importing General Ledger, Cost Center, and Budget data, then design a star-schema model that supports accurate, high-performing analytics. Through guided demos and hands-on practice, you’ll define relationships, create DAX measures for Gross Margin, and validate your model structure for reliable reporting. Next, you’ll apply Row-Level Security (RLS) and Role-Based Access Control (RBAC) to ensure sensitive data stays protected as you publish to Power BI Service. Along the way, you’ll explore how modeling and security intersect—where table structure influences filter logic and access rules affect collaboration. By the end of the course, you’ll have the confidence to build, test, and deploy Power BI dashboards that are both powerful and secure, ready for real enterprise environments.