I have successfully delivered a number of Power Platform Projects for nearly a year now. Even though I am no longer a Microsoft MVP, I still work hands-on with Microsoft products as well as providing more strategic thought leadership to business leaders. The current blog forms a summary of what's good, and what's not so good, about working with Power Platform projects.
Here are some solutions to get around Microsoft Teams authentication if you have multiple Office365 logins.
Welcome to Make Your Data Work Monday! The Data Relish team and I are holding AMA ‘ Ask Me Anything ‘ weekly surgery hour slot to help organisations to Make Your Data Work. These will take place every Monday at different weekly time slots. We will talk about Power BI, Excel, Azure, and SQL.
Change is hard, so digital transformation is tough. However, small changes with the agile methodology and Power BI can add up to produce results and deliver business value by moving the needle slowly but surely. Gently, gently, incrementally!
SQLBits Business Intelligence presentation. Data can be viewed as having a product lifecycle, where it can be collected, analysed, visualized, utilized and then monetized. In this session, aimed at business intelligence leaders, we will look at generating ideas and formulating a strategy that could benefit your organization by adding information as an asset to the organization.
User stories are development tasks often expressed as follows: persona + need + purpose A key component of agile software development is putting people first. User stories put actual business users at the front-and-centre of the conversation. In this post, we will cover the following topics: What makes a good user story? Story template Definition … Continue reading User Stories for Agile Business Intelligence
The Microsoft Power BI team have released a preview Data Lineage feature and I couldn't be happier! The Power BI lineage view displays the lineage relationships between all the artifacts in a workspace, and all its external dependencies.
Businesses need a clear line of sight on data asset ownership and stewardship. This has traditionally been in the hands of the IT department, but unfortunately the projects can become deprioritized as IT fight other battles elsewhere. IT can do so much, but the business do need to bring things to the table. Hence, we now see accessible tools appearing in technology such as Power BI.
I'm pleased to announce that the University of Washington are running a Foundations of Data Analysis course, starting in January 2020. In this 10-week course, you'll learn how to understand and analyze data. We’ll start with fundamental data-related concepts, terminology and ethical considerations. You’ll learn how to articulate business problems and identify required data. Using Microsoft Excel and SQL, you’ll practice gathering, cleaning and organizing data. Finally you’ll use Tableau to effectively describe, analyze and visualize data.
From the business intelligence perspective, it is incredibly useful to compare AWS RDS and Microsoft Azure SQL Database. As a freelance industry analyst who has worked with GigaOm, I'm pleased to see the GigaOM Transactional Field Test derived from the industry-standard TPC Benchmark™ E (TPC-E) report which compares Amazon Web Services Relational Database Service (AWS RDS) and Microsoft Azure SQL Database.
I'm excited to be attending ASG Technology's Evolve19 event in Dallas, Texas on October 21 - 23. I'm particularly interested in learning more about metadata management. As I've written previously, I believe that metadata management is often overlooked in data science. It's an important part of obtaining full value from data, and it should be … Continue reading Keynote and Session highlights at ASG Evolve19
At some point, however, we need to pay back data debt if we are to succeed in making better decisions.
Credit to stux-12364 for the jigsaw image. When you install SSDT, you can find that the SSIS Toolbox components are all missing. I am writing this blog for myself BECAUSE I ALWAYS FORGET WHERE IT IS and I am SO ANGRY with myself right now. Here is what to do: Click on Control Flow Go … Continue reading SSIS Toolbox components are all missing?! Here’s the fix!