Business Analytics with Power BI

via Udacity Nanodegree

Overview

Master data fundamentals applicable to any industry and learn to make data-driven decisions. From collecting and analyzing data to modeling business scenarios, students will learn Excel, SQL, and Power BI, utilizing data visualization skills to communicate findings.

Syllabus

Business Metrics with Spreadsheets

Turn spreadsheets into a powerful decision-making tool. This course covers how to interpret data, calculate essential business metrics, and visualize trends that reveal performance, opportunities, and strategic direction.

SQL for Data Analysis

SQL is one of the most versatile tools available when it comes to extracting insights from stored data.
Learn how to execute core SQL commands to define, select, manipulate, control access, aggregate, and join data and data tables. Understand when and how to use subqueries, several window functions, and partitions to complete complex tasks. Clean data, optimize SQL queries, and write select advanced JOINs to enhance analysis performance. Explain which cases you would want to use particular SQL commands and apply the results from queries to address business problems.

Data Visualization in Power BI

Build compelling, interactive Power BI dashboards that transform raw data into actionable insights. Explore core Power BI features, including data ingestion, transformation, and visualization. Use Power Query and DAX to prepare data and perform calculations. Master core chart types and match visuals to business questions. Design clean, effective dashboards with layout, accessibility, and storytelling in mind. Learn how to apply interactive filters, slicers, and drill-downs. In the final project, showcase your skills by analyzing sales trends, customer segments, and top products for a retail business using best practices in design, data modeling, and DAX.