ADVERTISEMENT

Power BI

larsIU

larsIU

Hall of Famer
Gold Member
Apr 17, 2010
14,437
21,107
113
Good Afternoon. I am old and need to learn how to better use Power BI (non development work). Company i work for is standing up a data warehouse and the only connection will be through Power BI (so far).

I am a pretty ****ing good excel jockey. Yes, i know Power BI is a completely different animal but I have a better than average understanidng of how relational tables work, etc. Additionally, at this point in my life this probably gets me more chuffed than Penthouse.

Please point me to all your favorite YouTube University channels, articles, gurus, whatevers that you've found useful.

@JamieDimonsBalls @twenty02 and anyone else if you're a user.

Thanks in advance.
 
  • Haha
Reactions: hookyIU1990
larsIU said:
Good Afternoon. I am old and need to learn how to better use Power BI (non development work). Company i work for is standing up a data warehouse and the only connection will be through Power BI (so far).

I am a pretty ****ing good excel jockey. Yes, i know Power BI is a completely different animal but I have a better than average understanidng of how relational tables work, etc. Additionally, at this point in my life this probably gets me more chuffed than Penthouse.

Please point me to all your favorite YouTube University channels, articles, gurus, whatevers that you've found useful.

@JamieDimonsBalls @twenty02 and anyone else if you're a user.

Thanks in advance.
Click to expand...
I am Today, days old the first I ever heard about Power BI.
 
larsIU said:
Lucky bastard.
Click to expand...
MY company is trying to upgrade to some space age shit rev of Salesforce. As the old man around I am pushing back about change (just because) although we are having some serious trouble with some interfaces that are in place.
After my weighted push back, we call Sales force to work on the issues.. Their response .... "WOW that is a really old version, and I don't think anyone in the salesforce company even knows that code anymore".
My response, "sounds like a good time for you to hire some back as contractors, now fix my shit" !

Power BI, it's probably a fade. It's pass by soon. :)
 
  • Like
  • Haha
Reactions: hookyIU1990, DANC and larsIU
larsIU said:
Good Afternoon. I am old and need to learn how to better use Power BI (non development work). Company i work for is standing up a data warehouse and the only connection will be through Power BI (so far).

I am a pretty ****ing good excel jockey. Yes, i know Power BI is a completely different animal but I have a better than average understanidng of how relational tables work, etc. Additionally, at this point in my life this probably gets me more chuffed than Penthouse.

Please point me to all your favorite YouTube University channels, articles, gurus, whatevers that you've found useful.

@JamieDimonsBalls @twenty02 and anyone else if you're a user.

Thanks in advance.
Click to expand...
Would a BetaMax and a Blackberry be helpful?
 
  • Haha
Reactions: DANC and Joe_Hoopsier
Joe_Hoopsier said:
MY company is trying to upgrade to some space age shit rev of Salesforce. As the old man around I am pushing back about change (just because) although we are having some serious trouble with some interfaces that are in place.
After my weighted push back, we call Sales force to work on the issues.. Their response .... "WOW that is a really old version, and I don't think anyone in the salesforce company even knows that code anymore".
My response, "sounds like a good time for you to hire some back as contractors, now fix my shit" !

Power BI, it's probably a fade. It's pass by soon. :)
Click to expand...
Salesforce is likely something I will have to consider as an optino for a portion of a workflow not yet fully designed. Possibly Temenos or Akuvo. None of which I've ever really worked with before.

I've worked with/designed a PEGA BPM app (from teh business side) in the past and was hoping to use it again but, sigh, no dice.

Why do i have to continue learning new things? Is learning to code better? Just asking.
 
larsIU said:
I am a pretty ****ing good excel jockey
Click to expand...

If you use a mouse in Excel...

christmas%2Bgif.gif


I'll respond with a longer answer tonight.
 
  • Like
  • Haha
