Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Zesty Drinks Sales Analysis: End-to-End Power BI Project
Rating: 4.7 out of 5(18 ratings)
770 students

Zesty Drinks Sales Analysis: End-to-End Power BI Project

Hands-on Power BI & Business Intelligence: Create dashboards, analyze data, use DAX, Power Query, and data modeling.
Last updated 9/2025
English

What you'll learn

  • Clean and transform data with Power Query.
  • Visualize business KPIs using interactive charts and graphs.
  • Connect, transform, and model data for reporting purposes.
  • Build a Power BI dashboard using Airbnb data.
  • Load CSV data in Snowflake.
  • Connect Power BI to Snowflake securely
  • Write core DAX for KPIs and time intelligence.
  • Build homepage UX, bookmarks, and tooltips.
  • Publish the dashboard to Power BI Service.
  • Validate metrics and tune performance.

Course content

5 sections46 lectures5h 55m total length
  • Project Overview Part 10:34

    Explore how zesty drinks use data to gain a 360-degree view of their business, including customer insights, inventory management, shipping efficiency, and product insights.

  • Project Overview Part 21:22

    Develop a BI project for Zesty Drinks by loading from Snowflake, cleaning with Power Query, modeling with a star schema, analyzing customers and inventory, and deploying to Power BI service.

  • Business Kickoff Meeting1:36

    Kick off a full end-to-end analysis across customers, product performance, inventory health, and shipping. Deliver a clear, data-driven report using company-wide data since inception to reveal trends and optimization opportunities.

  • Download the Project Dataset and PBIX File0:01
  • Data Import To Snowflake Part 19:05

    Set up a Snowflake account with a 30-day free trial, sign up, and import CSV files into Snowflake, creating databases and tables for Power BI data import.

  • Data Import To Snowflake Part 28:38

    Learn end-to-end data import in Power BI by loading dimension and fact tables from files, correcting table names, and building a star schema around the sales fact in Snowflake.

  • Load Data into Power BI5:27

    Import CSV files from Snowflake into Power BI desktop, then perform ETL, clean and model the data, and build the final report by transforming and loading data for analysis.

  • Data Cleaning Part 19:21

    Apply Power Query Editor to import tables, clean duplicates and blanks, create conditional columns, ensure data types, and set headers, while building a date table, loading fact and dimension tables.

  • Data Cleaning Part 23:34

    Clean and prepare the shipping, store, and warehouse dimensions and the shipping fact data in Power BI, ensuring correct column names and applying changes to load the dataset.

  • Build the Data Model8:01

    Connect the fact sales, inventory, production, and shipping tables to dimension tables using a star schema in Power BI, establishing date, product, store, region, channel, and promotion relationships.

  • Homepage Design Part 19:27

    Create a home page to set the project's tone, brand the Power BI report, and guide stakeholders by adding an about us section, learn more button, and cohesive visuals.

Requirements

  • Power BI Desktop installed.
  • Intermediate Power BI experience needed.
  • Power BI Service account required only if you plan to publish and set refresh (free or Pro/PPU per your org).

Description

Want a Power BI course that actually gets you hired? This hands-on, project-based class takes you from blank screen to a polished, executive-ready Power BI dashboard—the kind you can show in interviews, share with stakeholders, and add to your data analyst portfolio. Instead of scattered tutorials, you’ll follow a clear, end-to-end workflow: understand the business problem, shape data, build clean visuals, define KPIs, apply DAX for essential metrics, and deliver a professional dashboard that tells a story.

Designed for beginners and upskillers, the course emphasizes what hiring managers and teams look for: clarity, trustworthy numbers, and usable design. You’ll practice Power Query for data prep, create a tidy data model, and assemble a smooth user experience with a home page, intuitive navigation, and readable visuals. Along the way, you’ll use checklists, naming conventions, and simple validation tips to make your work credible and repeatable.

By the end, you’ll have a portfolio-ready Power BI project that proves you can turn raw data into insights, communicate results with charts that make sense, and ship a dashboard people want to use. If your goal is an entry-level data analyst role, moving from Excel to Power BI, or leveling up your business intelligence skills, this course gives you the structure, repetition, and confidence you need.

You’ll leave with: a complete Power BI dashboard, reusable DAX patterns, interview talking points, and a clean case study you can share on your resume, LinkedIn, or in a portfolio review. No fluff—just practical, job-focused Power BI.

Who this course is for:

  • Students building a portfolio for internships/jobs
  • Aspiring data analysts wanting hands-on project experience
  • Consultants delivering executive dashboards to clients
  • BI developers who want an end-to-end project workflow
  • Excel power users moving into Power BI