Related Posts
Additional Posts in Data & Analytics Consultants
Subject Expert
Mentor
Bowl Leader
Thought this was interesting. Across 160 teams of researchers, just about all failed to make good life outcome predictions on things like GPA, evictions, layoffs, and others. Data followed 4.5k families across 15 years, with 13k features (varied over time). Haven't looked at it directly yet, but will be turning the docs and data inside out... In the meantime, authors claim this as showing the limits of ML. Oh, and it's published in PNAS, so you know there's some big publication energy there.
https://www.pnas.org/content/117/15/8398
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Composite model, sources sharepoint, forms/excel specific or sharepoint/teams locations, ERP database, in Azure or on prem or other datalake of central business services..
Microsoft is 365 is one of the most flexible for using whatever you want to build whateber you need. You can collect data in a form, which stores in a table that joins to a budget table from sharepoint, that you build visuals on in PBI. Not hard, just got test things out.
One thing I will say, read up on star scheme models, using primary keys, and overall design concepts. Today you are only limited by your creativity. Keep building and dreaming up ideas!
Power apps if you want to add an input right in power bi. I recommend waiting on this as Fabric may have easier means, also there are easier ways to setup input collection than power apps. Power Bi is for visual and repprt building not really data input.
Start with your steps. What you are trying to do. Then how you get there. Consider where things will be, how they will update, and how your report/app will access them.
Example: I want to build a report of years of service
1. I need a source table from HR
2. What is its cadence to receive it (weekly)
3. How will I access it? file on sharepoint
4. Open power bi, use power query connect to data source sharepoint. (Input your sharepoint address)
5. Use the path date or other means to isolate to the lastest file on sharepoint (I recommend etl's to sharepoint replacing old) if there are many, target latest
6. Filter to file expand the combine
7. Now you see your file
8 edit table in power query if need
9 save and close
10 build visuals needed
11 test your report is working as expect
12 share report with end audience
13 in take feedback
14 make enhancements repeat 11 - 14