Reactions: DANC and larsIU
larsIU said:
Salesforce is likely something I will have to consider as an optino for a portion of a workflow not yet fully designed. Possibly Temenos or Akuvo. None of which I've ever really worked with before.

I've worked with/designed a PEGA BPM app (from teh business side) in the past and was hoping to use it again but, sigh, no dice.

Why do i have to continue learning new things? Is learning to code better? Just asking.
Click to expand...
I read; yadda yadda yadda Salesforce yadda yadda yadda code better yadda...
I think we are on the same page.
Keep up the good fight, I'm with ya.
 
  • Like
Reactions: BradStevens
larsIU said:
Good Afternoon. I am old and need to learn how to better use Power BI (non development work). Company i work for is standing up a data warehouse and the only connection will be through Power BI (so far).

I am a pretty ****ing good excel jockey. Yes, i know Power BI is a completely different animal but I have a better than average understanidng of how relational tables work, etc. Additionally, at this point in my life this probably gets me more chuffed than Penthouse.

Please point me to all your favorite YouTube University channels, articles, gurus, whatevers that you've found useful.

@JamieDimonsBalls @twenty02 and anyone else if you're a user.

Thanks in advance.
Click to expand...
Just a few off the top of my head…
Make a template for both report visuals & development processes. This way your reports will look the same across the organization & you won’t miss steps in creating them either. We use Azure DevOps for tracking projects, tasks, etc. I don’t want to be insulting but have no idea what your company has set up, but we develop & publish all reports & semantic models to Test & QA environments for validation before publishing to Production environments.

At some point you’ll need to start using DAX, which you may already be in Excel. Go to Bing, use Copilot to write it for you. (Unless you are getting a Premium license, then CoPilot is built in. Just be careful, if not everyone has Premium some of the report features you build in will not be available to them)

I like having my DBA’s use Star Schemas, with effective use of Fact & Dimension tables you’ll be able to build more versatile Semantic Models with more slicers & filtering.

Make a Data Dictionary table to store definitions of your measures, seems silly but you’ll be glad as you compile dozens of measures that you have them defined. Speaking of measures, save them in your Semantic Model, then you can use them in multiple reports.

There are Power BI summits every year, lots of great sessions & you can buy the recordings for @$100. I recommend these. I think RadaCad offers past years sessions.

I’ve had to oversee our development of our Data Warehouse in Azure & report development in PowerBI, message me if you have questions…

Edit: for templates, when I say look the same, I don’t mean same visuals on every page or report, just company logos, color scheme, fonts, etc…
 
Last edited:
  • Wow
  • Love
Reactions: DANC, JamieDimonsBalls, Joe_Hoopsier and 1 other person
jet812 said:
Just a few off the top of my head…
Make a template for both report visuals & development processes. This way your reports will look the same across the organization & you won’t miss steps in creating them either. We use Azure DevOps for tracking projects, tasks, etc. I don’t want to be insulting but have no idea what your company has set up, but we develop & publish all reports & semantic models to Test & QA environments for validation before publishing to Production environments.

At some point you’ll need to start using DAX, which you may already be in Excel. Go to Bing, use Copilot to write it for you.

I like having my DBA’s use Star Schemas, with effective use of Fact & Dimension tables you’ll be able to build more versatile Semantic Models with more slicers & filtering.

Make a Data Dictionary table to store definitions of your measures, seems silly but you’ll be glad as you compile dozens of measures that you have them defined. Speaking of measures, save them in your Semantic Model, then you can use them in multiple reports.

There are Power BI summits every year, lots of great sessions & you can buy the recordings for @$100. I recommend these. I think RadaCad offers past years sessions.

I’ve had to oversee our development of our Data Warehouse in Azure & report development in PowerBI, message me if you have questions…
Click to expand...
My eyes are bleeding . . .

There should be a new board for this type of stuff.
 
  • Like
  • Haha
  • Love
