Power BI can pull in and analyze data from a variety of sources. And once loaded, Power BI will form data relationships wherever it can. Even so, new datasets are sometimes needed instead of data relationships. One way to create these new datasets is to use the INTERSECT() expression with dataset pairs. One business scenario, … Continue reading Power BI: Dataset Intersect(s)
Power BI
Power BI: What If… Citizen Insights?
Microsoft is on a mission to empower everyone through technology. Whilst on this journey, they crafted the Power Platform and gave the world Power BI. At that moment, Microsoft empowered thousands of citizen developers to gather insights using their respective business datasets. Citizens could create richer data visualizations and analyze more data from varying sources... … Continue reading Power BI: What If… Citizen Insights?
Power BI: SPOList – Records v. Tables
Power BI Desktop can connect to a variety of data sources, including [SharePoint Online] lists. The text, date, and numerical columns will map directly, but a Person column will become a Record... E.g., list column Approver is a Person. So, what are Records? These are indexed data structures. Similar to hash tables, tuples, and structs, … Continue reading Power BI: SPOList – Records v. Tables
Power Platform x SharePoint – Approval Requests: Part III (Power BI)
The Power Platform is a Microsoft offering of tools to help organizations meet challenges effectively. Among these tools, there are some notable standouts: Power Automate – Create automated business processes.Power Apps – Create custom forms and portals.Power BI – Create rich charts, graphs, etc. With their powers combined, one could easily build in-house solutions using … Continue reading Power Platform x SharePoint – Approval Requests: Part III (Power BI)
Power BI: Intersect w/ Netflix Viewing Data
Recap: Visuals were built in the previous Netflix Viewing Data blog, but no formulas. Still, presenting the year-to-year viewing counts in stacked bar charts was simple enough. And the drilldowns weren't bad... Note: The Netflix viewing history export only includes the first time something is viewed, not each time it is viewed. However, today I … Continue reading Power BI: Intersect w/ Netflix Viewing Data
Power BI: Visualizations w/ Netflix Viewing Data
"Power BI is a business analytics service that delivers insights to enable fast, informed decisions." - Microsoft One third of the Microsoft Power Platform, Power BI quickly transforms data into rich visuals. If you were a fan of Power Query, Power Pivot, and Power View in Excel, then this should feel familiar... To recreate this … Continue reading Power BI: Visualizations w/ Netflix Viewing Data
Microsoft Ignite 2019 – Recap
Microsoft just hosted Ignite 2019 in Orlando, FL. This was my first year attending and there was more than enough content. It's impossible to recap it all because it was impossible for me see everything: 25,000+ attendees 1,000+ sessions 300+ sponsors 200+ hands-on experiences I mean WHOA! Microsoft mission:"Empower every person and every organization on … Continue reading Microsoft Ignite 2019 – Recap
console.log('Charles'); 