data modeling
652 TopicsMadison Power BI Apr 2022 - Junk Dimensions
In dimensional modeling, dimensions are often a tangible thing: the date, the time, the customer, the employee, the location, the product. It's something you can see and point to; even have a conversation with. But what happens when your dimension isn't a tangible thing? When it's just a collection of random pieces of information? How do you model things that aren't things? This is where you enter the murky world of junk and degenerate dimensions. Let's talk about why junk might be exactly what your model needs. PLUS, if you have your own Power BI/star schema modeling questions or challenges, bring them to share with the group and let's see if we can't help. --- The meeting will start at 6pm and end at 7.30pm on Wednesday April 6th. We'll have pizza and soft drinks. We do ask that you wear a mask. ***NEW LOCATION*** We'll be meeting on the ground floor of the Hy Cite offices in Middleton: 3252 Pleasant View Rd, Middleton, WI 53562. It's on the far west side - exit the beltline on Airport Rd (exit 250). Hy Cite is on the corner of N Pleasant View Rd and Airport Rd just before Airport Rd goes from 2 lanes to 1. The main entrance is on the Airport Rd side of the building. What3Words: ///trees.laser.boat --- Unrelated, if you are looking for (or are open to) a new position that uses your Power BI skills, get in touch! Weโre aware of at least 2 companies hiring in the Power BI space right now.127Views0likes0CommentsChicago Power BI User Group with SQLBI.com -Marco Russo & Alberto Ferrari
We are back downtown! Join us IN-PERSON for an incredible session with the best in the business: Marco Russo & Alberto Ferrari! The night will be an Ask Me Anything, where you can finally ask the foremost experts in DAX youโre pressing questions on DAX and Data Modeling. YOU MUST REGISTER ON MEETUP. There are limited seats available, so make sure to RSVP here to get in. We will also live stream the event if you are unable to attend in person. Please see at the end more details on attending. Marco Russo | Power BI Data Modeling About Marco Russo A veteran of end-to-end projects, Marco wrote several books with Alberto Ferrari about Power BI, Analysis Service, and Power Pivot. They also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Alberto Ferrari | Consultant & Mentor About Alberto Ferrari Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology. Today, Alberto's main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities. Topics - Discussion will be centered around DAX techniques and capabilities of Data Modeling Q&A - Question and Answer format where Marco & Alberto will answer a list of Frequently Asked Questions as well as answering a few from the audience COVID-19 SAFETY MEASURES COVID-19 vaccination required Event will be indoors COVID-19 โ Protocol - Access to Microsoft Office: Complete 30 minutes prior to arriving on site To access Microsoft facilities all visitors must provide either (1) proof of COVID-19 vaccination, (2) attest to receiving a negative COVID-19 test in the past week or (3) attest to a previous recovery from COVID-19. We accept proof of vaccination from all countries. Please be ready to show proof of vaccination to Reception If you do not have proof of vaccination or are unvaccinated, please attest that you will only enter a Microsoft facility if you have taken a COVID-19 test in the week prior to entry and tested negative. If you have attested to having a recent COVID infection in the MyHealth App, you may show the certificate you received as confirmation. If you are unable to use the HealthCheck app, a verbal health attestation will be read to you upon arrival. Payment & RSVP If you have RSVP'd but have not paid via PayPal, please do so here: https://paypal.me/pugliathomas There is a fee for this event as it is an on-site event and has limited capacity. Therefore, we want to ensure those who register are making the commitment to be there. If you have not paid 7 before the event date, you will be removed from the RSVP list. If you cannot make it, please contact Tommy Puglia to be refunded.Power BI Development Best Practices
In this session, Soheil will show you some Power BI development and design best practices, covering topics such as Power Query, Data Modeling, DAX, Data Visualization, Star schema, Data Type, and Relationships,... ๐๐๐๐ฉ๐๐ฃ๐ ๐ก๐๐ฃ๐ (๐๐ ๐๐๐๐ข๐จ): https://bit.ly/3CYM4A8 ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: Persian - Farsi661Views0likes0CommentsPower BI Development Best Practices - Part 2
Here is the video of the first part of this session, which was held on 20-Oct-22: https://youtu.be/ocDT_GFOvoE In this session, Soheil will show you some Power BI development and design best practices, covering topics such as Power Query, Data Modeling, DAX, Data Visualization, Star schema, Data Type, and Relationships,... ๐๐๐๐ฉ๐๐ฃ๐ ๐ก๐๐ฃ๐ (๐๐ ๐๐๐๐ข๐จ): https://bit.ly/3CYM4A8 ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL Language: Persian - Farsi232Views0likes0CommentsMy favorite hidden tricks in Power BI
In this session, Helen will show you her favorite Power BI tricks. Helen is a LinkedIn instructor for Microsoft Power BI, Excel, Python, R, AWS, for more details check out her LinkedIn profile: https://www.linkedin.com/in/helenrmwall/ Language: English ๐๐๐๐ฉ๐๐ฃ๐ ๐ก๐๐ฃ๐ (๐๐ ๐๐๐๐ข๐จ): https://bit.ly/3CYM4A8 ๐๐๐ง๐จ๐๐๐ฃ ๐๐ฝ๐๐๐- ๐๐๐๐ง๐ค๐จ๐ค๐๐ฉ ๐พ๐ค๐ข๐ข๐ช๐ฃ๐๐ฉ๐ฎ: https://bit.ly/3IAg7xT ๐๐๐ฃ๐ ๐๐๐๐ฃ: https://bit.ly/32tGkif ๐๐๐ก๐๐๐ง๐๐ข ๐พ๐๐๐ฃ๐ฃ๐๐ก: https://t.me/PersianPBIUG ๐๐ค๐ช๐๐ช๐๐: https://bit.ly/3hk20RL172Views0likes0CommentsPower BI Desktop End-to-End Solution
๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐๐ฒ๐๐ธ๐๐ผ๐ฝ ๐๐ป๐ฑ-๐๐ผ-๐ฒ๐ป๐ฑ ๐ฆ๐ผ๐น๐๐๐ถ๐ผ๐ป ๐๐ฟ๐ผ๐บ ๐๐ ๐ฐ๐ฒ๐น ๐๐ผ ๐ฆ๐๐๐ป๐ป๐ถ๐ป๐ด ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐ฅ๐ฒ๐ฝ๐ผ๐ฟ๐. Learn how to turn your Excel data into a powerful, visually appealing financial report with Power BI Desktop. ๐ง๐ต๐ถ๐ ๐๐ฅ๐๐ ๐๐ฟ๐ฎ๐ถ๐ป๐ถ๐ป๐ด ๐ด๐๐ถ๐ฑ๐ฒ๐ ๐๐ผ๐ ๐๐๐ฒ๐ฝ-๐ฏ๐-๐๐๐ฒ๐ฝ ๐๐ต๐ฟ๐ผ๐๐ด๐ต ๐ฐ๐ผ๐ป๐ป๐ฒ๐ฐ๐๐ถ๐ป๐ด, ๐๐ฟ๐ฎ๐ป๐๐ณ๐ผ๐ฟ๐บ๐ถ๐ป๐ด, ๐ฎ๐ป๐ฑ ๐๐ถ๐๐๐ฎ๐น๐ถ๐๐ถ๐ป๐ด ๐๐ผ๐๐ฟ ๐ฑ๐ฎ๐๐ฎ, ๐บ๐ฎ๐ธ๐ถ๐ป๐ด ๐ถ๐ ๐ฒ๐ฎ๐๐ ๐๐ผ ๐ฐ๐ฟ๐ฒ๐ฎ๐๐ฒ ๐ฝ๐ฟ๐ผ๐ณ๐ฒ๐๐๐ถ๐ผ๐ป๐ฎ๐น ๐ถ๐ป๐๐ถ๐ด๐ต๐๐. ๐๐ ๐ฝ๐ฒ๐ฐ๐๐ฒ๐ฑ๐ข๐๐๐ฝ๐๐: Up and Running Power BI Desktop End-to-End Financial Report ๐ฆ๐ฐ๐ต๐ฒ๐ฑ๐๐น๐ฒ: Date: November 29, 2024 (Friday) Time: 7:00PM to 10:00PM PH Time Venue: 100% Online via Data Analytics Philippines FB Page ๐๐ฒ๐ป๐ฒ๐ณ๐ถ๐๐: + ๐ญ๐ฌ๐ฌ% ๐๐ฅ๐๐๐ง๐ฟ๐ฎ๐ถ๐ป๐ถ๐ป๐ด๐๐ถ๐๐ต ๐ฒ-๐๐๐ฅ๐ง๐๐๐๐๐๐ง๐ + LIVE Training + Instructor-led + Beginner-friendly + Open to EveryJuan + FREE Power BI Template and Dataset Click to View the details3KViews0likes0CommentsLearning DAX for Power BI
"From Zero to Hero: Learning DAX for Power BI" is a hands-on workshop designed to help you master the fundamentals of DAX (Data Analysis Expressions) and unlock the full potential of Power BI. Whether you're a beginner or looking to sharpen your skills, this session will take you step-by-step through creating powerful calculations, building robust data models, and deriving actionable insights from your data. Join us to learn practical techniques, explore real-world use cases, and gain the confidence to tackle any data challenge. By the end of the event, you'll be equipped to create dynamic reports and elevate your data analytics game. Perfect for analysts, business professionals, and data enthusiasts who want to go from zero to hero with DAX in Power BI!473Views0likes1CommentBUILDING EFFICIENT DATA MODELS IN POWER BI FOR TELCO INDUSTRIES
Join us for an in-depth session on Building Efficient Data Models in Power BI for Telco Industries, where we explore best practices for structuring, optimizing, and visualizing telecom data. This session is ideal for data analysts, BI professionals, and/or telecom industry experts looking to enhance their Power BI modeling skills. Get ready for a hands-on learning experience that will elevate your analytics capabilities!546Views0likes0CommentsASK ME ANYTHING - POWER BI EDITION
ASK ME Anything: Power BI Edition Are you struggling with DAX formulas, data modeling, or Power BI visualization? Or maybe youโre just getting started and need guidance on best practices? Join us for an exclusive Power BI Ask Me Anything (AMA) session, where you can get real-time answers to your biggest challenges in Power BI. Whether you're a beginner looking for guidance or an experienced user tackling complex analytics, this session is for you!2.7KViews0likes0Comments