Reactions: All4You, DANC, BradStevens and 3 others
jet812 said:
Just a few off the top of my head…
Make a template for both report visuals & development processes. This way your reports will look the same across the organization & you won’t miss steps in creating them either. We use Azure DevOps for tracking projects, tasks, etc. I don’t want to be insulting but have no idea what your company has set up, but we develop & publish all reports & semantic models to Test & QA environments for validation before publishing to Production environments.

At some point you’ll need to start using DAX, which you may already be in Excel. Go to Bing, use Copilot to write it for you.

I like having my DBA’s use Star Schemas, with effective use of Fact & Dimension tables you’ll be able to build more versatile Semantic Models with more slicers & filtering.

Make a Data Dictionary table to store definitions of your measures, seems silly but you’ll be glad as you compile dozens of measures that you have them defined. Speaking of measures, save them in your Semantic Model, then you can use them in multiple reports.

There are Power BI summits every year, lots of great sessions & you can buy the recordings for @$100. I recommend these. I think RadaCad offers past years sessions.

I’ve had to oversee our development of our Data Warehouse in Azure & report development in PowerBI, message me if you have questions…
Click to expand...
Wow!!! Damn! Like a foreign language
 
  • Like
Reactions: Univee2, larsIU, Joe_Hoopsier and 1 other person
jet812 said:
Just a few off the top of my head…
Make a template for both report visuals & development processes. This way your reports will look the same across the organization & you won’t miss steps in creating them either. We use Azure DevOps for tracking projects, tasks, etc. I don’t want to be insulting but have no idea what your company has set up, but we develop & publish all reports & semantic models to Test & QA environments for validation before publishing to Production environments.

At some point you’ll need to start using DAX, which you may already be in Excel. Go to Bing, use Copilot to write it for you. (Unless you are getting a Premium license, then CoPilot is built in. Just be careful, if not everyone has Premium some of the report features you build in will not be available to them)

I like having my DBA’s use Star Schemas, with effective use of Fact & Dimension tables you’ll be able to build more versatile Semantic Models with more slicers & filtering.

Make a Data Dictionary table to store definitions of your measures, seems silly but you’ll be glad as you compile dozens of measures that you have them defined. Speaking of measures, save them in your Semantic Model, then you can use them in multiple reports.

There are Power BI summits every year, lots of great sessions & you can buy the recordings for @$100. I recommend these. I think RadaCad offers past years sessions.

I’ve had to oversee our development of our Data Warehouse in Azure & report development in PowerBI, message me if you have questions…

Edit: for templates, when I say look the same, I don’t mean same visuals on every page or report, just company logos, color scheme, fonts, etc…
Click to expand...
Thanks man.
 
  • Like
Reactions: jet812
jet812 said:
Just a few off the top of my head…
Make a template for both report visuals & development processes. This way your reports will look the same across the organization & you won’t miss steps in creating them either. We use Azure DevOps for tracking projects, tasks, etc. I don’t want to be insulting but have no idea what your company has set up, but we develop & publish all reports & semantic models to Test & QA environments for validation before publishing to Production environments.

At some point you’ll need to start using DAX, which you may already be in Excel. Go to Bing, use Copilot to write it for you. (Unless you are getting a Premium license, then CoPilot is built in. Just be careful, if not everyone has Premium some of the report features you build in will not be available to them)

I like having my DBA’s use Star Schemas, with effective use of Fact & Dimension tables you’ll be able to build more versatile Semantic Models with more slicers & filtering.

Make a Data Dictionary table to store definitions of your measures, seems silly but you’ll be glad as you compile dozens of measures that you have them defined. Speaking of measures, save them in your Semantic Model, then you can use them in multiple reports.

There are Power BI summits every year, lots of great sessions & you can buy the recordings for @$100. I recommend these. I think RadaCad offers past years sessions.

I’ve had to oversee our development of our Data Warehouse in Azure & report development in PowerBI, message me if you have questions…

Edit: for templates, when I say look the same, I don’t mean same visuals on every page or report, just company logos, color scheme, fonts, etc…
Click to expand...
You will be assimilated.
 
  • Like
  • Love
