Artwork

CPE Today에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 CPE Today 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.
Player FM -팟 캐스트 앱
Player FM 앱으로 오프라인으로 전환하세요!

Learn SQL with Steve

1:01:29
 
공유
 

저장한 시리즈 ("피드 비활성화" status)

When? This feed was archived on October 16, 2023 13:28 (6M ago). Last successful fetch was on October 17, 2023 12:42 (6M ago)

Why? 피드 비활성화 status. 잠시 서버에 문제가 발생해 팟캐스트를 불러오지 못합니다.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

Manage episode 330328229 series 2859815
CPE Today에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 CPE Today 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

Power Query and Power BI are genuinely incredible tools to revolutionize your workflow. They offer the promise of "write once, refresh many" reporting where your reports can be instantly updated in real-time with the click of a button. These tools can be hooked directly to your company's databases, accounting applications, enterprise resource planning solutions, etc. Once the connection is established, they can dynamically retrieve anything from the database and populate your reports. While incredible tools, these features require additional training and experience to master. This course series will review the different methods of connecting to your data and have multiple hands-on activities to help you master these incredible tools.

CPE Today has a brand-new learning tool to help you learn how to use Power Query and Power BI. We have created a public server with several sample databases to help you learn how to extract, transform and load data into your dashboards and spreadsheets. This tool will give you practical hands-on experience working with cloud databases from major accounting solutions, including QuickBooks Desktop, QuickBooks Online, and more. This course will provide you with the knowledge to turn your organization's actual data into repeatable refreshable pivot tables, Power BI dashboards, and more!

Are you a CPA?? Are you a Financial Professional?? Earn CPE Credits for Today's Podcast. Check out https://cpe.cx/lsql/. Take a quick 5 question quiz and get your certificate today. Super Easy!

Presented by Stephen M. Yoss, CPA, MS (https://yoss.io)
Produced by Alicia Yoss & Alanna Regalbuto
Graphics By Flaticon.com and iStock
Music by Bensound.com
Education and Compliance By K2 Enterprises (https://k2e.com)

Copyright. All product names, logos, and brands are the property of their respective owners. All company, product, and service names used in this website are for identification purposes only. The use of these names, logos, and brands does not imply endorsement.

Educational Use Only. The information presented in this presentation is for educational use only. The presenter will make specific recommendations, but the participant is highly recommended to do their own due diligence before making any investment decision.

  continue reading

100 에피소드

Artwork

Learn SQL with Steve

CPE Today

published

icon공유
 

저장한 시리즈 ("피드 비활성화" status)

When? This feed was archived on October 16, 2023 13:28 (6M ago). Last successful fetch was on October 17, 2023 12:42 (6M ago)

Why? 피드 비활성화 status. 잠시 서버에 문제가 발생해 팟캐스트를 불러오지 못합니다.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

Manage episode 330328229 series 2859815
CPE Today에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 CPE Today 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

Power Query and Power BI are genuinely incredible tools to revolutionize your workflow. They offer the promise of "write once, refresh many" reporting where your reports can be instantly updated in real-time with the click of a button. These tools can be hooked directly to your company's databases, accounting applications, enterprise resource planning solutions, etc. Once the connection is established, they can dynamically retrieve anything from the database and populate your reports. While incredible tools, these features require additional training and experience to master. This course series will review the different methods of connecting to your data and have multiple hands-on activities to help you master these incredible tools.

CPE Today has a brand-new learning tool to help you learn how to use Power Query and Power BI. We have created a public server with several sample databases to help you learn how to extract, transform and load data into your dashboards and spreadsheets. This tool will give you practical hands-on experience working with cloud databases from major accounting solutions, including QuickBooks Desktop, QuickBooks Online, and more. This course will provide you with the knowledge to turn your organization's actual data into repeatable refreshable pivot tables, Power BI dashboards, and more!

Are you a CPA?? Are you a Financial Professional?? Earn CPE Credits for Today's Podcast. Check out https://cpe.cx/lsql/. Take a quick 5 question quiz and get your certificate today. Super Easy!

Presented by Stephen M. Yoss, CPA, MS (https://yoss.io)
Produced by Alicia Yoss & Alanna Regalbuto
Graphics By Flaticon.com and iStock
Music by Bensound.com
Education and Compliance By K2 Enterprises (https://k2e.com)

Copyright. All product names, logos, and brands are the property of their respective owners. All company, product, and service names used in this website are for identification purposes only. The use of these names, logos, and brands does not imply endorsement.

Educational Use Only. The information presented in this presentation is for educational use only. The presenter will make specific recommendations, but the participant is highly recommended to do their own due diligence before making any investment decision.

  continue reading

100 에피소드

모든 에피소드

×
 
Loading …

플레이어 FM에 오신것을 환영합니다!

플레이어 FM은 웹에서 고품질 팟캐스트를 검색하여 지금 바로 즐길 수 있도록 합니다. 최고의 팟캐스트 앱이며 Android, iPhone 및 웹에서도 작동합니다. 장치 간 구독 동기화를 위해 가입하세요.

 

빠른 참조 가이드