<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Enterprise DNA on Medium]]></title>
        <description><![CDATA[Stories by Enterprise DNA on Medium]]></description>
        <link>https://medium.com/@sam.mckay?source=rss-56862a96358c------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*tIs8jq37Bb7AvqzBHyCbTw.png</url>
            <title>Stories by Enterprise DNA on Medium</title>
            <link>https://medium.com/@sam.mckay?source=rss-56862a96358c------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 00:50:25 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@sam.mckay/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Embracing the AI Revolution: Navigating Disruption and Opportunities in Data Analysis]]></title>
            <link>https://medium.com/@sam.mckay/embracing-the-ai-revolution-navigating-disruption-and-opportunities-in-data-analysis-7948e02a0eab?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/7948e02a0eab</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[ai]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Thu, 20 Jul 2023 08:00:10 GMT</pubDate>
            <atom:updated>2023-07-20T08:09:10.241Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1c_SQPa2TYuL8ysGZCcLGw.png" /><figcaption>Midjouney</figcaption></figure><p><em>This article was created out of content from the Analytic Mind podcast, hosted by Sam McKay, CEO of Enterprise DNA. You can listen to the podcast at the bottom of this post.</em></p><h4><strong>Introduction</strong></h4><p>In the dynamic world of technology, we are witnessing a paradigm shift that is transforming the way we understand and interact with data. This shift is driven by the rise of Artificial Intelligence (AI), a powerful tool that is reshaping the landscape of data analysis. This article will take us into the heart of the AI revolution, uncovering its challenges, seizing its opportunities, and understanding its implications for the future of data analysis.</p><h4><strong>The AI Revolution in Data Analysis</strong></h4><p>In the ever-evolving landscape of technology, we stand at the precipice of the next transformative wave: the AI revolution. This revolution is not a distant future concept but a present reality, fundamentally altering various sectors, including data analysis.</p><p>AI, at its core, is about creating machines that can think, learn, and make decisions like humans. But it’s not just about replicating human intelligence. It’s about augmenting our capabilities, taking us beyond what we could achieve alone.</p><blockquote>We are in a new era powered by AI, an era that is disrupting traditional paradigms and ushering in unprecedented possibilities.</blockquote><p>One of the most significant areas of impact is data analysis. In the past, data analysis was a labor-intensive process, requiring manual model building, formula creation, and a deep understanding of the data at hand. <strong>But AI is changing the game. It’s enabling us to analyze vast amounts of data quickly and accurately, uncovering insights that would have been very time consuming and resource intensive to find manually.</strong></p><p>But what does this mean for businesses and data professionals? It’s a call to adapt, to evolve, and to embrace the opportunities that this new era presents. It’s about recognizing that the old ways of doing things might not work in this new landscape. It’s about being open to new tools, new methodologies, and new ways of thinking.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RxFV0Ld-Y8B-alOf6MjOfA.png" /><figcaption>Midjourney</figcaption></figure><h4>Navigating the Challenges and Opportunities</h4><p>As we delve deeper into the AI revolution,<strong> it becomes increasingly clear that we are in an era of vast disruption.</strong> This disruption is not confined to a single sector but is permeating various areas such as content creation, customer acquisition, marketing, and sales.</p><p>In the realm of content creation, AI is transforming the way we generate and consume content. From AI-powered content curation tools that can generate articles and blog posts, to sophisticated algorithms that personalize content based on user behavior, AI is reshaping the content landscape. <strong>It’s enabling us to create more relevant, engaging, and personalized content,</strong> enhancing the user experience and driving engagement.</p><p>In the sphere of customer acquisition, AI is revolutionizing the way we understand and interact with our customers. With AI, we can analyze vast amounts of customer data, uncovering patterns and insights that can help us understand our customers better. This enables us to <strong>create more targeted marketing campaigns, improve customer service, and ultimately, acquire more customers.</strong></p><p>In the field of marketing and sales, AI is disrupting traditional practices. From predictive analytics that can forecast sales trends, to AI-powered chatbots that can handle customer inquiries,<strong> AI is already making marketing and sales more efficient and effective.</strong> It’s enabling us to reach our customers in new and innovative ways, driving sales and boosting business growth.</p><blockquote>This era of disruption is not without its challenges. It requires businesses and data professionals to adapt and evolve. It requires us to rethink our strategies, to embrace new tools and methodologies, and to be open to new ways of doing things. It’s about recognizing that in this era of disruption, the only constant is change.</blockquote><p><strong>Yet, amidst these challenges lie opportunities.</strong> Opportunities to innovate, to grow, and to transform. As we navigate this era of disruption, it’s these opportunities that we must seize.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*32bY06t4XqKG77XkzV1r8A.png" /><figcaption>Midjourney</figcaption></figure><h4>The Role of Data Professionals in the AI Era</h4><p>The rise of AI is significantly impacting the role of data professionals. As AI continues to transform data analysis, it necessitates a shift in the skills, tools, and methodologies employed by these professionals.</p><p>In the era of AI, data professionals are no longer just analysts; they are strategic partners in business decision-making.</p><blockquote>Their role has expanded to include understanding and interpreting AI outputs, integrating AI tools into their workflows, and leveraging these tools to generate insights that drive business growth.</blockquote><p>One of the key skills for data professionals in the AI era is the ability to work with AI, not against it. This involves understanding how AI works, how to interpret its results, and how to use it effectively in data analysis. It also involves staying up-to-date with the latest developments in AI and data analysis, as these fields are continuously evolving.</p><p>Moreover, data professionals need to be able to communicate the results of AI-powered data analysis effectively. <strong>They need to translate complex data insights into actionable recommendations that can inform business decisions.</strong> This requires not only technical skills but also strong communication and storytelling skills.</p><p>The rise of AI also presents significant opportunities for data professionals.</p><blockquote>It opens up new possibilities for insights, decision-making, and career growth.</blockquote><p><strong>It allows data professionals to leverage their skills in new and innovative ways, increasing their value and shaping the future of data analysis.</strong></p><p>In the face of these changes, the key to success for data professionals lies in <strong>embracing change, continuously learning and evolving, and seizing the opportunities</strong> that the AI era presents. As we move forward in our exploration of the AI revolution, we will delve deeper into how businesses and data professionals can navigate this new landscape, providing a comprehensive understanding of the AI revolution and its implications for the future of data analysis.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jJMgua_-Prku0khSxYnoAw.png" /><figcaption>Midjourney</figcaption></figure><h4>Embracing the Future of Data Analysis</h4><p>As we stand at the dawn of the AI revolution, the future of data analysis is bright. The possibilities are limitless, the opportunities are vast, and the potential for growth and transformation is immense. It’s an exciting time to be in the field of data analysis, and the journey is just beginning.</p><p>The advent of AI has created a new landscape for data analysis, one that is constantly evolving and full of opportunities. <strong>Navigating this landscape requires a strategic approach, a willingness to adapt, and a commitment to continuous learning.</strong></p><p>For businesses, navigating the AI landscape involves integrating AI into their operations and decision-making processes. This requires a deep understanding of AI and its capabilities, as well as the ability to adapt to the changes it brings. <strong>Businesses need to be open to new tools and methodologies, and willing to let go of outdated practices.</strong></p><blockquote>They also need to invest in training and development to ensure their teams have the necessary skills to work with AI.</blockquote><p>For data professionals, navigating the AI landscape involves expanding their skill set to include AI-related competencies. They need to understand how AI works, how to interpret its results, and how to use it effectively in their data analysis. They also need to stay up-to-date with the latest developments in AI and data analysis, as these fields are continuously evolving.</p><p>Moreover, navigating the AI landscape involves leveraging the opportunities it presents. AI’s ability to analyze vast amounts of data quickly and accurately opens up new possibilities for insights and decision-making. It allows businesses and data professionals to leverage their data in ways they never could before, driving innovation and competitive advantage.</p><h4>Conclusion</h4><p>As we conclude our exploration of the AI revolution, it’s clear that we are in the midst of a transformative era. The rise of AI is not just a passing trend, but a persistent shift that is reshaping the world of data analysis. It presents challenges, but also boundless opportunities for growth, innovation, and transformation. As we navigate this new landscape, the key to success lies in embracing change, seizing opportunities, and continuously learning and evolving. The future of data analysis is here, and it’s powered by AI. As we move forward, let’s embrace this future, harness the power of AI, and shape the future of data analysis.</p><p>You can listen the to the full Analytic Mind podcast episode here — <a href="https://open.spotify.com/episode/3kGyIPyRnrLeeieqhUzqc9?si=lnh9HTB4RJ6gecpqZA9-ig">https://open.spotify.com/episode/3kGyIPyRnrLeeieqhUzqc9?si=lnh9HTB4RJ6gecpqZA9-ig</a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J4WwtljDCDk6AngNJ6cWHA.jpeg" /><figcaption>Sam McKay, Midjournied!</figcaption></figure><h4>5 five key points from the article/podcast and corresponding action items:</h4><p><strong>1. Key Point: (AI) is transforming data analysis, ushering in a new era of rapid change and disruption.</strong></p><p>Action Item: Businesses and data professionals should stay informed about the latest developments in AI and understand how these changes could impact their work.</p><p><strong>2. Key Point: The challenges presented by this shift are significant, requiring a change in mindset and a willingness to learn.</strong></p><p>Action Item: Embrace a culture of continuous learning and adaptation. Invest in training and development to ensure teams have the necessary skills to work with AI.</p><p><strong>3. Key Point: AI presents opportunities for growth, innovation, and transformation.</strong></p><p>Action Item: Look for ways to leverage AI in your operations. This could involve integrating AI tools into your workflows or using AI-powered data analysis to inform decision-making.</p><p><strong>4. Key Point: AI has the potential to revolutionize data analysis, providing insights and visualizations without the need for manual model building or formula creation.</strong></p><p>Action Item: Data professionals should expand their skill set to include AI-related competencies. This could involve learning how to work with AI, how to interpret its results, and how to use it effectively in data analysis.</p><p><strong>5. Key Point: The future of data analysis is here, and it’s powered by AI.</strong></p><p>Action Item: Embrace AI as a part of your data analysis strategy. This could involve investing in AI tools, integrating AI into your decision-making processes, or using AI to enhance your data analysis capabilities.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7948e02a0eab" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI Challenge 16 — Consultancy Time and Earnings Analysis]]></title>
            <link>https://medium.com/@sam.mckay/power-bi-challenge-16-consultancy-time-and-earnings-analysis-2b7e7f1cbd9e?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/2b7e7f1cbd9e</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[dashboard]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Mon, 27 Sep 2021 00:50:06 GMT</pubDate>
            <atom:updated>2021-09-27T00:50:06.286Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power BI Challenge 16 — Consultancy Time and Earnings Analysis</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*2qkNN-AZGMVkWAI3.png" /></figure><p>We saw so many amazing submissions on the <a href="https://blog.enterprisedna.co/power-bi-challenge-15-formula-1-analysis"><strong>15th round of our Power BI Challenges</strong></a>, so we’re excited to see what everyone’s going to show us as we start the 16th round.</p><p>Previously, we did a challenge about Formula 1 Analysis. This time, let’s see how we can use Power BI for something that every business, consultant or organization needs — timesheet utilization.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*C5W98XG-sjsefNOo.jpeg" /></figure><p>The jump from F1 races to timesheet utilization only proves further one thing we already know for a fact — that Power BI is such a dynamic tool, you can use it for just about anything.</p><h3>Challenge #16</h3><p>When you’re working or running a business, you don’t want any minute wasted. You want every second to count. You’ll ask questions like, “How productive am I being?” or “Where do I spend the most time in?”</p><p>Those are the kind of questions we’re going to answer in this challenge.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*xhuDgmthwWSK7Slr.png" /></figure><p>Because Haroon doesn’t want anyone to start from scratch, he’s providing a .pbix file that already contains existing data. This file would be a great resource in planning your own submission before diving into report development.</p><p>Haroon also provided these two other sources that could help participants maximize their reports.</p><p><a href="https://www.metric.ai/metricopedia/utilization">https://www.metric.ai/metricopedia/utilization</a><a href="https://www.smartsheet.com/content/what-is-utilization-rate-formula">https://www.smartsheet.com/content/what-is-utilization-rate-formula</a></p><p>The deadline for submission is on <strong>October 3</strong>.</p><h3>The Power BI Challenge</h3><p>The Power BI Challenge has stirred some friendly competition in the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a>, but what made it all even more fun is the fact that as the challenges progress, we also saw more and more non-members sending their entries as well.</p><p>But more than the number of participants increasing, we’re also seeing amazing improvement among the participants. Our returning participants always come up with better and stronger submissions than their last, proving that this truly is a great learning opportunity.</p><p>The prizes that winners get also add so much value to joining these challenges, especially for first-time participants.</p><p><strong>Winning Enterprise DNA members</strong> get a free membership that can be passed on to a non-member who will benefit from the member-exclusive resources. The <strong>top 3 non-member winners</strong>, on the other hand, get1-year complimentary memberships.</p><p>As for first-time participant winners, they get to choose one prize from this list:</p><ol><li>A copy of the Definitive Guide to DAX, 2nd Edition (what we consider to be our “DAX bible”) or any book in the <a href="https://forum.enterprisedna.co/t/power-bi-book-recommendations/6095"><strong>EDNA Forum Recommended List</strong></a></li><li>A copy of <a href="https://www.techsmith.com/screen-capture.html"><strong>SnagIt 2020</strong></a>, a must-have capture and graphics tool that a lot of our <a href="https://enterprisedna.co/enterprise-dna-experts/"><strong>Enterprise DNA experts</strong></a> use</li><li>A four-month subscription to <a href="http://flaticon.com/"><strong>FlatIcon.com</strong></a>, an online source for downloadable and editable icons that can make your Power BI reports stand out</li></ol><p>All submissions also become part of our <a href="https://portal.enterprisedna.co/courses/enrolled/305961"><strong>Power BI Challenge Showcase</strong></a>. Not only do these downloadable reports serve as great tools for Enterprise DNA members for hands-on practice, it’s also a great avenue for participants to have their work showcased.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*aBZO9sgnj3XeV1hm.png" /></figure><p>If you want to go all out and go for the win, just focus on these 4 pillars of a great Power BI report:</p><ul><li>Data loading and transformation</li><li>Data modeling</li><li>DAX calculations</li><li>Reports and visualizations</li></ul><p>These are the factors we consider in judging who wins.</p><h3>How To Join</h3><p>Here’s how to join the challenge.</p><ol><li>Download the data set from the <a href="https://forum.enterprisedna.co/uploads/short-url/vKKKHJQ8Fm20WDBfueoNLkNMDgp.zip"><strong>forum</strong></a>.</li><li>Post the screenshot of your report and explanation in LinkedIn along with the name of the challenge (e.g. Power BI Challenge 16 — Timesheet Utilization Reporting)</li><li>Include this in your post: I accepted the #EnterpriseDNAPowerBIChallenge and hyperlink the challenge post from the Forum.</li><li>Submit your PBIX files to <a href="/service/mailto:powerbichallenge@enterprisedna.co"><strong>powerbichallenge@enterprisedna.co</strong></a></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*Q-qZPQ0QYK3GGsmS.png" /></figure><p>We can’t wait to see the amazing reports you guys will be submitting for this round!</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2b7e7f1cbd9e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Enterprise DNA Updates For August — New Courses, Showcases And More]]></title>
            <link>https://medium.com/@sam.mckay/enterprise-dna-updates-for-august-new-courses-showcases-and-more-4b01a3455dc?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/4b01a3455dc</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Thu, 16 Sep 2021 04:15:18 GMT</pubDate>
            <atom:updated>2021-09-16T04:15:18.863Z</atom:updated>
            <content:encoded><![CDATA[<h3>Enterprise DNA Updates For August — New Courses, Showcases And More</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*wcGoCLd9btyoimrE.png" /></figure><p>No one here at Enterprise DNA slowed down in August, as we continued to deliver new stuff that we know would be of high value to everyone in our community. In fact, we continue to expand our reach and bring more people into our circle, and we continue to see everyone improving day by day as we all learn the ins and outs of Power BI and other amazing data tools. Here’s a look at some Enterprise DNA updates for the month of August.</p><h3>Power BI Deployment Course</h3><p>We started August launching a new course, <a href="https://portal.enterprisedna.co/p/power-bi-deployment-strategy-planning-and-governance"><strong>Power BI Deployment Strategy, Planning &amp; Governance course</strong></a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*LqJ6l4fiorWaIy2O.png" /></figure><p>We all know how powerful Power BI is as a business intelligence tool. But without the proper deployment, you won’t be able to maximize everything that it has to offer. A successful deployment requires careful planning and execution, which is exactly what this course discusses.</p><p>The course is facilitated by none other than our founder, Sam McKay. Here, he shares his best strategies on how deployment should be done. It has 6 hours’ worth of on-demand video tutorials and resources that could help you perform a successful deployment.</p><p>This is perfect for beginners who are figuring out a way to make their use of Power BI more seamless, as well as for more advanced users who want to pick up a tip or two from Sam’s best practices.</p><h3>Power BI Challenge 15 — Formula 1 Analysis</h3><p>If you’ve been following our Power BI Challenges, you’ll know that we’ve always strived to focus on a different topic or industry every time.</p><p>At the start of the year, we took things to a different level by focusing on something that’s happening real-time — <a href="https://forum.enterprisedna.co/t/power-bi-challenge-11-covid-19-reporting/13479"><strong>the Covid-19 pandemic</strong></a>. Last August, we decided to once again feature something that was happening right as we launched the challenge — the Formula 1 races!</p><p><a href="https://forum.enterprisedna.co/t/power-bi-challenge-15-formula-1-analysis/18887"><strong>The challenge</strong></a> required a one-page report that dives into the data from the Formula 1 races, past and present. We <a href="https://forum.enterprisedna.co/t/power-bi-challenge-15-wrap-up/19572"><strong>wrapped up this challenge</strong></a> at the start of September, with @Gustaw emerging as the challenge winner.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*VbLf6fJu3xrXkhpr.jpeg" /></figure><p>There was also an excellent entry from @JBocher, who won the newcomer prize.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*e2nMBzZfXgUftWum.jpeg" /></figure><p>Both winning entries, as well as a number of other notable submissions displayed that perfect balance between in-depth insights and creative visualizations. With entries as amazing as these, we can’t wait to see what kind of entries we’re going to see in the next challenge.</p><p>Check out this video that highlights some of these reports.</p><p><a href="https://youtu.be/7D9M8YcEN1g">https://youtu.be/7D9M8YcEN1g</a></p><h3>Power BI Accelerator 3 And 4</h3><p>We launched the <a href="https://blog.enterprisedna.co/power-bi-accelerator-an-expert-guided-practice-for-power-bi-beginners"><strong>Power BI Accelerator</strong></a> as a form of hands-on practice for beginners who want to take their Power BI skills further. We’d like to believe that we’re successfully doing this, seeing that a lot of our Accelerator participants have also taken the jump and joined the Power BI Challenges for the first time as well!</p><p>This only shows how confident they’ve become with their work and how the Accelerator, along with theEnterprise DNA training series called Ultimate Beginner’s Guide, have helped them maximize Power BI as a data analysis and reporting tool.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*LIeCOXJDds0JU_47" /></figure><p>The 3rd Accelerator problem focused on how to change context in DAX measures using CALCULATE, ALL, ALLSELECTED, ALLEXCEPT and REMOVEFILTERS. As for Accelerator #4, Brian Julius, our Chief Content Manager and one of our Power BI Experts, decided to ask participants to reconstruct this report:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*5GPLZAFlQNHvH8bB.png" /></figure><p>This was a great way for them to practice putting together an entire report using the dataset provided.</p><p>With both Accelerator legs wrapped up, we’re looking forward to seeing the participants further enhance their skills and start taking on bigger challenges through our other initiatives.</p><h3>Additional Emergency Services Analysis Showcases</h3><p>In July, we added a batch of reports about Emergency Services Analytics to the <a href="https://enterprisedna.co/power-bi-showcase"><strong>Power BI Showcase</strong></a>. In August, we decided to add a few more reports about the same topic, knowing how critical emergency services has become since the pandemic started.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*J5edboyEXoAazv1g.png" /></figure><p>The Power BI Showcase is a collection of downloadable reports and dashboards that can be used for some hands-on practice and to get some best practices on report development. These reports also show a lot of creative elements, which can be great as a source of inspiration when it comes to the design aspect of building Power BI reports.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*UENAwfnvv6DzFZvZ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*Nb6E_nAWlWPQB7JD.jpeg" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*vyDiAlbYJL5OY_VM.jpeg" /></figure><p>Jump on over to the <a href="https://portal.enterprisedna.co/courses/enrolled/305961"><strong>Power BI Showcase</strong></a> and see how each of the pages in these reports deliver amazing insights using the sample data given.</p><h3>August Power BI Events</h3><p>We kicked off our August events with a live training workshop called <a href="https://enterprisedna.co/implementation-best-practices-for-power-bi-august-2021-registration/"><strong>Implementation Best Practices For Power BI</strong></a>, which was held on August 6. Facilitated by Sam, it talked about these key areas:</p><ul><li>Best practices in establishing relationships</li><li>Advanced techniques in the use of DAX</li><li>Best practices in transforming data using the Query Editor</li></ul><p>We also concluded the 2-day <a href="https://enterprisedna.co/business-analytics-week-august-2021-registration/"><strong>Business Analytics Week</strong></a>, which was held in August 26 and 27. Session 1 covered the basics of using Power BI for business analytics, while Session 2 took participants through a deep dive into some business insights.</p><h3>New COE And Membership Portal</h3><p>Enterprise DNA continues to empower more and more people to access, analyze, and report data through our membership program and the Center of Excellence. To make it easier for members to access the materials, resources, tools, and other perks that come with their subscription, we’ve given the <a href="https://membership.enterprisedna.co/"><strong>Membership Portal</strong></a> and the <a href="https://coe.enterprisedna.co/"><strong>COE Portal</strong></a> a new look, making every valuable piece of information more accessible than before.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6M84iu5us3idEUx_.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-mbP4jbCcBo9GBMh.png" /></figure><p>The <a href="https://enterprisedna.co/membership"><strong>Enterprise DNA membership</strong></a> is perfect for individuals who want to learn how to gain more insights on their data and present it in the most efficient way possible. As for the <a href="https://enterprisedna.co/center-of-excellence"><strong>Center of Excellence</strong></a>, this is meant for teams and departments that aim to streamline their processes and apply a more cohesive approach when dealing with data.</p><p>Aside from the more modern transformation, both portals now carry the newly introduced functional and industry labs.</p><h3>Functional And Industry Labs</h3><p>The functional and industry labs can be accessed through the membership and COE portals.</p><p>The <a href="https://portal.enterprisedna.co/courses/category/Functional%20Lab"><strong>functional lab </strong></a>focuses on delivering analytical techniques using data that are relevant to specific business functions, such as logistics or customer service.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*5h1mKFxg7OXZY0ul.png" /></figure><p>As for the industry lab, this targets insights that are specific to an industry, like mining or insurance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*inpAwqmkkC9YBofg.png" /></figure><p>This has been quite a list of Enterprise DNA updates from August, but you all know that there’s even more in store for the coming months.</p><p>We’re excited to see you all taking advantage of these resources, especially as members of Enterprise DNA. We also hope you’ll participate in our initiatives, as we have created these specifically to help you develop your Power BI skills in ways you can’t even begin to imagine.</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4b01a3455dc" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Enterprise DNA Updates For June And What To Look Forward To In July]]></title>
            <link>https://medium.com/@sam.mckay/enterprise-dna-updates-for-june-and-what-to-look-forward-to-in-july-c00c3fa720d3?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/c00c3fa720d3</guid>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[power-bi-tutorials]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Thu, 08 Jul 2021 03:43:12 GMT</pubDate>
            <atom:updated>2021-07-08T03:43:12.862Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*64yeOu1mFIJ98P3j" /></figure><p>As we say goodbye to the first half of the year, we’re amazed at how much we’ve accomplished so far. We stayed true to our commitment of releasing courses month over month and there were a lot of Enterprise DNA updates that involved resources, events, and challenges that allowed both members and non-members to enhance their Power BI skills even further.</p><p>We’re also excited to see what else is in store for our entire community as we usher in the year’s 2nd half. For sure, we’re going to continue the education and collaborative opportunities that we’ve always committed to providing.</p><p>Here’s a look back at what happened here at Enterprise DNA in June and a peek at what to expect for July.</p><h3>Launch of New Course: Power Query / M Masterclass</h3><p>We ended June with a bang through this most anticipated <a href="https://portal.enterprisedna.co/p/power-query-m"><strong>course about Power Query and M Codes</strong></a>. This masterclass is facilitated by <a href="https://enterprisedna.co/enterprise-dna-experts/"><strong>Enterprise DNA Expert</strong></a> Melissa de Korte, a genius when it comes to this topic as witnessed by our active forum participants.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/705/0*1q1TfwZBYuEzzLDI" /></figure><p>This is the 1st in a many-part series. Both beginners and advanced Power BI users can learn a lot from this course, especially when it comes to Power Query Editor, M data types and operators, using the “let” expression, and selection and projection.</p><p>Beginners can gain best practices that they can apply to their own report development process, while advanced users can learn how to maximize custom functions for their reports and dashboards.</p><h3>Power Platform Course</h3><p>The <a href="https://powerplatform.microsoft.com/en-us/"><strong>Microsoft Power Platform</strong></a> is a collective term used for three products that make data more accessible for every kind of user — Power BI, Power Apps, and Power Automate. Here at Enterprise DNA, we have an endless amount of content geared towards helping both members and non-members level up their game when it comes to Power BI. But now, we want to take that further by bringing all three of these powerful tools together so that users can take on data from every possible perspective.</p><p>That’s where our <a href="https://portal.enterprisedna.co/courses/enrolled/1437736"><strong>Power Platform course</strong></a> comes in.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/705/0*EDETzVwY8Qsgi9RS" /></figure><p>The Power Platform course contains materials that will teach you how to maximize the use of the Power Platform tools to enhance the way you present and interpret data. It includes tutorials on how to use Power Apps and Power Automate, how to create custom apps, how to refresh Power BI data through Power Automate, and more.</p><h3>Three New Showcases On Documentation</h3><p>The <a href="http://enterprisedna.co/power-bi-showcase(opens%20in%20a%20new%20tab)"><strong>Power BI Showcase</strong></a> features downloadable reports and dashboards that members can use as an educational tool or for hands-on practice. It’s a great way to see how Power BI can be used across various applications.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*iFGsK6xcuPejkiP0" /></figure><p>One such application would be creating documentation. Knowing how to prepare detailed documentation is just as important as creating insightful reports. That’s why we’ve added three new showcases about the topic.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*zlVEfI7HLGWCGOLI" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*oj5EBKGRSCyZQBze" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MNJZsiA3lmFv2gv1" /></figure><p>These showcases can also serve as inspiration for those who are struggling to put together their own reports. By downloading these PBIX files, you can piece together how these reports were built and what elements were used.</p><p>These reports are some of the best submissions in the previously concluded <a href="https://forum.enterprisedna.co/t/challenge-13-acing-documentation/16361"><strong>13th round of the Power BI Challenge</strong></a>.</p><h3>Power BI Challenge 14: Emergency Services Analytics</h3><p>If there’s one thing we love about the Power BI community, it’s the collaborative spirit that can be seen especially in the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a>. To make things more interesting, we added a little fun competition into the mix in the form of the <a href="https://forum.enterprisedna.co/c/power-bi-challenges/44"><strong>Power BI Challenges</strong></a>. And since we first introduced these challenges last year, we’ve seen a new breed of skill and talent emerge not just from the Enterprise DNA community, but from other Power BI communities as well.</p><p>We launched the 14th round in June, and this time, it’s all about Emergency Services Analytics.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*zFEzmkAdeVL61c68" /></figure><p>This has been another great way to show how dynamic Power BI really is. From the 1st challenge up to now, it’s amazing how we’ve covered different industries and applications. With a few more days to go before the deadline, we can’t wait to see the amazing submissions that participants will turn in for this round.</p><h3>Power BI Accelerator</h3><p>When it comes to the learning process, resource materials can only get you to a certain point in your development. The best way to learn the ins and outs of Power BI would still be through hands-on experience. That’s why we introduced the <a href="https://forum.enterprisedna.co/t/announcing-a-new-enterprise-dna-initiative-power-bi-accelerator/17776/12"><strong>Power BI Accelerator</strong></a>, a problem-solving exercise built for Power BI beginners.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*htShelGUtr980FwL" /></figure><p>The Enterprise DNA Education Platform was built to helps beginners start from the basics and progress based on the learning path they think is best for the path they want to take. But ideally, they all start at the same point — the <a href="https://portal.enterprisedna.co/courses/enrolled/157239"><strong>Ultimate Beginners Guide to Power BI</strong></a>.</p><p>The problems given in the <a href="https://blog.enterprisedna.co/power-bi-accelerator-an-expert-guided-practice-for-power-bi-beginners/"><strong>Power BI Accelerator</strong></a> works parallel to the Beginners Guide. Basically, it gives actual hands-on practice that can help beginners master each step of the process. The problems are also designed to be short and sweet, with each problem only requiring an hour or less to be completed.</p><p>Each problem will run for two weeks, after which a live teaching session and<a href="https://enterprisedna.co/power-bi-accelerator-week-1-member-only-july-2021-registration/"><strong> Q&amp;A with our Enterprise DNA experts</strong></a> will be done so that participants can check whether their solution is correct or not. These teaching sessions will be available for all our members.</p><h3>June Events: Business Analytics Week, Power BI Mastermind, And More</h3><p>June was a great month especially for our members because of the amazing mix of events that happened in Enterprise DNA.</p><p>First, we had the <a href="https://enterprisedna.co/power-bi-mastermind-with-sam-mckay-greg-philps/"><strong>Power BI Mastermind</strong></a> with our founder, Sam McKay and Greg Philps, one of our Enterprise DNA Experts. In this class, they talked about how Greg built his report about service desk issues and shared best practices that other Power BI users can replicate in their report development process.</p><p>We also had a live training workshop called <a href="https://enterprisedna.co/getting-started-with-powerapps-june-2021-registration/"><strong>Getting Started With PowerApps</strong></a> where participants were showed how to incorporate the Power Apps into their Power BI dashboard, which apps can improve productivity, and what limited transformations can be done through the power query editor.</p><p>Then, we spent two days on the Business Analytics Week. The 1st session covered how to discover unique and valuable insights, how to get advanced analytics using DAX, how to identify patterns and outliers, and how to understand deviations for the usual analysis. The 2nd session was about Power Apps and Power Automate, connecting operations between applications, creating complex workflows, and streamlining common business practices.</p><h3>What To Look Forward To In July</h3><p>As we usher in the 2nd half of the year, we’ve got exciting events for both members and non-members.</p><p>We’re concluding the 1st round of the Power BI Accelerator in July 8th through a member-exclusive solution walkthrough and <a href="https://enterprisedna.co/power-bi-accelerator-week-1-member-only-july-2021-registration/"><strong>Q&amp;A session</strong></a>. We’re also having a class called <a href="https://enterprisedna.co/data-model-development-best-practices-in-power-bi-july-2021-registration/"><strong>Data Model Development: Best Practices In Power BI</strong></a> on July 9, which is open to everyone. Then, we’ll be having another <a href="https://enterprisedna.co/power-bi-mastermind-with-sam-mckay-diana-bello"><strong>Power BI Mastermind, this time with Sam McKay and Diana Bello</strong></a>. This will be a member-only event on July 16th.</p><p>Expect some news about a new functional lab, industry lab, and Enterprise app build sessions with our very own Sam McKay on the <a href="https://www.youtube.com/channel/UCy2rBgj4M1tzK-urTZ28zcA"><strong>Enterprise DNA YouTube Channel</strong></a>.</p><p>We’re also expanding our reach and allowing even more people to benefit from our expertise as we introduce Enterprise DNA Courses on Udemy.</p><p>Stay tuned to the <a href="https://blog.enterprisedna.co/"><strong>Enterprise DNA Blog</strong></a> and stay connected to our community at the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a> for more Enterprise DNA updates and announcements.</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c00c3fa720d3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI Challenge 14 — Emergency Services Analytics]]></title>
            <link>https://medium.com/@sam.mckay/power-bi-challenge-14-emergency-services-analytics-dfd74f746a1f?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/dfd74f746a1f</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-challenge]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Wed, 07 Jul 2021 00:55:02 GMT</pubDate>
            <atom:updated>2021-07-07T00:55:02.207Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power BI Challenge 14 — Emergency Services Analytics</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jicWJggotBhwkH02" /></figure><p>We’ve been very busy here at Enterprise DNA as we continue to level up our content so that all of you can maximize more learning opportunities as far as Power BI is concerned. Of course, one of the best ways for you to put all of this knowledge to practice is by joining our <a href="https://forum.enterprisedna.co/c/power-bi-challenges/44"><strong>Power BI Challenge</strong></a>.</p><p>We just concluded the 13th round, which was all about acing report documentation. This time, we’re moving on to emergency services analytics.</p><h3>Challenge #14</h3><p>Power BI has seen quite a number of updates in the past few months, and we’re excited to see how these improvements can impact the tool’s real-world application. That’s why for this challenge, we looked into one of the most dynamic and in-demand industries, which is emergency services.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MMLGM-SV5KRZu81h" /></figure><p>To help you come up with deeper analytics, we’ve also put together a few things that you should consider in your report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/480/0*AJSqxVY0tPOCojpy" /></figure><p><strong>Deadline for submission is on July 11.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*M6lHRvYxC6OamOjG" /></figure><h3>The Power BI Challenge</h3><p>The Power BI Challenge is an initiative that we started last year not just to add some fun, friendly competition around the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a>, but also to explore just how endless the possibilities are when it comes to using Power BI as a tool. Seeing that this is the 14th round and that we’ve managed to present unique real-life scenarios that cover a different industry each time, this certainly proves how dynamic Power BI truly is.</p><p>The challenges have fostered a culture of collaboration and sharing throughout the community. We started out with active members of our Enterprise DNA Forum participating, but we have since been seeing non-members jumping in as well.</p><p>It has truly been inspiring seeing a lot of beginners plucking up the courage to join their first challenge and then seeing their submissions improving until they submit reports that rival that of our experts by their 3rd or 4th round. This is why we continue to encourage those who have been thinking twice about joining just because they feel they lack the experience to do so. There’s no better learning experience than hands-on application.</p><p>Winners get a range of different prizes, especially for first-time participants.</p><ul><li><strong>Winning Enterprise DNA Member</strong> — free membership that can be passed on to a non-member who will benefit from the member-exclusive resources</li><li><strong>Winning Non-Enterprise DNA Member </strong>— free membership</li><li><strong>Most Innovative Entry</strong> — open to both members and non-members; overall winner can also claim this title, with a free membership as the prize</li><li><strong>First Time Participant Winner</strong> — must be a member to qualify; winners get to choose their prize from <a href="https://forum.enterprisedna.co/t/newcomer-prize-for-data-challenge-5/9500"><strong>this list</strong></a> of tools and resources that can help them further improve their reports and dashboards</li></ul><p>All submissions also become part of our <a href="https://portal.enterprisedna.co/p/power-bi-challenge-submission/?preview=logged_out"><strong>Power BI Challenge Showcase</strong></a>, where Enterprise DNA members can download and use them for some hands-on practice.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*7favpgwCSFXV45Kw" /></figure><p>How do we judge who wins? We just stick to the 4 pillars that make a great Power BI report:</p><ul><li>Data loading and transformation</li><li>Data modeling</li><li>DAX calculations</li><li>Reports and visualizations</li></ul><p>So keep these in mind when you work on your submission. Staying true to these four elements can help you snag those prizes.</p><h3>How To Join</h3><p>Here’s how you can join the challenge.</p><ol><li>Download the data set from the <a href="https://forum.enterprisedna.co/t/challenge-14-emergency-services-analytics/17933"><strong>forum</strong></a>.</li><li><strong>Post the screenshot of your report and explanation in LinkedIn</strong> along with the name of the challenge (e.g. Power BI Challenge 14 — Emergency Services Analytics)</li><li>Include this in the post: I accepted the #EnterpriseDNAPowerBIChallenge and hyperlink the challenge post from the Forum.</li><li>Submit your PBIX files to <a href="/service/mailto:powerbichallenge@enterprisedna.co"><strong>powerbichallenge@enterprisedna.co</strong></a></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*vlkMfT8iFQr28x-i" /></figure><p>We’re looking forward to seeing the amazing reports you come up with!</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dfd74f746a1f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Enterprise DNA April Updates: New Course, Showcases and More]]></title>
            <link>https://medium.com/@sam.mckay/enterprise-dna-april-updates-new-course-showcases-and-more-87fc4a14b35?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/87fc4a14b35</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Fri, 14 May 2021 04:25:44 GMT</pubDate>
            <atom:updated>2021-05-14T04:25:44.827Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ffMdNqChoLaacGLu" /></figure><p>One thing that we love about the Enterprise DNA community is the fact that everyone has this unending thirst for knowledge. That’s why we’ve made it our mission to keep finding new ways to help everyone collaborate, educate and learn. The amazing things we did here at Enterprise DNA in April is clear proof of that.</p><p>Here are some of the highlights for the month of April.</p><h3>Advanced Visualization Techniques Parts 1 and 2</h3><p>Visualization is one of the four pillars that contribute to an effective report for a good reason; it has a huge impact on how audiences understand and interact with the data and insights presented.</p><p>This makes the two-part course called Advanced Visualization Techniques a critical part in creating and mastering your own report development process. <a href="https://portal.enterprisedna.co/courses/enrolled/1343263"><strong>Part 1</strong></a> focuses on how to create great visuals without advanced DAX skills, while <a href="https://portal.enterprisedna.co/courses/enrolled/1343267"><strong>Part 2</strong></a> zeroes in on the custom visuals that can be created with Charticulator.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/694/0*2oKxJlB-EhpTznFU" /></figure><p>The course was created and presented by Mudassir Ali, an <a href="https://enterprisedna.co/enterprise-dna-experts/"><strong>Enterprise DNA expert</strong></a> with a strong background in Management Accounting. If you’ve been following our <a href="https://forum.enterprisedna.co/c/power-bi-challenges/44"><strong>Power BI Challenges</strong></a>, his reports would probably be familiar to you. He has created some of the most creative submissions and has won three challenges in the past.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1008/0*2mslEyOy05O-XXQf" /></figure><p>One of the biggest takeaways from these two courses is the fact that there are skills to learn and tools to maximize that would allow you to create beautiful reports despite not having a creative background and advanced DAX skills. It is a common misconception that only artists can come up with creative designs, a myth that Mudassir busts.</p><p>The course can be paid for on its own, but for those who really want value, it’s much better to sign up for an <a href="https://enterprisedna.co/membership"><strong>Enterprise DNA membership</strong></a> and get access not just to this course, but to all other courses with the <a href="https://portal.enterprisedna.co/"><strong>Enterprise DNA Learning Center</strong></a>. There are new courses and resources launched every month, all geared towards helping Power BI users master the skills they need the most.</p><h3>Problem of the Week on Enterprise DNA in April</h3><p>The <a href="https://forum.enterprisedna.co/t/problem-of-the-week-10-dealing-with-time-periods/16072"><strong>10th Problem of the Week</strong></a> was launched and concluded in April through the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a>. This time, the DAX-only problem was about dealing with time periods.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*zAMnL6ILX36y0d9e" /></figure><p>Basically, the challenge requires calculating the number of customers between a specific time period while also defining the start time and end time for the said period. This is a great topic to cover because time is one of the elements that could cause issues in any report.</p><p>The great thing about this problem is that it focuses more on the technical side of things. It’s a practical problem that anybody will encounter no matter what industry they’re from, so picking up the right technique to use will definitely have long-term value.</p><p>Watch Haroon’s explanation and solution in this video.</p><p><a href="https://youtu.be/ZCpoW757ZHg">https://youtu.be/ZCpoW757ZHg</a></p><p>The <a href="https://forum.enterprisedna.co/c/problem-of-the-week/51"><strong>Problem of the Week</strong></a> series is launched every 2 weeks, with each problem requiring either a DAX-only or a Power Query-only solution.</p><h3>Enterprise DNA April Events</h3><p>April was just brimming with <a href="https://enterprisedna.co/enterprise-dna-events-page/"><strong>great events</strong></a> meant for both members and non-members of Enterprise DNA.</p><p>Our founder, Sam McKay, facilitated a live workshop called <a href="https://enterprisedna.co/advanced-dax-concepts-april-2021-registration/"><strong>Advanced DAX Concepts</strong></a> for members and non-members last April 2.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*bMY5IDhWoKMotJWv" /></figure><p>The workshop was helpful for analysts, database professionals, Excel users, and data enthusiasts as it talked about cumulative totals, measure branching, and dynamic grouping using DAX. Members are still able to access the replay through their membership portal.</p><p>We also had the <a href="https://enterprisedna.co/power-bi-mastermind-with-sam-mckay-melissa-dekorte/"><strong>Power BI Mastermind</strong></a>, an exclusive members-only event facilitated by Sam McKay and Melissa de Korte. Here, Melissa shares best practices and tips on how she builder her reports. One of our experts, Melissa is skilled in ETL and modeling and is one of the best when it comes to Power Query solutions in Power BI and Excel.</p><p>The <a href="https://enterprisedna.co/power-bi-dax-master-class-april-2021-registration"><strong>Power BI &amp; DAX Master Class</strong></a> was also concluded in April. It covered the 4 key pillars of Power BI development, the fundamentals of DAX, DAX formula combinations, and advanced analytics using Power BI.</p><p>The <a href="https://enterprisedna.co/analyst-hub-best-practices-live-webinar-april-2021-registration/"><strong>Analyst Hub Best Practices</strong></a> was another valuable webinar concluded in April. It’s a great class to watch for those who want to supercharge the Power BI development strategies, especially since we’ve been seeing a lot of new useful tools within the <a href="https://enterprisedna.co/analyst-hub-home/"><strong>Analyst Hub</strong></a> in the past few months.</p><p>The live training workshop entitled <a href="https://enterprisedna.co/high-level-analytics-wpower-bi-april-2021-registration/"><strong>High Level Analytics with Power BI</strong></a> closed off our April events. This workshop helped the participants analyze their data in a more comprehensive manner, optimize their techniques in interpreting patterns and trends, and combine high level analysis with the power of the data model.</p><h3>Three New Power BI Showcases on Purchase, Sales, Inventory Trends and More</h3><p>The Power BI Showcase is a great resource for Power BI users. It features reports and dashboards that can be downloaded and used for real hands-on experience, with each showcase focusing on a unique industry and purpose.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*PMK3WsI5fRPrd1zg" /></figure><p>Three showcases were added to the collection in April. These were among the best submissions on the Power BI Challenge, which is done every 2 to 3 weeks. One is about purchases, sales and inventory trends, the second is a purchases summary report, and the third is a Covid-19 global report.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*3G_3D77natoaQmWn" /></figure><p>The great thing about these showcases is that they show how dynamic Power BI really is. And for Enterprise DNA members who have access to these showcases, the downloaded files can help them figure out how each of these reports were built from the ground up. This could help them create their own development process as well, especially if their field of expertise relates closely to the report highlighted.</p><h3>Introducing the Hub Chat</h3><p>The <a href="https://enterprisedna.co/analyst-hub-home/"><strong>Analyst Hub </strong></a>is the ultimate productivity and collaboration tool for Power BI users. This web-based application contains apps that help make report development a more seamless and effective process. It also allows teams to work together more efficiently.</p><p>An ongoing project that we’ve been working on over the past year, we continue to add new elements that will make the Hub even more powerful. The latest addition, the Hub Chat, makes communication even clearer and more efficient.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/712/0*mqM2RpHNfWa2fmCR" /></figure><p>Aside from the Enterprise DNA Forum, this is one of the best places to be connected to the entire community and get real time answers to your questions. Even our experts are active in the chat, so you’ll know that there’s always someone willing to help with any concern.</p><p>Stay tuned to the <a href="https://blog.enterprisedna.co/"><strong>Enterprise DNA Blog</strong></a> and stay connected to our community at the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a> for more updates and announcements.</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=87fc4a14b35" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Enterprise DNA March Updates: Analyst Hub, Membership Portals, New Course, Events, and More]]></title>
            <link>https://medium.com/@sam.mckay/enterprise-dna-march-updates-analyst-hub-membership-portals-new-course-events-and-more-696853ccfba1?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/696853ccfba1</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[power-bi-tutorials]]></category>
            <category><![CDATA[power-bi-training]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Fri, 09 Apr 2021 08:20:55 GMT</pubDate>
            <atom:updated>2021-04-09T08:20:55.162Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*RrEK_5z2Y1cujiUt" /></figure><p>We had an amazingly productive month here at Enterprise DNA in March with new courses and amazing events. As you all know, we continue to find more ways to help the members of our community grow in their respective fields through the use of Power BI.</p><p>Here are some of the highlights for the month of March.</p><h3>New Course: Geospatial Analysis in Power BI</h3><p>We launched a new course called <a href="https://blog.enterprisedna.co/geospatial-analysis-new-course-on-enterprise-dna/"><strong>Geospatial Analysis in Power BI</strong></a>, which was created by Paul Lucassen, one of our Enterprise DNA experts. We definitely consider this as an exciting addition to our education platform, especially since geospatial analysis is one of the gaps that we’re seeing in our offerings. A lot of members have been requesting for a course like this for quite some time now, and we’re honored to have an expert with us who specializes in the field.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/705/0*VDoHbm6cDFyiewXF" /></figure><p>Paul Lucassen, founder of Lucassen Consulting, is known as a global expert on locational intelligence, supply chain analysis, and transportation and logistics. As one of the very few people who specialize in this area, he does admit that there are quite a few challenges in using Power BI for this purpose. But he has found techniques to make it possible, something that could be helpful for those who want to apply their skills in the field.</p><p>The great thing about Paul’s course is that the concepts discussed here can also be used for other applications. Plus, the course comes with PBIX files that can be downloaded and analyzed further.</p><h3>Power BI Challenge 12 and 8th Problem of the Week</h3><p>To continue our practice of encouraging collaboration and having that fun competitive spirit, we conducted the 12th Power BI Challenge and had the 8th Problem of the Week in March.</p><p><a href="https://forum.enterprisedna.co/t/power-bi-challenge-12-transport-shipping-data/14846"><strong>Power BI Challenge 12</strong></a> is all about transport and shipping data, and so far, we’re seeing quite a good number of people who submitted amazing entries for this challenge. The deadline was last March 28, so we’re excited to see who managed to grab the prizes.</p><p>We also decided that experts will no longer have the ability to win the Power BI Challenges. Instead, they will be part of a different category.</p><p>We also made a few changes to the challenge prizes. We have a sponsor (who would rather remain anonymous) who kindly volunteered to add a few prizes aside from the usual Enterprise DNA membership. The new prizes include:</p><ul><li><strong>Winning Enterprise DNA member</strong> — $500 (Or amazon Voucher equivalent) + Free Membership</li><li><strong>Most innovative Entry</strong> — $250 (Or amazon Voucher equivalent) + Free Membership (Open to both members and non-members and the overall winner can also claim the most innovative title)</li><li><strong>Winning Non-Enterprise Member</strong> — $250 (Or amazon Voucher equivalent) + Free Membership (Open to everyone)</li><li><strong>First time participant winner-</strong> Pick from a selection of prizes as mentioned <a href="https://forum.enterprisedna.co/t/newcomer-prize-for-data-challenge-5/9500">here</a>. You must be an Enterprise DNA member to qualify.</li></ul><p>With these new prizes up for grabs, we’re hoping to see even more people joining in the next rounds.</p><p>As for the <a href="https://forum.enterprisedna.co/t/new-enterprise-dna-initiative-sneak-preview-problem-of-the-week/12504"><strong>Problem of the Week</strong></a>, the <a href="https://forum.enterprisedna.co/t/problem-of-the-week-8-pq-hierarchy-problem/15184"><strong>8th round</strong></a>, which we recently concluded, looks into hierarchies in Power BI visualizations. For this problem, participants are only allowed to use Power Query to come up with the solution.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*o_jxemjT0jdVufg8" /></figure><p>The Problem of the Week is done in two cycles every month — a DAX-based problem is posted every 1st Wednesday of the month, then a Power Query-based problem is posted every 3rd Wednesday of the month. The solution is posted the week after the problem was posted, with one of our experts walking everyone through the process.</p><p>Just like our Power BI Challenges, the Problem of the Week focuses on real-world scenarios that could help prepare participants should they encounter similar issues in the future.</p><h3>March Events: Power BI Mastermind, Business Analytics Week and More</h3><p>March was definitely a busy month in terms of events and we’re anticipating even more in the coming months.</p><p>In March, we had two rounds of Power BI Mastermind workshops.</p><p>The <a href="https://enterprisedna.co/member-only-registration-power-bi-mastermind-with-edna-covid-dashboard-expert-team/"><strong>1st one was held in </strong></a><a href="https://enterprisedna.co/power-bi-mastermind-with-sam-mckay-alex-badiu/"><strong>March</strong></a><a href="https://enterprisedna.co/member-only-registration-power-bi-mastermind-with-edna-covid-dashboard-expert-team/"><strong> 4</strong></a> and was facilitated by Sam McKay and Alex Badiu. Here, they discussed one of the winning entries for the Power BI Challenge we had last year using Covid-19 data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*YnAdJ382BllO378w" /></figure><p>The 2nd one, which was <a href="https://enterprisedna.co/member-only-registration-power-bi-mastermind-with-edna-covid-dashboard-expert-team/"><strong>held in March 11</strong></a>, was facilitated by our Enterprise DNA Covid dashboard expert team. The dashboard on spotlight here focuses on the same Power BI Challenge on Covid-19, but this time, some of our experts collaborated to come up with one of the best submissions we’ve seen.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*z3Yw4C-L5rZwfcvd" /></figure><p>We also had an advanced analytics event called <a href="https://enterprisedna.co/business-analytics-week-march-2021-registration/"><strong>Business Analytics Week</strong></a>, which was a 4-day training session that ran from March 15 to March 19. Here, the participants learned about how to optimize KPIs, how to discover unique and valuable insights, how to do advanced analytics using DAX formulas, and how to evaluate patterns and outliers in a dynamic manner.</p><p>A live training workshop called <a href="https://enterprisedna.co/take-your-analysis-to-another-level-wdax-formula-patterns-march-2021-registration/"><strong>Take Your Analysis to Another Level w/ DAX Formula Patterns</strong></a> was also concluded in March 25. Some of the topics discussed here include advanced scenario analysis techniques and enhancing related distinct counts.</p><p>Lastly, we had a live webinar about <a href="https://enterprisedna.co/analyst-hub-webinar-march-2021-registration/"><strong>Analyst Hub Best Practices</strong></a>. It dug deep into the apps inside the Analyst Hub and discussed ways on how to maximize the use of these tools for better Power BI report development.</p><h3>New Apps in the Analyst Hub</h3><p>The Analyst Hub helps Power BI users to create powerful reports and dashboards through different tools that make the entire process more seamless. Last February, we introduced a number of new apps in the Analyst Hub like the Analytics Planner and the Data Model Planner. And because we always grab every opportunity to enhance the report development process, we added a few more apps last March.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rKZ09eSPR_ho4avF" /></figure><p>The <a href="https://analysthub.enterprisedna.co/apps/m-code"><strong>M Code Repository</strong></a> allows users to save and edit their M code formulas so that they can be easily accessed for future use. <a href="https://analysthub.enterprisedna.co/apps/raw-code"><strong>Raw Code</strong></a> is another app where users can save and edit their code regardless of what coding language they’re using. The <a href="https://analysthub.enterprisedna.co/apps/playlist"><strong>Video Playlist</strong></a> is another useful app where users can create playlists containing helpful YouTube videos that can be shared with their teams.</p><h3>Membership Portals</h3><p>We know how a precious few seconds can impact one’s productivity. Because of this, we created the Enterprise DNA Membership Portal and the Center of Excellence Portal where users can find everything they need in one place.</p><p>The Enterprise DNA Membership Portal provides one-click access to trainings and tools that can help members maximize their learning experience.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*WQR4xJT9SnjxYNPx" /></figure><p>It contains links to the <a href="https://portal.enterprisedna.co/"><strong>Learning Center</strong></a> where all courses can be found, as well as to our <a href="https://enterprisedna.co/power-bi-showcase"><strong>Power BI Showcases</strong></a> where members can download actual reports and dashboards and use them for hands-on application. It also contains links to our member-exclusive events, the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a>, our <a href="https://portal.enterprisedna.co/p/enterprise-dna-power-bi-certification"><strong>Certification Testing</strong></a> page, and other resources.</p><p>Teams subscribed to our Center of Excellence are also provided with their own portal.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*B1tKexRMe9-fgfZu" /></figure><p>The Center of Excellence allows teams of different sizes to plan, manage and scale their Power BI training. As with the Enterprise DNA membership portal, team members can also access all the tools and resources they need in a single click through the <a href="http://coe.enterprisedna.co/"><strong>CoE portal</strong></a>.</p><p>Stay tuned to the <a href="https://blog.enterprisedna.co/"><strong>Enterprise DNA Blog</strong></a> and stay connected to our community at the <a href="https://forum.enterprisedna.co/"><strong>Enterprise DNA Forum</strong></a> for more updates and announcements.</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=696853ccfba1" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI Challenge 12 — Transport & Shipping Data]]></title>
            <link>https://medium.com/@sam.mckay/power-bi-challenge-12-transport-shipping-data-ca3d536db045?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/ca3d536db045</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[data-visualization]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Mon, 15 Mar 2021 08:45:23 GMT</pubDate>
            <atom:updated>2021-03-15T08:45:23.781Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power BI Challenge 12 — Transport &amp; Shipping Data</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*MD4eVTv2Zwlz1hX_" /></figure><p>We had an amazing 11th round for the Power BI Challenge, which was the 1st for the year. Looking at the submissions, it was evident that the new year has brought about a new resolve for our participants to deliver reports that greatly bested their past submissions.</p><p>Now, we’re moving onto the next round, which focuses on transport and shipping data.</p><p>Of course, we’re staying true to tradition and jumping into a new industry we haven’t covered before. This shows how dynamic Power BI can be as a tool, especially when it comes to real-life scenarios like this one.</p><h3>Updates to the Power BI Challenge</h3><p>There are a few changes that will be applied to the Power BI Challenge starting on this round.</p><p>First, we appreciate the amount of learning opportunities that our Enterprise DNA experts have been presenting since day 1. However, it’s understandable that our participants are asking for the playing field to be leveled a bit. This is why our expert panel will not be allowed to win these challenges anymore. Instead, their submissions will fall under a separate category.</p><p>For those who want to participate in the challenges but have no idea where to start, Jarrett, one of our experts, has created <a href="https://portal.enterprisedna.co/p/mastering-report-development"><strong>an entire course</strong></a> that can help you out. It shares a detailed step-by-step process that shows how you can create reports from start to finish.</p><p>Another change we’re making would be adding cash prizes on top of the <a href="https://enterprisedna.co/membership"><strong>Enterprise DNA Membership</strong></a> we’ve been awarding to challenge winners. These prizes are sponsored by a generous client who prefers to remain anonymous.</p><p>The new prizes should make the competition more interesting, and will hopefully attract more participants to join in the fun.</p><ul><li><strong>Winning Enterprise DNA member</strong> — $500 (or Amazon voucher equivalent) + free membership</li><li><strong>Most Innovative Entry</strong> — $250 (or Amazon voucher equivalent) + free membership (open to both members and non-members, with the overall winner still given the chance to claim this prize)</li><li><strong>Winning Non-Enterprise DNA Member</strong> — $250 (or Amazon voucher equivalent) + free membership (open to everyone)</li><li><strong>First-Time Participant Winner-</strong> Pick from a selection of prizes, which includes a copy of the Definitive Guide to DAX, 2nd Edition or any book of your choice from the <a href="https://forum.enterprisedna.co/t/power-bi-book-recommendations/6095"><strong>eDNA Forum Recommended List</strong></a>, a copy of SnagIt 2020 which is a do-it-all screen capture and graphics tool, or a four-month subscription to <a href="http://flaticon.com/"><strong>FlatIcon.com</strong></a> which is is an online service with millions of downloadable and editable icons you can use on your reports. (only for Enterprise DNA members)</li></ul><p>If you’ve been participating in the challenges before, this should be a great motivation for you to level up your reports even further. If you haven’t joined the Power BI Challenge before, then this is a great reason to start joining!</p><h3>Challenge #12</h3><p>We chose a topic that really hits home with Challenge #11, which involves Covid-19 data. This time, we’re looking at a case for a client who want to see what Power BI can do for them in terms of reporting and analytics.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Hfv9wdimtJtZ5qjB" /></figure><p>The great thing about this challenge is that you have the chance to really showcase the possibilities that Power BI brings to the table. You can be as creative as you want while ensuring that you’re delivering topnotch insights at the same time.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*qa29HQeVt5_VMv6Q" /></figure><p><strong>Deadline for submission is on March 28, 2021.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*htQegClI_GDMSKTW" /></figure><h3>The Power BI Challenge</h3><p>We had a great year last year, but we’re expecting that this year is going to be even better for all our challenge participants, especially with the new prizes we’re giving away. If you’ve been following our Power BI Challenges, then you’ll agree that it has fostered a culture of collaboration and shared learning throughout the community.</p><p>The way the participants have progressed as Power BI users has been inspiring to watch as well. We see first time joiners struggling through their first challenge or two, but submitting amazing reports worthy of recognition by their 3rd or 4th round. This only goes to show that if you’re still thinking twice about your ability to complete the challenges, just go for it! After all, the best way for you to improve your skills is to get started — and this is the best starting point.</p><p>As mentioned earlier, the winner gets a cash prize plus a complimentary membership to <a href="https://portal.enterprisedna.co/"><strong>Enterprise DNA Online</strong></a>. Aside from that, winning entries are also added to the <a href="https://portal.enterprisedna.co/courses/enrolled/305961"><strong>Power BI Showcase</strong></a> where Enterprise DNA members can download and use them for some hands-on practice.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*q8J8eOIQWk4isrui" /></figure><p>Just remember that we judge the entries based on the 4 pillars of a great power BI report:</p><ul><li>Data loading and transformation</li><li>Data modeling</li><li>DAX calculations</li><li>Reports and visualizations</li></ul><p>Keep these in mind as you work on your submission! Each round has been tougher to judge, with participants getting better challenge after challenge.</p><p><a href="https://youtu.be/3zwtMW219Zg">https://youtu.be/3zwtMW219Zg</a></p><h3>How To Join</h3><p>Here’s how you can join the challenge.</p><p><strong>For Enterprise DNA members, check the forum thread inside the </strong><a href="https://forum.enterprisedna.co/t/power-bi-challenge-12-transport-shipping-data/14846"><strong>Enterprise DNA Forum.</strong></a></p><ol><li>Download the data set from this link: <a href="https://forum.enterprisedna.co/uploads/short-url/lDxPBeWB8UnOJ8NIc1G8ut8hj3W.xlsx"><strong>Challenge #12</strong></a></li><li>Post your report on the thread.</li><li>Submit your PBIX files to <a href="/service/mailto:powerbichallenge@enterprisedna.co"><strong>powerbichallenge@enterprisedna.co</strong></a></li></ol><p>When you submit your report, just use the subject line <strong>Power BI Challenge 12 — Name (Member)</strong>. If you’re not a member yet, use the subject line <strong>Power BI Challenge 12 — Name (Non-member)</strong> instead.</p><p><strong>Not yet an Enterprise DNA member? You can still join by going here:</strong></p><ol><li>Submit your PBIX file, images of the report, link and description to <a href="/service/mailto:powerbichallenge@enterprisedna.co"><strong>powerbichallenge@enterprisedna.co</strong></a></li><li>Post this caption on your social media accounts along with the image below: <strong>I accepted Enterprise DNA’s Power BI Challenge</strong></li><li>Make sure to hyperlink this post</li><li>Use these hashtags on your social media post — <strong>#EnterpriseDNA #EnterpriseDNAPowerBIChallenge #PowerBIChallenge #PowerBIChallengeAccepted</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/0*ClxKrMgJORfxqvdM" /></figure><p>Join Power BI Challenge #12 now! We can’t wait to see what kind of insights you can share with us through your report.</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ca3d536db045" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI Challenge #10 Wrap Up]]></title>
            <link>https://medium.com/@sam.mckay/power-bi-challenge-10-wrap-up-ecfaf1ddb5e9?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/ecfaf1ddb5e9</guid>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-analytics]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Wed, 30 Dec 2020 06:05:27 GMT</pubDate>
            <atom:updated>2020-12-30T06:06:25.932Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*aoh3SK46cxwO-gb6" /></figure><p>We’ve concluded yet another Power BI Challenge and it’s quite a milestone for the Enterprise DNA team, as well as the active participants in the forum. It is, after all, our 10th challenge!</p><p>This <a href="https://wordpress.com/post/blog.enterprisedna.co/125040"><strong>10th Power BI Challenge</strong></a> involves supplier insights. Participants were supposed to pretend that they’re working with a manufacturer who needs an efficient procurement system. This system should help them validate which suppliers are delivering quality goods.</p><p>Let’s see what kind of creativity the participants showed this time.</p><p><strong>Power BI Challenges</strong></p><p>The <a href="https://forum.enterprisedna.co/search?q=power%20bi%20challenge"><strong>Power BI Challenges</strong></a> aim to cover different scenarios across various industries. This showcases how dynamic Power BI really is. The challenges also invite not only Enterprise DNA members, but non-members as well. Because of this, we have helped create a more collaborative environment for a lot of Power BI users regardless if they’ve been participating in discussions on our forum or not.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1023/0*_nZ8JJ_UyKJevl1G" /></figure><p>Making each challenge unique from the others has also allowed participants to find out what they’re really capable of. This has become quite a learning opportunity for everyone as they find the best ways to deliver what is asked for. You can also see people in our forum asking questions and helping each other out.</p><p>Aside from the learning and collaboration happening while each challenge is ongoing, it all continues over the long term as well. The best submissions are featured in Enterprise DNA Online where members can download the report and experience how it works firsthand through the <a href="https://portal.enterprisedna.co/courses/enrolled/1090000"><strong>Power BI Challenge Showcase</strong></a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/0*kC7IW2SDMFov5q33" /></figure><p>How do we gauge whose submission is the best? We look at the 4 pillars of an effective Power BI report — data modeling, DAX calculations, loading and transforming data and reports and visualizations.</p><p>It’s interesting to see how the participants are improving as Power BI users as well. We’ve seen some participants who started out with simple and basic reports but are now coming up with amazing submissions combining insights and creativity. That’s why we encourage those who are just starting to learn how to use Power BI to jump in and join these challenges as well.</p><p>Winners get a <a href="https://portal.enterprisedna.co/"><strong>complimentary membership to Enterprise DNA Online</strong></a>. For winning members, they can pass on the membership to someone else who could potentially benefit from the access to more Power BI resources from our team. We also have a separate winner for non-members.</p><p>First-time joiners also get the chance to win an amazing package as part of the newcomer category.</p><p><strong>Challenge #10 Winners</strong></p><p>We admit that in this round, it took a longer time to pick a winner. As mentioned earlier, the participants just keep getting better and better with every challenge. That’s why it also seems like the bar is being raised even higher each time.</p><p>But note that everyone still has a chance to win. It doesn’t matter if it’s your first time or if you’ve been submitting entries since day 1. At the end of the day, the report that delivers what it required the best possible way wins.</p><p>It’s also interesting that this round brought a lot of participants, probably due to the fact that the data set in this scenario was simple and straightforward.</p><p>The winner for this challenge is @alexbadiu who managed to deliver so much insight in a single report without making it look cluttered or over-complicated.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/983/0*Nqi8xfgYQKGTTQ0n" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/983/0*r2cglg3z4CpR8P8s" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/977/0*1EIasK3Ce3P_suST" /></figure><p>As for our non-member category, we’d like to congratulate Jihwan Kim for doing a great job in laying out as much information as possible about the data involved.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/883/0*dZlFx4avmbLOe7Kv" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/977/0*TnfK5Ddu5soFnT0x" /></figure><p>Kudos also to Jose Bressan, a first-time participant who won our newcomer challenge! His report is clean, straightforward and really covered all the bases.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/689/0*z4QLRWQ9gHUXwgAa" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/690/0*-pfem0FQ_vlcKlnf" /></figure><p>Great job to our winners and the rest of the participants!</p><p>If you want to make the challenges even more interesting by sponsoring a challenge or two, let us know! We also encourage everyone to spare us a minute or two to leave reviews on the write-ups and posts.</p><p>Stay tuned to see what we have in store for you in the next round. We’re also looking forward to seeing a lot of you joining in these challenges and showing us what kind of magic you can work through Power BI.</p><p>All the best,</p><p>Enterprise DNA Team</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ecfaf1ddb5e9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Power BI Challenge 10 — Supplier Insights]]></title>
            <link>https://medium.com/@sam.mckay/power-bi-challenge-10-supplier-insights-7dadafd3523a?source=rss-56862a96358c------2</link>
            <guid isPermaLink="false">https://medium.com/p/7dadafd3523a</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[power-bi-challenge]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Enterprise DNA]]></dc:creator>
            <pubDate>Tue, 08 Dec 2020 08:20:52 GMT</pubDate>
            <atom:updated>2020-12-08T08:20:52.711Z</atom:updated>
            <content:encoded><![CDATA[<h3>Power BI Challenge 10 — Supplier Insights</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*77uptXaE4W1fuG8o" /></figure><p>We’ve launched the <a href="https://forum.enterprisedna.co/t/power-bi-challenge-10-supplier-insight/12521"><strong>10th Power BI Challenge</strong></a> and this time, we’re covering supplier insights.</p><p>Once again, we’ve come up with a unique scenario that everyone can work on to make sure we’re maximizing what Power BI can do. A complimentary membership to Enterprise DNA Online is also more than worth it, knowing that this membership can give you access to amazing resources that could deepen your knowledge of Power BI and its capabilities.</p><p><a href="https://enterprisedna.co/membership"><strong>Enterprise DNA Membership</strong></a></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/633/0*fNWzYT8sMsll6d6B" /></figure><h3>Challenge #10</h3><p><a href="https://wordpress.com/post/blog.enterprisedna.co/124583"><strong>Challenge #9</strong></a> was about currency conversion. With challenge #10, we’re going to focus on supplier insights.</p><p>The project brief gives a clear picture of the scenario at hand:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*AiMdX3dq30hjLREV" /></figure><p>It’s going to be interesting to see all participants take the role of the experts and answer these critical questions that this challenge aims to answer:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/512/0*qvvhOunwiFMDo9X-" /></figure><p><strong>Deadline for submission is on December 13, 2020.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/512/0*aTMvpdk67Cs00bNE" /></figure><h3>The Power BI Challenge</h3><p>The <a href="https://forum.enterprisedna.co/search?q=power%20bi%20challenge"><strong>Power BI Challenge </strong></a>continues to evolve after every round. We started out with challenges that were exclusive to members of Enterprise DNA Online. Then, we realized that this was a great opportunity for everyone to collaborate. So we opened up the challenges to non-members as well.</p><p>Eventually, we also added a separate prize for first-timers. All you need to do is tell us that it’s your 1st time to participate, and you become eligible to win a prize.</p><p>What makes the experience more exciting for us is the fact that we’re seeing so much improvement in everybody’s work as well. This only proves that the challenges have become an amazing opportunity for learning, too. Those who started out in the first few challenges are now submitting reports that are leaps and bounds ahead than their first submissions.</p><p>The Enterprise DNA Team judges the submissions based on the 4 pillars of a great Power BI report — data loading and transformation, data modeling, reports and visualizations, and DAX calculations.</p><p>Aside from getting the chance to win great prizes, winning submissions also get featured on <a href="https://portal.enterprisedna.co/p/power-bi-challenge-submission">Power BI Challenge Showcase</a>. This means that members of Enterprise DNA Online get to practice using your reports and dashboards to get some hands-on experience. Again, this makes these challenges a great learning opportunity.</p><h3>How To Join</h3><p>Here’s how you can join the challenge.</p><p><strong>For Enterprise DNA members, check the forum thread inside the </strong><a href="https://forum.enterprisedna.co/t/power-bi-challenge-10-supplier-insight/12521"><strong>Enterprise DNA Forum.</strong></a></p><ol><li>Download the data set from this link: <a href="https://forum.enterprisedna.co/uploads/short-url/pXfiCVw2srB5JtlydqTbLMxc0s6.xlsx"><strong>Challenge #10</strong></a></li><li>Post your report on the thread.</li><li>Submit your PBIX files to <a href="/service/mailto:powerbichallenge@enterprisedna.co"><strong>powerbichallenge@enterprisedna.co</strong></a></li></ol><p>When you submit your report, just use the subject line <strong>Power BI Challenge 10 — Name (Member)</strong>. If you’re not a member yet, use the subject line <strong>Power BI Challenge 10 — Name (Non-member)</strong> instead.</p><p><strong>If you’re not yet an Enterprise DNA member, you can still join by going here:</strong></p><p><a href="https://forum.enterprisedna.co/t/power-bi-challenge-10-supplier-insight/12521"><strong>Enterprise DNA Power BI Challenge 10</strong></a></p><ol><li>Submit your PBIX file, images of the report, link and description to <a href="/service/mailto:powerbichallenge@enterprisedna.co"><strong>powerbichallenge@enterprisedna.co</strong></a></li><li>Post this caption on your social media accounts along with the image below: <strong>I accepted Enterprise DNA’s Power BI Challenge</strong></li><li>Make sure to hyperlink this post</li><li>Use these hashtags on your social media post — <strong>#EnterpriseDNA #EnterpriseDNAPowerBIChallenge #PowerBIChallenge #PowerBIChallengeAccepted</strong></li></ol><p>Join Challenge #10 now and show us what kind of insights you can deliver using Power BI!</p><p>All the best,</p><p>Enterprise DNA Team</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*0aFxKWbalKXm15j7" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8m6E1ko5b4d_8niX" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1023/0*ZeQeN6h7Ikf_r3jG" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7dadafd3523a" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>