29. Practice Exercises and Final Assignment
29.1 Modules 1–2: Introduction and Interface
- List the five components of Power BI and write one sentence about each.
- Explain the typical Power BI workflow in eight steps to a friend who uses only Excel.
- Which licence would a 20-person team need to share reports among themselves? Which option lets hundreds of free users view reports?
- Open Power BI Desktop and locate: Table view, Model view, the Data pane, the Format visual pane, Performance analyzer.
- What is the difference between
.pbix,.pbitand.pbipfiles?
Practice files (fictional): pq_raw_pune_export.csv
Hints
- Module 1.3 lists the components; Module 2.6–2.7 explains the file types.
- For the licence question think who creates vs who only views.
Solutions (checked on the practice files)
- Desktop (build), Service (share, refresh), Mobile apps (view), Report Server (on-premises), Gateway (connects the Service to local data). Some lists add Report Builder for paginated reports.
- Get data → clean in Power Query → model (relationships) → DAX measures → visuals → publish → share/app → schedule refresh.
- Pro for each of the 20 people (or PPU). Hundreds of free viewers need content in a Premium/Fabric capacity (check current licence names and sizes).
- Table view and Model view: icons on the left. Data pane and Format visual pane: right side of Report view. Performance analyzer: Optimize tab.
- .pbix = report + data in one file; .pbit = template without data (prompts for parameters); .pbip = project folder of text files for source control.
Ravindra Bagale's Tip
Friends, many students read the exercise, think "I know this" and skip it. Actually do each exercise in Power BI Desktop, even the easy ones. Knowing where the buttons are is part of the skill interviewers test. Don't make this mistake!
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students exercise वाचतात, "हे मला येतं" असं समजतात आणि ती वगळतात. प्रत्येक exercise, सोपी असली तरी, Power BI Desktop मध्ये प्रत्यक्ष करा. Buttons कुठे आहेत हे माहीत असणं हा पण interviewers चेक करतात त्या skill चा भाग आहे. ही चूक करू नका!
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students exercise पढ़ते हैं, सोचते हैं "यह मुझे आता है" और उसे छोड़ देते हैं. हर exercise, आसान वाली भी, Power BI Desktop में सच में करो. Buttons कहाँ हैं यह जानना भी उस skill का हिस्सा है जिसे interviewers परखते हैं. यह गलती मत करना!