Reactions: All4You and larsIU
jet812 said:
When friends have asked what my latest “project” is at work, I tell them to call me if they’re having trouble sleeping & I can take care of it by talking about this project. I enjoy it, but it’s not for everyone…
Click to expand...
Probably not for people who took college algebra 11 times
 
  • Haha
Reactions: DANC and BradStevens
larsIU said:
Good Afternoon. I am old and need to learn how to better use Power BI (non development work). Company i work for is standing up a data warehouse and the only connection will be through Power BI (so far).

I am a pretty ****ing good excel jockey. Yes, i know Power BI is a completely different animal but I have a better than average understanidng of how relational tables work, etc. Additionally, at this point in my life this probably gets me more chuffed than Penthouse.

Please point me to all your favorite YouTube University channels, articles, gurus, whatevers that you've found useful.

@JamieDimonsBalls @twenty02 and anyone else if you're a user.

Thanks in advance.
Click to expand...
Most bi's I know aren't very powerful. More submissive, actually.

As with most things worth knowing, I'd first do a search on a handy platform referred to as Pornhub. You'll find all kinds of things that might fit this bill.
 
  • Haha
Reactions: DANC, Joe_Hoopsier, Hoopsdoc1978 and 2 others
jet812 said:
Just a few off the top of my head…
Make a template for both report visuals & development processes. This way your reports will look the same across the organization & you won’t miss steps in creating them either. We use Azure DevOps for tracking projects, tasks, etc. I don’t want to be insulting but have no idea what your company has set up, but we develop & publish all reports & semantic models to Test & QA environments for validation before publishing to Production environments.

At some point you’ll need to start using DAX, which you may already be in Excel. Go to Bing, use Copilot to write it for you. (Unless you are getting a Premium license, then CoPilot is built in. Just be careful, if not everyone has Premium some of the report features you build in will not be available to them)

I like having my DBA’s use Star Schemas, with effective use of Fact & Dimension tables you’ll be able to build more versatile Semantic Models with more slicers & filtering.

Make a Data Dictionary table to store definitions of your measures, seems silly but you’ll be glad as you compile dozens of measures that you have them defined. Speaking of measures, save them in your Semantic Model, then you can use them in multiple reports.

There are Power BI summits every year, lots of great sessions & you can buy the recordings for @$100. I recommend these. I think RadaCad offers past years sessions.

I’ve had to oversee our development of our Data Warehouse in Azure & report development in PowerBI, message me if you have questions…

Edit: for templates, when I say look the same, I don’t mean same visuals on every page or report, just company logos, color scheme, fonts, etc…
Click to expand...
So obvious. Like, who didn't even know this? Linux processing M4 Disc-something-or-other, too, amIright?
 
  • Like
  • Haha
Reactions: DANC and jet812
larsIU said:
Thanks man.
Click to expand...
I just reread & noticed that in my excitement that someone wanted, or needed, to talk about Power BI I neglected to read carefully enough that you said non development work.😳 Sorry. Offer stands, message if you need help, I use it every day. It’s only as good as your source data & model, make sure your gang is cleaning the data during ETL so you’ve got good stuff to work with. Make sure you’ve got test scripts or artifacts to use for validation though as you’re making new reports, & I’d ask them to to provided daily scorecards comparing source data record counts to your warehouse so you know everything is getting loaded.
 
  • Like
Reactions: DANC and larsIU
BradStevens said:
So obvious. Like, who didn't even know this? Linux processing M4 Disc-something-or-other, too, amIright?
Click to expand...

Code: 
System:    Kernel: 5.6.0-2-amd64 x86_64 bits: 64 compiler: gcc v: 8.3.0 
           parameters: BOOT_IMAGE=/boot/vmlinuz-5.6.0-2-amd64 root=UUID=<filter> ro quiet splash 
           Desktop: KDE Plasma 5.14.5 wm: kwin_x11 vt: 7 dm: SDDM Distro: MX-19.4_KDE_x64 patito feo August 16  2020 
           base: Debian GNU/Linux 10 (buster) 
