Blogs

 

 

1 person recommends this.
Thinking of registering for Power Summit  Phoenix this October? To give you a little more insight, we interviewed Microsoft MVP, Power Summit Program Committee Member and Academy Instructor, Belinda Allen to get her thoughts on why others should attend the inaugural Power Summit event and what you can expect to gain by attending.   To you, why is content one of the top reasons to attend this conference? Using (our) data to gain insights about where we’ve been and where we are (potentially) going is one of the main use cases for using Power BI.  The exposure we get, at a conference like Power Summit, on HOW others are asking questions of their data, ...
0 comments
Be the first person to recommend this.
The August PUG Leader Challenge will run from June 20 -29.   The Winning PUG receives two free tickets to the World Tour location of their choice and will be featured on the website, as well as in the PUG Monthly Update, in a blog post, and PUG Newsletter. This month’s challenge: To win this month's challenge, leaders will need to:    1. Use the World Tour   marketing kit   & hashtag   #PBIWORLDTOUR   to promote  the Power BI World Tour. 2. Invite new PUG members to join your community We are here to help you with this challenge! Reach out on this thread or email   info@pbiusergroup.com   for assistance with any of the steps above.
0 comments
Be the first person to recommend this.
There’s only  one week left to save $400 on your Power Summit Phoenix registration . Don’t wait to register and miss the  lowest price offered  - the price increases after Thursday, June 28: Register Now. Why Attend Power Summit, October 15-18 Are you struggling to keep up with what is now becoming a very data-driven world? Power Summit is an unbeatable way for you to get answers to your burning questions and boost your ability to succeed in your job every day. What you learn at Power Summit will fuel your career for years to come. Microsoft Power Series – Sessions Released At Summit, “content is king and networking is queen!” ...
0 comments
Be the first person to recommend this.
When: 7/17/2018 10AM PST Where: https://www.meetup.com/Power-BI-User-Group-Norway/events/251897518/   July 2018 Update for Power BI Embedding with Ted Pattiso
0 comments
Be the first person to recommend this.
Power BI World Tour is back! These value packed two-day events will take place in eight cities over the course of four months. Registration is open – don’t miss out on early bird pricing, a savings of $100 ending July 10! Each event is packed full of amazing content and people, including a Microsoft keynote speaker providing a product roadmap and more than 24 breakout sessions at each location. The content is broken up into three tracks, for New Business User, Power User and Technical, to allow attendees to customize content to their needs and bring their learning to the next level. Don’t miss the chance to network with hundreds of users, community ...
0 comments
2 people recommend this.
  Have you heard about the Microsoft Power Series ? It is a series of hands-on breakout sessions, each over two hours, led by the Microsoft product teams themselves. The series of power sessions was immensely popular in Dublin at the 2018 Data & BI Summit and is being brought to Power Summit Phoenix this October 15-18 for the premiere user group event with even more to offer. Expanded now to cover all areas of power user content including Power BI, PowerApps, Microsoft Flow, and CDS for Apps and Analytics.   The #PowerUGSummit Microsoft Power Series sessions include:   CDS for Apps CDS for Analytics Do More with Microsoft ...
