Skillwave Training

New to Power BI? We will turn you into a #PowerBI ninja, showing you how to to transform your data with #PowerQuery, extract more data insights with #DAX, and create and share reports. 📊 This is a completely end-to-end Power BI course with hands-on experience. You’ll produce reports that get rave reviews from your team and WOW your boss! 🤩 If you want to learn how expert Matt Allington uses Power BI to create amazing reports and how you can do it too, go sign up here: https://skw-t.com/pbiba #BusinessIntelligence #DataAnalytics #DataAnalysis #DataModeling

Following on last week's Monkey Shorts video, we are going to look at one potential "gotcha" that can happen when converting a #PivotTable into CUBE functions - the array formula. 😱 These show up when you have multiple fields in your dimensions and are confusing to users who are not used to seeing them. In this video, Ken Puls shows how you can identify an array, and how to break it so that you can make your formulas dynamic again: https://lnkd.in/gMiEuUen #Excel #DataAnalytics #BusinessIntelligence

We know that there are other learning resources out there. Our promise to you is that the material you will find here at Skillwave will be the best learning resources created by the best instructors in the business. 🚀 Skyrocket your #BusinessIntelligence and #DataAnalytics skills - check out our course catalog today at https://lnkd.in/gM4aYZjd #PowerBI #Excel #PowerQuery #DAX #DataModeling #DataVisualization

A common #BusinessIntelligence requirement is the need to limit a #PowerBI visual to only show completed months and exclude the current active month. The chart shown here is a good example. As usual in Power BI, there are various ways to solve this problem. The way Matt Allington likes to do it is to create a calculated column in the calendar table (you could use #PowerQuery, too). 📅 Check out his solution here: https://lnkd.in/gQApskDw #DataVisualization #DataAnalytics

Have you ever wanted to grab a single cell of data from your #PowerPivot #DataModel? Tired of setting up an entire #PivotTable and using GETPIVOTDATA() formulas to do it? In this episode of Monkey Shorts, Ken Puls shows how you can quickly convert your Power Pivot backed PivotTable into CUBE formulas, and simplify them. Good bye tabular constraints! Watch here: https://lnkd.in/gaEmvnZD #DataModeling #Excel

📊 Unlock the power of #DataVisualization. Learn to create engaging and effective graphs, charts, and diagrams in #Excel and #PowerBI with our experts Jonathan Schwabish, Ken Puls, and Matt Allington. Communicate insights, tell stories, and save time. Enroll now and transform your data communication skills: https://skw-t.com/dataviz #DataViz #DataCommunication #DataStorytelling

📢 Join Sandeep Pawar and I next Friday, August 8th @ 9:30 AM (PT)! Semantic Link in Microsoft Fabric offers a new way to access the data and semantic information contained in a semantic model. This allows data scientists, data engineers and data analysts to preserve and re-use the business and domain knowledge in creating enterprise solutions. In this session, Sandeep will give you an overview of Semantic Link and provide practical use cases to use Semantic Link in your development workflow to automate common Power BI tasks, optimize the semantic models and also monitor/manage the tenant. He will also show Semantic Link Labs, an open-source Python library with hundreds of useful utilities. #PowerBI #SemanticLink #Fabric #Microsoft https://lnkd.in/gTHVb2uR

As an accountant, Ken Puls regularly builds #FinancialReports. One thing we have to deal with is getting the numbers to display in a friendly format. Because of the way that debits and credits are stored in databases, this can be a little challenging. 😕 In this article, Ken walks through the process of building a simple profit and loss statement in #Excel with #PowerPivot, showing how to make all values show correctly. 🙂 There are some key issues that we’ve got to work through, and we’ll do that using a conditional #DAX measure: https://lnkd.in/dV8UcBsq #FinancialAnalysis #BusinessIntelligence

If you're subscribed to our newsletter, it's time to check your inbox as the July edition is here! 📬 If you're not subscribed, sign up today and receive our monthly round-up of content from our experts, plus information on courses, events, and specials. Plus, we'll also send you our free Power Query eBook, Magic Tricks for Data Wizards! 📗 Go to https://skw-t.com/news

Did you know that an official #Excel table (Ctrl + T) can be set up to have a single cell? In this video, Ken Puls shows you how this is done, as well how it can be used to read data into and out of #PowerQuery. 🔁 https://lnkd.in/gXJYKG-P