Power BI StepUp Challenge: Elevate Your Power BI and Data Skills!

Embark on a transformative journey to master Power BI. Gain practical skills, and earn a Credly badge, advancing your path to Power BI success.

Collab365 Challenge

Presenter

Jon Manderville, Coach

Suitable For

Intermediate

Study Duration

2 Hours

What you'll gain my completing this Challenge:

  • DAX Insight: Gain expertise in Data Analysis Expressions for deeper data insights.
  • Expert Data Analysis Techniques: Utilize filtering and drill-through reports for nuanced data exploration.
  • Publishing and Security: Learn to publish Power BI apps and implement row-level security.
  • Advanced Data Integration: Techniques for importing and transforming data from diverse sources.
  • Effective Data Modelling: Skills in linking tables and creating effective data models in Power BI.
  • Dynamic Visualizations: Learn to create interactive and compelling visualizations.

Note: This Challenge is included with the Power BI Success Path.

Subscribe to all of the training in the Collab365 Academy:
Get this training plus over 450 hours of training and access to the Collab365 Academy. Learn More.

Description:

Embark on an engaging journey with the Power BI  StepUp Challenge, designed to take your Power BI skills to the next level. This Challenge is a natural progression from the popular Power BI Jumpstart Challenge, but don't worry if you haven't completed it - you can still dive right in!

The Power BI StepUp Challenge is an self paced, hands-on learning experience designed for those who want to deepen their understanding of Power BI. Led by Jon Mandeville from the Collab365 Academy, this challenge guides you through the nuances of Power BI, from adding and transforming data to creating insightful visualizations and robust data models. You'll learn about DAX, filtering, publishing apps, and ensuring data security. Completing this challenge will not only enhance your skill set but also earn you a respected Credly badge as part of your success path.

After you complete the StepUp Challenge, you will be able to enhance and publish ...

...these stunning, interactive & shareable reports to every device...

Power BI Report

... once you've graduated you will be able to add this to your Skills Portfolio:

Challenge Learning Modules:

