ADEAcademy of
Design Excellence
Explore
Explore ADE
Discover the wider ADE ecosystem beyond courses.
About ADE→

Who we are, why ADE exists and where the ecosystem is heading.

ADE for Business→

Talent, team capability and business collaboration through ADE.

Community→

Connect with learners, professionals, instructors and collaborators.

Events→

Workshops, conversations, showcases and live ADE experiences.

Insights / Articles→

Practical ideas across technology, careers, business and learning.

YouTube & Media→

Videos, interviews, explainers, sessions and stories from ADE.

Partnerships→

Build programs, experiences and shared opportunities with ADE.

Success Stories→

See the people, projects and progress behind real outcomes.

Careers→

Explore ways to help build the next version of ADE.

What’s New→

New launches, platform updates, programs and announcements.

Not sure where to start?Open finder →
Learn
ADE Learn
Choose the learning format that fits your goal, time and stage.
All Courses→

Browse every published ADE course, program and learning experience.

Career Programs→

Deeper programs designed to build career-ready capability and proof.

Work
ADE Work
Find opportunities where skills, projects and proof can move you forward.
All Opportunities→

Browse every open job, internship, freelance role and project on ADE Work.

Full-time Jobs→

Career opportunities for professionals ready to apply verified capability.

Showcase
ADE Showcase
Explore projects and portfolios that make practical capability visible.
All Showcase→

Browse public projects, portfolios, case work and evidence from the ADE community.

Projects→

Focused pieces of work showing the problem, approach, outcome and skills used.

Resources
ADE Resources
Useful tools, trusted recommendations and practical guidance for everyday work and growth.
Tools→

Useful day-to-day utilities for documents, careers, productivity and practical work.

Software & Services→

Curated software and services, including future affiliate-supported recommendations.

Business
ADE for Business
Hire, develop and understand talent through capability, evidence and opportunity.
Overview→

See how ADE connects talent, learning, evidence and opportunity for organizations.

Hire Talent→

Discover people through projects, skills, credentials and public evidence.

ExploreLearnWorkShowcaseResourcesBusiness
Power BI Data Analytics course
Data & Analytics • Beginner to Intermediate

Power BI Data Analytics

Transform raw data into a clean model, meaningful DAX measures and decision-ready dashboards.

22 estimated hours6 modules12 lessonsGraded ADE certificate
ENROLLMENT
Start with one ADE identity

Sign in before enrollment so progress, graded assessments and credentials remain connected to you.

Sign in to enroll
CURRICULUM

Sequential learning structure

Each lesson unlocks only after the previous required step is completed. Module assessments are gates: a failed checkpoint or capstone keeps the following module locked until the pass mark is achieved.

01
Power BI analytics workflow
Understand the Power BI workflow and inspect data before modelling.
Navigate the Power BI workflowChoose sensible data sourcesProfile imported data
The Power BI workflow and model mindset45 min
Profile sources before transforming45 min
02
Power Query for analytics
Transform raw data into analysis-ready tables.
ADE INDIVIDUAL PLANS
Free. Standard. Pro.

Start at $0, step up to Standard for higher usage, or unlock ADE Full Access with Pro.

Compare plans →
ADE

Learn. Build. Prove. Grow. A skills-to-opportunity ecosystem built around practical learning and trusted evidence.

PLATFORM
ExploreLearningShowcaseADE PassportPlans & Pricing
OPPORTUNITY
ADE WorkBusinessPartnersVerify credential
ACCOUNT
WorkspaceMy planSettingsNotificationsSecurity
ADE V2 beta review build • Subscription catalogue live • Payments disabled during testing
Short Courses→

Focused learning for a specific skill, tool or practical outcome.

Free Learning→

Open sessions and accessible learning experiences to start exploring.

Upcoming Workshops→

Live workshops, masterclasses and hands-on learning sessions.

Certifications→

Assessment-led routes that can lead to recognized ADE credentials.

Learning Paths→

Structured sequences that connect related skills into a clear progression.

Browse by subject, format and level.Open finder →
Internships→

Early-career opportunities to build experience, evidence and industry context.

Freelance & Contract→

Flexible client work, contract roles and independent assignments.

Projects & Gigs→

Short applied projects where practical skills matter more than job titles.

Remote Opportunities→

Roles and projects designed for remote or location-flexible work.

Entry-Level Opportunities→

Roles designed for emerging talent with strong evidence and potential.

Browse by role type, field and work mode.Open finder →
Portfolios→

Collections of selected work that show range, craft and professional identity.

Verified Work→

Projects with an active ADE verification record attached to the evidence.

Featured Work→

High-signal work surfaced for quality, evidence and practical relevance.

Student Work→

Projects and portfolios from learners building their first body of evidence.

Professional Work→

Public work from practicing professionals across the ADE ecosystem.

Browse by work type, field and evidence.Open finder →
Guides→

Practical ADE guides, checklists and templates for skills, projects, careers and business.

Tools for doing. Guidance for deciding.Explore resources →
Post Opportunities→

Publish jobs, internships, freelance work and project opportunities.

Train Your Team→

Build workforce capability through courses, workshops and custom learning.

Verify Skills→

Use evidence-aware assessment and verification to understand demonstrated capability.

Business Solutions→

Combine talent, learning and verification into a solution for your organization.

Partnerships→

Collaborate with ADE on programs, events, technology, community and talent initiatives.

Business Workspace→

Manage your organization, opportunities and applicants in the ADE workspace.

Build a stronger talent and capability system with ADE.Open workspace →
Set correct data types
Clean and reshape data
Build repeatable query steps
Power Query cleaning patterns55 min
Shape data for analysis55 min
03
Dimensional data modelling
Build a model that supports reliable filtering and measures.
Separate facts and dimensionsCreate appropriate relationshipsRecognise model grain
Build a star schema60 min
Relationships, keys and cardinality55 min
04
DAX measures and context
Create measures that respond correctly to report filters.
Distinguish measures from columnsUnderstand filter contextUse CALCULATE and time logic
Measures, columns and filter context65 min
CALCULATE and time-aware analysis65 min
05
Visual analytics and delivery
Turn measures into a clear interactive report and understand delivery basics.
Choose visuals for analytical purposeControl interactionsApply accessibility and publishing checks
Visual design for analytical questions55 min
Interactions, accessibility and delivery50 min
06
Power BI dashboard capstone
Build and explain an executive performance dashboard from raw data.
Transform and model raw dataCreate meaningful DAX measuresTell a defensible data story
Capstone brief: executive performance dashboard50 min
Validate and explain your BI solution45 min
CERTIFICATE GRADING

Your result is not just “completed”.

Checkpoint scores and the reviewed capstone produce a weighted final result. The certificate displays both the grade and classification.

A+ · High Distinction95–100%
A · Distinction90–94%
B+ · High Merit85–89%
B · Merit80–84%
C+ · Credit75–79%
C · Pass70–74%
Below 70% is not eligible for the course certificate. A failed gated assessment must be passed before progression.
ADE PROOF

How learning becomes evidence

Learning progress is attached to your ADE identity
Assessment attempts retain scored or reviewed outcomes
Applied work contributes to the course result
The certificate records final score, grade and classification
Professional ADE Skill Verification remains a separate, stronger process
INSTRUCTORS

Instructor assignments will appear here when academic operations connects the course to faculty records.