Machine:   Type: Desktop Mobo: ASUSTeK model: M4A87TD/USB3 v: Rev 1.xx serial: <filter> BIOS: American Megatrends v: 0601 
           date: 04/02/2010 
CPU:       Info: Quad Core model: AMD Athlon II X4 630 bits: 64 type: MCP arch: K10 family: 10 (16) model-id: 5 stepping: 2 
           microcode: 10000DB cache: L2: 2 MiB 
           flags: lm nx pae sse sse2 sse3 sse4a svm bogomips: 22474 
           Speed: 800 MHz min/max: 800/2800 MHz Core speeds (MHz): 1: 800 2: 800 3: 2800 4: 800 
           Vulnerabilities: Type: itlb_multihit status: Not affected 
           Type: l1tf status: Not affected 
           Type: mds status: Not affected 
           Type: meltdown status: Not affected 
           Type: spec_store_bypass status: Not affected 
           Type: spectre_v1 mitigation: usercopy/swapgs barriers and __user pointer sanitization 
           Type: spectre_v2 mitigation: Full AMD retpoline, STIBP: disabled, RSB filling 
           Type: srbds status: Not affected 
           Type: tsx_async_abort status: Not affected 
Graphics:  Device-1: Brooktree Bt878 Video Capture vendor: Hauppauge works WinTV Series driver: bttv v: 0.9.19 bus-ID: 02:06.0 
           chip-ID: 109e:036e class-ID: 0400 
           Device-2: NVIDIA GF119 [GeForce GT 610] vendor: PNY driver: nouveau v: kernel bus-ID: 05:00.0 chip-ID: 10de:104a 
           class-ID: 0300 
           Display: x11 server: X.Org 1.20.9 compositor: kwin_x11 driver: loaded: modesetting unloaded: fbdev,vesa 
           display-ID: :0 screens: 1 
           Screen-1: 0 s-res: 2880x900 s-dpi: 96 s-size: 762x238mm (30.0x9.4") s-diag: 798mm (31.4") 
           Monitor-1: DVI-I-1 res: 1440x900 hz: 60 dpi: 90 size: 408x255mm (16.1x10.0") diag: 481mm (18.9") 
           Monitor-2: VGA-1 res: 1440x900 hz: 60 dpi: 90 size: 408x255mm (16.1x10.0") diag: 481mm (18.9") 
           OpenGL: renderer: NVD9 v: 4.3 Mesa 20.1.8 direct render: Yes 
Audio:     Device-1: Advanced Micro Devices [AMD/ATI] SBx00 Azalia driver: snd_hda_intel v: kernel bus-ID: 00:14.2 
           chip-ID: 1002:4383 class-ID: 0403 
           Device-2: Brooktree Bt878 Video Capture vendor: Hauppauge works WinTV Series driver: bttv v: 0.9.19 bus-ID: 02:06.0 
           chip-ID: 109e:036e class-ID: 0400 
           Device-3: Brooktree Bt878 Audio Capture vendor: Hauppauge works WinTV Series driver: snd_bt87x v: kernel 
           bus-ID: 02:06.1 chip-ID: 109e:0878 class-ID: 0480 
           Device-4: NVIDIA GF119 HDMI Audio vendor: PNY driver: snd_hda_intel v: kernel bus-ID: 05:00.1 chip-ID: 10de:0e08 
           class-ID: 0403 
           Sound Server-1: ALSA v: k5.6.0-2-amd64 running: yes 
           Sound Server-2: PulseAudio v: 12.2 running: yes 
Network:   Device-1: Realtek RTL8111/8168/8411 PCI Express Gigabit Ethernet vendor: ASUSTeK P8P67 and other motherboards 
           driver: r8169 v: kernel port: a800 bus-ID: 01:00.0 chip-ID: 10ec:8168 class-ID: 0200 
           IF: eth0 state: up speed: 100 Mbps duplex: full mac: <filter> 