Introduction to Power BI StepUp Challenge

  • Overview of Power BI capabilities.
  • Setting up a Microsoft 365 Developer Environment.
  • Pace and structure of the learning journey.
  • Adding Data to Your Model

  • Importing data from CSV files and SharePoint lists.
  • Using Power Query for data transformation.
  • Exploring Olympic medal data as a case study.
  • Creating a Transform Process

  • Cleansing data and ensuring data integrity.
  • Naming conventions and data type selection.
  • Utilizing Power BI's built-in intelligence for geographical data.
  • Linking Tables in Your Data Model

  • Creating and managing relationships between tables.
  • Understanding cardinality and its impact on data models.
  • Practical exercises in linking Olympic data sets.
  • Experimenting with Visualizations

  • Techniques for dynamic and influential visualizations.
  • Filtering data and identifying patterns.
  • Hands-on experience with advanced visualization tools.
  • DAX and Advanced Data Analysis

  • Introduction to DAX for creating calculated columns and measures.
  • Analyzing influence factors like BMI on Olympic medalists.
  • Building complex measures using DAX expressions.
  • Publishing and Security

  • Best practices for publishing Power BI reports and apps.
  • Implementing row-level security for data protection.
  • Collaborative features and workspace management in Power BI.
  • What is a Collab365 Challenge?

    Blue Certified Solution

    In many cases, our Challenges are built so that you can "learn by doing". To achieve this we follow our B.L.U.E. Framework. Learn why BLUE is a superior way to learn. Here's a summary of the 4 phases.

    step 1

    BUILD IT

    Learners conceptualise and start creating the app during the ‘Build It’ phase. They tap into the Power Platform’s capabilities to design an intuitive and user-friendly interface while meeting the task’s business requirements. This hands-on experience, right from the start, deepens their understanding of the platform and its functionalities.

    step 2

    LEARN IT

    As they move into the ‘Learn It’ stage, learners realise the platform’s intricacies, discovering functionalities they were previously unaware of. This phase provides an immediate feedback loop, allowing learners to correct misconceptions, deepen their understanding, and improve their skills.

    step 3

    USE IT

    In the ‘Use It’ phase, learners experience their creations from a user’s perspective. They test the app, identifying any flaws or usability issues. This hands-on testing and usage phase provides invaluable insights into user experience, an essential aspect of any app development process.

    step 4

    ENHANCE IT

    Finally, during the ‘Enhance It’ stage, learners refine their app based on the feedback and insights gained during testing. This iterative process simulates a real-world development cycle, reinforcing the importance of continual learning and improvement in the technology industry.

    Mandy McPhail | Power Platform Enthusiast

    "Another great learning experience!"

    I particularly like Jon's presentation method, however, I really appreciate being able to stop and go back in the videos as that meant I could work out where I'd made a mistake or missed something

    Earn an industry-recognised certification.

    Collab365 Certification Issued in Credly

    Upon successfully completing this training, you will be awarded a prestigious Collab365 certification, issued through Credly, the leader in digital credentials. This certification serves as a testament to your newly acquired skills and your dedication to professional growth.

    The Value of a Credly Certification:

    • Global Recognition: Your Credly badge is a globally acknowledged symbol of your Power BI expertise, enhancing your professional stature on platforms like LinkedIn and beyond.
    • Digital and Shareable: Easily share your achievements across social media and professional networks, increasing your visibility to potential employers and peers.
    • Verified Skills: Each badge carries detailed, verifiable information about the skills you've mastered, adding credibility and trust to your professional profile.

    Achieving a Credly certification through our Challenges and Success Paths not only marks your mastery of valuable skills but also significantly elevates your professional presence in the digital world.

    What do I need to take the challenge?

    No Previous skills necessary

    We've built the Challenge for anyone to follow along with, so you don't need any previous skills. We'd strongly encourage completing our JumpStart Challenge first, however as long as you already know the basics, we'll give you what you need to build from there.

    "Power BI Desktop" on your Windows PC

    To follow along with the report building aspects, you will need the Power BI Desktop application. You can get it from the Microsoft Store. It's very easy to install and 100% free. You need a Windows PC.

    Microsoft 365 Tenant

    You will be publishing in this challenge so you'll want access to the Power BI cloud service.  You can get it as part of a free M365 Developer Licence. There's also a very cheap paid alternative called a Microsoft Business Basics licence (around USD $5pcm). Or you can use your own Microsoft 365 Tenant. 

    Are you a Mac User?

    The Power BI Desktop is currently not supported on MacOS so you need a machine running Microsoft Windows. If you don't have one, you can always setup a Virtual PC in the Cloud (we're sorry, we dont teach you how to do this part so you'll need to be set up ready)

    This training includes:

    • 2 hours of study
    • Access to the Collab365 Academy
    • StepUp Data Pack Download
    • Watch on Desktop or Mobile

    Meet your Trainer:

    Jon Manderville, Coach

    Jon Manderville, Collab365 Coach

    Jon is one of the original Collab365 Coaches and has helped build the Academy into what you see today.

    He's passionate about the Power Platform but knows first-hand what it was like to begin fresh with this technology.

    Having worked as a Scrum Master for many years, Jon is someone who spotted the potential for Microsoft 365 services to help teams visualise their results, data and processes so that they could improve all the time.

    Jon's extensive business background and desire to build no-code solutions led him to start learning the Power Platform.

    You'll be in good hands with Jon. His style is relaxed but inclusive and mindful that not everyone starts from the same place. So be prepared to get involved and have some fun along the way.

    100% Satisfaction guaranteed

    100% Guaranteed

    We're thrilled to have you explore our content! Like many of our happy customers, we're sure you'll find great value in what we offer. If, for any reason, you're not completely satisfied with a stand-alone purchase, please reach out within 30 days. We're more than happy to process a refund for you.

    As for our Platinum Plan, we invite you to take advantage of our Collab365 Academy with a full-access, 7-day trial. It's a wonderful opportunity to experience all that we have to offer. Please note, due to the nature of this comprehensive trial, we are unable to provide refunds for plan purchases.

    Frequently Asked questions:

    Can I get an invoice?

    As soon as you purchase your pass you will be emailed a receipt. If you'd also like a formal invoice, please send your request to hello@collab365.com.

    Can I get refund?

    We're thrilled to have you explore our content! Like many of our happy customers, we're sure you'll find great value in what we offer. If, for any reason, you're not completely satisfied with a stand-alone purchase, please reach out within 30 days. We're more than happy to process a refund for you.

    As for our Platinum Plan, we invite you to take advantage of our Collab365 Academy with a full-access, 7-day trial. It's a wonderful opportunity to experience all that we have to offer. Please note, due to the nature of this comprehensive trial, we are unable to provide refunds for plan purchases.

    Can I buy a team or multi-user pass?

    Absolutely, we also offer discounts for multiple purchases. To sign-up for a Teams Pass, please visit our Platinum Plan page.

    Can I share the videos and ebooks?

    No, only the person who purchases the pass will be able to watch the videos and will receive the ebooks. We ask that you do not share them.

    Who do I contact if there's a problem?

    Send us an email at hello@collab365.com and we can help. 

    Can I cancel my subscription?

    Of course. The trial lasts for 7-Days and you can cancel anytime before that. If you choose to continue as a paid platinum member you can also cancel at any time.

    How do I get my certifications?

    If the training you purchase also includes a certification, then as soon as you complete, we will automatically email you so you can redeem your badge on Credly. Good luck!

    What is included in the Platinum Plan?

    The Platinum Plan offers a comprehensive suite of resources tailored for Microsoft 365 learners:

    • Complete access to our current library of over 200 hours of detailed Microsoft 365 training and 108 Ebooks.
    • A rich selection of over 30 half-day workshops covering essential Microsoft 365 and Power Platform concepts.
    • Membership in an active community of 10,000 learners for peer support and networking.
    • Continuous updates with all new workshops, challenges, and success paths to keep your skills sharp and current.
    • Lifetime access to all virtual summit session recordings, with insights from top industry experts.
    • As we evolve, so will our content. The Platinum Plan includes all future training that aligns with the core educational content and formats currently offered.

    What is not included in the Platinum Plan?

    While the Platinum Plan is extensive, there are a few exclusives that fall outside its scope:

    • One-on-one coaching sessions and personalized, coached training programs.*
    • Custom software solutions or tools that are not a part of the standard offerings within the Collab365 Academy.
    • Niche training that falls outside of the Power Platform, SharePoint, or Microsoft Teams ecosystem.
    • External certifications or formal accreditation from third-party institutions.

    *Please note that there may be occasional exceptions to the coached training programs. Stay tuned for special announcements or offers that may include these features.

    • Personal

    • Teams

    Subscribe to all of the training in the Collab365 Academy:
    Get this training plus over 450 hours of training and access to the Collab365 Academy. Learn More.