0 comments
Be the first person to recommend this.
Gartner recently positioned   Microsoft’s Power BI  as a leader in their annual Magic Quadrant for Business Intelligence and Analytics Platforms. Also, for the second year in the row, Microsoft is placed farthest in vision within the leader’s quadrant. The reason behind this achievement is mainly because of the new exciting features Power BI team releases every month. Let’s have a look at few of the key features released in February and March 2018.   1. Formatting changes: We can now control the labeling of data in scattering and another kind of cartesian charts. This improves the readability of the report and helps in a situation when data ...
0 comments
Be the first person to recommend this.
Get away from your desk to connect in-person with peers, friends, and experts in a lively, engaged environment at Power Summit Phoenix, October 15-18 . Power Summit is your place to share product insights, trouble-shoot your toughest challenges, and walk away with lifelong friends and more new knowledge than you thought possible.  Early Bird Pricing Ends June 28 You’re running out of time to save big on your Power Summit registration. There’s only 14 days left to SAVE $400 before the price increases after June 28. Don’t miss this discount: Register Now! Hear From Peers in Summit 2017 Video Learn why Summit attendees keep coming back ...
0 comments
Be the first person to recommend this.
Dynamic Communities and Microsoft are working closely together to bring you a series of great learning opportunities in the coming months. Here are two events we want to make sure are on your calendar:   Power Summit Phoenix Join us October 15-18 in Phoenix for the inaugural  Power  Summit Phoenix .  Attend this event for over 60 dedicated sessions to teach you how to visualize, analyze and access data through Power BI, PowerApps, Microsoft Flow and more. At   Power  Summit , you’ll team up with user group peers, All Stars, and MVPs to turn your online support network into real-life connections! You’ll dive in to share your knowledge… and ...
0 comments
1 person recommends this.
Es cierto que Power BI es una aplicacion bastante versatile a la hora de visualizar y analizar datos, y aunque se menciona en varios blogs y white papers las capacidadesd de analisis predictivo o Machine Learning (al margen de usar el R script ), aqui presento un compendio de las funcionalidades que ya existen para tal fin sin necesidad de usar codigo en R o ningun otro codigo. En cuanto a los metodos o funcionalidades de analisis predictivo, vamos a distinguir entre las capacidades 'propias de Power BI' y las visualizaciones que actualmente estan disponibles en el ‘AppStore’ de Microsoft para Power BI. No es la intencion de este blog de describir o explicar ...
0 comments
1 person recommends this.
I wanted to give a summary of what the Tampa Power BI User Group has started to integrate in our monthly meetups - many of you have heard about the Project Professional Program. We have already covered 3 sessions (overview, data modeling, and query editor), and if you are interested below is what we are covering and the goals of the series: Overview: To educate & train Tampa PUG members on building Power BI Reports by guided & interactive sessions via using the “Dashboard in an Hour” (DIAH) or Workshop format. The workshops & sessions will focus on best practices, advanced features & how to implement in reports, and providing solutions by ...
0 comments
Be the first person to recommend this.
Is it possible to drill through to a different, related table? When I tried this, the context menu doesn't show Drill Through. The tables are related OK, as this work for filters (which achieve a similar effect). My scenario is I have a detail table (of events) and an aggregated table, which shows counts of different types of events for the aggregation criteria, which is one week in my case, so the tables are related by the week (start date); this is surely a common type of scenario?
0 comments
Be the first person to recommend this.
Add Pre-Conference Academy to your registration for extra training! It’s already time to start planning your trip to the inaugural  Power   Summit Phoenix happening October 15 – 18 . Whether you’re a technology user or partner, Summit has something for you with dynamic sessions, a robust exhibitor community, and the opportunity to network with professionals in similar careers. Early Bird Pricing – Don’t MISS OUT on Savings Don’t delay your registration and  save $400 today with Early Bird pricing ! The  price increases on June 28 , so don’t miss this limited time offer:  Register for Power Summit Pre-Conference Academy ...
0 comments
Be the first person to recommend this.
Congratulations to Wolfgang Strasser and Markus Ehrenmuller and the Austria PUG on winning the June challenge of the month. We spent some time with the leaders of this community to learn more about the PUG in Austria.   What has been the most exciting thing for your PUG so far? Of course: Having won the June PUG Leader Challenge! The whole journey of seeing the features of the product growing over the past years and the local & global community in parallel is very exciting.   What makes your group successful? Our PUG is well connected with the existing Microsoft Data Platform community which is driven forward via PASS Austria.  ...
0 comments
Be the first person to recommend this.
We sat down with new PUG Leaders, Ricardo Freitas and Pedro Reis to learn more about them and the PUG they recently launched in Porto. Pedro Reis   Ricardo Freitas   What inspired you to want to start a new PUG in Porto?   Pedro: When I was in the Microsoft Excel championship final last year, I had the opportunity to meet many BI professionals, Microsoft staff, Power BI trainers from Microsoft partners, and many others. I started consuming even more are more Power BI courses, blogs, videos, forums and developing work on it, but I couldn’t find any Portuguese community joining the few amazing professionals that I already knew! I had to ...
0 comments
1 person recommends this.
Join your user group community to learn, network & engage! The inaugural Power Summit Phoenix will take place October 15-18, 2018 at the Phoenix Convention Center in Phoenix, AZ. Power Summit is the can’t-miss conference for Power Users, Business Analysts, IT Administrators, and Developers –  register now ! Why you should attend Leave behind the world of net-centered chat to power real-life growth between peers and experts in a lively, engaged environment all community-driven. Here’s a preview of what you can look forward to onsite: Meet & network with your user group community:  Power Summit provides countless opportunities ...
0 comments
Be the first person to recommend this.
Excited to announce the 2018 Power BI World Tour has expanded this year to visit 8 cities – now adding Melbourne, Australia! This city addition is the first stop in a series of eight over the course of four months. Registration is now open – secure your seat today!   Whether you are local to the area, traveling from near or faraway, the Power BI World Tour will provide exclusive learning and networking opportunities. Don't miss the opportunity to get involved in one or more of these amazing event locations, as either a speaker, content committee member, or attendee. Call for Proposals for all city locations are open now and closing ...
0 comments
Be the first person to recommend this.
Someone asked how he could get a calculated column with the value for a certain column in the previous row. In Excel, this is a simple task. However in M, things become a bit more tricky. Suppose you are taking measurements, and for some reason you want the previous measurement to be stored with your data. There are optimization concerns that may make this a useful thing to do, as Power Query only performs its actions on refresh, and not once the data loaded. Alternatively, DAX does it’s work every time you select a slider, click a visualization, or basically change anything on the report. This is one of the times when a good SQL background helps your M ...
0 comments
Be the first person to recommend this.
Someone had written a measure that gave a certain range of outputs, such as “A”, “B”, or “C”. They had a process that gave a grade to each order depending on how well it performed in certain ways — how fast it was shipped, how many times the customer called in, how much profit was made, etc. They then wanted to know how many As, Bs, and Cs were given. In short, they wanted to be able to count the measure results. When you want to measure other measures, you need the iterative functions (a.k.a the “X” functions). In this case they wanted  COUNTX() . I threw together an example PBIX with some random data. I have 4 data measurements each day ( M1  –  M4 ...
0 comments
Be the first person to recommend this.
Someone asked how he could find the start of the current month in a different year. He had a report that contained a parameter that selected a year, say 2007. He wanted to find the beginning of the current month, say May, in that year. So what he wanted was the string "May 1, 2007" when the current date was May 26, 2018. And if the current date were October 5, 2023, he would want the string to read "October 1, 2007". Whenever you talk about dates in Power BI, you have to know how dates are stored. In this case, the date table was created with the DAX function Dates = CALENDAR(DATE(2001,1,1), TODAY()) That gives you a table named Dates with a column named ...
0 comments