Drives:    Local Storage: total: 476.03 GiB used: 129.64 GiB (27.2%) 
           SMART Message: Unable to run smartctl. Root privileges required. 
           ID-1: /dev/sda maj-min: 8:0 vendor: Mushkin model: MKNSSDRW480GB size: 447.13 GiB block-size: physical: 512 B 
           logical: 512 B speed: 3.0 Gb/s type: SSD serial: <filter> rev: 0A0 scheme: MBR 
           ID-2: /dev/sdb maj-min: 8:16 type: USB vendor: PNY model: USB 3.0 FD size: 28.9 GiB block-size: physical: 512 B 
           logical: 512 B type: N/A serial: <filter> rev: PMAP scheme: MBR 
           SMART Message: Unknown USB bridge. Flash drive/Unsupported enclosure? 
Partition: ID-1: / raw-size: 437.36 GiB size: 429.5 GiB (98.20%) used: 129.64 GiB (30.2%) fs: ext4 dev: /dev/sda1 maj-min: 8:1 
Swap:      Alert: No swap data was found. 
Sensors:   System Temperatures: cpu: 47.0 C mobo: 34.0 C gpu: nouveau temp: 45.0 C 
           Fan Speeds (RPM): cpu: 2419 psu: 0 case-1: 0 
           Power: 12v: 12.05 5v: N/A 3.3v: 3.38 vbat: N/A 
Repos:     Packages: note: see --pkg apt: 2783 lib: 1662 flatpak: 0 
           No active apt repos in: /etc/apt/sources.list 
           Active apt repos in: /etc/apt/sources.list.d/debian-stable-updates.list 
           1: deb http://deb.debian.org/debian buster-updates main contrib non-free
           Active apt repos in: /etc/apt/sources.list.d/debian.list 
           1: deb http://deb.debian.org/debian buster main contrib non-free
           2: deb http://deb.debian.org/debian-security buster/updates main contrib non-free
           Active apt repos in: /etc/apt/sources.list.d/google-chrome.list 
           1: deb [arch=amd64] http://dl.google.com/linux/chrome/deb/ stable main
           Active apt repos in: /etc/apt/sources.list.d/mx.list 
           1: deb http://mxrepo.com/mx/repo/ buster main non-free
           No active apt repos in: /etc/apt/sources.list.d/various.list 
Info:      Processes: 196 Uptime: 12h 14m wakeups: 1 Memory: 7.78 GiB used: 2.44 GiB (31.3%) Init: SysVinit v: 2.93 
           runlevel: 5 default: 5 tool: systemctl Compilers: gcc: 8.3.0 alt: 8 Shell: quick-system-in default: Bash v: 5.0.3 
           running-in: quick-system-in inxi: 3.3.06
 
  • Haha
Reactions: Baller23Boogie, BradStevens, twenty02 and 2 others
You must log in or register to reply here.

Similar threads

R

With 3 added via portal and decommit, are we now better than last year?

Replies
63
Views
4K
TheHoosier.com IU Hoop Forum
rocketo
R
Radio Zero

Links inside.

Replies
14
Views
2K
Andy's Off Topic Forum
larsIU
larsIU
daddyhoosier

I'm dejected

Replies
70
Views
3K
IU Football Board
Jackskip23
J
Thyrsis

Has anyone here written an assessment of CTA?

Replies
10
Views
653
Premium IU Football Forum
nurban
N
C

Coach Tom Allen & CO: DO NOT GIVE UP ON THE OPTION..!!! Tho Execution Lacking (first game), It Is the WAY to GO !!

Replies
21
Views
1K
IU Football Board
daddyhoosier
daddyhoosier
ADVERTISEMENT

Latest posts

ADVERTISEMENT
Top Bottom
Back