Power BI ‘WaFish’ List0709
4 min readSep 12, 2023
Flow 🌊
┌───── •✧✧• ─────┐
……….Challenges……….
└───── •✧✧• ─────┘
- Print Hello World in three levels /N87
- Print Hello world for ten times /N21
- Print Hello world and Hello earth for ten times /N22
- Create a dataset with “Hello world” as 10 rows in first column, and do a Card visual and Bar Chart /N32
- In mtcars dataset, do a scatter plot between `mpg and wt` or `mpg and hp` /N12
- Get the photo of Best Mileage Car in mtcars /N290
- Compute Correlation between mpg and wt /N11
- Draw an area chart of mileage and get the best car in background /N876
- Simulate two dice /N0980
- Simulate three coins /N12121
- Get the iris dataset from excel /N8766
- Grab Planets dataset from wikipedia /N20
- Grab World Population from wikipedia /N8764
- Create a Expense Sheet in Excel /N777
- Creat a Map visual on Countries using wikipedia data /N12120
- Draw Planets as scatter plot /N65
- Do a financial model of a school /N1197
- Use Darkmode to whitemode /N098
- Get Data from a PDF file /N98708
- Append the data from a PDF file /N212097
- Change images as per IPL orange cap /N109
- Toss a dice for 100 times in DAX /N2143
- Say “Hello World” 10 times in DAX /N087
- Create a Cricket Card for the Game /N076
- Pick up 11 Cricketers from the 22 in any next game /N1207
- Create a Task list of your own /N1108
- Create a Budget list of your won /N076
- Create a Expense list of your own /N1754
- Create a summary table of 100 times dice throw /N742
- Imitate the IPL Dashboard as is /N1285
- Imitate the Adventure Works Dashboard as is /N32765
- Link up Crime Reports with State-wide Reports /N1208
- Learn to make Hypothesis building with Titanic Dataset /N97384
- Will you provide loan to a person /N2356
- Is the person’s lump is malignant or benign /N34567
- Is the person’s portfolio will stand long term /N3495
- Why you should not go for a credit card loan /N436
- Why you should not take a hand loan if they demand a Compunded Annual Growth Rate ? /N4958
- Can I solve the shortest route using Power BI ? /N235
- Let’s take the dates to understand Birthday Paradox /N937459
- How to find if someone is a fraud, if he asks to pay upfront before giving job /N8976
Heuristics
- Use Trend in scatter plot /N112
- If you cannot join in Navy, be a pirate /N877
- Funnel will not have unique values, fish will be in flower braces {..}
- Links will be connected to challenges with square braces [..]
Fish/Topics 🐟🐟
Notes: List of all visuals
- Pie Chart /N111
- Donought Chart /N007
- Bar Chart /N231
- Stacked Bar Chart /N216
- Area Chart /N44
- Text Box /N19
- Image Box /N1
- Wordcloud /N2
- Histogram /N4
- Card Visual /N5
- Table Visual /N123
- Matrix Visual /N909
- AI Visual ~ Key Influencer /N009
- AI Visual ~ Decomposition Tree /N1123
- Slicer /N109
- Maps /N9090
- Gauge /N1198
- Python/R Visual /N76
- Get Data from CSV using web /N9
- Get Data from Excel /N1234
- Get Data from JSON /N098
- Get Data from Wikipedia Table /N1245
- Query Editor /N0987
- Measure /N77777
- Bookmarks /N654
- AI Text Analytics /N11
- Powe BI web service /N19
- How to do Data Refresh /N09
- How to do Row level security /N34
- [Break point 1209 for class notes]
- SQL basics /N654
- Action Buttons /N3209
- Power BI Themes /N4329
- Manage Relationships /N76
- Work on different joins /N6547
- Time intelligence in DAX /N8765
- Introduction of relationships
- Creating relationships
- Cardinality
- Cross filter direction
- Use of inactive relationships
- Introduction of DAX
- DAX functions
- Context in DAX
- Calculated columns using DAX
- Measures using DAX
- Calculated tables using DAX
- Learning about table, information, logical, text, iterator,
- Time intelligence functions (YTD, QTD, MTD)
- Cumulative values, calculated tables, and ranking and rank over groups
- Date and time functions
- Identify poorly performing measures, relationships, and visuals
- DAX advanced features
Funnel 🥅
- Print Hello World in three levels /N87 {N19} {N0987} {N77777}
- Print Hello world for ten times /N21
- Print Hello world and Hello earth for ten times /N22
- Create a dataset with “Hello world” as 10 rows in first column, and do a Card visual and Bar Chart /N32
- In mtcars dataset, do a scatter plot between `mpg and wt` or `mpg and hp` /N12
#mtcars
- Get the photo of Best Mileage Car in mtcars /N290
- Compute Correlation between mpg and wt /N11
- Draw an area chart of mileage and get the best car in background /N876
- Simulate two dice /N0980
- Simulate three coins /N12121
- Get the iris dataset from excel /N8766
- Grab Planets dataset from wikipedia /N20
- Grab World Population from wikipedia /N8764
- Create a Expense Sheet in Excel /N777
- Creat a Map visual on Countries using wikipedia data /N12120
Tools/Concepts ⛏️
Only 2 to 3 words, hence use them as Hashtags
- Power BI
- SQL
- Excel
- DAX Measures
- Power Query Editor
- Data Visualisation
- Data Computation
- Data Modelling
- Data Analysis
- Data Science Modelling
- Text Analytics
- iris dataset
#iris
- mtcars dataset
#mtcars
Class Notes — Funnel
- Pie Chart /N111 [+]
- Donought Chart /N007 [+]
- Bar Chart /N231 (Vertical & Horizontal) [+]
- Stacked Bar Chart /N216 [+]
- Area Chart /N44 [+]
- Text Box /N19 [+]
- Image Box /N1 [+]
- Wordcloud /N2 [-]
- Histogram /N4 [-]
- Card Visual /N5 [+]
- Table Visual /N123 [-]
- Matrix Visual /N909 [-]
- AI Visual ~ Key Influencer /N009 [+]
- AI Visual ~ Decomposition Tree /N1123 [+]
- Slicer /N109 [-]
- Maps /N9090 [+]
- Gauge /N1198 [-]
- Python/R Visual /N76 [-]
- Get Data from CSV using web /N9 [+]
- Get Data from Excel /N1234 [+]
- Get Data from JSON /N098 [+]
- Get Data from Wikipedia Table /N1245 [+]
- Query Editor /N0987 [+]
- Measure /N77777 [+]
- Bookmarks /N654 [-]
- AI Text Analytics /N11 [-]
- Powe BI web service /N19 [-]
- How to do Data Refresh /N09 [-]
- How to do Row level security /N34 [-]
- [Break point 1209 for class notes]
Event Coordinates:
- Power BI Batch II