Episodes

  • Snowflake DBT Tools
    Dec 5 2023
    The podcast today is the latest episode of Beyond Transformation, where we talk about Snowflake DBT or data build tools. To help with the topic, Prabhash Thakur from Beyond Key joined.    Beyond Transformation is brought to you by Beyond Key. Beyond Key is a software development solutions organization. One of the services that we offer is Snowflake. DBT interacts with Snowflake.   Snowflake DBT Overview Dbt is short for a data build tool. It's a development framework combining modular SQL and software engineering best practices to make your data transformation reliable, fast, and fun.  Dbt is familiar to those who know how to write SQL select statements. They have the power to build their models, write test scenarios, and schedule their jobs to produce reliable, actionable data sets.   When you have data, you need to transform the data to give you business insight so that you can build the report on top of this. DBT acts as an orchestration for your transformation.   What is Dbt?   First, dbt is not a data warehousing solution. For example, in data warehousing, you follow the ETL (extract, transform, and load) approach,    In ETL, you first extract and load full raw data into your data warehouse that will act as a data link, and then you do the transformation on top of that raw data.  You then always have the true data, so you can perform as many transformations as you want. DBT helps you with the “T” or the transformation part of ELT.   Analytical Engineering: Data Engineering and Data Analyst   DBT uses another concept called analytical engineering. Analytical engineering acts as a bridge between data engineering and data analysis.   When we talk about data engineering, we build custom data integrations to manage the overall pipeline orchestration. Then, we deploy machine learning endpoints to build and maintain the data platforms.   Data engineering folks will then do some performance optimization. Analytical engineering provides clean, transformed data ready for analysis using software engineering best practices.   For example, delivering your models into small sprints. That's agile methodology. It's very difficult to perform agile methodology in data engineering because it is not enabled everywhere.   DBT comes with that. The tool documents the transformation in case anyone needs to review how the data transformed, what logic was used for the process, and the data sources.   On the other hand, a data analyst will do deep inside work like why did this point spike last month? What are the best acquisition channels? Then, they will work with the business users to understand data requirements to build forecasting dashboards.   DBT is key to analytical engineering because it maintains the documentation and trains business users how to use the data visualization created from the transformation of insights. As we said earlier, DBT is the “T” or the transformation of data.   How can you use DBT to transform your data into usable insights?   DBT is not connected to your extraction tool like how data is coming inside Snowflake or other data warehousing solutions like:   BigQuery   Databricks   Postgres   Redshift   Spark   Azure Synapse    Teradata   The number of platforms connected to DBT keeps changing. You need to take the data and load it in raw format into your data platform; DBT will connect your data platform.   It will use your data platform's compute and storage resources. You can access the DBT through your account credentials or use service account credentials to perform the transformation.   How can you use DBT to transform your data into usable insights with the right BI tool?  You can start building your DBT models by creating SQL files with select statements. DBT will do the rest for you.   For executives, an SQL file is like a CSV file. You create a .SQL file that works with any code editor like Notepad++ or VS code to store relational ...
    Show more Show less
    25 mins
  • National CyberSecurity Awareness Month Audit
    Oct 18 2023
    Today on Beyond Transformation, we have some exciting news to share with you in honor of 2023 National Cybersecurity Awareness Month. Learn how you can protect yourself and your business from ever-present threats in the digital world. The Current Cyber Threat Landscape 2023 has seen cyber threats everywhere. Every click, download, or email carries the potential for danger. But what if we told you that you have the power to turn the tables and protect yourself? It's not as tricky as it seems, and it's all within your reach. Beyond Key's Free Security Assessment This October, during Cybersecurity Awareness Month, Beyond Key offers you an opportunity you won't want to miss - a free security audit. Yes, you heard that right. We have an exclusive audit for 10 free audits in October. Claim one of the ten free audit slots this month. Your Four-Week Journey to Peace of Mind Beyond Key's free audit covers a wide range of areas to ensure your online presence is secure. Over four weeks, they'll assess your website, protect your mobile platforms, tune up your network, and shield your valuable data. This comprehensive approach lets you enjoy peace of mind knowing your cybersecurity is airtight. Benefits of the Free Audit So, what are the benefits of this free audit? Beyond Key ensures you stay compliant with regulatory standards, which is more critical than ever in today's digital landscape. Why Your Business Needs Cybersecurity Now, you might be wondering, "Why does my business need cybersecurity?" Without it, you're vulnerable to ransomware, cyberattacks, and hefty data breach costs. But with Beyond Key's cybersecurity solutions, you can reduce successful attacks, decrease remediation time, and save your business significant money. Cybersecurity Awareness Conclusion So, don't miss out on this incredible opportunity during the 2023 National Cybersecurity Awareness Month. Outsmart the invisible and champion the unseen with Beyond Key. Claim your free audit and take the first step towards a safer digital future. Stay tuned for more cybersecurity insights in future episodes. Thanks for joining Beyond Transformation!
    Show more Show less
    2 mins
  • Boost Your Fundraising Efforts With The Right Donor Management Solution
    May 31 2023
    Getting donors is one of the most crucial aspects of any nonprofit organization. That is why it is vital to have the right donor management solution for your organization. The information below comes from a Donor Management Solutions webinar we hosted leveraging Dynamics 365, SharePoint, the Power Platform, and Azure. https://youtu.be/YnYwmMHr24c Donor Management Solution Overview Today, let's begin our discussion by focusing on the opportunity for the donor management solution to leverage your donor data. The opportunity is to understand what type of people donate to your organization. Where did you find them? Target Donor Audiences For example, is your organization very active on social media? Do you have an extensive referral network? Are you getting people that you're talking to on the street? Your media campaigns may generate interest. How do you find these opportunities? How do you source them? Also, not only that, who are these people that are, are donating to your organization? For example, a nonprofit like MADD (Mothers Against Drunk Driving) has a particular targeted pro profile. They connect with mothers of middle school and high school-age students to make sure those mothers can have access to the correct information. And they know those mothers will also be more likely to donate to their organization. It's a targeted profile to ensure they're helping kids stay safe. That compares very differently, by the way, if you're in some other organization. If you happen to work with a community kitchen, your target audience will be quite different. You'll need to communicate directly with more individual philanthropic individuals who may not be directly connected to the cause. How do you connect with that audience? Understanding that target profile is vital. And the more you have information to that, that data, that opportunity, and this is something that you could also enter a CRM system, the more you can integrate that into your payment systems. Payment Solutions Once you have the opportunity, you want to connect them and get them to donate to your organization. Other work happens here to build that relationship. Still, for the donor section, we're helping you integrate it into your payment gateways and website. Whatever you do to get them to that step to donate, you have a path for them to do that. And you could integrate that. And by the way, this doesn't have to be an external solution. We mentioned earlier the Power Pages. Maybe you're using Power Pages to give your donors a place to go where they could set up a donation. And the great thing is, once they've made that payment, they also have the information they added. When people donate, you ask them to enter your credit card information. You're asking for their name, their email, their phone number. You might ask, why are they donating? You might also ask, how do they find out about you? You start tracking this information. And the great thing about doing this online is that you can monitor mobile and online donations. You could start tracking that if multiple people visit your portal through their smartphones. That means you know how to find those people better through mobile than through a laptop. It's all about understanding that information because you can start tracking it once you have it. Then you can start automating your processes. For example, we discussed building the relationship with the integrations. Donor Management Relationships You don't just go from finding someone who wants to be a donor to asking them two minutes later to donate. That might work occasionally, but more than likely, people need to build up a relationship with your nonprofit before they donate. You could start creating automated messages to those opportunities and let them know how they can be part of your organization and how they could help your organization. Once they've donated, you could also talk about how they could refer others.
    Show more Show less
    8 mins
  • Create a Dynamic Data Analytics Strategy 
    May 16 2023
    During our Data Analytics Panel, we discussed leveraging data analytics to improve your operations. In this segment, Piyush Richhariya and Raj Krishnan share their thoughts on creating a cohesive data analytics strategy. Data Analytics Strategy Transcription It is crucial to demonstrate the potential impact of data analytics projects or tools to earn stakeholder buy-in. You can achieve these goals through key metrics and how they will improve with the introduction of data analytics.  The key to getting stakeholder buy-in for data analytics projects or tools is to focus on the impact on the business and involve stakeholders in the process from the beginning. By demonstrating the potential benefits and keeping stakeholders informed, you can build support and ensure the project's success. It is essential to focus on the outcomes that matter to get stakeholders interested in data analytics. While they may not be interested in the technical details of how ML improves Power BI (Business Intelligence) or what platform to use, they care about data analytics’ impact on the business.  To build interest and buy-in, you must show stakeholders how data analytics can help them achieve their objectives and key results (OKRs) for the project. This requires understanding the stakeholder's priorities and how data analytics can help them solve genuine business problems.  One practical approach is to start with a specific business problem or challenge the stakeholder faces and then show how data analytics can help solve that problem. This could be improved customer satisfaction, increased operational efficiency, or better decision-making.  Another approach is to provide examples of how data analytics has helped other businesses achieve their goals. This can help stakeholders see the potential benefits and get excited about what data analytics can do for their business.  Finally, involving stakeholders in the process from the beginning is important. This can help build interest and ownership in the project and ensure that the final solution meets their needs and expectations.  Final Thoughts Data analytics is great for helping stakeholders leverage data analytics for their operations. If you have additional questions about how to use data analytics for your organization, schedule a free consultation with our team today. https://youtu.be/ua0ZAEpZ0cE
    Show more Show less
    4 mins
  • SharePoint Migration Process
    Jan 5 2023
    Do you want to ensure your corporate documents are safe and accessible simultaneously? Then you need the right technology to ensure this happens. That is why more and more companies migrate their documents to SharePoint Online. Microsoft's enterprise-level security and cloud access ensures that registered users can access and share their files on any device. The podcast episode shares how the SharePoint Migration Process works. Also, check out our on-demand webinar to learn more about the Benefits and Strategies for SharePoint Migration. https://youtu.be/zmrjUWDcZRs 5 SharePoint Migration Process Steps When we talk about the SharePoint migration process, here are 5 steps that take you from an on-prem to an online SharePoint Document Management System. Step 1: discovery As the name suggests, with the discovery, you start by evaluating your current on-premise server. For example, "We have 100,000 documents stored on our site." The question becomes how many of these documents are PDFs. How many of these documents are word docs? How many are JPEGs or images? It's important to understand this breakdown, research that information, and see how much space you're using on your current server. Discovery gives you a baseline of what and how much data you need to transfer. Step 2: Assessment Now you can assess what your needs are. Again, maybe you have 100,000 documents, but maybe 10,000 haven't been opened in three years or more. Do you still need old files? With that line of thinking, how long do you need to keep documents in your organization? For example, you must keep financial documents secure for seven years because that's how long the IRS can go back to audit. So by looking at this information, you have to assess your specific needs and which documents you should migrate ahead of time. Step 3: Pilot Once you've assessed your documents, you could start creating a pilot. Instead of just moving everything over at once, you want to test that things work correctly first. You may have a few department members test how the process will work. Instead of sending 100,000 or 90,000 documents, you send 1000 documents over and test whether it works in that small, limited pilot. Since documents and data are the lifeblood of your organization, you want to reduce interruptions. A pilot migration can help with this objective. Step 4: Execution The SharePoint migration doesn't start until you get to the execution stage when you send over your documents. Remember the first three steps focus on the functional migration part of this process. The fourth step we're talking about for execution handles the content side. You can automate this process using the right software and tools when you perform steps 1-3. You can find a demo of the SharePoint migration process in the on-demand webinar we mentioned previously. Step 5: Onboarding Once you finish the execution stage, remember you still need to finish the onboarding because your staff needs to know how to use your new SharePoint online site correctly to ensure it fits in with your processes and systems. SharePoint Migration Process Final Thoughts If you are interested in learning more about how your organization can migrate your SharePoint site, contact us for a free 1-hour consultation.
    Show more Show less
    3 mins
  • Dynamics 365 for Customer Service Workflow
    Nov 14 2022
    If you want raving fans, then it is vital to set up a quality customer service flow. Dynamics 365 can help with this process. This podcast episode shows how Dynamics 365 for Customer Service flow works. To learn more, check out the entire webinar: Create Raving Customers With Dynamics 365. https://youtu.be/O1XoVMEI1p0 Dynamics 365 Customer Service Flow How does the Dynamics 365 Customer Service Flow work? Well, let's take random customer questions about sprockets. They decide they need to know more about how to use a specific sprocket and want the ultra-sprocket. What they do is say, "Hey, look, I'm having trouble with my ultra-sprocket. Can you please help me?" They go into the Power Apps portal and initiate a case. Once they do that, the customer can then reach out to your company, and they can do this through your portal. You can use the workflow to help with the following: Text messages Phone calls Chat or email Let's talk about automation One of the great things is that once the customer creates the case, it automatically creates a case. And we'll show you how cool this looks on Dynamics 365. It will create a case number, and what they'll do is it'll allow it to route that case automatically over to specific agents. Customer service example Let's say you have a company with 500 to 700 employees, and maybe you have about 20 to 30 different customer agents working at any time. You have 20 to 30 agents working on sprockets. Well, maybe only five of them are trained in knowing how the ultra-sprocket works. What it could do is route that information to that specific agent. The agent will ask, "Hey, okay, so this person has a question about the ultra-sprocket. Let me see what I could do to help them." Even though they know a lot about the ultra-sprocket, they might not know everything. And that's where that knowledge management module comes in. It helps you research the information and say, "Oh, you know what? It looks like you're having this problem with the sprocket. Let's see how we can help you out." They could go through that information; they could research it. Then they could go back to the customer and help resolve that case by sharing that knowledge with the customer. And once that happens, the knowledge is then you could then resolve the case. Remember that if you have a company that sells a hundred thousand sprockets a year, you're probably not just having one customer reach out to you yearly. You have 20 or 30 agents in this example. In that case, you need to make sure there's a queue here, and then the agent could return to the remaining cases. The example discussed above is one case among many. And every time you have a case, this process starts over again. The customer initiates the case, and they reach out. Then the agent identifies, researches, resolves the case and then goes back to the next one. So that's one example of what we see. Dynamics 365 for Customer Service Final Thoughts If you are interested in learning more about improving your customer flow, let us know how we can help. Set up a free 1-hour consultation with our Dynamics 365 experts to improve the quality of your customer service.
    Show more Show less
    4 mins
  • Data Visualization Benefits
    Oct 18 2022
    The ability to visualize your data is one of the greatest advancements over the past decade in the data analytics field. Tools like Power BI make this a reality by quickly showing information that would take hours to create through spreadsheets and other legacy systems. This podcast discusses the many data visualization benefits your organization has when they use these tools correctly. The clip for this episode comes from the Data Visualization Tools webinar, where we share tools like Power BI, Tableau, and Domo. https://youtu.be/Xch0RELdeeg Data Visualization Transcript First, remember data visualization is not new. People have been turning data into charts and graphs for a long time. The difference is now we can incorporate real-time updates thanks to data visualization software. Organizations need better ways to sift through daily, weekly, monthly, quarterly, and annual reports. That is because it takes a long time to sift through the data with real-time analysis. Data visualization helps you automatically see what's happening in your organization to make faster, more educated decisions. That happens due to integrating numerous secure data sources. The keyword for your privacy is in a secure environment. If you have customer data you want to transfer into a data visualization platform, you must ensure it's safe. Fortunately, Power BI safely and privately integrates your various programs to make sure you can see what your business intelligence operations look like across multiple tools Business intelligence visualization tools improve planning across departments A lot of what we're going to discuss today is how organizations can leverage the data to complete different tasks. For example, if you're in the marketing department, you generate website traffic from social media and search engines. You can compare quality traffic breakdowns between search and social traffic. It helps to have a process to analyze how all different marketing components work together in one central location. If you don't have a unified way of seeing the entire picture, you will struggle in today’s competitive environment. If they could say, “Hey, look in quarter one, we did this. Here's what I think we can do in quarter two, based on our website traffic in quarter one, your organization can take advantage of opportunities faster and remove the speedbumps from your marketing efforts. Final Thoughts Leverage data visualization services to help your organization understand your story and predict where your organization can go with the right information. Contact us today to set up a free 1-hour consultation with our data visualization team.
    Show more Show less
    3 mins
  • What PowerApps Can and Cannot Do
    Aug 17 2022
    If you had superpowers, would you want to know what they are and how to use them? So does every other organization. That is why we help organizations learn more about how they can leverage PowerApps to supercharge their operations. The latest Beyond Transformation Podcast covers a clip from our free On-Demand Webinar, Discover the 5 PowerApps Use Case Superpowers. As the name suggests, the webinar covered information about leveraging PowerApps for your organization. We provide you with different use cases that explore how various organizations use this tool. https://youtu.be/4z1ChcGxxX8 PowerApps Webinar Transcript Using tools like PowerApps, you have an enterprise-level platform that helps you easily build new business applications or customized existing apps. How can PowerApps help your organization? PowerApps is a framework to run your cloud-based PowerApps applications. You can even leverage their sample apps library. So, even if you don't know the exact business processes or don't know how to connect different things, you have a sample apps library that guides you to update your processes. Furthermore, you don't always need to know how to code. The great thing about PowerApps is it connects your PowerApps with over 480 different data sources, as the last time we checked, and this is a growing list. As you continue to watch this, it's very possible that it will continue to grow over time because it has so far. In addition, I mentioned that you don't need to have a lot of coding experience. The one coding they have on PowerApps is what's called Power FX. Power FX is an open-source coding based on Excel formulas. The idea is that you're using these formulas to help understand how to manipulate the data for your own purposes. With that said, there are some limitations of PowerApps. We're not going to say this is the end-all, be-all of all applications. So, you must first know that this is not for commercial use. So, you're looking at PowerApps, you're like, "Oh, this is so great. It connects all this data. It does all these things." What does PowerApps not do? One thing it does not do is you cannot sell it on an app store. So, for example, if you go into the Google Play Store or the Apple App Store, you could download an application. This is not for that type of use. This is for internal audiences only. Additionally, because this is designed for citizen developers, there are some limitations on what developers can do with customizing HTML and JavaScript code. Furthermore, you're also reliant on Microsoft to roll out new functions. That said, they do have a regular schedule. For example, we talked about the Dataverse in terms of connecting information and connecting data. One of the things they just rolled out was a simplified Dataverse search to help connect all this information together, and you now have a way to search for it. There are also advanced lookup capabilities and model-driven apps. There are model-driven and canvas apps. And this is a model-driven app that helps you so that you have better ways of creating those different model-driven apps. So again, they are rolling out new functions regularly, but you are relying on Microsoft to roll out those functions in the first place. Final Thoughts Thanks again for listening to the Beyond Transformation Podcast. Hope you enjoyed this episode. And again, don't forget to check out the free webinar.
    Show more Show less
    4 mins