- Introduction
- Raw data and course activities
- Keep Fact and Dimension tables separate
- Before you forget
- Keep the structure simple - From Snowflake to star
- Always Format measures
- Always use a date table 1. Turn off Auto date tables
- Always use a date table 2. Create a date table on the fly with Power query
- Always use a date table 3. Mark a date table as a date table
- Hide Fields
- Document measures using Tool-tips
- Do not Transform data using DAX
- Conclusion
What you'll learn
- Tips and tricks to improve your DAX skills when working in Power BI or Power Pivot
- This is not a course teaching you DAX, but a course of tips and tricks to help you improve your DAX and Power BI or Power Pivot skills
- Modeling Tips
- Date table tricks
- Power BI tricks
- Shortcuts
Description
Looking to supercharge your productivity, refine your modeling prowess, and master DAX in Power BI or Power Pivot? Look no further than this comprehensive course tailored just for you.
In today's data-driven landscape, proficiency in DAX is increasingly vital. Whether you're a seasoned analyst or just starting out, this course offers invaluable insights and strategies to elevate your DAX game.
Designed as a treasure trove of practical tips and tricks, this course is your ticket to saving time and maximizing efficiency. Dive deep into the world of DAX with expert guidance on:
Data Modeling: Unlock the secrets to creating robust data models that power your insights.
Harnessing Date Tables: Learn to wield the power of date tables to fuel dynamic analyses.
Mastering Keyboard Shortcuts: Discover time-saving shortcuts to streamline your workflow.
Optimizing Models: Fine-tune your models for peak performance and efficiency.
Transforming Data: Explore essential data transformation techniques for cleaner, more usable datasets.
Leveraging Power Query: Unleash the full potential of Power Query for seamless data wrangling.
And that's just the beginning! With a wealth of additional topics and hands-on exercises, you'll gain practical experience every step of the way. Downloadable workbooks ensure you can practice at your own pace, reinforcing your newfound skills.
Whether you're aiming to boost your career prospects or simply enhance your proficiency, this course empowers you to stay ahead of the curve. Join us today and unlock the full potential of DAX in Power BI or Power Pivot. Your journey to mastery starts here.
this course is aimed at those looking to upskills
Other Courses
React JS For Beginners 2023
A brief introduction to ReactJS for beginners, learn React from scratch.
Learn Python Language Fundamentals In Simple Way
To Know Basics of Python and To Enter Python World Very Easily
Gain Your Trading Edge Using the Crypto Wizards Tool Suite
How to use the Crypto Wizards platform to find an edge in trading with statistical arbitrage, vanilla arbitrage and ML
Project Management Crash Course in 100 minutes
Essentials Fast-Tracked: Navigating the Basics of Project Management
Prompt Engineering+: Master Speaking To AI (2023)
Prompt Engineering | 10x Productivity | Few/Zero-Shot Techniques and Best Practices | 50+ Optimised Prompts | GPT-4
How to Change Your Thinking & become more Positive
Quick inspirational video tips to shift your perceptions so that you can live the life you deserve.
About the instructors
- 4.44 Calificación
- 153067 Estudiantes
- 14 Cursos
Paula Guilfoyle CPA
CPA Accountant, & Life Long Learner
With over 25 years of expertise in Accountancy, Business Management, and Operations, I, Paula, am a seasoned CPA (Certified Public Accountant) dedicated to empowering learners with practical skills and knowledge. As a former Microsoft MVP (Most Valuable Professional) in Excel for two consecutive years (2020 & 2021), I've been recognized for my commitment to excellence in spreadsheet solutions and financial analysis.
Having immersed myself in the Web3 landscape since 2016, I've become a leading voice in simplifying complex concepts, making Web3 and Blockchain technology accessible to all. And so, my journey took an exciting turn in 202 when I embraced the transformative potential of Web3, Blockchain, and Digital Assets and pivoted my training to focus on web.
Founder of A Block of Crypto: As the founder of A Block of Crypto, I am passionate about demystifying the world of cryptocurrency and blockchain. Through engaging courses and interactive online meetups, I strive to make Web3 and blockchain technology as intuitive as ABC. My mission is not just to educate but to onboard and retain users in the rapidly evolving Web3 ecosystem.
What I Offer:
Comprehensive Courses: Dive deep into the fundamentals of Web3, Blockchain, and Crypto with my meticulously crafted courses designed for beginners and seasoned professionals alike.
Interactive Online Meetups: Join our vibrant community and participate in regular online meetups where you can network with like-minded individuals, ask questions, and stay updated on the latest developments in the world of Web3.
Web3 Support: Whether you're navigating your first crypto project or exploring decentralized finance (DeFi) protocols, I'm here to provide guidance and support every step of the way.
Let's Connect: Embark on your journey into the exciting world of Web3 and Blockchain with me. Follow me on Udemy to stay updated on upcoming courses, events, and exclusive learning opportunities. Together, let's unlock the full potential of decentralized technology and shape the future of finance and beyond.
Student feedback
Course Rating
Reviews
Nice explanation in easy to understand.
Very good explanation of thought process behind why tasks are performed a certain way.
good
Good presentation and explained well. thanks.