
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Configure navigation buttons on the homepage by adjusting default and hover styles, colors, icons, padding, borders, and actions to navigate between pages like business overview, customer insights, and product insights.
Craft a Power BI home page with navigable buttons and icons, set page names like inventory insights and shipping insights, add contact details, and plan navigation before building visuals.
Create a business overview dashboard in Power BI to display total revenue, total profit, profit margin, and sales growth, while setting up the canvas, KPIs, and a navigation pane.
Create an interactive Power BI dashboard by designing hover-enabled buttons with custom icons, managing styles and text, and grouping reports for seamless navigation across product, inventory, and shipping insights.
Group elements to build a cohesive dashboard, then design three visuals and five kpi cards with gradient backgrounds, borders, and formatted images, using dax expressions to drive insights.
Create end-to-end Power BI visuals for the business overview by building KPI measures with DAX expressions, computing total revenue with sum, formatting as currency, and arranging cards, lines, and images.
Drive end-to-end Power BI project insights by defining measures for total profit and units sold, calculating profit margin from the sales fact, and presenting results with cards, callouts, and visuals.
Format the profit margin as a zero units profit margin percentage and build a new sales growth percentage measure comparing current year to prior year revenue in Power BI.
Compute sales growth year-over-year and build KPIs and visuals in Power BI, including a line chart of total profit and revenue by year, with date table cleanup in Power Query.
Adjust grid lines and colors, enable bold white data labels for total revenue and profit, and create a donut chart of total units sold by continent with concise data labels.
Create a Power BI stacked bar chart of the top seven countries by total revenue, apply a top-n filter, and add a text box for total units sold by continent.
Create and customize slicers for continent and country in a dynamic Power BI dashboard, adjusting fonts and visuals, inserting logos, and enabling interactive profit and revenue insights.
Duplicate the business analysis dashboard to create a customer insights page, rename it, customize visuals, tweak hover effects and colors, and refine navigation for a cohesive Power BI report.
Import KPI cards for total revenue and total profit, format them, and create an average revenue per customer measure using DAX by dividing total revenue by distinct customer IDs.
Learn to build measures in Power BI to analyze gold tier customers and compute their percentage using count rows and divide, with zero error handling.
Group customers by age with a switch function to form bands from teen to senior, then visualize revenue and profit by age group in a clustered bar chart.
Build a Power BI customer analysis dashboard with visuals for gender, total customers by segment, and a dynamic age-group slicer, plus KPIs for average revenue per customer and profit.
Duplicate the report, rename it product insights, and customize visuals. Arrange three visuals with gradients, adjust buttons, and display total revenue and total profit kpis.
Develop key measures in Power BI, including total discount given and average profit margin, then compute inventory value with sumx on inventory on hand multiplied by related product cost.
Configure inventory value with zero decimals, insert KPI images for average profit margin, inventory value, total discounts, start visualizations with a stacked column chart in end-to-end Power BI project.
Analyze Power BI dashboards for zesty drinks: total revenue by category and flavor, a filter for three flavors, and a decomposition tree to explore profit by category, flavor, country.
Design a Power BI product analysis dashboard with a total cost by category measure, a stacked bar chart, and category and flavor slicers.
Learn to build an inventory analysis dashboard in the zesty drinks sales analysis project, duplicating tabs, updating visuals, and creating kpis for total inventory and total reorder level.
Create measures for total reorder level and average reorder level using DAX, link inventory and sales fact tables, and build visuals for total inventory by year and inventory value.
Create a Power BI inventory analytics dashboard by formatting axis titles, colors, and data labels, and compare total inventory to reorder levels with a stacked column chart.
learn how to modify a Power BI shipping analysis report by duplicating and renaming visuals, deleting elements, and applying shipping insights styles with hover effects.
Create KPIs in Power BI to track shipping cost, shipments, and average carrier rating using the sales fact table, then build a stacked column chart of shipments by mode.
Master end-to-end Power BI learning for shipping analytics, showing total shipments by mode and yearly shipping cost with line and stacked column visuals, plus slicers and page navigation.
Learn end-to-end Power BI navigation across business overview, customer insights, product insights, inventory insights, and shipping insights dashboards, using the Ctrl key to move between pages and return home.
Publish your report to the Power BI service, create and manage the workspace, and share with teammates using work accounts; pin visuals to a dashboard for stakeholders.
Discover how data predicts the best Airbnb deals, overpriced listings, and loved stays, guiding pricing strategies and revealing customer preferences through visuals of reviews, listings, and prices.
Load and clean the Airbnb open data, transform fields, replace nulls, and analyze reviews per month and revenue for active listings.
Build an Airbnb data report in Power BI, creating visuals for service fees by room type, reviews by room type, neighborhood prices, and monthly trends, with slicers and publishing steps.
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.