Data Science / Intermediate
Power BI Business Intelligence Internship
An intermediate company-provided program for learners comfortable with spreadsheets, basic KPIs, and structured tables. Use a fictional retailer case and synthetic data to prepare sources in Power Query, build a star model, write DAX measures, design an accessible report, and package a PBIX and PDF portfolio. Power BI Desktop practice requires Windows; cloud sharing may require a separate license and is not required. The 20 lessons include module quizzes and a final assessment. Practical files are self-checked, not uploaded or graded by this site. Suggested pace: one month, with early completion allowed. Passing earns a company-provided internship training certificate, not Microsoft certification or government accreditation.
Your curriculum
4 modulesComplete the lessons, pass each module quiz, then take the final assessment.
01Prepare Reliable Operations Data5 lessons
- Define the report audience, decisions and grainReading · 40 min
- Install Power BI Desktop and inspect local case filesReading · 40 min
- Load CSVs and set data types deliberatelyReading · 50 min
- Profile and clean with Power QueryReading · 55 min
- Combine files and validate prepared dataReading · 55 min
02Model Facts and Write Understandable Measures5 lessons
- Design a star model with unique dimension keysReading · 50 min
- Configure relationships and filter direction safelyReading · 45 min
- Distinguish measures from calculated columnsReading · 45 min
- Calculate revenue, returns and margin with DAXReading · 60 min
- Validate filter context with a test fixtureReading · 45 min
03Build an Accessible Interactive Report5 lessons
- Choose visuals for operations questionsReading · 45 min
- Add filters, slicers and deliberate interactionsReading · 45 min
- Build a meaningful date comparison measureReading · 55 min
- Use drillthrough and report-page navigationReading · 50 min
- Check alt text, tab order and non-color labelsReading · 50 min
04Deliver and Maintain the Portfolio5 lessons
- Inspect misleading totals and slow visual choicesReading · 50 min
- Rehearse a file refresh and diagnose changed inputsReading · 55 min
- Compare PDF, PBIX and service-sharing choicesReading · 40 min
- Package the operations case study with assumptionsReading · 60 min
- Present evidence and complete the capstone reviewReading · 60 min
Final assessment: Power BI modeling and decision reports
Pass with 70% or higher to complete the program and receive your internship completion certificate.